Free course · Programming
Advanced SQL
Joins, windows and the queries that actually answer the question.
- 5 lessons
- about 10 minutes (estimate)
- Free
- Video in اردو
- Exercises in اردو
- 10 quiz questions
- 5 exercises
- 1 graded lab
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.
Skills covered
- Database Design
- PostgreSQL
- SQL
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
Course lab
Graded lab · optional practice Find the wrong number in a chain store's sales report Open the lab →
When you want the whole trade
Data Analytics
Data Analytics
This free course is the introduction to the full Data Analytics programme. 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