Learn SQL from scratch in Arabic - for beginners
In this course, you will learn SQL basics from A to Z in Arabic!
The content of the course as in sections and videos;
01:
1- What is flat file?
2- Flat file VS relational database.
3- Flat file advantages.
4- Flat file disadvantages.
5- Database.
6- RDBMS.
7- What is SQL?
8- SQL commands in brief.
02:
Download and install MS SQL server 2019 and SSMS
03:
1- CREATE database.
2- DROP database.
3- USE keyword.
4- MDF VS LDF files.
5- SQL server transaction.
6- NDF files.
04:
1- CREATE database table.
2- DROP database table.
3- ALTER database table.
ADD column.
DROP COLOMN.
ALTER COLUMN.
05:
1- SQL constraints
1.1- NOT NULL
1.2- UNIQUE
1.3- PRIMARY KEY
1.4- FOREIGN KEY
1.5- CHECK
1.6- DEFAULT
2- AUTO INCREMENT.
3- constraint naming.
4- Practicing on using constraints in both create table time and alter table.
06:
Data manipulation language
1. insert a record.
2. update a record.
3. delete a record.
4. delete all records.
5. truncate table.
6. SELECT statement.
7. SELECT DISTINCT statement.
8. WHERE clause.
9. AND, OR and NOT.
10. Combining AND, OR and NOT.
11. ORDER BY.
12. Aliases.
07:
SQL subqueries
1. What is subquery in SQL.
2. Subquery in SELECT statement.
3. Subquery in INSERT statement.
4. Subquery in UPDATE statement.
5. Subquery in DELETE statement.
6. Advantages & disadvantages of subqueries.
08:
SQL Joins:
1. What is SQL join?
2. Inner join.
3. Left join.
4. Full join
09:
Aggregation functions:
1. MIN()
2. MAX()
3. COUNT()
4. AVG()
5. SUM()
10:
1. GROUP BY
2. HAVING
3. LIKE
With exercises.
