SQL

Curriculum

• Introduction to Databases, SQL, and MySQL Free

  4 Lesson 14 Min
  Welcome to SQL Free Why SQL? Free Why MySQL? Free Introduction to databases Free
• SQL Theory Free

  6 Lesson 20 Min
  SQL as a declarative language Free Data definition language (DDL) Free SQL keywords Free Data manipulation language (DML) Free Data control language (DCL) Free Transaction control language (TCL) Free
• Basic Database Terminology Free

  7 Lesson 34 Min
  Relational database essentials Free Databases vs spreadsheets Free Database terminology Free Relational schemas - Primary key Free Relational schemas - Foreign key Free Relational schemas - Unique key and null values Free Relationships Free
• Installing MySQL and Getting Acquainted with the Interface

  8 Lesson 25 Min
  Installing MySQL Additional note – Installing – Visual C Installing MySQL on macOS and Unix systems The Client-Server Model Setting up a connection Important - Please read New Authentication Plugin - Creating a New User Introduction to the MySQL interface
• First Steps in SQL

  11 Lesson 40 Min
  Creating a Database - Part I SQL files Creating a Database - Part II Introduction to data types String data types Integers Fixed and floating-point data types Other useful data types Creating a table Using databases and tables Additional notes on using tables
• MySQL Constraints

  7 Lesson 33 Min
  PRIMARY KEY constraint FOREIGN KEY constraint - Part I FOREIGN KEY constraint - Part II UNIQUE Constraint DEFAULT Constraint NOT NULL Constraint - Part I NOT NULL Constraint - Part II
• SQL Best Practices

  2 Lesson 10 Min
  Coding techniques and best practices - Part I Coding techniques and best practices - Part II
• Loading the Data

  1 Lesson 2 Min
  Loading the 'employees' database
• SQL SELECT STATEMENT

  20 Lesson 70 Min
  SELECT… FROM… WHERE AND OR Operator Precedence IN - NOT IN LIKE - NOT LIKE Wildcard Characters BETWEEN… AND… IS NOT NULL - IS NULL Other Comparison Operators SELECT DISTINCT Introduction to Aggregate Functions ORDER BY GROUP BY Using Aliases (AS) HAVING WHERE vs HAVING - Part I WHERE vs HAVING - Part II LIMIT
• SQL INSERT Statement

  3 Lesson 12 Min
  The INSERT statement - Part I The INSERT statement - Part II Inserting Data INTO a New Table
• SQL UPDATE Statement

  3 Lesson 9 Min
  TCL's COMMIT and ROLLBACK The UPDATE Statement - Part I The UPDATE Statement - Part II
• SQL DELETE Statement

  3 Lesson 8 Min
  The DELETE Statement - Part I The DELETE Statement - Part II DROP vs TRUNCATE vs DELETE
• MySQL Aggregate Functions

  8 Lesson 19 Min
  COUNT() SUM() MIN() and MAX() AVG() ROUND() COALESCE() - Preamble IFNULL() and COALESCE() Another Example of Using COALESCE()
• SQL JOINs

  15 Lesson 73 Min
  Introduction to JOINs INNER JOIN - Part I INNER JOIN - Part II A Note on Using Joins Duplicate Records LEFT JOIN - Part I LEFT JOIN - Part II RIGHT JOIN The new and the old join syntax JOIN and WHERE Used Together CROSS JOIN Using Aggregate Functions with Joins JOIN more than two tables in SQL Tips and tricks for joins UNION vs UNION ALL
• SQL Subqueries

  3 Lesson 17 Min
  SQL Subqueries with IN nested inside WHERE SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE SQL Subqueries nested in SELECT and FROM
• SQL Self Join

  1 Lesson 8 Min
  SQL Self Join
• SQL Views

  1 Lesson 7 Min
  Using SQL views
• Stored Routines

  10 Lesson 45 Min
  Introduction to Stored Routines The MySQL syntax for stored procedures Stored Procedures - Example - Part I Stored Procedures - Example - Part II Another Way to Create a Procedure in MySQL Stored Procedures with an Input Parameter Stored Procedures with an Output Parameter Variables User-defined functions in MySQL Stored routines - conclusion
• Advanced SQL Topics

  8 Lesson 41 Min
  Types of MySQL Variables - Local Variables Session Variables Global Variables User-Defined vs System Variables MySQL Triggers - Preamble MySQL Triggers MySQL Indexes The CASE Statement