Audience profile

The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.

Prerequisites

• This is a foundation-level course and therefore only requires general computer literacy.

Course outline

1. Introduction to Databases

• Relational databases
• Other types of databases
• Data analysis
• Database languages in SQL Server

2. Data Modeling

• Data modeling
• ANSI/SPARC database model
• Entity relationship modeling

3. Normalization

• Fundamentals of Normalization
• Normal from
• Denormalization

4. Relationships

• Introduction to relationships
• Planning referential integrity

5. Performance

• Indexing
• Query performance
• Concurrency

6. Database Objects

• Tables
• Views
• Stored procedures, triggers and functions

Lab 1: Exploring and querying SQL Server databases

Lab 2: Identify components in entity relationship modeling

Lab 3: Normalizing data

Lab 4: Planning and implementing referential integrity

Lab 5: Performance issues

Lab 6: Using SQL Server