Course Highlights
  • 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
Curriculum

1 Topic
intro

4 Topics
What is a Database
MySQL Overview
Understanding Storage Engines
Understanding Data Types

5 Topics
Windows Installation
Linux Installation
Environment Setup With Xampp
PHPMyAdmin
MySQL Workbench Setup

3 Topics
Principles & Normalization
Database Design Process
Map Out Structure

4 Topics
Create Tables & Columns
Importing & Exporting
Relations & Foriegn Keys
Junction Tables

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

4 Topics
Union Concat & Count
Using The IN Clause
Math & Subqueries
Using Group By

7 Topics
PHP Fundamentals
Template & MySQL Connect
Select & Display With PHP
Insert Data With PHP
Update & Delete With PHP
Wrap up
Bonus Lecture: More Interesting Stuff Offers and Discounts

  Write a Review

Learn Database Design with MySQL

Go to Paid Course