SQL
اسأل بياناتك عن أي شيء.
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.
- الدروس
- ٢٥
- الوقت
- ٣ ساعة
- المستوى
- مبتدئ
دروس هذا المسار بالإنجليزية حاليًا.
- البرونز متاحة
- الفضة متاحة
- الذهب مقفلة
مستعد لإثبات نفسك؟
ثلاثة امتحانات في انتظارك: البرونز والفضة والذهب.
ما ستتمكن من فعله
- 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
الرحلة
١ الوحدة ١Databases and tables
What a relational database is, how tables are built, and your first SELECT.
٠ / ٣٢ الوحدة ٢Filtering and sorting
Keep only the rows you want, handle NULL correctly and put results in order.
٠ / ٤٣ الوحدة ٣Aggregation
Turn many rows into answers: counts, totals, averages and groups.
٠ / ٣٤ الوحدة ٤Joins
Combine tables: match rows, keep the unmatched ones and find what is missing.
٠ / ٣٥ الوحدة ٥Changing data
Add, change and remove rows, and use transactions so mistakes can be undone.
٠ / ٤٦ الوحدة ٦Designing tables
Create tables with the right types, protect them with constraints and speed them up with indexes.
٠ / ٤٧ الوحدة ٧Powerful queries
Subqueries, EXISTS, CTEs, CASE and window functions for real leaderboards.
٠ / ٤