Learn SQL from scratch in Arabic - for beginners

Learn SQL from Scratch in Arabic: A Comprehensive Guide!

This course provides a complete introduction to SQL (Structured Query Language) in Arabic, taking you from the very basics to more advanced concepts. We'll cover everything you need to know to effectively manage and query databases. The course is structured with clear sections and video lessons for easy understanding.

Module 1: Foundations of Databases

• Understanding Data Storage: Explore the difference between flat files and relational databases.
• Flat File Basics: Discover the advantages and disadvantages of using flat files for data storage.
• Database Fundamentals: Learn about databases and RDBMS (Relational Database Management Systems).
• What is SQL?: A detailed introduction to SQL and its role in data management.
• SQL Commands Overview: A brief overview of essential SQL commands.

Module 2: Setting Up Your SQL Environment

• Installing MS SQL Server 2019 & SSMS: Step-by-step instructions for downloading and installing MS SQL Server 2019 and SQL Server Management Studio (SSMS).
• Database Management:
  • CREATE database: Learn how to create new databases.
  • DROP database: Understand how to delete databases.
  • USE keyword: Using the USE command to select a database.
  • MDF vs LDF files: Understanding the role of MDF and LDF files in SQL Server.
  • SQL Server Transactions: Learn about transaction management in SQL Server.
  • NDF files: Understanding secondary data files.

Module 3: Table Design and Manipulation

• Creating Tables: Learn how to CREATE database tables.
• Modifying Tables:
  • DROP database table: Deleting tables.
  • ALTER database table: Modifying existing tables.
  • Adding Columns: Adding new columns to a table.
  • Dropping Columns: Removing columns from a table.
  • Altering Columns: Changing column properties.
• SQL Constraints: Ensure data integrity with various constraints:
  • NOT NULL: Preventing null values.
  • UNIQUE: Ensuring unique values.
  • PRIMARY KEY: Defining primary keys.
  • FOREIGN KEY: Establishing relationships between tables.
  • CHECK: Validating data based on specified conditions.
  • DEFAULT: Setting default values.
• Auto Increment: Implementing auto-incrementing columns.
• Constraint Naming: Best practices for naming constraints.
• Practical Exercises: Hands-on practice using constraints during table creation and modification.

Module 4: Data Manipulation Language (DML)

• Inserting Data: Insert a record into a table.
• Updating Data: Update a record in a table.
• Deleting Data: Delete a record from a table.
• Truncating Tables: Delete all records from a table using TRUNCATE TABLE.
• SELECT Statement: Retrieving data with the SELECT statement.
• SELECT DISTINCT Statement: Retrieving unique values.
• WHERE Clause: Filtering data with the WHERE clause.
• Logical Operators: Using AND, OR, and NOT in queries.
• Combining Operators: Combining logical operators for complex filtering.
• ORDER BY: Sorting results.
• Aliases: Using aliases for column and table names.

Module 5: SQL Subqueries

• Understanding Subqueries: What are subqueries in SQL?
• Subqueries in SELECT: Using subqueries in the SELECT statement.
• Subqueries in INSERT: Using subqueries in the INSERT statement.
• Subqueries in UPDATE: Using subqueries in the UPDATE statement.
• Subqueries in DELETE: Using subqueries in the DELETE statement.
• Advantages & Disadvantages: Understanding the pros and cons of using subqueries.

Module 6: SQL Joins

• What is a SQL Join?: Understanding the concept of SQL joins.
• Inner Join: Retrieving common rows from two tables.
• Left Join: Retrieving all rows from the left table and matching rows from the right table.
• Full Join: Retrieving all rows from both tables