What you'll learn
- 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 have a PC / laptop.
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 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.
Who this course is for:
- Computer science students.
- Those who are totally beginners in programming field.
Instructors
- 4.5 Instructor Rating
- 181 Reviews
- 9,301 Students
- 4 Courses
CS Empire is a leading provider of software solutions and training services that are designed to help individuals and organizations stay ahead in the ever-evolving tech landscape. Our courses cover a wide range of programming languages and concepts, all taught in Arabic and with a focus on delivering high-quality content at an affordable cost.
Whether you're looking to learn a new programming language or improve your existing skills, our team of expert instructors is here to help. With CS Empire, you'll have access to a wealth of knowledge and resources that can help you achieve your goals and take your career to the next level.
So why wait? Sign up for one of our courses today and start building the skills you need to succeed in the fast-paced world of tech.
- 4.5 Instructor Rating
- 181 Reviews
- 9,301 Students
- 4 Courses
I am Ahmed Hatem, a Computer Science graduate and currently pursuing my Pre-Master’s in Data Science at Helwan University. Passionate about software development, data science, and technical training, I strive to make complex topics accessible through structured, engaging learning experiences.
My journey includes:
- Pre-Master’s Student in Data Science – Helwan University
- Former trainee at the Ministry of Communication and Information Technology (MCIT)
- Former technical core-team member at Google Developer Student Club – Helwan University (GDSC-HU)
- Former trainee at the National Technology Institute (NTI)
- Former trainer at the Helwan ICPC Community
I have hands-on experience with C, C++, C#, Java, HTML, CSS, Data Structures, and Algorithms, with a strong foundation in problem-solving and software development.
My passion is helping learners bridge the gap between theory and real-world applications, making technology more approachable for everyone. Join me on Udemy as we explore programming, data science, and cutting-edge technologies together!