0

MySQL Tutorial

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
  • 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 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 LIMIT & OFFSET Tutorial with Examples

Most Dreaded Topics!

  • Tutorial
  • MySQL JOINS Tutorial: INNER, OUTER, LEFT, RIGHT, CROSS
  • 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
  • Top 50 SQL Interview Questions & Answers