Section summary | Coding Your Career

Autoplay
Autocomplete

Previous Lesson Complete and Continue

SQL Essentials

Introduction to SQL and Databases

Getting Setup for the Course (4:18)
Setting up the Northwind Database (5:36)
Basic Tour of MySQL Workbench (6:29)
Why MySQL Workbench? (2:40)

What is SQL?

What is Auto Increment (2:31)
Understanding SQL Data Types (7:24)
Understanding String Length and Varchar (3:40)
What Are Primary Keys (3:13)

SQL Queries – Retrieving Data

SELECT Statements (3:07)
SQL Data Types (7:17)
Filtering with WHERE (9:23)
BETWEEN and IN (7:23)
Using Order By (5:06)
Using the LIKE Operator (7:06)
Quiz
Section summary

Deep Dive into Aggregate Functions

Introduction to Aggregate Functions (8:32)
Advanced Aggregate Functions (9:45)
Using Group By (11:30)
Filtering With Having (8:56)
Quiz
Section summary

Working With Dates and Time

Intro to Working With Dates (5:34)
The DateAdd Function (6:17)
Formatting Dates (6:22)
The DateDiff Function (6:24)
Quiz
Section summary

Modifying Data

Creating Tables (7:42)
Altering a Table (6:55)
INSERT INTO Statement (7:02)
UPDATE Statement and DELETE (5:58)

Understanding Joins

Understanding Foreign Keys (9:20)
Introduction to Joins (11:50)
Example Usage of Joins (7:47)
LEFT JOIN (12:35)
RIGHT Join (6:25)
Self Joins (5:34)
Quiz
Section summary

Performing Subqueries

Introduction to Sub Queries (10:05)
Common Subquery Errors (4:24)
Derived Tables and Sub Queries (11:44)
Quiz
Section summary

Stored Procedures

Introduction to Stored Procedures (8:16)
Creating and Using Stored Procedures (7:24)
Quiz
Section summary

SQL Exam

SQL Exam Questions
SQL Exam Easy Questions Answers (6:42)
SQL Exam Medium Questions Answers Part 1 (10:21)
SQL Exam Medium Questions Answers Part 2 (5:37)
SQL Exam Hard Questions Answers Part 1 (12:03)
SQL Exam Hard Questions Answers Part 2 (19:49)

SQL Performance Optimization

Writing Efficient Queries (8:03)
Indexing for Performance (9:07)
Understanding Query Execution Plans (8:51)
Optimization Rules of Thumb (11:26)
Quiz
Section summary

Teach online with

Section summary

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock