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



This course is a stepping stone in obtaining your MCSA SQL Server 2012.

This course is NOT required to get your MCSA, nor does it count toward your MCSA.

This course assumes you have NO prior database experience. There are no prerequisites for this course.

Unsure if you may be over qualified for this course, the first course in a series of 3 for obtaining your MCSA SQL Server (Course 20461) prerequisites are:

  • Working knowledge of relational databases
  • Basic knowledge of the Microsoft Windows operating system and its core functionality
*This course is not eligible for use of Software Assurance Vouchers.

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. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam.


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.

Learning Objectives

After completing this course, students will be able to:

  • Understand Core Database Concepts
  • Create Database Objects
  • Manipulate Data
  • Understand Data Storage
  • Administer a Database

Course Outline

Module 1: Understanding Core Database Concepts

Module 2: Creating Database Objects

Module 3: Manipulating Data

Module 4: Understanding Data Storage

Module 5: Administering a Database