Section 1 : Introduction to databases, SQL, and MySQL
Lecture 1 About Certification
Lecture 2 Why SQL
Lecture 3 Why MySQL 00:01:57 Duration
Lecture 4 Introduction to databases 00:04:44 Duration

Section 2 : SQL theory
Lecture 1 SQL as a declarative language 00:02:11 Duration
Lecture 2 Data definition language (DDL) 00:04:13 Duration
Lecture 3 SQL keywords 00:01:12 Duration
Lecture 4 Data manipulation language (DML) 00:04:55 Duration
Lecture 5 Data control language (DCL) 00:05:03 Duration
Lecture 6 Transaction control language (TCL 00:03:02 Duration

Section 3 : Basic database terminology
Lecture 1 Relational database essentials 00:04:51 Duration
Lecture 2 Databases vs spreadsheets 00:06:32 Duration
Lecture 3 Database terminology 00:04:17 Duration
Lecture 4 Relational schemas - Primary key 00:04:55 Duration
Lecture 5 Relational schemas - Foreign key 00:04:59 Duration
Lecture 6 Relational schemas - Unique key and null values 00:03:08 Duration
Lecture 7 Relationships 00:04:39 Duration

Section 4 : Installing MySQL and getting acquainted with the interface
Lecture 1 Installing MySQL 00:10:49 Duration
Lecture 2 Additional note – Installing –Visual C
Lecture 3 Installing MySQL on macOS and Unix systems
Lecture 4 The Client-Server Model
Lecture 5 Setting up a connection 00:02:34 Duration
Lecture 6 Setting up a connection 00:02:34 Duration
Lecture 7 Read me!!!
Lecture 8 New Authentication Plugin - Creating a New User 00:06:18 Duration
Lecture 9 Introduction to the MySQL interface 00:05:09 Duration

Section 5 : First steps in SQL
Lecture 1 Creating a Database - Part I 00:05:12 Duration
Lecture 2 SQL files
Lecture 3 Creating a Database - Part I -exercise
Lecture 4 Creating a Database - Part I -solution
Lecture 5 Creating a Database - Part II 00:02:22 Duration
Lecture 6 Creating a Database - Part II -exercise
Lecture 7 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM
Lecture 8 Introduction to data types 00:02:16 Duration
Lecture 9 String data types 00:05:01 Duration
Lecture 10 Integers 00:04:10 Duration
Lecture 11 1 Fixed- and Floating-Point Data Types
Lecture 12 Other useful data types 00:06:12 Duration
Lecture 13 Creating a table 00:05:17 Duration
Lecture 14 Creating a table - exercise
Lecture 15 Creating a table - solution
Lecture 16 Using databases and tables 00:03:03 Duration
Lecture 17 Using databases and tables - exercise
Lecture 18 Using databases and tables -solution
Lecture 19 Additional notes on using tables 00:02:12 Duration
Lecture 20 Additional notes on using tables - exercise

Section 6 : MySQL constraints
Lecture 1 PRIMARY KEY constraint 00:05:23 Duration
Lecture 2 PRIMARY KEY constraint -exercise
Lecture 3 PRIMARY KEY constraint -solution
Lecture 4 FOREIGN KEY constraint - Part I 00:05:25 Duration
Lecture 5 FOREIGN KEY constraint - Part II 00:05:26 Duration
Lecture 6 FOREIGN KEY constraint - Part II - exercise
Lecture 7 FOREIGN KEY constraint - Part II - solution
Lecture 8 UNIQUE Constraint 00:05:01 Duration
Lecture 9 UNIQUE Constraint - exercise
Lecture 10 DEFAULT Constraint 00:05:24 Duration
Lecture 11 DEFAULT Constraint - exercise
Lecture 12 DEFAULT Constraint - solution
Lecture 13 NOT NULL Constraint - Part I 00:05:53 Duration
Lecture 14 NOT NULL Constraint - Part I -exercise
Lecture 15 NOT NULL Constraint - Part I - solution
Lecture 16 NOT NULL Constraint - Part II 00:01:59 Duration

Section 7 : SQL best practices
Lecture 1 Coding techniques and best practices - Part I 00:05:34 Duration
Lecture 2 Coding techniques and best practices - Part II 00:04:11 Duration

Section 8 : Loading the 'employees' database
Lecture 1 Loading the 'employees' database 00:01:37 Duration
Lecture 2 Loading the 'employees' database

Section 9 : SQL SELECT statement
Lecture 1 SELECT - FROM 00:04:57 Duration
Lecture 2 SELECT - FROM - exercise
Lecture 3 SELECT - FROM - solution
Lecture 4 WHERE 00:02:30 Duration
Lecture 5 WHERE - exercise
Lecture 6 WHERE - solution
Lecture 7 AND 00:02:14 Duration
Lecture 8 AND - exercise
Lecture 9 AND - solution
Lecture 10 OR 00:03:36 Duration
Lecture 11 OR - exercise
Lecture 12 OR - solution
Lecture 13 Operator precedence 00:03:36 Duration
Lecture 14 Operator precedence - exercise
Lecture 15 Operator precedence - solution
Lecture 16 IN - NOT IN 00:03:12 Duration
Lecture 17 IN - NOT IN - exercise 1
Lecture 18 IN - NOT IN - solution 1
Lecture 19 IN - NOT IN - exercise 2
Lecture 20 IN - NOT IN - solution 2
Lecture 21 LIKE - NOT LIKE 00:03:36 Duration
Lecture 22 LIKE - NOT LIKE - exercise
Lecture 23 LIKE - NOT LIKE - solution
Lecture 24 Wildcard characters 00:01:45 Duration
Lecture 25 Wildcard characters - exercise
Lecture 26 Wildcard characters - solution
Lecture 27 BETWEEN - AND 00:02:20 Duration
Lecture 28 BETWEEN - AND - exercise
Lecture 29 BETWEEN - AND- solution
Lecture 30 IS NOT NULL - IS NULL 00:01:38 Duration
Lecture 31 IS NOT NULL - IS NULL - exercise
Lecture 32 IS NOT NULL - IS NULL - solution
Lecture 33 Other comparison operators 00:04:30 Duration
Lecture 34 Other comparison operators -exercise
Lecture 35 Other comparison operators -solution
Lecture 36 SELECT DISTINCT 00:02:06 Duration
Lecture 37 SELECT DISTINCT - exercise
Lecture 38 SELECT DISTINCT - solution
Lecture 39 Introduction to aggregate functions
Lecture 40 Introduction to aggregate
Lecture 41 Introduction to aggregate functions - solution
Lecture 42 ORDER BY 00:03:46 Duration
Lecture 43 ORDER BY - exercise
Lecture 44 ORDER BY - solution
Lecture 45 GROUP BY 00:06:00 Duration
Lecture 46 Using Aliases (AS) 00:02:09 Duration
Lecture 47 Using Aliases (AS) - exercise
Lecture 48 Using Aliases (AS) - solution
Lecture 49 HAVING
Lecture 50 HAVING - exercise
Lecture 51 HAVING - solution
Lecture 52 WHERE vs HAVING- Part I 00:04:04 Duration
Lecture 53 WHERE vs HAVING- Part II 00:03:08 Duration
Lecture 54 WHERE vs HAVING - Part II -exercise
Lecture 55 WHERE vs HAVING - Part II -solution
Lecture 56 LIMIT 00:04:52 Duration
Lecture 57 LIMIT - exercise
Lecture 58 LIMIT - solution

Section 10 : SQL INSERT statement
Lecture 1 The INSERT statement - Part I
Lecture 2 The INSERT statement - Part II 00:02:19 Duration
Lecture 3 The INSERT statement -exercise 1
Lecture 4 The INSERT statement -solution 1
Lecture 5 The INSERT statement -exercise 2
Lecture 6 The INSERT statement -solution 2
Lecture 7 Inserting data INTO a new table 00:03:56 Duration
Lecture 8 Inserting Data INTO a New Table - exercise
Lecture 9 Inserting Data INTO a New Table - solution

Section 11 : SQL UPDATE Statement
Lecture 1 TCL's COMMIT and ROLLBACK 00:02:42 Duration
Lecture 2 The UPDATE Statement - Part I 00:03:18 Duration
Lecture 3 ROLLBACK; ARTICLE
Lecture 4 The UPDATE Statement - Part II 00:02:55 Duration
Lecture 5 The UPDATE Statement – Part II - exercise
Lecture 6 The UPDATE Statement – Part II - solution

Section 12 : SQL DELETE Statement
Lecture 1 The DELETE Statement - Part I 00:04:14 Duration
Lecture 2 The DELETE Statement - Part II 00:01:30 Duration
Lecture 3 The DELETE Statement – Part II - exercise
Lecture 4 The DELETE Statement – Part II - solution
Lecture 5 DROP vs TRUNCATE vs DELETE 00:03:23 Duration

Section 13 : MySQL - Aggregate functions
Lecture 1 COUNT() 00:04:14 Duration
Lecture 2 COUNT() - exercise
Lecture 3 COUNT() - solution
Lecture 4 SUM() 00:01:31 Duration
Lecture 5 SUM() - exercise
Lecture 6 SUM() - solution
Lecture 7 MIN() and MAX() 00:01:15 Duration
Lecture 8 MIN() and MAX() - exercise
Lecture 9 MIN() and MAX() - solution
Lecture 10 AVG() 00:01:58 Duration
Lecture 11 AVG() - exercise
Lecture 12 AVG() - solution
Lecture 13 ROUND() 00:02:06 Duration
Lecture 14 ROUND() - exercise
Lecture 15 ROUND() - solution
Lecture 16 1 COALESCE() - Preamble
Lecture 17 IFNULL() and COALESCE() 00:06:25 Duration
Lecture 18 Another Example of Using COALESCE() 00:01:37 Duration
Lecture 19 Another example of using COALESCE() - exercise 1
Lecture 20 Another example of using COALESCE() - solution 1
Lecture 21 Another example of using COALESCE() - exercise 2
Lecture 22 Another example of using COALESCE() - solution 2

Section 14 : SQL Joins
Lecture 1 Introduction to JOINs 00:04:23 Duration
Lecture 2 Intro to JOINs - exercise 1
Lecture 3 Intro to JOINs - solution 1
Lecture 4 Intro to JOINs - exercise 2
Lecture 5 INNER JOIN - Part I 00:06:03 Duration
Lecture 6 INNER JOIN - Part II 00:05:34 Duration
Lecture 7 INNER JOIN - Part II - exercise
Lecture 8 INNER JOIN - Part II - solution
Lecture 9 A Note on Using Joins 00:04:10 Duration
Lecture 10 Duplicate Records 00:04:21 Duration
Lecture 11 LEFT JOIN - Part I 00:04:31 Duration
Lecture 12 LEFT JOIN - Part II 00:05:46 Duration
Lecture 13 LEFT JOIN - Part II - exercise
Lecture 14 LEFT JOIN - Part II - solution
Lecture 15 RIGHT JOIN 00:04:31 Duration
Lecture 16 The new and the old join syntax 00:04:18 Duration
Lecture 17 The new and the old join syntax - exercise
Lecture 18 The new and the old join syntax - solution
Lecture 19 JOIN and WHERE Used Together 00:02:54 Duration
Lecture 20 Important – Prevent Error Code 1055!
Lecture 21 JOIN and WHERE Used Together - exercise
Lecture 22 JOIN and WHERE Used Together - solution
Lecture 23 CROSS JOIN 00:07:42 Duration
Lecture 24 CROSS JOIN - exercise 1
Lecture 25 CROSS JOIN - solution 1
Lecture 26 CROSS JOIN - exercise 2
Lecture 27 CROSS JOIN - solution 2
Lecture 28 JOIN more than two tables in SQL 00:04:27 Duration
Lecture 29 1 JOIN More Than Two Tables in SQL
Lecture 30 Join more than two tables in SQL - exercise
Lecture 31 oin more than two tables in SQL - solution
Lecture 32 Tips and tricks for joins 00:05:39 Duration
Lecture 33 Tips and tricks for joins - exercise
Lecture 34 Tips and tricks for joins -solution
Lecture 35 UNION vs UNION ALL 00:05:45 Duration
Lecture 36 UNION vs UNION ALL - exercise
Lecture 37 UNION vs UNION ALL

Section 15 : SQL Subqueries
Lecture 1 SQL Subqueries with IN nested inside WHERE 00:04:32 Duration
Lecture 2 SQL Subqueries with IN nested inside WHERE - exerc
Lecture 3 SQL Subqueries with IN nested inside WHERE - solut
Lecture 4 SQL Subqueries with EXISTS-NOT EXISTS nested insi 00:03:43 Duration
Lecture 5 SQL Subqueries with EXISTS-NOT EXISTS nested insid
Lecture 6 SQL Subqueries with EXISTS-NOT EXISTS nested insid
Lecture 7 SQL Subqueries nested in SELECT and FROM 00:07:57 Duration
Lecture 8 SQL Subqueries nested in SELECT and FROM - exercis
Lecture 9 SQL Subqueries nested in ELECT and FROM - solution
Lecture 10 SQL Subqueries nested in SELECT and FROM - exercis
Lecture 11 SQL Subqueries nested in SELECT and FROM -

Section 16 : SQL Self Join
Lecture 1 Self Join 00:07:45 Duration

Section 17 : SQL Views
Lecture 1 Views 00:07:13 Duration
Lecture 2 Views - exercise
Lecture 3 Views - solution

Section 18 : Stored routines
Lecture 1 Introduction to stored routines 00:03:26 Duration
Lecture 2 The MySQL syntax for stored procedures 00:04:32 Duration
Lecture 3 Stored procedures - Example - Part I 00:02:45 Duration
Lecture 4 Stored procedures - Example - Part II 00:04:49 Duration
Lecture 5 Stored procedures - Example -Part II - exercise
Lecture 6 Stored procedures - Example - Part II - solution
Lecture 7 Another way to create a procedure 00:03:19 Duration
Lecture 8 Stored procedures with an input paramete 00:06:29 Duration
Lecture 9 Stored procedures with an output parameter 00:03:20 Duration
Lecture 10 Stored procedures with an output parameter - exerc
Lecture 11 Stored procedures with an output parameter - solu
Lecture 12 Variables 00:06:50 Duration
Lecture 13 Variables - exercise
Lecture 14 Variables - solution
Lecture 15 User-defined functions in MySQL 00:06:14 Duration
Lecture 16 Error Code 1418.
Lecture 17 User-defined functions in MySQL - exercise
Lecture 18 User-defined functions in MySQL - solution
Lecture 19 Stored routines - conclusion 00:03:55 Duration

Section 19 : Advanced SQL Topics
Lecture 1 Types of MySQL Variables - Local Variables 00:04:56 Duration
Lecture 2 Session Variables 00:05:21 Duration
Lecture 3 Global Variables 00:02:18 Duration
Lecture 4 User-Defined vs System Variables 00:04:13 Duration
Lecture 5 MySQL+Triggers.sql
Lecture 6 MySQL Triggers - exercise
Lecture 7 MySQL Triggers - solution
Lecture 8 MySQL Indexes 00:07:27 Duration
Lecture 9 MySQL Indexes - exercise 1
Lecture 10 MySQL Indexes - solution 1
Lecture 11 MySQL Indexes - exercise 2
Lecture 12 MySQL Indexes - solution 2
Lecture 13 The CASE Statement 00:05:57 Duration
Lecture 14 The CASE Statement - exercise 1
Lecture 15 The CASE Statement - solution 1
Lecture 16 The CASE Statement - exercise 2
Lecture 17 The CASE Statement - solution 2
Lecture 18 The CASE Statement - exercise 3
Lecture 19 The CASE Statement - solution 3

Section 20 : Combining SQL and Tableau - Introduction
Lecture 1 The Advantages of Software Integration 00:05:20 Duration
Lecture 2 Why Combining SQL and Tableau is useful 00:04:54 Duration
Lecture 3 Installing Tableau Public 00:01:51 Duration
Lecture 4 Loading the 'employees_mod' Database 00:02:55 Duration
Lecture 5 Loading the 'employees_mod' Database

Section 21 : Combining SQL and Tableau - Task 1
Lecture 1 Task 1 00:05:33 Duration
Lecture 2 Task 1 - Text
Lecture 3 Important clarification!
Lecture 4 Task 1 SQL Solution
Lecture 5 Task 1 SQL Solution - Code
Lecture 6 Transferring a Dataset from SQL to Tableau 00:04:13 Duration
Lecture 7 Chart 1 Visualizing and Analyzing the Solution in 00:06:17 Duration
Lecture 8 Chart 1 Visualizing and Analyzing the Solution in 00:05:25 Duration

Section 22 : Combining SQL and Tableau - Task 2
Lecture 1 Task 2 00:03:50 Duration
Lecture 2 Task 2 - Text
Lecture 3 Task 2 SQL Solution 00:03:43 Duration
Lecture 4 Task 2 SQL Solution - Code
Lecture 5 Chart 2 Visualizing and Analyzing the Solution in 00:06:09 Duration

Section 23 : Combining SQL and Tableau - Task 3
Lecture 1 Task 3 00:02:21 Duration
Lecture 2 Task 3 - Text
Lecture 3 Task 3 SQL Solution 00:03:15 Duration
Lecture 4 Task 3 SQL Solution - Code
Lecture 5 Chart 3 Visualizing and Analyzing the Solution in 00:04:57 Duration

Section 24 : Combining SQL and Tableau - Task 4
Lecture 1 Task 4 00:02:46 Duration
Lecture 2 Task 4 - Text
Lecture 3 Task 4 Solution in SQL 00:02:48 Duration
Lecture 4 Task 4 Solution in SQL - Code
Lecture 5 Chart 4 Visualizing and Analyzing the Solution in 00:03:22 Duration

Section 25 : Combining SQL and Tableau - Task 5
Lecture 1 Task 5 Organizing Charts 1-4 into a Beautiful Dash 00:06:04 Duration

Section 26 : Practice SQL – 10 Final Query Questions
Lecture 1 Practice SQL – 10 Final Query