This module covers intermediate SQL concepts like SQL queries, SELECT query, SQL WHERE, SQL DISTINCT, SQL GROUP BY, SQL ORDER BY, SQL aggregate functions, SQL joins, and SQL subqueries.

Become a Database Professional with SQL

In this module, you will explore Structured Query Language (SQL), mastering its core concepts through hands-on projects. You’ll start with fundamental SQL queries like SELECT query, SQL WHERE, etc. and gradually progress to using SQL DISTINCT, SQL GROUP BY, SQL ORDER BY, and SQL aggregate functions. You'll learn how to create and manage tables, compute new fields, and optimize data relationships using foreign keys. By the end, you will be adept at using SQL joins, SQL subqueries, and merging techniques to generate comprehensive reports.

Learn SQL

Learn how storing derived fields in databases poses integrity and redundancy challenges.


تعرّف على كيفية تسبب تخزين الحقول المشتقة في قواعد البيانات في تحديات تتعلق بالسلامة والتكرار.

Managing Computed Attributes

إدارة السمات المحسوبة

Learn how storing derived fields in databases poses integrity and redundancy challenges.

Managing Computed Attributes

Challenges of storing derived fields