Tutorialspoint

Learn SQL from Scratch in Arabic - for Beginners

للمبتدئين SQL تعلم

  CS Empire,   Ahmed Hatem

   Development, Database Design & Development, SQL

Language - Arabic Published on 08/2022

Description

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.

What Will I Get ?

  • Microsoft SQL Server 2019

  • Create and drop database

  • Master database files

  • Log database files

  • Secondary database files

  • SQL Server transaction

  • Create and drop database table

  • Alter database table (Add, drop & alter column)

  • SQL constraints

  • Data manipulation language (dealing with records)

  • SELECT and SELECT DISTINCT

  • WHERE clause

  • AND, OR and NOT

  • ORDER BY

  • Aliases

  • SQL subqueries

  • SQL Joins

  • Aggregation functions (MIN, MAX, AVG, SUM, COUNT)

  • GROUP BY

  • HAVING

  • LIKE

Requirements

  • There are no perquisites to start this course, only a PC / laptop.

    Feedbacks (0)

  • No Feedbacks Posted Yet..!
Learn SQL from Scratch in Arabic - for Beginners
This Course Includes :

2.5 hours

13 Lectures

Lifetime Access

30-Days Money Back Guarantee

We make use of cookies to improve our user experience. By using this website, you agree with our Cookies Policy.