no prerequisites for this course.

Module 1: Understanding Core Database Concepts

• Understanding Database Concepts
• Understanding Relational Databases
• Understanding Data Manipulation Language
• Understanding Data Definition Language (DDL)

Module 2: Creating Database Objects

• Defining Data Types 
• Creating and Using Tables
• Creating Views
• Creating Sorted Procedures

Module 3: Manipulating Data

• Using Queries to Select Data
• Using Queries to Insert Data
• Updating Data and Databases
• Deleting Data

Module 4: Understanding Data Storage

• Normalizing a Database
• Understanding Primary, Foreign and Composites Key
• Understanding Clustered and Non-Clustered Indexes

Module 5:  Administrating a Database

• Securing Databases
• Backing Up and Restoring Databases

.Exam 98- 364

Course Days: 3 Days