Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn to Build SQL Query | Ultimate SQL and DataBase Concepts
First Section
Introduction (3:57)
Fundamentals
Why SQL (2:15)
SELECT (7:52)
Arithmetic Expressions (6:13)
Building Blocks (8:22)
Conditioning Sorting and Operators
Writing Comparison Operators and Precedence (8:10)
Logical Operators (5:04)
Operator Precedence (2:45)
ORDER BY Clause (4:50)
Functions
Character Functions (11:44)
Numbers (3:36)
Dates (6:28)
Conversion (3:39)
General (4:11)
Nesting Functions (1:33)
Groups
Multiple Row Functions on Table (4:21)
Multiple Row Functions on Different Table (9:52)
Join
Primary Key and Foreign Key (9:11)
Joins (3:41)
Cartesian Product (3:05)
Equie Join Simple Join Self Join (10:06)
Non Equie Join (2:32)
Outer Join (3:23)
Self Join (5:32)
Bonus
For more
Building Blocks
Complete and Continue