Ενημερωση για COVID-19

Λόγω των έκτακτων μέτρων, από τις 07/11/2020 έως και την λήξη του lock down, σας ενημερώνουμε ότι η εταιρεία μας, συνεχίζει κανονικά την λειτουργία της αλλά με αποκλειστικά εξ’ αποστάσεως εκπαίδευση και με αναστολή μόνο όλων των εξετάσεων πιστοποίησης που παρέχουμε.
Το ωράριο λειτουργίας, διαμορφώνεται ως εξής: Δευτέρα έως Παρασκευή 09:00 - 20:00.

Microsoft

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

  • Duration: 3 days
  • Job Role:
  • Exam: 98-364

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

Share This Learning Path

Share on facebook
Share on linkedin
Share on twitter
Share on email
Need more info? Contact us

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

  • There are no prerequisites for this course.

Course outline

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 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 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 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 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​

  • Search Paths

  • Vendors

Latest Learning Paths​

Join our community of certified professionals

Sign Up to our newsletter, and stay always up to date with latest IT certifications

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

Facebook
Linkedin

Learn

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

Explore

Contact Us

International Computer Training Center

Copyright reserved to ICTC. Proudly Crafted by GTP Works

Choose how to get more info...

Give as a call

211 500 2 900

Let us, call you

Send us an email