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 the 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- PDF files.

04:

1- CREATE database table.

2- DROP database table.

3- ALTER database table.

ADD column.

DROP COLUMN.

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 creating 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 a subquery in SQL?

2. Subquery in the SELECT statement.

3. Subquery in the INSERT statement.

4. Subquery in UPDATE statement.

5. Subquery in a 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.

Who this course is for:

• Computer science students.
• Those who are totally beginners in the programming field.