Back to Database Management System

SQL Basics

Get hands-on with SQL (Structured Query Language). Learn the core commands (DDL, DML, DCL, TCL) and how to write fundamental SELECT queries with filtering, sorting, and grouping.

2 weeks

Topics in this Chapter

1

Data Definition Language (DDL)

Learn to define and manage database structure with CREATE, ALTER, DROP.

2

Data Manipulation Language (DML)

Learn to manage data with INSERT, UPDATE, DELETE.

3

DCL & TCL

Understand data control (GRANT, REVOKE) and transaction control (COMMIT, ROLLBACK).

4

SELECT Queries

Master the fundamental SELECT statement to retrieve data.

5

WHERE, ORDER BY, GROUP BY

Learn to filter, sort, and group data in your queries.

6

Aggregate Functions

Learn to perform calculations on sets of data with COUNT, SUM, AVG, MAX, MIN.

GeekDost - Roadmaps & Snippets for Developers