SQL Server 2014, Part 4 of 9: Designing and Creating a Database
Interactive

SQL Server 2014, Part 4 of 9: Designing and Creating a Database

BizLibrary
Updated Feb 04, 2020

Creating a database is not just inputting data into a computer and expecting a database to appear. This course will teach you the basics of relational database design principles. You will then see how to create a SQL Server database based on sound design principles. Then see how to build tables using the SQL Server Management Studio designers. You will learn about SQL Server data types, how to create constraints, triggers, and indexes. Then to finish up create a database diagram and define relationships to enforce referential integrity.


Lesson 1:

  • Database Design Principles
  • Origins of Relational Design
  • Key Terms
  • Relational Theory
  • Surrogate Keys
  • Demo: Sample Database
  • Data Normalization
  • First Normal Form
  • Demo: First Normal Form
  • Demo: Repeating Groups
  • Second Normal Form
  • Demo: Second Normal Form
  • Third Normal Form
  • Demo: Third Normal Form
  • Beyond Codd's Normal Forms.

Lesson 2:

  • Referential Integrity
  • One-to-Many Relationships
  • Many-to-Many Relationships
  • One-to-One Relationships
  • Enforcing
  • Cascading Updates and Deletes
  • Cascading Updates
  • Cascading Deletes
  • Cascading Actions
  • Beyond Normalization
  • Enforcing Business Rules.

Lesson 3:

  • Database Storage
  • Data Integrity
  • Recovery Models
  • Creating Databases
  • Demo: Creating Database
  • Demo: Database Options
  • Demo: File Groups
  • Rules for Identifiers
  • Modifying Database Options
  • Demo: Changing DB Options
  • Demo: Retrieve a Value
  • Creating Tables.

Lesson 4:

  • SQL Server Data Types
  • Data Types - Numeric
  • Data Types - Fractional
  • Data Types - Date and Time
  • Data Types - Date
  • Data Types - Binary
  • Data Types - Identifier
  • Data Types - sql_variant
  • Data Types - Variable only
  • Data Types - XML
  • Data Types - SQLCLR
  • Data Types - User-Defined
  • Demo: Data Types
  • Demo: Create Columns .

Lesson 5:

  • Demo: Computed Column
  • Demo: Saving Tables
  • Creating Constraints
  • Default Constraints
  • Demo: Default Constraints
  • Check Constraints
  • Demo: Check Constraints
  • Demo: Change Script
  • Demo: Run Constraint
  • Demo: Constraints on Columns .

Lesson 6:

  • Triggers
  • Creating Indexes
  • Demo: Creating Indexes
  • Demo: Index Options
  • Using Database Diagrams
  • Demo: Database Diagrams
  • Demo: Diagram
  • Demo: Create Relationships
  • Demo: Right Click Options.
;