Log In
Join
for free
Log In
Join
for free
Back To Course Home
An Introductory Guide to SQL
0% completed
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
Untitled Masterpiece
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
Feedback
Quiz 7
Level up your interview prep. Join Educative to access 80+ hands-on prep courses.
Start Learning