Course 40364-A: Database Administration Fundamentals: MTA Exam 98-364

Microsoft

Course 40364-A: Database Administration Fundamentals: MTA Exam 98-364

Share This Learning Path

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.

Prerequisites

Course outline

Module 1: Understanding Core Database Concepts

Module Overview

In this module, you will understanding core database concepts.

Lessons

Understanding Database Concepts
Understanding Relational Databases
Understanding Data Manipulation Language
Understanding Data Definition Language (DDL)

Lab Sessions

Knowledge Assessment
Competency Assessment
Proficiency Assessment

Lab Lessons

Fill in the Blank
Multiple Choice
Considering Database Layout
Designing a Relational Database
Using Help from SQL Server 2008
Creating Databases Using the SSMS Graphical Interface

After completing this module, students will be able to:

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

Module 2: Creating Database Objects

Module Overview

In this module, you will learn how to creating database objects.

Lessons

Defining Data Types
Creating and Using Tables
Creating Views
Creating Stored Procedures

Lab Sessions

Knowledge Assessment
Competency Assessment
Proficiency Assessment

Lab Lessons

Fill in the Blank
Multiple Choice
Calculating the Size of a Table
Choosing Data Types
Understanding Tables and How to Create Them
Extracting Data from a Database

After completing this module, students will be able to:

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

Module 3: Manipulating Data

Module Overview

In this module, you will learn how to manipulating data.

Lessons

Using Queries to Select Data
Using Queries to Insert Data
Updating Data and Databases
Deleting Data

Lab Sessions

Knowledge Assessment
Competency Assessment
Proficiency Assessment

Lab Lessons

True or False
Fill in the Blank
Multiple Choice
Using the SELECT Command
Deleting Data from Tables
Manipulating Data Using SELECT and JOIN Statements
Manipulating Data Using INSERT and UPDATE Statements

After completing this module, students will be able to:

Select data.
Insert data.
Update data.
Delete data.

Module 4: Understanding Data Storage

Module Overview

In this module, you will understanding data storage.

Lessons

Normalizing a Database
Understanding Primary, Foreign and Composite Keys
Understanding Clustered and Non-Clustered Indexes

Lab Sessions

Knowledge Assessment
Competency Assessment
Proficiency Assessment

Lab Lessons

True or False
Fill in the Blank
Multiple Choice
Looking at 1NF
Comparing Clustered and Non-Clustered Indexes
Creating a Clustered Index
Creating a Clustered Index Using Transact-SQL

After completing this module, students will be able to:

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

Module 5: Administering a Database

Module Overview

In this module, you will learn how to administering a database.

Lessons

Securing Databases
Backing Up and Restoring Databases

Lab Sessions

Knowledge Assessment
Competency Assessment
Proficiency Assessment

Lab Lessons

True or False
Fill in the Blank
Multiple Choice
Looking at SQL Server Security
Using Full and Incremental Backups
Backing Up a Database
Restoring a Backup (Complete Restore)

After completing this module, students will be able to:

Understand database security concepts.
Understand database backups and restores.

Book Your Seat

Find Learning Paths

Latest Learning Paths

Microsoft

Course 50196-C: Microsoft Office SharePoint Server 2007 for the Site Owner/Power User

Microsoft

Course 55279-A: Introduction to Microsoft Access 2019

Microsoft

Course 55249-A: Developing with the SharePoint Framework

Join our community of certified professionals

About Us

ICTC is the leader in technical certification courses and exams. Our labs consist of a latest tech PCs and our instructors are certified from each vendor

Learn

View all the provided certifications and there relevant courses. Book online for a certification exam.

Contact Us

International Computer Training Center