Course curriculum

  1. 01
    • Introduction

    • How to get Course Requirements

    • Getting Started On Windows, Linux or Mac

    • How To Ask Great Questions

    • FAQ’s

    • What is Source Code

  2. 02
    • Section Introduction

    • MySQL Server Installation

    • Connect MySQL Server Instance

    • MySQL Workbench Overview

    • Download and Restore Sample Database

  3. 03
    • Section Introduction

    • Overview of Databases

    • Creating Database

    • SQL Data Types

    • Column Data Types on Workbench

    • Creating Table

    • Overview of Primary and Foreign Key

    • Primary Key

    • Foreign Key

    • Creating Temporary tables

    • EER – Enhanced Entity Relationship Diagrams

  4. 04
    • Section Introduction

    • Insert Statement

    • Update Statement

    • Delete Statement

  5. 05
    • Section Introduction

    • CREATE Table Statement

    • DROP Statement

    • ALTER Statement

    • TRUNCATE Statement

    • COMMENT in Query

    • RENAME Table

  6. 06
    • Create Database User

    • GRANT Permissions

    • REVOKE Permissions

  7. 07
    • Section Introduction

    • SQL Statement Basic

    • SELECT Statement

    • SELECT DISTINCT

    • SELECT With Column Headings

    • Column AS Statement

    • DASHBOARD Analytics

  8. 08
    • SELECT WHERE Clause – Theory

    • SELECT WHERE Clause – Practical

  9. 09
    • Sum()

    • Min()-Max()

  10. 10
    • Order By statement

    • SELECT TOP 3 records

    • BETWEEN command

    • IN operator

    • Search Data using LIKE cards

  11. 11
    • Section Introduction

    • Group by – theory

    • Data Analytics with Group By

    • Having Statement

  12. 12
    • Overview of Joins

    • What are Joins

    • Inner Join

    • Left outer Join

    • Right outer Join

    • Union

    • Query Exercise

    • CERTESIAN Product or Cross Join

    • Solution for Query Exercise

  13. 13
    • Section Introduction

    • Check Constraint

    • NOT NULL Constraint

    • UNIQUE Constraint

  14. 14
    • Creating Views

    • Data Analytic Views from multiple tables

  15. 15
    • Section Introduction

    • Timestamp

    • Extract from Timestamp

    • Mathematical Scalar Functions

    • String functions

    • Sub Queries

    • Advanced Functions

    • SELECT with Calculations

  16. 16
    • Create Stored Procedure

    • Stored procedure With Parameter

    • Drop Procedure

  17. 17
    • Section Introduction

    • Import .csv File

    • Export Data to .csv File

  18. 18
    • Section Introduction

    • Creating Database Backup

    • Restoring Database Backup