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