Traning Summary
MySQL is the most popular open-source database. This course starts with database basics, normalization and MySQL Workbench installation. Later it teaches MySQL commands like Select, Insert, Group By and advance topics like Wildcards & Functions.
What should I know?
The course is designed for MySQL beginners. No prior Database experience is required.
Syllabus
Database Fundamentals
| Tutorial | What is a database? & What is SQL? |
| Tutorial | MySQL Workbench Tutorial & MySQL Introduction |
Database Design
| Tutorial | Database Design Tutorial: Learn Data Modeling |
| Tutorial | What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples |
| Tutorial | What is ER(Entity-relationship) Modeling? Learn with Example |
SQL Basics
| Tutorial | MySQL Create Database & MySQL Data Types Tutorial |
| Tutorial | MySQL SELECT Statment with Examples |
| Tutorial | MySQL WHERE Clause with Examples - AND, OR, IN, NOT IN |
| Tutorial | MySQL query INSERT INTO Table with Examples |
| Tutorial | MySQL UPDATE & DELETE Query with Example |
Data Sorting
| Tutorial | Sorting in MySQL : ORDER BY, DESC and ASC |
| Tutorial | MySQL GROUP BY and HAVING Clause Tutorial |
| Tutorial | MySQL Wildcards Tutorial: Like, NOT Like, Escape, ( % ), ( _ ) |
| Tutorial | MYSQL Regular Expressions (REGEXP) with Syntax & Examples |
| Tutorial | MySQL Functions & Procedures:String, Numeric, Userdefined, Stored |
| Tutorial | MySQL Aggregate Functions Tutorial : SUM, AVG, MAX, MIN , COUNT, DISTINCT |
Must Know Stuff!
| Tutorial | MySQL IS NULL & IS NOT NULL Tutorial with Examples |
| Tutorial | MySQL AUTO_INCREMENT Tutorial with Examples |
| Tutorial | MYSQL - ALTER, DROP, RENAME, MODIFY |
| Tutorial | MySQL LIMIT & OFFSET Tutorial with Examples |
Most Dreaded Topics!
| Tutorial | MySQL SubQuery Tutorial with Examples |
| Tutorial | MySQL JOINS Tutorial: INNER, OUTER, LEFT, RIGHT, CROSS |
| Tutorial | MySQL UNION - Complete Tutorial |
| Tutorial | Views in MySQL Tutorial: Create, Join & Drop with Examples |
| Tutorial | MySQL INDEXES - Create, Drop & Add Index Tutorial |
| Tutorial | Your First Application using MySQL and PHP |