Database Administration Fundamentals (Course Code 40364)

Candidates will learn Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database.

 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