Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL - FREE PREVIEW
Introduction to Databases, SQL, and MySQL
Welcome to SQL (0:26)
Welcome to the Course
Why SQL (3:17)
Why MySQL (1:57)
Introduction to Databases (4:44)
SQL Theory
SQL as a declarative language (2:10)
Data Definition Language (DDL) (4:12)
SQL Keywords (1:12)
Data Manipulation Language (DML) (4:55)
Data Control Language (DCL) (5:03)
Transaction Control Language (TCL) (3:02)
Basic Database Terminology
Relational Database Essentials (4:51)
Databases vs spreadsheets (7:05)
Database Terminology (4:17)
Relational Schemas: Primary Key (4:55)
Foreign Key (4:58)
Unique Key and Null Values (3:07)
Relationships (4:39)
Installing MySQL and Getting Acquainted with the Interface
Installing MySQL (10:48)
Additional note – Installing – Visual C
The Client-Server Model
Setting Up a Connection (2:34)
New Authentication Plugin - Creating a New User (6:18)
Introduction to the MySQL Interface (5:09)
Installing MySQL on macOS and Unix Systems
First Steps in SQL
Creating a Database - Part I (5:12)
Creating a Database - Part I - solution
Creating a Database - Part II (2:21)
Creating a Database - Part II - solution
Introduction to Data Types (2:16)
String Data Types (5:01)
Integers (4:10)
Fixed and Floating-Point Data Types (5:43)
Other Useful Data Types (6:12)
Creating a Table (5:16)
Creating a table - solution
Using Databases and Tables (3:03)
Using databases and tables - solution
Additional Notes on Using Tables (2:12)
A message from the instructors (1:01)
Get Full Access
MySQL Constraints
PRIMARY KEY Constraint
PRIMARY KEY Constraint - Solution
FOREIGN KEY Constraint - Part I
FOREIGN KEY Constraint - Part II
FOREIGN KEY constraint - Part II - solution
UNIQUE Constraint
DEFAULT Constraint
DEFAULT Contstraint - solution
NOT NULL Constraint - Part I
NOT NULL Constraint - Part I - solution
NOT NULL Constraint - Part II
SQL Best Practices
Coding Techniques and Best Practices - Part I
Coding Techniques and Best Practices - Part II
Loading the Data
Loading the 'employees' Database
Loading the 'employees' Database
SQL SELECT STATEMENT
SELECT… FROM…
SELECT - FROM - solution
WHERE
WHERE - solution
AND
AND - solution
OR
OR - solution
Operator Precedence
Operator precedence - solution
IN - NOT IN
IN - NOT IN - solution 1
IN - NOT IN - solution 2
LIKE - NOT LIKE
LIKE - NOT LIKE - solution
Wildcard Characters
Wildcard characters - solution
BETWEEN… AND…
BETWEEN... AND... solution
IS NOT NULL - IS NULL
IS NOT NULL - IS NULL - solution
Other Comparison Operators
Other comparison operators - solution
SELECT DISTINCT
SELECT DISTINCT - solution
ORDER BY
ORDER BY - solution
Introduction to Aggregate Functions
Introduction to aggregate functions - solution
GROUP BY
Using Aliases (AS)
Using Aliases (AS) - solution
HAVING
HAVING - solution
WHERE vs HAVING - Part I
WHERE vs HAVING - Part II
WHERE vs HAVING - Part II - solution
LIMIT
LIMIT - solution
SQL INSERT Statement
The INSERT Statement - Part I
The INSERT Statement - Part II
The INSERT Statement - exercise 1
The INSERT statement - solution 1
The INSERT Statement - exercise 2
The INSERT statement - solution 2
Inserting Data INTO a New Table
Inserting Data INTO a New Table - solution
SQL UPDATE Statement
TCL's COMMIT and ROLLBACK
The UPDATE Statement- Part I
The UPDATE Statement- Part II
The UPDATE Statement – Part II - solution
SQL DELETE Statement
The DELETE Statement - Part I
The DELETE Statement - Part II
The DELETE Statement – Part II - solution
DROP vs TRUNCATE vs DELETE
MySQL Aggregate Functions
COUNT()
COUNT() - solution
SUM()
SUM() - solution
MIN() and MAX()
MIN() and MAX() - solution
AVG()
AVG() - solution
ROUND()
ROUND() - solution
COALESCE() - Preamble
IFNULL() and COALESCE()
Another Example of Using COALESCE()
Another example of using COALESCE() - solution 1
Another example of using COALESCE() - solution 2
SQL JOINs
Introduction to JOINs
Intro to JOINs - solution 1
INNER JOIN - Part I
INNER JOIN - Part II
INNER JOIN - Part II - solution
A Note on Using Joins
Duplicate Records
LEFT JOIN - Part I
LEFT JOIN - Part II
LEFT JOIN - Part II - solution
RIGHT JOIN
The New and the Old Join Syntax
The new and the old join syntax - solution
JOIN and WHERE Used Together
JOIN and WHERE Used Together - solution
CROSS JOIN
CROSS JOIN - solution 1
CROSS JOIN - solution 2
Using Aggregate Functions with JOINs
JOIN more than Two Tables in SQL
Join more than two tables in SQL - solution
Tips and Tricks for JOINs
Tips and tricks for joins - solution
UNION vs UNION ALL
UNION vs UNION ALL - solution
SQL Subqueries
SQL Subqueries with IN nested inside WHERE
SQL Subqueries with IN nested inside WHERE - solution
SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE
SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - solution
SQL Subqueries nested in SELECT and FROM
SQL Subqueries nested in SELECT and FROM - solution 1
SQL Subqueries nested in SELECT and FROM - solution 2
SQL Self Join
SQL self join
SQL Views
Using SQL views
Views - solution
Stored Routines
Introduction to Stored Routines
The MySQL Syntax for Stored Procedures
Stored Procedures - Example - Part I
Stored Procedures - Example - Part II
Stored procedures - Example - Part II - solution
Another Way to Create a Procedure in MySQL
Stored Procedures with an Input Parameter
Stored Procedures with an Output Parameter
Stored procedures with an output parameter - solution
Variables
Variables - solution
User-Defined Functions in MySQL
User-defined functions in MySQL - solution
Stored Routines - Conclusion
Advanced SQL Topics
Types of MySQL Variables - Local Variables
Session Variables
Global Variables
User-Defined vs System Variables
MySQL Triggers
MySQL Triggers - solution
MySQL Indexes
MySQL Indexes - solution 1
MySQL Indexes - solution 2
The CASE Statement
The CASE Statement - solution 1
The CASE Statement - solution 2
The CASE Statement - solution 3
UNIQUE Constraint
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock