Microsoft Technology Associate (MTA) - Database Fundamental

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.

Summary

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.

Audience Profile

MTA certification is the gateway to advanced Microsoft Certifications. For those individuals with little exposure to foundational technology concepts, MTA provides that essential “first step”, and the baseline understanding that they need to successfully pursue MCSA, MCSE and MCSD credentials.

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.

Find even more details on the Microsoft website. Click here

Module 1: Understanding Core Database Concepts
  • Understanding Database Concepts
    • Understanding Flat-Type Databases
    • Understanding Hierarchical Databases
    • Understanding Relational Databases
    • Understanding Database Fundamentals
    • Understanding Relational Database Concepts
    • Using the SQL Server Management Studio Interface
  • Understanding Data Manipulation
  • Language (DML)
  • Understanding Data Definition Language (DDL)
    • Using DDL Statements
Module 2: Creating Database Objects
  • Defining Data Types
    • Using Built-in Data Types
    • Using Exact Numeric Data Types
    • Using Approximate Numeric Data Types
  • Creating and Using Tables
  • Creating Views
  • Creating Stored Procedures
    • Understanding SQL Injections
Module 3: Manipulating Data
  • Using Queries to Select Data
    • Combining Conditions
    • Using the BETWEEN Clause
    • Using the NOT Clause
    • Using the UNION Clause
    • Using the EXCEPT and INTERSECT Clauses
    • Using the JOIN Clause
  • Using Queries to Insert Data
    • Inserting Data
  • Updating Data and Databases
    • Using the UPDATE Statement
  • Deleting Data
    • Using the DELETE Statement
    • Truncating a Table with TRUNCATE TABLE
    • Deleting a Table with DROP TABLE
    • Using Referential Integrity
Module 4: Understanding Data Storage
  • Normalizing a Database
  • Understanding Normalization
    • Understanding the First Normal Form
    • Understanding the Second Normal Form
    • Understanding the Third Normal Form
    • Understanding the Fourth Normal Form
    • Understanding the Fifth Normal Form
  • Understanding Primary, Foreign, and Composite Keys
    • Understanding Primary Keys
    • Understanding Foreign Keys
    • Understanding Composite Primary Keys
  • Understanding Clustered and Non-clustered Indexes
    • Understanding Clustered Indexes
    • Understanding Non-clustered Indexes
    • Creating a Non-clustered Table
Module 5: Administering a Database
  • Securing Databases
    • Understanding Server-Level Security
    • Understanding Database-Level Security
    • Understanding Windows Security
    • Understanding SQL Authentication
    • Understanding Database Server Roles
    • Granting Access to a Database
    • Understanding Fixed Database Roles
    • Understanding Object Permissions
    • Managing Roles
    • Understanding Ownership Chains
    • Reviewing a Sample Security Model
  • Backing Up and Restoring Databases
    • Understanding Recovery Models
    • Understanding Database Backups
    • Understanding Backup Devices
    • Understanding Database Restores

Price

18,000 MUR including Microsoft Original Courseware and Exam Voucher

Early Bird: Register 1 month in advance and get 10% discount.

Ask us for a Group Discounts as from 3 students.

Courseware

Each participant will receive the Microsoft Original Courseware (MOC).

Certification

This course prepares students for the exam 98-364: Database Fundamentals. The Prometric exam voucher is already included and students can pass the exam in our Testing Center.