40364 Database Administration Fundamentals
CLASS DATE(s):
7/6/2020 - 7/8/2020

COURSE LENGTH: 3 Days

COURSE COST: $1050.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

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.

AUDIENCE AND PREREQUISITES

The Microsoft Technology Associate (MTA) is Microsoft’s newest suite of technology certification exams that validate fundamental knowledge needed to begin building a career using Microsoft technologies. This program provides an appropriate entry point to a future career in technology and assumes some hands-on experience or training but does not assume on-the-job experience.

There are no prerequisites for this course.

  

*Course Cost listed does not include the cost of courseware or exam. Course is subject to a minimum enrollment to run. Course may run virtually as a Virtual Instructor-Led (VILT) class if the minimum enrollment is not met. If the course is under the minimum enrollment the course may run as 4 day class (Bootcamp Style). For more information, please contact learn@vtec.org or call 207-775-0244.

COURSE TOPICS:


Module 1: Understanding Core Database Concepts
Understanding Core Database Concepts
Understanding Data Manipulation
Understanding Data Definition Language
Lab

Module 2: Creating Database Objects
Understanding Database Concepts
Defining Data Manipulation
Understanding Data Definition Language
Lab

Module 3: Manipulating Data
Using Queries to Select Data
Using Queries to Insert Data
Updating Data and Databases
Deleting Data
Lab

Module 4: Understanding Data Storage
Normalizing a Database
Understanding Primary, Foreign, and Composite Keys
Understanding Clustered and Non-clustered Indexes
Lab

Module 5: Administering a Database
Securing Databases
Backing Up and Restoring Databases
Lab