Free course · Programming
Advanced SQL
Joins, windows and the queries that actually answer the question.
- 5 lessons
- about 10 minutes (estimate)
- Taught by Ali
- Free
- Video in اردو
- Exercises in اردو
- 10 quiz questions
- 5 exercises
Watch the course walkthrough
اردو
That was a one-minute preview. The full course video is for signed-in learners. Sign in to watch it here, or create a free BvLogic ID; it takes a minute, and this course is added to it.
What you'll be able to do
- Combine tables without producing wrong numbers.
- Learn the most useful thing after joins.
- Write complex queries somebody can read.
- Diagnose and fix slow queries.
- Write SQL that can be relied on.
Course content
- 1 Joins, properly Combine tables without producing wrong numbers.
- 2 Window functions Learn the most useful thing after joins. Sign in to open
- 3 CTEs, subqueries and structure Write complex queries somebody can read. Sign in to open
- 4 Making queries fast Diagnose and fix slow queries. Sign in to open
- 5 Queries in production Write SQL that can be relied on. Sign in to open
When you want the whole trade
Data Analytics
Data Analytics
This free course is the introduction. The programme is taught by a trainer, marked by the academy, and carries the syllabus in full: the part an employer asks about.
See the full syllabus and fee