Skip to main content

CS403: Introduction to Modern Database Systems

Unit 8: Introduction to SQL
Structured Query Language (SQL) is the main data definition language used for the creation and maintenance of databases. In this unit, we will look at basic SQL syntax, including some data definition and data manipulation language commands.

Completing this unit should take you approximately 14 hours.
- Unit 8 Learning Outcomes Page
- 8.1: Overview
  - Stanford University: "Introduction to SQL" Page
    Watch this lecture.
  - 8.1.1: What Is SQL?
    W3Schools: "Introduction to SQL" URL
    Read this page for an introduction to the definition and function of Structured Query Language (SQL).
    Vrije Universiteit Brussel: Beat Signer's "Introduction to Databases" URL
    Read these slides.
  - 8.1.2: SQL Syntax
    W3Schools: "SQL Syntax" URL
    Read this page.
- 8.2: Data Definition Language (DDL) Commands
  - ProgrammingVideos: "Database, Table, Index" Page
    Watch this video.
  - 8.2.1: Create Table
    SQL Tutorial: "SQL CREATE TABLE" URL
    Read this tutorial to learn how to use SQL to create a database table.
  - 8.2.2: Drop Table
    SQL Tutorial: "SQL DROP TABLE" URL
    Read this tutorial to learn how to use SQL to delete data from a table and to remove the structure of the table.
    ProgrammingVideos: "Alter Drop" Page
    Watch this video.
  - 8.2.3: Alter Table
    SQL Tutorial: "SQL ALTER TABLE" URL
    Read this tutorial to learn how to use SQL to modify a database table.
- 8.3: Column and Table Level Constraints
  - 8.3.1: Not Null
    W3Schools: "SQL NOT NULL Constraint" URL
    Read this page.
  - 8.3.2: Unique
    W3Schools: "SQL UNIQUE Constraint" URL
    Read this page.
  - 8.3.3: Primary Key
    W3Schools: "SQL PRIMARY KEY Constraint" URL
    Read this page.
  - 8.3.4: Foreign Key
    W3Schools: "SQL FOREIGN KEY Constraint" URL
    Read this page.
  - 8.3.5: Default
    W3Schools: "SQL DEFAULT Constraint" URL
    Read this page.
  - 8.3.6: Check
    W3Schools: "SQL CHECK Constraint" URL
    Read this page.
- 8.4: Data Manipulation Language (DML) Commands
  - 8.4.1: Insert Operator and Command Syntax
    W3Schools: "SQL INSERT INTO Statement" URL
    Read this page.
    Stanford University: "Data Modification Statements" Page
    Watch this video.
    ProgrammingVideos: "Insert, Update, Delete" Page
    Watch this video.
  - 8.4.2: Update Operator and Command Syntax
    W3Schools: "SQL UPDATE Statement" URL
    Read this page.
  - 8.4.3: Delete Operator and Command Syntax
    W3Schools: "SQL DELETE Statement" URL
    Read this page.
  - 8.4.4: Select Operator and Command Syntax
    W3Schools: "SQL SELECT Statement" URL
    Read this page.