Learn Database Design with MySQL

Description

In this course, you will :

• To Learn Database design Process.
• To Learn Database Normalization.
• To Learn Database development using MySQL.
• To Master SQL.
• To Learn to use PHP with MySQL.

Syllabus :

1. Getting Started With MySQL

• Windows Installation
• Linux Installation
• Environment Setup With Xampp
• PHPMyAdmin
• MySQL Workbench Setup

 

2. Planning & Design

• Principles & Normalization
• Database Design Process
• Map Out Structure

 

3. Creating A Database

• Create Tables & Columns
• Importing & Exporting
• Relations & Foriegn Keys
• Junction Tables

 

4. SQL Fundamentals

• Command Line & Inserting Data
• Basic Select Queries
• Updating & Deleting Data
• Aliases & Joins

 

5. Advanced SQL

• Union, Concat & Count
• Using The IN Clause
• Math & Subqueries
• Using Group By

 

6. PHP & MySQL

• PHP Fundamentals
• Template & MySQL Connect
• Select & Display With PHP
• Insert Data With PHP
• Update & Delete With PHP

Show more