Build your understanding of database fundamentals with MTA: Database Fundamentals

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.

View Entire Schedule

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

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

General office computer skills
Business knowledge around the use of database systems

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:

Request this course in a different delivery format.

Download Course Details

Cart () Loading...

Subtotal

MTA: Database Administration Fundamentals

Course Overview

Schedule

What You'll Learn

Outline