Learn Database Design with MySQL

Database design is one of the most important aspects of Web programming. Successful implementation of any system with Data Storage will always need proper database design. In order to create great database design you will not only have to master the Database technology but will have to master database design process and normalization.

This course will teach you the nuances of proper database design. It will teach you all the hidden tips and tricks and will ensure that you learn all the major concepts of a proper database design. This course will also teach you SQL and you will be a SQL power user by the end of this course.

You will start with basic introduction to data storage and will follow it up with storage engines and other tools. You will also learn about MySQL installation and database design process. Database design , normalization, structure mapping, keys and junction tables comes next.

Course Content

  • What is Database
  • MySQL Overview
  • Understanding Storage Engines
  • Understanding Data Types
  • Windows Installation
  • Linux Installation
  • Environment Setup With Xampp
  • PHPMyAdmin
  • MySQL Workbench Setup
  • Principles & Normalization
  • Database Design Process
  • Map Out Structure
  • Create Tables & Columns
  • Importing & Exporting
  • Relations & Foriegn Keys
  • Junction Tables
  • Command Line & Inserting Data
  • Basic Select Queries
  • Updating & Deleting Data
  • Aliases & Joins
  • Union, Concat & Count
  • Using The IN Clause
  • Math & Subqueries
  • Using Group By
  • PHP Fundamentals
  • Template & MySQL Connect
  • Select & Display With PHP
  • Insert Data With PHP
  • Update & Delete With PHP
  • Wrap up