Relational Database Design and Implementation 101

This series provides an introduction to SQL Server 2005. You will be introduced to relational database concepts, relational database design as well the various components of SQL Server 2005. You will also walk through the steps of installation and understand the many tasks needed to manage and support your SQL Server implementation.

Total Time: 3 Hours 59 Minutes              Total Videos: 23

  • Lesson 1: Database Overview

    • Video 1.1: What is a database
      (Running Time: 11:09)

      In this video, you will be learn what a database is and specifically a relational database. You will understand the key features of a relational database management system and the many advantages of using relational databases to store your data.


    • Video 1.2: Understanding Database Tables and Records
      (Running Time: 11:13)

      This video will explain relational database concepts such as tables, columns and how to achieve and maintain data integrity using constraints.


    • Video 1.3: Relational Database Concepts
      (Running Time: 11:48)

      This video will explain important relational database concepts such as referential integrity and demonstrate how to use primary and foreign keys to relate tables in your database.


    • Video 1.4: Introduction to Normalization
      (Running Time: 11:34)

      The steps you take to achieve proper database design is called normalization. This video will explain the various steps of normalization and how it can help you achieve better database design.

  • Lesson 2: SQL Server 2005 Introduction

    • Video 2.1: SQL Server 2005 Overview
      (Running Time: 7:42)

      This video will provide an overview of the various editions of SQL Server 2005. The Enterprise, Standard, Workgroup, Express and Compact Editions will be discussed. You will learn the major differences between the editions and be able to choose the addition that best suits your needs.

    • Video 2.2: Overview of SQL Server 2005 Components
      (Running Time: 5:09)

      SQL Server 2005 is a relational database management system that includes many components and services. This video will provide an overview to the database engine, reporting services and analysis services.

  • Lesson 3: Installation and Management of SQL Server

    • Video 3.1: Installing SQL Server 2005
      (Running Time: 12:13)

      This video will walk you through all of the steps and decisions needed to install SQL Server 2005.

    • Video 3.2: Introduction to SQL Server Management Studio
      (Running Time: 6:18)

      This video will provide a brief introduction into SQL Server Management Studio and point on some of the most important features.

  • Lesson 4: Relational Database Design

    • Video 4.1: Introduction to Data Modeling and Entity-Relationship-Diagrams
      (Running Time: 11:41)

      Database Modeling is critical to creating a database that will stand the test of time. In this video, you will learn the first steps required in data modeling and begin creating an Entity-Relationship-Diagram.

    • Video 4.2: Diagramming Relationships using Entity-Relationship-Diagrams
      (Running Time: 15:19)

      This video will show you how to model the relationships between your entities using an Entity-Relationship-Diagram.

    • Video 4.3: Understanding Cardinality
      (Running Time: 9:11)

      When this video is complete, you will understand cardinality and be able to construct an Entity-Relationship-Diagram from beginning to end. Your data model will be complete in preperation for implementation.

  • Lesson 5: Creating and Working with Databases

    • Video 5.1: Creating Databases with SQL Server 2005 and SSMS
      (Running Time: 11:08)

      This video will demonstrate how to create a database in SQL Server Management Studio (SSMS) using the visual tools provided.

    • Video 5.2: Understanding System Databases
      (Running Time: 10:32)

      This video will explain the system databases that are included with SQL Server 2005. You will learn how each of the system databases are used and why they are important.

    • Video 5.3: Understanding Data Files, Log Files and Filegroups
      (Running Time: 11:53)

      This video will explain the concepts of Data Files, Log Files and Filegroups. You will learn how to identify the files associated with your database and how to manage log files for your database.

  • Lesson 6: Designing and Creating Tables

    • Video 6.1: Introdution to Data Types
      (Running Time: 11:07)

      This video will provide an introduction to Data Types in SQL Server 2005. You will understand why and how data types are used and be introduced to the wide variety of Data Types that are available.

    • Video 6.2: Creating and Implementing Tables
      (Running Time: 11:22)

      This video will demonstrate how to create tables in SQL Server 2005. You will also understand some important properties associated with tables that you should consider when creating and implementing tables on your own.

    • Video 6.3: Establishing Table Relationships
      (Running Time: 11:00)

      Defining the relationships between tables in your database will help you maintain data integrity and lead to more manageable data. This video will show you how to define relationships between tables using the visual tools within SQL Server Management Studio.

  • Lesson 7: Implement Attributes and Constraints

    • Video 7.1: Understanding and Implementing Default Constraints
      (Running Time: 7:15)

      Constraints are used to enforce business rules and this video will explain the different types of constraints that you can define within SQL Server 2005.

    • Video 7.2: Implementing Check Constraints
      (Running Time: 11:40)

      Check Constraints are used to validate data prior to saving data to your tables. You will learn how to create check constraints using the visual tools provided within SQL Server Management Studio.

    • Video 7.3: Creating and Using Unique Constraints
      (Running Time: 5:07)

      This video will show you how to implement Unique Constraints on columns in your tables using SQL Server Management Studio.

  • Lesson 8: Overview and Implementation of Indexes

    • Video 8.1: Introduction to Indexes
      (Running Time: 10:41)

      This video will explain what Indexes are and how they are used. You will understand the differences between Clustered and Non-Clustered indexes and we'll explore some common guidelines for using each type.

    • Video 8.2: Implementing and Using Indexes Effectively
      (Running Time: 14:26)

      This video will walk you through how to create indexes on your tables using the visual tools provided within SQL Server 2005. You will see how to create both clustered and non-clustered indexes and explore some additional properites for indexes as well.

  • Lesson 9: SQL Server 2005 Security

    • Video 9.1: Understanding Schemas and Identifiers
      (Running Time: 9:59)

      This video introduces you to the concept of identifiers and the rules required to name and reference your database objects.