Section 1 : Introduction to databases, SQL, and MySQL

lecture 1 About Certification Pdf
lecture 2 Why SQL
lecture 3 Why MySQL 1:57
lecture 4 Introduction to databases 4:44

Section 2 : SQL theory

lecture 5 SQL as a declarative language 2:11
lecture 6 Data definition language (DDL) 4:13
lecture 7 SQL keywords 1:12
lecture 8 Data manipulation language (DML) 4:55
lecture 9 Data control language (DCL) 5:3
lecture 10 Transaction control language (TCL 3:2

Section 3 : Basic database terminology

lecture 11 Relational database essentials 4:51
lecture 12 Databases vs spreadsheets 6:32
lecture 13 Database terminology 4:17
lecture 14 Relational schemas - Primary key 4:55
lecture 15 Relational schemas - Foreign key 4:59
lecture 16 Relational schemas - Unique key and null values 3:8
lecture 17 Relationships 4:39

Section 4 : Installing MySQL and getting acquainted with the interface

lecture 18 Installing MySQL 10:49
lecture 19 Additional note – Installing –Visual C Text
lecture 20 Installing MySQL on macOS and Unix systems Text
lecture 21 The Client-Server Model Text
lecture 22 Setting up a connection 2:34
lecture 22 Setting up a connection 2:34
lecture 23 Read me!!! Text
lecture 24 New Authentication Plugin - Creating a New User 6:18
lecture 25 Introduction to the MySQL interface 5:9

Section 5 : First steps in SQL

lecture 26 Creating a Database - Part I 5:12
lecture 27 SQL files Text
lecture 28 Creating a Database - Part I -exercise Text
lecture 29 Creating a Database - Part I -solution Text
lecture 30 Creating a Database - Part II 2:22
lecture 31 Creating a Database - Part II -exercise Text
lecture 32 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM Pdf
lecture 33 Introduction to data types 2:16
lecture 34 String data types 5:1
lecture 35 Integers 4:10
lecture 36 1 Fixed- and Floating-Point Data Types Pdf
lecture 37 Other useful data types 6:12
lecture 38 Creating a table 5:17
lecture 39 Creating a table - exercise Text
lecture 40 Creating a table - solution Text
lecture 41 Using databases and tables 3:3
lecture 42 Using databases and tables - exercise Text
lecture 43 Using databases and tables -solution Text
lecture 44 Additional notes on using tables 2:12
lecture 45 Additional notes on using tables - exercise Text

Section 6 : MySQL constraints

lecture 46 PRIMARY KEY constraint 5:23
lecture 47 PRIMARY KEY constraint -exercise Text
lecture 48 PRIMARY KEY constraint -solution Text
lecture 49 FOREIGN KEY constraint - Part I 5:25
lecture 50 FOREIGN KEY constraint - Part II 5:26
lecture 51 FOREIGN KEY constraint - Part II - exercise Text
lecture 52 FOREIGN KEY constraint - Part II - solution Text
lecture 53 UNIQUE Constraint 5:1
lecture 54 UNIQUE Constraint - exercise Text
lecture 55 DEFAULT Constraint 5:24
lecture 56 DEFAULT Constraint - exercise Text
lecture 57 DEFAULT Constraint - solution Text
lecture 58 NOT NULL Constraint - Part I 5:53
lecture 59 NOT NULL Constraint - Part I -exercise Text
lecture 60 NOT NULL Constraint - Part I - solution Text
lecture 61 NOT NULL Constraint - Part II 1:59

Section 7 : SQL best practices

lecture 62 Coding techniques and best practices - Part I 5:34
lecture 63 Coding techniques and best practices - Part II 4:11

Section 8 : Loading the 'employees' database

lecture 64 Loading the 'employees' database 1:37
lecture 65 Loading the 'employees' database Text

Section 9 : SQL SELECT statement

lecture 66 SELECT - FROM 4:57
lecture 67 SELECT - FROM - exercise Text
lecture 68 SELECT - FROM - solution Text
lecture 69 WHERE 2:30
lecture 70 WHERE - exercise Text
lecture 71 WHERE - solution Text
lecture 72 AND 2:14
lecture 73 AND - exercise Text
lecture 74 AND - solution Text
lecture 75 OR 3:36
lecture 76 OR - exercise Text
lecture 77 OR - solution Text
lecture 78 Operator precedence 3:36
lecture 79 Operator precedence - exercise Text
lecture 80 Operator precedence - solution Text
lecture 81 IN - NOT IN 3:12
lecture 82 IN - NOT IN - exercise 1 Text
lecture 83 IN - NOT IN - solution 1 Text
lecture 84 IN - NOT IN - exercise 2 Text
lecture 85 IN - NOT IN - solution 2 Text
lecture 86 LIKE - NOT LIKE 3:36
lecture 87 LIKE - NOT LIKE - exercise Text
lecture 88 LIKE - NOT LIKE - solution Text
lecture 89 Wildcard characters 1:45
lecture 90 Wildcard characters - exercise Text
lecture 91 Wildcard characters - solution Text
lecture 92 BETWEEN - AND 2:20
lecture 93 BETWEEN - AND - exercise Text
lecture 94 BETWEEN - AND- solution Text
lecture 95 IS NOT NULL - IS NULL 1:38
lecture 96 IS NOT NULL - IS NULL - exercise Text
lecture 97 IS NOT NULL - IS NULL - solution Text
lecture 98 Other comparison operators 4:30
lecture 99 Other comparison operators -exercise Text
lecture 100 Other comparison operators -solution Text
lecture 101 SELECT DISTINCT 2:6
lecture 102 SELECT DISTINCT - exercise Text
lecture 103 SELECT DISTINCT - solution Text
lecture 104 Introduction to aggregate functions
lecture 105 Introduction to aggregate Text
lecture 106 Introduction to aggregate functions - solution Text
lecture 107 ORDER BY 3:46
lecture 108 ORDER BY - exercise Text
lecture 109 ORDER BY - solution Text
lecture 110 GROUP BY 6:0
lecture 111 Using Aliases (AS) 2:9
lecture 112 Using Aliases (AS) - exercise Text
lecture 113 Using Aliases (AS) - solution Text
lecture 114 HAVING
lecture 115 HAVING - exercise Text
lecture 116 HAVING - solution Text
lecture 117 WHERE vs HAVING- Part I 4:4
lecture 118 WHERE vs HAVING- Part II 3:8
lecture 119 WHERE vs HAVING - Part II -exercise Text
lecture 120 WHERE vs HAVING - Part II -solution Text
lecture 121 LIMIT 4:52
lecture 122 LIMIT - exercise Text
lecture 123 LIMIT - solution Text

Section 10 : SQL INSERT statement

lecture 124 The INSERT statement - Part I
lecture 125 The INSERT statement - Part II 2:19
lecture 126 The INSERT statement -exercise 1 Text
lecture 127 The INSERT statement -solution 1 Text
lecture 128 The INSERT statement -exercise 2 Text
lecture 129 The INSERT statement -solution 2 Text
lecture 130 Inserting data INTO a new table 3:56
lecture 131 Inserting Data INTO a New Table - exercise Text
lecture 132 Inserting Data INTO a New Table - solution Text

Section 11 : SQL UPDATE Statement

lecture 133 TCL's COMMIT and ROLLBACK 2:42
lecture 134 The UPDATE Statement - Part I 3:18
lecture 135 ROLLBACK; ARTICLE Text
lecture 136 The UPDATE Statement - Part II 2:55
lecture 137 The UPDATE Statement – Part II - exercise Text
lecture 138 The UPDATE Statement – Part II - solution Text

Section 12 : SQL DELETE Statement

lecture 139 The DELETE Statement - Part I 4:14
lecture 140 The DELETE Statement - Part II 1:30
lecture 141 The DELETE Statement – Part II - exercise Text
lecture 142 The DELETE Statement – Part II - solution Text
lecture 143 DROP vs TRUNCATE vs DELETE 3:23

Section 13 : MySQL - Aggregate functions

lecture 144 COUNT() 4:14
lecture 145 COUNT() - exercise Text
lecture 146 COUNT() - solution Text
lecture 147 SUM() 1:31
lecture 148 SUM() - exercise Text
lecture 149 SUM() - solution Text
lecture 150 MIN() and MAX() 1:15
lecture 151 MIN() and MAX() - exercise Text
lecture 152 MIN() and MAX() - solution Text
lecture 153 AVG() 1:58
lecture 154 AVG() - exercise Text
lecture 155 AVG() - solution Text
lecture 156 ROUND() 2:6
lecture 157 ROUND() - exercise Text
lecture 158 ROUND() - solution Text
lecture 159 1 COALESCE() - Preamble Pdf
lecture 160 IFNULL() and COALESCE() 6:25
lecture 161 Another Example of Using COALESCE() 1:37
lecture 162 Another example of using COALESCE() - exercise 1 Text
lecture 163 Another example of using COALESCE() - solution 1 Text
lecture 164 Another example of using COALESCE() - exercise 2 Text
lecture 165 Another example of using COALESCE() - solution 2 Text

Section 14 : SQL Joins

lecture 166 Introduction to JOINs 4:23
lecture 167 Intro to JOINs - exercise 1 Text
lecture 168 Intro to JOINs - solution 1 Text
lecture 169 Intro to JOINs - exercise 2 Text
lecture 170 INNER JOIN - Part I 6:3
lecture 171 INNER JOIN - Part II 5:34
lecture 172 INNER JOIN - Part II - exercise Text
lecture 173 INNER JOIN - Part II - solution Text
lecture 174 A Note on Using Joins 4:10
lecture 175 Duplicate Records 4:21
lecture 176 LEFT JOIN - Part I 4:31
lecture 177 LEFT JOIN - Part II 5:46
lecture 178 LEFT JOIN - Part II - exercise Text
lecture 179 LEFT JOIN - Part II - solution Text
lecture 180 RIGHT JOIN 4:31
lecture 181 The new and the old join syntax 4:18
lecture 182 The new and the old join syntax - exercise Text
lecture 183 The new and the old join syntax - solution Text
lecture 184 JOIN and WHERE Used Together 2:54
lecture 185 Important – Prevent Error Code 1055! Text
lecture 186 JOIN and WHERE Used Together - exercise Text
lecture 187 JOIN and WHERE Used Together - solution Text
lecture 188 CROSS JOIN 7:42
lecture 189 CROSS JOIN - exercise 1 Text
lecture 190 CROSS JOIN - solution 1 Text
lecture 191 CROSS JOIN - exercise 2 Text
lecture 192 CROSS JOIN - solution 2 Text
lecture 193 JOIN more than two tables in SQL 4:27
lecture 194 1 JOIN More Than Two Tables in SQL Pdf
lecture 195 Join more than two tables in SQL - exercise Text
lecture 196 oin more than two tables in SQL - solution Text
lecture 197 Tips and tricks for joins 5:39
lecture 198 Tips and tricks for joins - exercise Text
lecture 199 Tips and tricks for joins -solution Text
lecture 200 UNION vs UNION ALL 5:45
lecture 201 UNION vs UNION ALL - exercise Text
lecture 202 UNION vs UNION ALL Text

Section 15 : SQL Subqueries

lecture 203 SQL Subqueries with IN nested inside WHERE 4:32
lecture 204 SQL Subqueries with IN nested inside WHERE - exerc Text
lecture 205 SQL Subqueries with IN nested inside WHERE - solut Text
lecture 206 SQL Subqueries with EXISTS-NOT EXISTS nested insi 3:43
lecture 207 SQL Subqueries with EXISTS-NOT EXISTS nested insid Text
lecture 208 SQL Subqueries with EXISTS-NOT EXISTS nested insid Text
lecture 209 SQL Subqueries nested in SELECT and FROM 7:57
lecture 210 SQL Subqueries nested in SELECT and FROM - exercis Text
lecture 211 SQL Subqueries nested in ELECT and FROM - solution Text
lecture 212 SQL Subqueries nested in SELECT and FROM - exercis Text
lecture 213 SQL Subqueries nested in SELECT and FROM -

Section 16 : SQL Self Join

lecture 214 Self Join 7:45

Section 17 : SQL Views

lecture 215 Views 7:13
lecture 216 Views - exercise Text
lecture 217 Views - solution Text

Section 18 : Stored routines

lecture 218 Introduction to stored routines 3:26
lecture 219 The MySQL syntax for stored procedures 4:32
lecture 220 Stored procedures - Example - Part I 2:45
lecture 221 Stored procedures - Example - Part II 4:49
lecture 222 Stored procedures - Example -Part II - exercise Text
lecture 223 Stored procedures - Example - Part II - solution Text
lecture 224 Another way to create a procedure 3:19
lecture 225 Stored procedures with an input paramete 6:29
lecture 226 Stored procedures with an output parameter 3:20
lecture 227 Stored procedures with an output parameter - exerc Text
lecture 228 Stored procedures with an output parameter - solu Text
lecture 229 Variables 6:50
lecture 230 Variables - exercise Text
lecture 231 Variables - solution Text
lecture 232 User-defined functions in MySQL 6:14
lecture 233 Error Code 1418. Text
lecture 234 User-defined functions in MySQL - exercise Text
lecture 235 User-defined functions in MySQL - solution Text
lecture 236 Stored routines - conclusion 3:55

Section 19 : Advanced SQL Topics

lecture 237 Types of MySQL Variables - Local Variables 4:56
lecture 238 Session Variables 5:21
lecture 239 Global Variables 2:18
lecture 240 User-Defined vs System Variables 4:13
lecture 241 MySQL+Triggers.sql
lecture 242 MySQL Triggers - exercise Text
lecture 243 MySQL Triggers - solution Text
lecture 244 MySQL Indexes 7:27
lecture 245 MySQL Indexes - exercise 1 Text
lecture 246 MySQL Indexes - solution 1 Text
lecture 247 MySQL Indexes - exercise 2 Text
lecture 248 MySQL Indexes - solution 2 Text
lecture 249 The CASE Statement 5:57
lecture 250 The CASE Statement - exercise 1 Text
lecture 251 The CASE Statement - solution 1 Text
lecture 252 The CASE Statement - exercise 2 Text
lecture 253 The CASE Statement - solution 2 Text
lecture 254 The CASE Statement - exercise 3 Text
lecture 255 The CASE Statement - solution 3 Text

Section 20 : Combining SQL and Tableau - Introduction

lecture 256 The Advantages of Software Integration 5:20
lecture 257 Why Combining SQL and Tableau is useful 4:54
lecture 258 Installing Tableau Public 1:51
lecture 259 Loading the 'employees_mod' Database 2:55
lecture 260 Loading the 'employees_mod' Database Text

Section 21 : Combining SQL and Tableau - Task 1

lecture 261 Task 1 5:33
lecture 262 Task 1 - Text Text
lecture 263 Important clarification! Text
lecture 264 Task 1 SQL Solution
lecture 265 Task 1 SQL Solution - Code Text
lecture 266 Transferring a Dataset from SQL to Tableau 4:13
lecture 267 Chart 1 Visualizing and Analyzing the Solution in 6:17
lecture 268 Chart 1 Visualizing and Analyzing the Solution in 5:25

Section 22 : Combining SQL and Tableau - Task 2

lecture 269 Task 2 3:50
lecture 270 Task 2 - Text Text
lecture 271 Task 2 SQL Solution 3:43
lecture 272 Task 2 SQL Solution - Code Text
lecture 273 Chart 2 Visualizing and Analyzing the Solution in 6:9

Section 23 : Combining SQL and Tableau - Task 3

lecture 274 Task 3 2:21
lecture 275 Task 3 - Text Text
lecture 276 Task 3 SQL Solution 3:15
lecture 277 Task 3 SQL Solution - Code Text
lecture 278 Chart 3 Visualizing and Analyzing the Solution in 4:57

Section 24 : Combining SQL and Tableau - Task 4

lecture 279 Task 4 2:46
lecture 280 Task 4 - Text Text
lecture 281 Task 4 Solution in SQL 2:48
lecture 282 Task 4 Solution in SQL - Code Text
lecture 283 Chart 4 Visualizing and Analyzing the Solution in 3:22

Section 25 : Combining SQL and Tableau - Task 5

lecture 284 Task 5 Organizing Charts 1-4 into a Beautiful Dash 6:4

Section 26 : Practice SQL – 10 Final Query Questions

lecture 285 Practice SQL – 10 Final Query Text