Course Outline
MTA Database Administration Fundamentals course overview
This 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.
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
This short MTA course is hands-on, instructor-led and classroom based. This training can be taken as a part-time evening course or even on the weekends. A list of all upcoming public MTA training course is given on training dragon website.
Who is MTA Database Administration Fundamentals training for?
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 for MTA Database Administration Fundamentals course
- You should be able to create, copy folders and files on your computer and use internet.
- If you are a complete beginner in databases, you should first attend our hands-on and practical SQL Course before attending this MTA
What will I get?
- Training from professional MTA certified trainers:
Training Dragon consultants have been implementing professional Microsoft networking solutions across a range of companies for many years. Those consultants write and teach our MTA training courses, so their experience directly informs course content.
- Practical Projects:
This MTA training is designed to prepare you not only for MTA certification, but also to train you for your next job. To do this, next to certification you will also work on real-world practical MTA related exercises in this MTA course. This will ensure that you can apply the knowledge gained from this course to your work environment.
- Course Material and Practice exams:
MTA electronic notes are included in this course. You will also take practice exams as part of the course.
- Course Completion Certificate:
After completing this training you will receive MTA course completion certificate.
- Support and Careers Advice:
After the course if you have any problems or questions regarding MTA , do not hesitate to contact us. Training Dragon’s trainers and career consultants are expert in their fields and if you need any help with you career choice, please speak to one of our career consultants.
- Pass Guarantee and Train again for Free:
We are sure that you will pass your MTA certification exam at first attempt. However, if you don’t, you can come back within a year and take the complete course for free.
- Official Course Curriculum:
This MTA certification course is based on the official Microsoft recommended course syllabus.
MTA Database Administration Fundamentals Course Contents
- Module 1: Understanding Core Database Concepts
- Module 2: Creating Database Objects
- Module 3: Manipulating Data
- Module 4: Understanding Data Storage
- Module 5: Administering a Database
Understanding core database concepts (20–25%)
- Understand how data is stored in tables
- Understand what a table is and how it relates to the data that will be stored in the database; columns/fields, rows/records
- Understand relational database concepts
- Understand what a relational database is, the need for relational database management systems (RDBMS), and how relations are established
- Understand data manipulation language (DML)
- Understand what DML is and its role in databases
- Understand data definition language (DDL)
- Understand how T-SQL can be used to create database objects, such as tables and views
- Preparation resources
- Designing tables
- 3 - Implementing a relational database
- Data Manipulation Language (DML) statements (Transact-SQL)
Create database objects (20–25%)
- Choose data types
- Understand what data types are, why they are important, and how they affect storage requirements
- Understand tables and how to create them
- Purpose of tables; create tables in a database by using proper ANSI SQL syntax
- Create views
- Understand when to use views and how to create a view by using T-SQL or a graphical designer
- Create stored procedures and functions
- Select, insert, update, or delete data
- Preparation resources
- Publishing data and database objects
- CREATE TABLE (Transact-SQL)
- How to: Create views (Visual Database Tools)
Manipulate data (25–30%)
- Select data
- Utilize SELECT queries to extract data from one table, extract data by using joins, combine result sets by using UNION and INTERSECT
- Insert data
- Understand how data is inserted into a database, how to use INSERT statements
- Update data
- Understand how data is updated in a database and how to write the updated data to the database by using the appropriate UPDATE statements, update by using a table
- Delete data
- Delete data from single or multiple tables, ensure data and referential integrity by using transactions
- Preparation resources
- Selecting data using the SqlDataSource control
- Walkthrough: Retrieving, updating, inserting, and deleting data with the LinqDataSource and DetailsView controls
- How to: Delete rows from the database (LINQ to SQL)
Understand data storage (15–20%)
- Understand normalization
- Understand the reasons for normalization, the five most common levels of normalization, how to normalize a database to third normal form
- Understand primary, foreign, and composite keys
- Understand the reason for keys in a database, choose appropriate primary keys, select appropriate data type for keys, select appropriate fields for composite keys, understand the relationship between foreign and primary keys
- Understand indexes
- Understand clustered and non-clustered indexes and their purpose in a database
- Preparation resources
- Working with keys
- How to: Handle composite keys in queries (LINQ to SQL)
- Working with indexes
Administer a database (10–15%)
- Understand database security concepts
- Understand the need to secure a database, what objects can be secured, what objects should be secured, user accounts, and roles
- Understand database backups and restore
- Understand various backup types, such as full and incremental, importance of backups, how to restore a database
- Preparation resources
- Security considerations for a SQL Server installation
- SQL Server security (ADO.NET)
- Backing up and restoring databases in SQL Server
View Complete Course outline 
