SQL for Data Analysis

Logo-2021-1
Bootcamp AI

Curriculum

220 Lessons

Basic SQL

01. Video: SQL Introduction0:54Preview
02. Video: The Parch & Posey Database0:48
03. Video + Text: The Parch & Posey Database0:52
04. Quiz: ERD Fundamentals
05. Video: Why SQL 11:20
05. Video: Why SQL 200:1:53
06. Video: How Databases Store Data0:45
07. Types of Databases
08. Video: Types of Statements0:59
09. Statements
10. Video: SELECT & FROM2:17
11. Your First Queries in SQL Workspace1:58
11.1 Practice – Your First Queries in SQL Workspace00:00:00
12. Solution: Your First Queries
13. Formatting Best Practices
14. Video: LIMIT1:10
15. Quiz: LIMIT
16. Solution: LIMIT
17. Video: ORDER BY1:13
18. Quiz: ORDER BY
19. Solutions: ORDER BY
20. Video: ORDER BY Part II00:00:00
21. Quiz: ORDER BY Part II
22. Solutions: ORDER BY Part II
23. Video: WHERE1:33
24. Quiz: WHERE
25. Solutions: WHERE
26. Video: WHERE with Non-Numeric Data0:43
27. Quiz: WHERE with Non-Numeric
28. Solutions: WHERE with Non-Numeric
29. Video: Arithmetic Operators1:10
30. Quiz: Arithmetic Operators
31. Solutions: Arithmetic Operators
32. Text: Introduction to Logical Operators
33. Video: LIKE00:00:00
34. Quiz: LIKE
35. Solutions: LIKE
36. Video: IN00:00:00
37. Quiz: IN
38. Solutions: IN
39. Video: NOT00:00:00
40. Quiz: NOT
41. Solutions: NOT
42. Video: AND and BETWEEN00:00:00
43. Quiz: AND and BETWEEN
44. Solutions: AND and BETWEEN
45. Video: OR 11:17
45. Video: OR 21:06
46. Quiz: OR
47. Solutions: OR
48. Text: Recap & Looking Ahead

SQL Joins

SQL Aggregations

SQL Subqueries & Temporary Tables

SQL Window Functions

SQL Advanced JOINS & Performance Tuning

Create a Git Repo

Review A Repo’s History

Add Commits to A Repo

Tagging, Branching, and Merging

Undoing Changes

Working With Remotes

Staying In Sync With A Remote Repository