• Home
  • Testing
  • SAP
  • Web
  • Must Learn!
  • Big Data
  • Live Projects
  • Blog

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 20 Best SQL Management Tools in 2018
Tutorial Top 50 SQL Interview Questions & Answers