SQL Syllabus
Database Fundamentals
What is a Database? — Definition, Meaning, Types, Example
What is SQL? — Learn SQL Basics, SQL Full Form & How to Use
MySQL Workbench Tutorial for Beginners — How to Install MySQL Workbench & Use
Database Design
Database Design Tutorial — Learn Data Modeling
What is Normalization? — 1NF, 2NF, 3NF, BCNF Database Example
What is ER Modeling? — Learn with Example
SQL Basics
MySQL Create Table — How to Create Database in MySQL
MySQL SELECT Statement — Learn with Example
MySQL WHERE Clause — AND, OR, IN, NOT IN Query Example
MySQL INSERT INTO Query — How to add Row in Table (Example)
MySQL DELETE Query — How to Delete Row from a Table
MySQL UPDATE Query — Learn with Example Data Sorting
ORDER BY in MySQL — DESC & ASC Query with EXAMPLE
SQL GROUP BY and HAVING Clause — Learn with Example
MySQL Wildcards Tutorial — Like, NOT Like, Escape, ( % ), ( _ )
MYSQL Regular Expressions (REGEXP) — What is, Syntax and Examples
Functions:
MySQL Functions — String, Numeric, User-Defined, Stored
MySQL Aggregate Functions Tutorial — SUM, AVG, MAX, MIN , COUNT, DISTINCT
Must Know Stuff!
MySQL IS NULL & IS NOT NULL Tutorial — Learn with Example
MySQL AUTO_INCREMENT — Learn with Example
MYSQL – ALTER, DROP, RENAME, MODIFY — What is, Syntax with Examples
MySQL LIMIT & OFFSET — Learn with Example
Most Dreaded Topics!
MySQL SubQuery Tutorial — Learn with Example
MySQL JOINS Tutorial — INNER, OUTER, LEFT, RIGHT, CROSS
MySQL UNION — Complete Tutorial
MySQL Views — How to Create View from Tables with Examples
MySQL Index Tutorial — Create, Add & Drop