Section 1 : Introduction to databases, SQL, and MySQL
Lecture 1 Why SQL
Lecture 2 Why MySQL 00:01:57 Duration
Lecture 3 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 Setting up a connection 00:02:34 Duration
Lecture 3 Setting up a connection 00:02:34 Duration
Lecture 4 New Authentication Plugin - Creating a New User 00:06:18 Duration
Lecture 5 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 Creating a Database - Part II 00:02:22 Duration
Lecture 3 Introduction to data types 00:02:16 Duration
Lecture 4 String data types 00:05:01 Duration
Lecture 5 Integers 00:04:10 Duration
Lecture 6 Other useful data types 00:06:12 Duration
Lecture 7 Creating a table 00:05:17 Duration
Lecture 8 Using databases and tables 00:03:03 Duration
Lecture 9 Additional notes on using tables 00:02:12 Duration

Section 6 : MySQL constraints
Lecture 1 PRIMARY KEY constraint 00:05:23 Duration
Lecture 2 FOREIGN KEY constraint - Part I 00:05:25 Duration
Lecture 3 FOREIGN KEY constraint - Part II 00:05:26 Duration
Lecture 4 UNIQUE Constraint 00:05:01 Duration
Lecture 5 DEFAULT Constraint 00:05:24 Duration
Lecture 6 NOT NULL Constraint - Part I 00:05:53 Duration
Lecture 7 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

Section 9 : SQL SELECT statement
Lecture 1 SELECT - FROM 00:04:57 Duration
Lecture 2 WHERE 00:02:30 Duration
Lecture 3 AND 00:02:14 Duration
Lecture 4 OR 00:03:36 Duration
Lecture 5 Operator precedence 00:03:36 Duration
Lecture 6 IN - NOT IN 00:03:12 Duration
Lecture 7 LIKE - NOT LIKE 00:03:36 Duration
Lecture 8 Wildcard characters 00:01:45 Duration
Lecture 9 BETWEEN - AND 00:02:20 Duration
Lecture 10 IS NOT NULL - IS NULL 00:01:38 Duration
Lecture 11 Other comparison operators 00:04:30 Duration
Lecture 12 SELECT DISTINCT 00:02:06 Duration
Lecture 13 Introduction to aggregate functions
Lecture 14 ORDER BY 00:03:46 Duration
Lecture 15 GROUP BY 00:06:00 Duration
Lecture 16 Using Aliases (AS) 00:02:09 Duration
Lecture 17 HAVING
Lecture 18 WHERE vs HAVING- Part I 00:04:04 Duration
Lecture 19 WHERE vs HAVING- Part II 00:03:08 Duration
Lecture 20 LIMIT 00:04:52 Duration

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 Inserting data INTO a new table 00:03:56 Duration

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 The UPDATE Statement - Part II 00:02:55 Duration

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 DROP vs TRUNCATE vs DELETE 00:03:23 Duration

Section 13 : MySQL - Aggregate functions
Lecture 1 COUNT() 00:04:14 Duration
Lecture 2 SUM() 00:01:31 Duration
Lecture 3 MIN() and MAX() 00:01:15 Duration
Lecture 4 AVG() 00:01:58 Duration
Lecture 5 ROUND() 00:02:06 Duration
Lecture 6 IFNULL() and COALESCE() 00:06:25 Duration
Lecture 7 Another Example of Using COALESCE() 00:01:37 Duration

Section 14 : SQL Joins
Lecture 1 Introduction to JOINs 00:04:23 Duration
Lecture 2 INNER JOIN - Part I 00:06:03 Duration
Lecture 3 INNER JOIN - Part II 00:05:34 Duration
Lecture 4 A Note on Using Joins 00:04:10 Duration
Lecture 5 Duplicate Records 00:04:21 Duration
Lecture 6 LEFT JOIN - Part I 00:04:31 Duration
Lecture 7 LEFT JOIN - Part II 00:05:46 Duration
Lecture 8 RIGHT JOIN 00:04:31 Duration
Lecture 9 The new and the old join syntax 00:04:18 Duration
Lecture 10 JOIN and WHERE Used Together 00:02:54 Duration
Lecture 11 CROSS JOIN 00:07:42 Duration
Lecture 12 JOIN more than two tables in SQL 00:04:27 Duration
Lecture 13 Tips and tricks for joins 00:05:39 Duration
Lecture 14 UNION vs UNION ALL 00:05:45 Duration

Section 15 : SQL Subqueries
Lecture 1 SQL Subqueries with IN nested inside WHERE 00:04:32 Duration
Lecture 2 SQL Subqueries with EXISTS-NOT EXISTS nested insi 00:03:43 Duration
Lecture 3 SQL Subqueries nested in SELECT and FROM 00:07:57 Duration

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

Section 17 : SQL Views
Lecture 1 Views 00:07:13 Duration

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 Another way to create a procedure 00:03:19 Duration
Lecture 6 Stored procedures with an input paramete 00:06:29 Duration
Lecture 7 Stored procedures with an output parameter 00:03:20 Duration
Lecture 8 Variables 00:06:50 Duration
Lecture 9 User-defined functions in MySQL 00:06:14 Duration
Lecture 10 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 Indexes 00:07:27 Duration
Lecture 6 The CASE Statement 00:05:57 Duration

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

Section 21 : Combining SQL and Tableau - Task 1
Lecture 1 Task 1 00:05:33 Duration
Lecture 2 Task 1 SQL Solution
Lecture 3 Transferring a Dataset from SQL to Tableau 00:04:13 Duration
Lecture 4 Chart 1 Visualizing and Analyzing the Solution in 00:06:17 Duration
Lecture 5 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 SQL Solution 00:03:43 Duration
Lecture 3 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 SQL Solution 00:03:15 Duration
Lecture 3 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 Solution in SQL 00:02:48 Duration
Lecture 3 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