SQL BootCamp – Learn MySQL for Data Analysis

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome

Lecture 2: Course Outline

Lecture 3: Introduction to SQL

Chapter 2: Environment Setup

Lecture 1: Downloading MySQL for Mac OS

Lecture 2: Downloading MySQL for windows OS

Lecture 3: Downloading sample database 1

Lecture 4: Downloading sample database 2

Chapter 3: ALL ABOUT SELECT

Lecture 1: What you will learn in this Section

Lecture 2: SELECT Using WHERE and DISTINCT

Lecture 3: SELECT Using WHERE and DISTINCT Cont.

Lecture 4: AND Operator 1

Lecture 5: AND Operator 2

Lecture 6: OR Operator

Lecture 7: NOT Operator

Lecture 8: AND, OR, NOT

Lecture 9: ARITHMETIC OPERATIONS

Lecture 10: COMPARISON OPERATIONS

Lecture 11: IN OPERATIONS

Lecture 12: BETWEEN OPERATOR

Lecture 13: LIKE OPERATOR 1

Lecture 14: LIKE OPERATOR 2

Lecture 15: ALIASES

Lecture 16: LIMIT, MAX AND MIN FUNCTIONS 1

Lecture 17: LIMIT, MAX AND MIN FUNCTIONS 2

Lecture 18: AVG, COUNT and SUM FUNCTIONS

Lecture 19: Using Order and Group By Clauses

Lecture 20: Using HAVING and ROLLUP CLAUSE

Lecture 21: Section Recap

Chapter 4: Functions

Lecture 1: All about Functions

Lecture 2: Cast and Convert

Lecture 3: Null Functions

Lecture 4: Using COALESCE

Lecture 5: DATE FUNCTION 1

Lecture 6: DATE FUNCTION 2

Lecture 7: DATE FUNCTIONS 3

Lecture 8: DATE CHALLENGE ANSWER

Lecture 9: Using CONCAT Function

Lecture 10: String Function – INSTRING

Lecture 11: String Function – LOWER and UPPER

Lecture 12: Replace and Trim

Lecture 13: SECTION RECAP

Chapter 5: SQL JOINS

Lecture 1: Section Intro

Lecture 2: Inner Join

Lecture 3: Left Join 1

Lecture 4: Left Join 2

Lecture 5: Right Join

Lecture 6: Cross Join

Lecture 7: Self Join 1

Lecture 8: Self Join 2

Lecture 9: SECTION RECAP

Chapter 6: SET OPERATORS

Lecture 1: Section Intro

Lecture 2: UNION OPERATOR

Lecture 3: FULL OUTER JOIN USING THE UNION OPERATOR

Lecture 4: FULL OUTER JOIN USING THE UNION OPERATOR 2

Lecture 5: INTERSECT OPERATOR

Lecture 6: MINUS OPERATOR

Lecture 7: SECTION RECAP

Chapter 7: ADVANCED SELECT STATEMENTS

Lecture 1: Section Intro

Lecture 2: CASE STATEMENT

Lecture 3: CASE STATEMENT 2

Lecture 4: SUBQUERY

Lecture 5: DERIVED TABLE 1

Lecture 6: DERIVED TABLE 2

Lecture 7: DERIVED TABLE 3

Lecture 8: Using EXISTS

Lecture 9: COMMON TABLE EXPRESSIONS (CTE)

Lecture 10: SECTION RECAP

Chapter 8: OTHER DML COMMANDS

Lecture 1: Section Intro

Lecture 2: INSERT STATEMENT

Lecture 3: INSERT INTO SELECT 1

Lecture 4: INSERT INTO SELECT 2

Lecture 5: UPDATE STATEMENT

Lecture 6: DELETE STATEMENT

Lecture 7: REPLACE STATEMENT

Lecture 8: SECTION RECAP

Chapter 9: Creating Databases and Tables

Lecture 1: Section Intro

Lecture 2: SQL Datatypes

Lecture 3: SQL Constraints

Lecture 4: Create Database and Table 1

Lecture 5: Create Database and Table 2

Lecture 6: Create Database and Table 3

Lecture 7: Create Table Like

Chapter 10: OTHER DDL COMMANDS

Lecture 1: Section Intro