40364: Database Administration Fundamentals (MTA)

Can’t find the right date? Consider a self study option. Get immediate access to online training videos, course materials and exam prep guides. Check out our Microsoft Self Study Courses >>>.

All Prices Are in Candian Dollars

Price : CAD

Description

About this Course
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.

Audience Profile
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.

About this Course
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.

Audience Profile
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.

At Course Completion
After completing this course, students will be able to:

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

Prerequisites
There are no prerequisites for this course.

Module 1: Understanding Core Database Concepts
Database Concepts
Data Manipulation Language (DML)
Data Definition Language (DDL)

Module 2: Creating Database Objects
Key Terms
Data Types
Creating and Using Tables
Creating Views
Creating Stored Procedures

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

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

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

All search results