1.1 34 - Select Statement Recap.txt
1. Select Statement Recap
2.1 35 - Select Distinct.txt
2. Select Distinct
3. Note on the JC BIKE DATA 22 Table
4.1 37 - Filtering Records with the WHERE Clause.txt
4.2 WHERE Clause.html
4. Filtering Records with the WHERE Clause
5.1 38 - Filtering Records Based on Multiple Conditions.txt
5.2 AND Operator.html
5.3 BETWEEN Operator.html
5.4 NOT Operator.html
5.5 OR Operator.html
5. Filtering Records Based on Multiple Conditions
6.1 39 - Filtering Records with the IN and LIKE Operators.txt
6.2 IN Operator.html
6.3 LIKE Operator.html
6. Filtering Records with the IN and LIKE Operators
7.1 40 - Deleting Records.txt
7.2 DELETE FROM Syntax.html
7. Deleting Records
8.1 Built In Functions Documentation.html
8. Databricks SQL Built In Functions Overview
9.1 42 - String Functions.txt
9.2 String Functions.html
9. String Functions
10.1 43 - Numerical Functions.txt
10.2 Numerical Functions.html
10. Numerical Functions
11.1 44 - Date and Timestamp Functions.txt
11.2 Date and Timestamp Functions.html
11.3 Datetime Patterns.html
11. Date and Timestamp Functions
12.1 45 - Converting Strings to DatesTimestamps.txt
12.2 Conversion Functions.html
12.3 Datetime Patterns.html
12.4 TO DATE.html
12.5 TO TIMESTAMP.html
12. Converting Strings to DatesTimestamps
13.1 46 - Conditional Functions.txt
13.2 CASE Expression.html
13.3 IF Function.html
13. Conditional Functions
14.1 47 - Aggregate Functions.txt
14.2 Aggregate Functions.html
14. Aggregate Functions
15.1 48 - Group By Clause.txt
15. Group By Clause
16.1 49 - Filtering Aggregated Tables with the Having Clause.txt
16.2 Having Clause.html
16. Filtering Aggregated Tables with the Having Clause
17. Joining Tables Overview
18.1 51 - Joining Tables Demo.txt
18.2 JOIN.html
18. Joining Tables Demo
19.1 52 - Order By and Limit Clauses.txt
19.2 Limit Clause.html
19.3 Order By Clause.html
19. Order By and Limit Clauses
20.1 53 - SQL Order of Execution.txt
20. SQL Order of Execution
21.1 54 - Subqueries.txt
21.2 Subqueries.html
21. Subqueries
22.1 55 - Views.txt
22.2 CREATE VIEW.html
22. Views
23.1 56 - Set Operators.txt
23.2 Set Operators.html
23. Set Operators
24.1 57 - SQL Challenge 1.txt
24. SQL Challenge 1
25.1 58 - SQL Challenge 2.txt
25. SQL Challenge 2
26.1 59 - SQL Challenge 3.txt
26. SQL Challenge 3
27.1 60 - SQL Challenge 4.txt
27. SQL Challenge 4
28.1 61 - SQL Challenge 5.txt
28. SQL Challenge 5
29. Schema Clean Up
