30-days Money-Back Guarantee
CS Empire, Ahmed Hatem
Updated on Sep, 2026
Programming, Database and Design Development, SQL
Duration - 2.5 hours
Training 5 or more people ?
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
In this course, you will learn SQL basics from A to Z in Arabic!
The content of the course as in sections and videos;
1- What is the flat file?
2- Flat file VS relational database.
3- Flat file advantages.
4- Flat file disadvantages.
8- SQL commands in brief.
Download and install MS SQL server 2019 and SSMS
4- MDF VS LDF files.
5- SQL server transaction.
1- CREATE database table.
2- DROP database table.
3- ALTER database table.
3- constraint naming.
4- Practicing on using constraints in both creating table time and alter table.
Data manipulation language
4. delete all records.
6. SELECT statement.
7. SELECT DISTINCT statement.
9. AND, OR, and NOT.
10. Combining AND, OR, and NOT.
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.
1. What is SQL join?
Aggregation functions:
Microsoft SQL Server 2019
Create and drop database
Master database files
Secondary database files
SQL Server transaction
Create and drop database table
Alter database table (Add, drop & alter column)
Data manipulation language (dealing with records)
SELECT and SELECT DISTINCT
Aggregation functions (MIN, MAX, AVG, SUM, COUNT)
There are no perquisites to start this course, only a PC / laptop.
Check out the detailed breakdown of what’s inside the course
Use your certificate to make a career change or to advance in your current career.
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Master prominent technologies at full length and become a valued certified professional.