Başlanğıc Kod məhəlləsi

SQL

Verilənlərinizdən istədiyinizi soruşun.

SQL is the language of databases. Every post, like and game score in an app like Nova lives in database tables, and SQL is how you ask those tables questions. This track starts from zero: reading tables with SELECT, filtering and sorting, counting and grouping, joining tables, changing data safely, designing your own tables, and finally subqueries, CTEs and window functions.

Every lesson works with the same small dataset from Nova, a made-up social app (users, posts, likes and scores) and shows the exact result of every query, so you always know what answer to expect.

Dərslər: 25
Vaxt: 3 saat
Səviyyə: Başlanğıc

Kursa başla · What is a database?

Bu kursun dərsləri hələlik ingiliscədir.

Bürünc açıqdır
Gümüş açıqdır
Qızıl bağlıdır

Sübut etməyə hazırsınız?

Üç imtahan sizi gözləyir: Bürünc, Gümüş və Qızıl.

İmtahanlara keç

Nələri bacaracaqsınız

Read and filter any table with SELECT and WHERE
Summarize data with COUNT, SUM, AVG, GROUP BY and HAVING
Combine tables with INNER JOIN and LEFT JOIN
Insert, update and delete rows safely inside transactions
Design tables with keys, constraints and indexes
Build a leaderboard with subqueries, CTEs and window functions

Səyahət

1
Bölmə 1
Databases and tables

What a relational database is, how tables are built, and your first SELECT.

0 / 3
2
Bölmə 2
Filtering and sorting

Keep only the rows you want, handle NULL correctly and put results in order.

0 / 4
3
Bölmə 3
Aggregation

Turn many rows into answers: counts, totals, averages and groups.

0 / 3
4
Bölmə 4
Joins

Combine tables: match rows, keep the unmatched ones and find what is missing.

0 / 3
5
Bölmə 5
Changing data

Add, change and remove rows, and use transactions so mistakes can be undone.

0 / 4
6
Bölmə 6
Designing tables

Create tables with the right types, protect them with constraints and speed them up with indexes.

0 / 4
7
Bölmə 7
Powerful queries

Subqueries, EXISTS, CTEs, CASE and window functions for real leaderboards.

0 / 4