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

Customized Onsite Training

3
Days
  • Customized Content
  • For Groups of 5+
  • Online or On-location
  • Expert Instructors

Live Online Training

$1,335.00
or 3 vouchers
  • Expert Instructors
  • Guaranteed to Run
  • 100% Free Re-take Option
  • 1-minute Video
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. 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.

Goals
  1. Learn to understand Core Database Concepts.
  2. Learn to create Database Objects.
  3. Learn to manipulate Data.
  4. Learn to understand Data Storage.
  5. Learn to administer a Database.
Outline
  1. Core Database Concepts
    1. Database Concepts
    2. Data Manipulation Language (DML)
    3. Data Definition Language (DDL)
  2. Creating Database Objects
    1. Key Terms
    2. Data Types
    3. Creating and Using Tables
    4. Creating Views
    5. Creating Stored Procedures
  3. Manipulating Data
    1. Using Queries to Select Data
    2. Using Queries to Insert Data
    3. Updating Data and Databases
    4. Deleting Data
  4. Data Storage
    1. Normalizing a Database
    2. Primary, Foreign, and Composite Keys
    3. Clustered and Non-Clustered Indexes
  5. Administering a Database
    1. Securing Databases
    2. Backing Up and Restoring Databases
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this SQL Server class:

  • There are no prerequisites for this course.
Preparing for Class
Certifications

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

81,519

Students who have taken Live Online Training

15,629

Organizations who trust Webucator for their training needs

100%

Satisfaction guarantee and retake option

9.40

Students rated our trainers 9.40 out of 10 based on 4,754 reviews

This course will get you thinking about new applications and uses for your SharePoint Site Collections. Well worth the time and money.

Andrew Motsinger, JEA

This training was the best of both worlds. I could attend without being totally and completely detached from my work environment. Yet, I could focus on the instruction and content easily due to the excellence of the instructor and the online presentation. It's the finest remote training that I've ever taken. I'd recommend it to anyone interested in learning new technologies and timely topics.

Greg Scarfo, Aspect Software, Inc
Chelmsford MA

The instructor was very patient and explained the lessons clearly.

Hang Vu, Promontory Interfinancial Network
Arlington VA

The instructor is awesome.

Ginger Loverde, MetroPCS
Norcross GA

Contact Us or call 1-877-932-8228