Skip to main content

Course Content


Topic outline

  • Introduction

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

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

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