Basic SQL Course in English pdf

1.SQL Server
o What is SQL?
o Importance of SQL in data management
o Overview of database concepts
2.Database Basics

o Types of databases (Relational vs. Non-
relational)

o Understanding tables, rows, and columns
o Primary keys and foreign keys
3.Installing SQL
o Setting up a local SQL environment
(MySQL, PostgreSQL, etc.)
o Using an SQL client (eg, MySQL
Workbench)

4.Basic SQL Commands
o The SELECT statement
o The where clause
o ORDER BY and LIMIT clauses
5.Filtering and Sorting Data
o Using different operators (AND, OR, NOT)
o Sorting data with ORDER BY
6.Aggregating Data
o Using aggregate functions (COUNT, SUM,
AVG, MAX, MIN)
o GROUP BY clause

3
o having clause
7.Joins
o INNER JOIN, LEFT JOIN, RIGHT JOIN,
FULL JOIN
o Understanding how to join tables
8.Subqueries
o Using subqueries in SELECT, INSERT,
UPDATE, DELETE
o Correlated subqueries
9.Data Manipulation
o INSERT, UPDATE, DELETE commands
o Using transactions and rollback
10. Data Definition Language (DDL)
o Creating and modifying tables (CREATE,
ALTER, DROP)
o Constraints (UNIQUE, NOT NULL,
CHECK)

11. Indexes and Views
o What are indexes and why are they
important?
o Creating and using views
12. SQL Functions
o Built-in functions (string, numeric, date
functions)
o User-defined functions

and more