Lecturer
Dr. Shihab Hamad AL-Dulaimi
Related Course
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

Material File
Lecture-4-5.pdf