Basic SQL
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 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 Workspace
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 II2:14
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: LIKE1:16
34. Quiz: LIKE
35. Solutions: LIKE
36. Video: IN0:52
37. Quiz: IN
38. Solutions: IN
39. Video: NOT1:17
40. Quiz: NOT
41. Solutions: NOT
42. Video: AND and BETWEEN1:33
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
02. Video: Why Would We Want to Split Data Into Separate Tables?0:31
02. Video: Why Would We Want to Split Data Into Separate Tables? 22:08
03. Video: Introduction to JOINs1:13
04. Text + Quiz: Your First JOIN
04.2 Text + Quiz: Your First JOIN
05. Solution: Your First JOIN
06. Text: ERD Reminder
07. Text: Primary and Foreign Keys
08. Quiz: Primary – Foreign Key Relationship
09. Text + Quiz: JOIN Revisited
10. Video: Alias0:43
11. Quiz: JOIN Questions Part I
12. Solutions: JOIN Questions Part I
13. Video: Motivation for Other JOINs1:06
14. Video: LEFT and RIGHT JOINs1:39
14. Video: LEFT and RIGHT JOINs 22:50
15. Text: Other JOIN Notes
16. LEFT and RIGHT JOIN
17. Solutions: LEFT and RIGHT JOIN
18. Video: JOINs and Filtering2:23
19. Quiz: Last Check
20. Solutions: Last Check
21. Text: Recap & Looking Ahead
SQL Aggregations
02. Video: Introduction to NULLs0:39
03. Video: NULLs and Aggregation1:36
04. Video + Text: First Aggregation – COUNT1:00
05. Video: COUNT & NULLs1:27
06. Video: SUM0:40
07. Quiz: SUM
08. Solution: SUM
09. Video: MIN & MAX0:30
10. Video: AVG0:49
11. Quiz: MIN, MAX, & AVG
12. Solutions: MIN, MAX, & AVG
13. Video: GROUP BY2:18
14. Quiz: GROUP BY
15. Solutions: GROUP BY
16. Video: GROUP BY Part II0:57
17. Quiz: GROUP BY Part II
18. Solutions: GROUP BY Part II
19. Video: DISTINCT0:53
20. Quiz: DISTINCT
21. Solutions: DISTINCT
22. Video: HAVING1:45
23. HAVING
24. Solutions: HAVING
25. Video: DATE Functions2:27
26. Video: DATE Functions II3:05
27. Quiz: DATE Functions
28. Solutions: DATE Functions
29. Video: CASE Statements3:54
30. Video: CASE & Aggregations00:00
31. Quiz: CASE
32. Solutions: CASE
33. Text: Recap
SQL Subqueries & Temporary Tables
02. Video: Introduction to Subqueries00:00
03. Video + Quiz: Write Your First Subquery00:00
04. Solutions: Write Your First Subquery
05. Text: Subquery Formatting
06. Video: More On Subqueries1:57
07. Quiz: More On Subqueries
08. Solutions: More On Subqueries
09. Solution Video: More On Subqueries6:32
10. Quiz: Subquery Mania
11. Solution: Subquery Mania00:00
12. Video: WITH0:52
12. Video: WITH 21:27
13. Text + Quiz: WITH vs. Subquery
14. Quiz: WITH
15. Solutions: WITH
16. Video: Subquery Conclusion00:00
SQL Window Functions
02. Video: Window Functions 12:46
03. Quiz: Window Functions 1
04. Solutions: Window Functions 1
05. Quiz: Window Functions 2
06. Solutions: Window Functions 2
07. Video: ROW_NUMBER & RANK00:00
08. Quiz: ROW_NUMBER & RANK
09. Solutions: ROW_NUMBER & RANK
10. Video: Aggregates in Window Functions00:00
11. Quiz: Aggregates in Window Functions
12. Solutions: Aggregates in Window Functions
13. Video: Aliases for Multiple Window Functions00:00
14. Quiz: Aliases for Multiple Window Functions
15. Solutions: Aliases for Multiple Window Functions
16. Video: Comparing a Row to Previous Row00:00
17. Quiz: Comparing a Row to Previous Row
18. Solutions: Comparing a Row to Previous Row
19. Video: Introduction to Percentiles00:00
20. Video: Percentiles00:00
21. Quiz: Percentiles
22. Solutions: Percentiles
23. Video: Recap00:00
SQL Advanced JOINS & Performance Tuning
02. Text + Images: FULL OUTER JOIN
03. Quiz: FULL OUTER JOIN
04. Solutions: FULL OUTER JOIN
05. Video: JOINs with Comparison Operators00:00
05. Video: JOINs with Comparison Operators 200:00
06. Quiz: JOINs with Comparison Operators
07. Solutions: JOINs with Comparison Operators
08. Video: Self JOINs00:00
09. Quiz: Self JOINs
10. Solutions: Self JOINs
11. Video: UNION00:00
11. Video: UNION 200:00
11. Video: UNION 300:00
11. Video: UNION 400:00
12. Quizzes: UNION
13. Solutions: UNION
14. Video: Performance Tuning Motivation0:34
15. Video + Quiz: Performance Tuning1:55
15. Video + Quiz: Performance Tuning 13:04
16. Video: Performance Tuning 200:00
17. Video: Performance Tuning 300:00
18. Video: JOINing Subqueries00:00
19. More Practice!
20. Video: SQL Completion Congratulations00:00
Create a Git Repo
01. Intro00:00
02. Create A Repo From Scratch
03. Clone An Existing Repo
05. Outro00:00
Review A Repo’s History
01. Intro00:00
02. Displaying A Repository’s Commits00:00
03. Changing How Git Log Displays Information00:00
03. Changing How Git Log Displays Information 200:00
04. Viewing Modified Files00:00
06. Viewing A Specific Commit
07. Outro00:00
Add Commits to A Repo
01. Intro00:00
04. Commit Messages
06. Having Git Ignore Files
07. Outro00:00
Tagging, Branching, and Merging
01. Intro00:00
02. Tagging00:00
03. Branching00:00
04. Branching Effectively00:00
05. Merging00:00
06. Merge Conflicts
07. Outro00:00
Undoing Changes
01. Intro00:00
02. Modifying The Last Commit
03. Reverting A Commit
04. Resetting Commits00:00
05. Lesson Outro00:00
06. Course Outro00:00
Working With Remotes
01. Intro00:00
02. Remote Repositories00:00
02. Remote Repositories 200:00
03. Add A Remote Repository00:00
04. Push Changes To A Remote00:00
05. Pulling Changes From A Remote00:00
05. Pulling Changes From A Remote 200:00
06. Pull vs Fetch00:00
06. Pull vs Fetch00:00
07. Lesson Wrap Up00:00
Staying In Sync With A Remote Repository
01. Intro00:00
02. Create a Pull Request00:00
03. Stay in sync with source project00:00
04. Manage an active PR
05. Squash Commits 100:00
05. Squash Commits 200:00
05. Squash Commits 300:00
06. Course Wrap Up00:00
Performance Testing
01. Video: SQL Introduction
