Skip to main content

Course Content


Topic outline

  • Introduction

    • page icon
      Page
      Installing SQL Server 2016 Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      How to Install SSMS Page
      Not available unless: Your Email address is not empty
  • Lessons

    • page icon
      Page
      Beginner Terms Part 1 Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      Beginner Terms Part 2 Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      Beginner Terms Part 3 Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      One-to-One Relationship Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      One-to-Many Relationship Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      Many-to-Many Relationship Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      Database Relationships Summary Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      Entity Integrity Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      Referential Integrity Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      Domain Integrity Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      Primary Key Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      Composite Key Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      Foreign Key Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      ON DELETE and ON UPDATE Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      Intro to Normalization Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      1NF Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      2NF Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      3NF Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      Normalization Summary Page
      Not available unless: Your Email address is not empty
  • Queries

    • page icon
      Page
      Intro to Queries Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      CREATE TABLE Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      Drop Table Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      PRIMARY KEY, NOT NULL, UNIQUE Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      How to Create FOREIGN KEY Constraints Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      Composite Primary Key Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      How to Name Constraints Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      How to INSERT Data Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      How to SELECT Data Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      How to Create an Alias with AS Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      Indexes Page
      Not available unless: Your Email address is not empty
    • page icon
      Page
      How to Create and Drop Indexes Page
      Not available unless: Your Email address is not empty