مدرس المادة
Dr. Shihab Hamad AL-Dulaimi
المساق الجامعي
Database Management system
  1. Introduction to Introduction to SQL

    1. Data Definition Language (DDL)

    2. Data Manipulation Language (DML)

    3. Data Query Language (DQL)

  2.  Introduction to SQL Server

    1. SQL Server Management Studio

    2. Create a new Database

    3. The most important Queries in SQL

  3. CREATE TABLE

    1. Database Modelling

    2. Create Tables using the Designer Tools

    3. SQL Constraints

      1. PRIMARY KEY

      2. FOREIGN KEY

      3. NOT NULL / Required Columns

      4. UNIQUE

      5. CHECK

      6. DEFAULT

      7. AUTO INCREMENT or IDENTITY

  4. The INSERT INTO 

  5. The UPDATE

  6. The DELETE

  7. The SELECT

  8.  Summary

تحميل الملف
Lecture-4-5.pdf