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

Understand the impact of redundancy on storage overhead and data integrity risks.

Introduction to SQL

SQL SELECT

SQL Queries: SELECT, WHERE, AND, OR, NOT, and Strings

SQL ORDER BY, Aggregate functions, and GROUP BY

SQL CREATE, DESCRIBE, INSERT INTO, UPDATE and DELETE Tables

SQL Alter Table and Aliases

Data Redundancy

SQL Joins and Subqueries

SQL DATE, LIKE, and INDEX

Wrap Up

Data Redundancy

Identifying redundant data in the `SalesData` table

Introduction to SQL

SQL SELECT

SQL Queries: SELECT, WHERE, AND, OR, NOT, and Strings

SQL ORDER BY, Aggregate functions, and GROUP BY

SQL CREATE, DESCRIBE, INSERT INTO, UPDATE and DELETE Tables

SQL Alter Table and Aliases

Data Redundancy

SQL Joins and Subqueries

SQL DATE, LIKE, and INDEX

Wrap Up

Data Redundancy

Identifying redundant data in the SalesData table

Identifying redundant data in the `SalesData` table