SQL for Data Analysis

Bootcamp AI

Curriculum

225 Lessons

Basic SQL

01. Video: SQL Introduction0:54
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 21:53
06. Video: How Databases Store Data00:00:00
07. Types of Databases
08. Video: Types of Statements00:00:00
09. Statements
10. Video: SELECT & FROM00:00:00
11. Your First Queries in SQL Workspace00:00:00
12. Solution: Your First Queries
13. Formatting Best Practices
14. Video: LIMIT00:00:00
15. Quiz: LIMIT
16. Solution: LIMIT
17. Video: ORDER BY00:00:00
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: WHERE00:00:00
24. Quiz: WHERE
25. Solutions: WHERE
26. Video: WHERE with Non-Numeric Data00:00:00
27. Quiz: WHERE with Non-Numeric
28. Solutions: WHERE with Non-Numeric
29. Video: Arithmetic Operators00:00:00
30. Quiz: Arithmetic Operators
31. Solutions: Arithmetic Operators00:00:00
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 100:00:00
45. Video: OR 200:00:00
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

Write a review

sql couser1
Free
Level
Beginner
Lectures
225 lectures
Language
English Español عربي 中国人

Enrolment validity: Lifetime

Wishlist 0
Open wishlist page Continue shopping