MOC 40364 - Database Administration Fundamentals: Training for MTA Exam 98-364

3 Days

This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database.

Goals
  1. Learn to understand Core Database Concepts.
  2. Learn to create Database Objects.
  3. Learn to manipulate Data.
  4. Learn to understand Data Storage.
  5. Learn to administer a Database.
Outline
  1. Core Database Concepts
    1. Database Concepts
    2. Data Manipulation Language (DML)
    3. Data Definition Language (DDL)
  2. Creating Database Objects
    1. Key Terms
    2. Data Types
    3. Creating and Using Tables
    4. Creating Views
    5. Creating Stored Procedures
  3. Manipulating Data
    1. Using Queries to Select Data
    2. Using Queries to Insert Data
    3. Updating Data and Databases
    4. Deleting Data
  4. Data Storage
    1. Normalizing a Database
    2. Primary, Foreign, and Composite Keys
    3. Clustered and Non-Clustered Indexes
  5. Administering a Database
    1. Securing Databases
    2. Backing Up and Restoring Databases
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this SQL Server class:

  • There are no prerequisites for this course.