MISSION 190

Building and Organizing Complex Queries

Learn techniques to organize your queries to make them easier to read and understand.

Objectives

  • Learn to format queries to make them readable.
  • Learn how use the WITH clause and views to organize your queries.
  • Learn how to use set operations to combine tables.

Mission Outline

1. Introduction
2. Writing Readable Queries
3. The With Clause
4. Creating Views
5. Combining Rows With Union
6. Combining Rows Using Intersect and Except
7. Multiple Named Subqueries
8. Challenge: Each Country's Best Customer
9. Next Steps
10. Takeaways

Course Info:

SQL Intermediate: Table Relations and Joins

Intermediate

The average completion time for this course is 10-hours.

This course requires a basic subscription and has six mission including two guided projects. It is the 12th course in the Data Analyst in Python path and Data Scientist in Python path.

START LEARNING FREE

Take a Look Inside

Share On Facebook
Share On Twitter
Share On Linkedin
Share On Reddit