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: Introduction
What this lesson is about…
Up to this point you have learned a lot about working with data using SQL. This lesson will focus on three topics:
- Subqueries
- Table Expressions
- Persistent Derived Tables
Both subqueries and table expressions are methods for being able to write a query that creates a table, and then write a query that interacts with this newly created table. Sometimes the question you are trying to answer doesn’t have an answer when working directly with existing tables in database.
However, if we were able to create new tables from the existing tables, we know we could query these new tables to answer our question. This is where the queries of this lesson come to the rescue.
If you can’t yet think of a question that might require such a query, don’t worry because you are about to see a whole bunch of them!
