Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

MTA: Database Administration Fundamentals

Build your understanding of database fundamentals.

GK# 7996 Vendor# M40364A

Course Overview

TOP

In this course, you will be introduced to database design and administration. You will gain an understanding of core database concepts, creation of database objects, manipulation of data, data storage, and administration of a database.

This course assists you in preparation for Microsoft Technology Associate Exam 98-364.

What You'll Learn

TOP
  • Data types
  • Data manipulation language
  • Database queries
  • Primary keys
  • Database backups.

Outline

TOP
Viewing outline for:

Virtual Classroom Live Outline

1. Core Database Concepts

  • Database Concepts
  • Data Manipulation Language (DML)
  • Data Definition Language (DDL)

2. Creating Database Objects

  • Key Terms
  • Data Types
  • Creating and Using Tables
  • Creating Views
  • Creating Stored Procedures

3. Manipulating Data

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

4. Data Storage

  • Normalizing a Database
  • Primary, Foreign, and Composite Keys
  • Clustered and Non-Clustered Indexes

5. Administering a Database

  • Securing Databases
  • Backing Up and Restoring Databases

Who Should Attend

TOP

Business or IT professionals who need to understand core database concepts and how databases can be used to store, manipulate, and analyze data

Course Delivery

This course is available in the following formats:

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 3 day

Request this course in a different delivery format.
Enroll