Skip to content
learn@aiera

Databases · advanced

SQL Advanced: CTEs, Windows and Performance

Write readable multi-step queries with CTEs, rank and compare rows with window functions, and learn how indexes, views and transactions work.

4 lessonsAbout 53 minFree
Start course

Not started

Finish every lesson, then sign in and pass the final assessment to earn a free certificate

Module 1: Powerful queries

  1. CTEs and Recursive Queries13 min · Up next
  2. Window Functions14 min · Not started

Module 2: Speed and safety

  1. Indexes and Query Plans12 min · Up next
  2. Views, Transactions and Triggers14 min · Not started

Questions about SQL Advanced: CTEs, Windows and Performance

What will I learn in SQL Advanced: CTEs, Windows and Performance?

Write readable multi-step queries with CTEs, rank and compare rows with window functions, and learn how indexes, views and transactions work. The course has 4 lessons, organised in 2 modules: Module 1: Powerful queries; Module 2: Speed and safety.

How long does SQL Advanced: CTEs, Windows and Performance take?

About 53 minutes in total, across 4 lessons. You can learn at your own pace and stop and continue any time.

Do I need experience to take SQL Advanced: CTEs, Windows and Performance?

You should be comfortable with the beginner and intermediate material first. If not, start with those courses.

Is SQL Advanced: CTEs, Windows and Performance free?

Yes. The whole course is free and you do not need an account to learn. A free account is only needed for the final assessment and the certificate.

Do I get a certificate for SQL Advanced: CTEs, Windows and Performance?

Yes, a free certificate of completion. Finish every lesson, sign in, and pass the 15-question final assessment with 80% or more. It is not an accredited qualification.