AI Features

0% completed

All LessonsFree Lessons (6)

Introduction

Introduction Relational vs Non-Relational MySQL History & Architecture

Basic SQL

Exploring MySQL Create Database Data Types Create Table ... continue Temporary Table Collations & Character Sets Inserting Data Querying Data LIKE Operator Combining Conditions ORDER BY LIMIT Deleting Data TRUNCATE Updating Data Primary Key and Indexes ... continued Alterations Alter Index More on Alter Alias DISTINCT Aggregate Methods GROUP BY HAVING

Joins

Types of Joins Self Inner Join Inner Join Union Left and Right Joins Natural Join

Nested Queries

Nested Scalar Queries Nested Column Queries Nested Row Queries EXISTS Operator Correlated Queries

Multi Table Operations

Multi-Table Delete Multi-Table Update SELECT and INSERT REPLACE

Views

Creating a View Updating a View With Check Option Local & Cascaded Check Drop, Show, & Rename Views

Stored Procedures

What are Stored Procedures?Create, Delete, and Alter a Stored Procedure Variables Parameters Conditional Statements Iterative Statements Cursors Error Handling SIGNAL and RESIGNAL Stored Functions

Triggers

What are Triggers?Create and Delete a Trigger INSERT Triggers UPDATE Triggers DELETE Triggers Multiple Triggers

Miscellaneous

Transaction EXPLAIN Foreign Keys

Practice & Prep

Quiz 1 Quiz 2 Quiz 3 Quiz 4 Quiz 5 Quiz 6 Quiz 7 Quiz 8 Quiz 9 Quiz 10 Quiz 11 Quiz 12 Quiz 13 Quiz 14 Quiz 15 Quiz 16 Practice Set 1 Solution Practice Set 1 Practice Set 2 Solution Practice Set 2 Practice Set 3 Solution Practice Set 3 Practice Set 4 Solution Practice Set 4 Practice Set 5 Solution Practice Set 5 Practice Set 6 Solution Practice Set 6 Cheat Sheet

Epilogue

An Introductory Guide to SQL

Feedback

We'll cover the following...

Feedback

Feedback

We’d love to hear your ...