Brief about MTA 98-364, Database Administration Fundamentals Exam

Microsoft’s Technology Associate (MTA) Exam 98-364 Exam offers the fundamental knowledge needed to begin building a career using Microsoft technologies.

The MTA 98364 allows candidates to evaluate their knowledge and skills with databases and operations. This exam will expand the knowledge and skills of candidates in the following areas:

• core database concepts
• relational database concepts
• security requirements for databases and the data stored in them
• database objects, such as tables and views
• graphical tools and T-SQL scripts
• database queries
• stored procedures

Career Prospects

There are several career opportunities open to candidates who are MTA certified professional such as:

• Database developer
• Database Fundamentals

At the end of the Course candidates would be able to understand:

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

98-364 Course/Exam Objectives

Chapter 1: Understanding Core Database Concepts

• Understand how data is stored in tables
• Understand relational database concepts.
• Understand data manipulation language (DML)
• Understand data definition language (DDL).

Chapter 2: Creating Database Objects

• Choose data types
• Understand tables and how to create them.
• Create views.
• Create stored procedures and functions.

Chapter 3: Manipulating Data

• Select data
• Inserting data
• Updating data
• Deleting data

Chapter 4: Understanding Data Storage

• Understand normalization
• Understand primary, foreign, and composite keys.
• Understand indexes

Chapter 5: Administering a Database

• Understand database security concepts
• Understand database backups and restore

Exam Prerequisites

It is recommended that candidates be familiar with the concepts and have hands-on experience with the related technologies. However, job experience is not expected for the exam.

Preparation Materials

There are a few options candidates can avail to prepare for the exam. Firstly it is strongly recommended to have hands-on experience with the product. Secondly candidates can use the following training resources.

• Learning Plans and Classroom Training: MTA Exam 98-364 - this is a 3 day instructor led course.
• Practice Tests: candidates can find practice tests at Measure Up (Measureup.com).

Exam Registration

• Candidates affiliated with an academic institute can schedule their exam through the exam provider Certiport.
• Candidates who are not affiliated with an academic institute can schedule their exam through the exam provider Prometric.

Exam Details:

Published in August 2010 the exam technology used is Microsoft SQL Server 2008. It is available in English and is a proctored exam.

Click Here to find out more details about ExamCertify study material for 98-364 and get 15% discount.

ExamCertify offers 15% discount for 000-585 and Bas-004 and other IT Certifications material with instant download and 90 days free updates.