1. Section1: Get Started البداية
معلومات
1.1 SQL Introduction
1.2 SQL Syntax
1.3 SQL Comments
1.4 SQL History and Versions
1.5 SQL vs NoSQL
2. Section2: Basic SQL Queries الاستعلامات الأساسية
معلومات
2.1 SELECT statement
2.2 WHERE clause (filtering data)
2.3 ORDER BY (sorting results)
2.4 DISTINCT (eliminating duplicates)
2.5 SQL AND
2.6 SQL NOT
2.7 SQL IN
2.8 SQL BETWEEN
2.9 SQL LIKE
2.10 SQL Wildcards
2.11 SQL NULL Values
2.12 SQL SELECT TOP
3. Section3: Data Manipulation معالجة البيانات
معلومات
3.1 INSERT INTO (adding data)
3.2 INSERT INTO SELECT (adding data
3.3 UPDATE (modifying data)
3.4 DELETE (removing data)
4. Section4: Aggregate Functions دوال التجميع
معلومات
4.1 Aggregate Functions Overview
4.2 MIN, MAX
4.3 Count
4.4 SUM
4.5 AVG
4.6 Group By
4.7 Having
5. Section5: Table Relationships and Joins
معلومات
5.1 JOIN OVERVIEW
5.2 INNER JOIN
5.3 LEFT JOIN
5.4 RIGHT JOIN
5.5 FULL OUTER JOIN
5.6 SELF JOIN
5.7 UNION, UNION ALL
6. Section6: Database and Table Management
معلومات
6.1 Create DB
6.2 Drop DB
6.3 Backup DB
6.4 Create Table
6.5 Drop Table
6.6 Alter Table
6.7 Dates
6.8 Injection
6.9 Hosting
6.10 Data Types
6.11 SELECT INTO
7. Section7: Constraints and Indexes
معلومات
7.1 Constraints
7.2 Not Null
7.3 UNIQUE
7.4 Primary Key
7.5 Foreign Key
7.6 Check
7.7 Default
7.8 Index
7.9 Auto Increment
7.10 Composite Key
7.11 Foreign Key Actions ON DELETE / ON UPDATE
7.12 Clustered, Non-Clustered Index
8. Section8: Advanced SQL Concepts
معلومات