MySQL Tutorial for Beginners Learn in 7 Days
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
- Tutorial
- Oracle MySQL 5.6 Certification with Study Guide
- Tutorial
- SQL vs MySQL: What's the Difference?
- Tutorial
- 20 Best SQL Management Tools
- Tutorial
- Top 50 SQL Interview Questions & Answers