MTA Database Administration Fundamentals
Duration
3 Days
Exam Details
- Exam Code: Exam 98-364: Database Fundamentals
- Skills measured:
o Understanding core database concepts (20–25%)
o Create database objects (20–25%)
o Manipulate data (25–30%)
o Understand data storage (15–20%)
o Administer a data base (10–15%)
Price
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.
Objectives
- Understanding core database concepts
o How data is stored in tables
o Relational database concepts
o Data manipulation language (DML)
o Data definition language (DDL) - Creating database objects
o Data types
o Tables and Create tables
o Create Views
o Create stored procedures and functions - Manipulating data
o Select Data
o Insert Data
o Update Data
o Delete Data - Understanding data storage
o Normalization
o Primary, foreign, and composite keys
o Indexes - Administering a database
o Database security concepts
o Database backups and restore
Audiences
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.
Contact
- Nurman (+62 857-2375-3840)
- Irna (+62 822-1664-7749)
- Puji (+62 813-2424-2115)
- Shafa (+62 813-9049-0664)