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

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

CERTESIAN Product or Cross Join

Query Exercise

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

String functions

Advanced functions

Sub Queries

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