Name		Name	Last commit message	Last commit date
Exercise 10: The BETWEEN Operator		Exercise 10: The BETWEEN Operator
Exercise 11: Logical Operators - NOT		Exercise 11: Logical Operators - NOT
Exercise 12: Join even more conditions		Exercise 12: Join even more conditions
Exercise 13: Use Text		Exercise 13: Use Text
Exercise 14: The Percentage Sign (%)		Exercise 14: The Percentage Sign (%)
Exercise 15: The Percentage Sign (%) Continued		Exercise 15: The Percentage Sign (%) Continued
Exercise 16: The Underscore Sign (_)		Exercise 16: The Underscore Sign (_)
Exercise 17: Looking for NOT NULL values		Exercise 17: Looking for NOT NULL values
Exercise 18: Looking For NULL Values		Exercise 18: Looking For NULL Values
Exercise 19: Comparisons With NULL		Exercise 19: Comparisons With NULL
Exercise 1: Get All Data		Exercise 1: Get All Data
Exercise 20: Basic Mathematical Operators		Exercise 20: Basic Mathematical Operators
Exercise 21: Put Your Skills Into Practice (1)		Exercise 21: Put Your Skills Into Practice (1)
Exercise 22: Join Tables on a Condition		Exercise 22: Join Tables on a Condition
Exercise 23: Joining Tables With JOIN		Exercise 23: Joining Tables With JOIN
Exercise 24: Display Specific Columns		Exercise 24: Display Specific Columns
Exercise 25: Refer to Columns Without Table Names		Exercise 25: Refer to Columns Without Table Names
Exercise 26: Rename Columns With AS		Exercise 26: Rename Columns With AS
Exercise 27: Filter Joined Tables		Exercise 27: Filter Joined Tables
Exercise 28: Filter Joined Tables Continued		Exercise 28: Filter Joined Tables Continued
Exercise 29: Put Your Skills Into Practice (2)		Exercise 29: Put Your Skills Into Practice (2)
Exercise 2: Select One Column		Exercise 2: Select One Column
Exercise 30: Further Practice		Exercise 30: Further Practice
Exercise 31: Sort the Rows - ORDER BY		Exercise 31: Sort the Rows - ORDER BY
Exercise 32: ORDER BY With Conditions		Exercise 32: ORDER BY With Conditions
Exercise 33: Ascending and Descending Orders		Exercise 33: Ascending and Descending Orders
Exercise 34: Sort By A Few Columns		Exercise 34: Sort By A Few Columns
Exercise 35: Select Distinctive Values		Exercise 35: Select Distinctive Values
Exercise 36: Select Distinctive Values in Certain Columns		Exercise 36: Select Distinctive Values in Certain Columns
Exercise 37: Count the Rows		Exercise 37: Count the Rows
Exercise 38: Count the Rows, Ignore the NULLS		Exercise 38: Count the Rows, Ignore the NULLS
Exercise 39: Count Distinctive Values in a Column		Exercise 39: Count Distinctive Values in a Column
Exercise 3: Select Many Columns		Exercise 3: Select Many Columns
Exercise 40: Find the Minimum and Maximum Value		Exercise 40: Find the Minimum and Maximum Value
Exercise 41: Find the Average Value		Exercise 41: Find the Average Value
Exercise 42: Find the Sum		Exercise 42: Find the Sum
Exercise 43: Group the Rows and Count Them		Exercise 43: Group the Rows and Count Them
Exercise 44: Find Min and Max Values in Groups		Exercise 44: Find Min and Max Values in Groups
Exercise 45: Find the Average Value in Groups		Exercise 45: Find the Average Value in Groups
Exercise 46: Group By a Few Columns		Exercise 46: Group By a Few Columns
Exercise 47: Filter Groups		Exercise 47: Filter Groups
Exercise 48: Filter Groups Continued		Exercise 48: Filter Groups Continued
Exercise 49: Order Groups		Exercise 49: Order Groups
Exercise 4: Select Only A Few Rows		Exercise 4: Select Only A Few Rows
Exercise 50: Put Your Skills Into Practice (3)		Exercise 50: Put Your Skills Into Practice (3)
Exercise 51: JOIN Revised		Exercise 51: JOIN Revised
Exercise 52: JOIN Columns Revised		Exercise 52: JOIN Columns Revised
Exercise 53: INNER JOIN		Exercise 53: INNER JOIN
Exercise 54: LEFT JOIN Explained		Exercise 54: LEFT JOIN Explained
Exercise 55: LEFT JOIN Again		Exercise 55: LEFT JOIN Again
Exercise 56: RIGHT JOIN Explained		Exercise 56: RIGHT JOIN Explained
Exercise 57: RIGHT JOIN Again		Exercise 57: RIGHT JOIN Again
Exercise 58: The Keyword OUTER		Exercise 58: The Keyword OUTER
Exercise 59: NATURAL JOIN		Exercise 59: NATURAL JOIN
Exercise 5: Conditional Operators		Exercise 5: Conditional Operators
Exercise 60: Table Aliases		Exercise 60: Table Aliases
Exercise 61: Aliases In Self-Joins		Exercise 61: Aliases In Self-Joins
Exercise 62: Joining More Tables		Exercise 62: Joining More Tables
Exercise 63: Get to Know Subqueries		Exercise 63: Get to Know Subqueries
Exercise 64: Subqueries With Various Logical Operators		Exercise 64: Subqueries With Various Logical Operators
Exercise 65: Subqueries With Functions		Exercise 65: Subqueries With Functions
Exercise 66: The Operator IN		Exercise 66: The Operator IN
Exercise 67: The Operator IN With Subqueries		Exercise 67: The Operator IN With Subqueries
Exercise 68: The Operator ALL		Exercise 68: The Operator ALL
Exercise 69: The Operator ANY		Exercise 69: The Operator ANY
Exercise 6: The Not Equal Sign (!=)		Exercise 6: The Not Equal Sign (!=)
Exercise 70: Get To Know Correlated Queries		Exercise 70: Get To Know Correlated Queries
Exercise 71: Aliases For Tables		Exercise 71: Aliases For Tables
Exercise 72: The Operator IN With Correlated Subqueries		Exercise 72: The Operator IN With Correlated Subqueries
Exercise 73: The Operator EXISTS		Exercise 73: The Operator EXISTS
Exercise 74: The Operator EXISTS With NOT		Exercise 74: The Operator EXISTS With NOT
Exercise 75: The Operator ALL In Correlated Subqueries		Exercise 75: The Operator ALL In Correlated Subqueries
Exercise 76: The Operator ANY In Correlated Subqueries		Exercise 76: The Operator ANY In Correlated Subqueries
Exercise 77: Subqueries in the FROM Clause (1)		Exercise 77: Subqueries in the FROM Clause (1)
Exercise 78: Subqueries in the FROM Clause (2)		Exercise 78: Subqueries in the FROM Clause (2)
Exercise 79: Subqueries in the SELECT Clause		Exercise 79: Subqueries in the SELECT Clause
Exercise 7: Conditional Operators and Selecting Columns		Exercise 7: Conditional Operators and Selecting Columns
Exercise 80: How UNION Works		Exercise 80: How UNION Works
Exercise 81: The Keyword UNION ALL		Exercise 81: The Keyword UNION ALL
Exercise 82: How INTERSECT Works		Exercise 82: How INTERSECT Works
Exercise 83: How EXCEPT Works		Exercise 83: How EXCEPT Works
Exercise 84: MINUS Instead of EXCEPT		Exercise 84: MINUS Instead of EXCEPT
Exercise 8: Logical Operators - OR		Exercise 8: Logical Operators - OR
Exercise 9: Logical Operators - AND		Exercise 9: Logical Operators - AND
Quiz: Task 1 - Selecting Rows From One Table		Quiz: Task 1 - Selecting Rows From One Table
Quiz: Task 2 - Selecting Rows From Multiple Tables		Quiz: Task 2 - Selecting Rows From Multiple Tables
Quiz: Task 3 - Aggregation and Grouping		Quiz: Task 3 - Aggregation and Grouping
Quiz: Task 4 - Sophisticated JOINs		Quiz: Task 4 - Sophisticated JOINs
Quiz: Task 5 - Subqueries		Quiz: Task 5 - Subqueries
Quiz: Task 6 - Set Operations		Quiz: Task 6 - Set Operations
Quiz: Task 7 - Challenge		Quiz: Task 7 - Challenge
README.md		README.md

Repository files navigation

Vertabelo-Academy---SQL-Essentials---SQL-Queries-Course

SQL Training course for work

About

SQL Training course for work

6 stars

1 watching

Report repository

Releases

Packages

Contributors