SQL103 · Analytical Queries and Quality

Categories: Data & BI
Wishlist Share

About Course

Use CTEs and window functions, test query logic and explain performance trade-offs.

Advance · 8 hours · Part of the Program in SQL for Business Data Analysis

Lessons

  • Lesson 1 · CTEs to organize queries in steps
  • Lesson 2 · Window functions: rankings, comparisons and running totals
  • Lesson 3 · Testing query logic
  • Lesson 4 · Performance: execution plans, indexes and trade-offs

Self-paced, 12-month access. Questions are answered in writing through the student panel. A completion record is issued when you finish the course.

Next step

Continue with SQL104 · Commercial Analysis Project · 8 hours · $56.00

Continue to the next course

Prefer the whole program? Program in SQL for Business Data Analysis · $202.00 (10% less than buying the courses separately)

Course Content

SQL103 · Analytical Queries and Quality (8 h)
Use CTEs and window functions, test query logic and explain performance trade-offs.

  • Lesson 1 · CTEs to organize queries in steps
  • Lesson 2 · Window functions: rankings, comparisons and running totals
  • Lesson 3 · Testing query logic
  • Lesson 4 · Performance: execution plans, indexes and trade-offs
  • SQL103 Assessment · Analytical Queries and Quality
Scroll to Top