Learn MySQL from scratch for Data Science and Analytics
Introduction
How to get Course Requirements
Getting Started On Windows, Linux or Mac
How To Ask Great Questions
FAQ’s
What is Source Code
Section Introduction
MySQL Server Installation
Connect MySQL Server Instance
MySQL Workbench Overview
Download and Restore Sample Database
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
Section Introduction
Insert Statement
Update Statement
Delete Statement
Section Introduction
CREATE Table Statement
DROP Statement
ALTER Statement
TRUNCATE Statement
COMMENT in Query
RENAME Table
Create Database User
GRANT Permissions
REVOKE Permissions
Section Introduction
SQL Statement Basic
SELECT Statement
SELECT DISTINCT
SELECT With Column Headings
Column AS Statement
DASHBOARD Analytics
SELECT WHERE Clause – Theory
SELECT WHERE Clause – Practical
Sum()
Min()-Max()
Order By statement
SELECT TOP 3 records
BETWEEN command
IN operator
Search Data using LIKE cards
Section Introduction
Group by – theory
Data Analytics with Group By
Having Statement
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
Section Introduction
Check Constraint
NOT NULL Constraint
UNIQUE Constraint
Creating Views
Data Analytic Views from multiple tables
Section Introduction
Timestamp
Extract from Timestamp
Mathematical Scalar Functions
String functions
Sub Queries
Advanced Functions
SELECT with Calculations
Create Stored Procedure
Stored procedure With Parameter
Drop Procedure
Section Introduction
Import .csv File
Export Data to .csv File
Section Introduction
Creating Database Backup
Restoring Database Backup