MTA Database Administration Fundamentals
This course is designed to provide the student with the necessary skills, knowledge and abilities (KSAs) to gain an entry level IT position working with databases. In this course you will learn how to administer a database, understands data storage, grasp core databases concepts, create database objects, and manipulate data. When done with this course not only will you gain these valuable skills you will also be prepared to take the Microsoft Technology Associate (MTA) exam 94-364 for Database Administration.
Self Paced
Computer Science
Buy the course for only $59 and get a copy of "Database Administration Fundamentals" at no additional cost
By including eTextbooks in our courses, StraighterLine is helping students achieve their academic goals by providing best-in-class tools to make studying more convenient.
No reviews have been submitted for MTA Database Administration Fundamentals
Course Objectives
After completing this course, you will be able to:
- Administer a database
- Understand data storage
- Understanding core database concepts
- Create a database
- Manipulate data
| Topic | Topic Title | Subtopics |
|---|---|---|
| 1 | Introduction to MTA and Certifications |
|
| 2 | Understanding Core Database Concepts |
|
| 3 | Creating Database Objects |
|
| 4 | Manipulating Data |
|
| 5 | Understanding Data Storage |
|
| 6 | Administering a Database |
|
| 7 | Course Final Examination and Certification Submission |
There are no prerequisites to take MTA Database Administration Fundamentals.
The required eTextbook for this course is included with your course purchase at no additional cost. More information on StraighterLine eTextbooks
Prefer the hard copy? Simply purchase from your favorite textbook retailer; you will still get the eTextbook for free.
Students who are beginning studies in technology need a strong foundation in the basics before moving on to more advanced technology courses and certification programs. The Microsoft Technology Associate (MTA) is a new and innovative certification track designed to provide a pathway for future success in technology courses and careers. The MTA program curriculum helps instructors teach and validate fundamental technology knowledge and provides students with a foundation for their careers as well as the confidence they need to succeed in advanced studies. Through the use of MOAC MTA titles you can help ensure your students future success in and out of the classroom. Database Administration Fundamentals covers introductory knowledge and skills including: relational databases; core database concepts; relational database concepts; security requirements for databases and the data stored in them; database objects - such as tables and views; graphical tools and T-SQL scripts; database queries; and stored procedures.
Microsoft® Official Academic Course - Database Administration Fundamentals, Exam 98-364 Copyright © 2017 by John Wiley & Sons, Inc. All rights reserved. Used by arrangement with John Wiley & Sons, Inc.
StraighterLine provides a percentage score and letter grade for each course. See Academic Questions section in FAQ for further details on percentage scores and grading scale. A passing percentage is 70% or higher.
If you have chosen a to award credit for this course, your final grade will be based upon that college's grading scale. Only passing scores will be considered by Partner Colleges for an award of credit.
There are a total of 1000 points in the course:
| Topic | Assessment | Points Available |
|---|---|---|
| 1 | Topic 1 Quiz | 110 |
| 2 | Topic 2 Quiz | 110 |
| 3 | Topic 3 Quiz | 110 |
| 4 | Topic 4 Quiz | 110 |
| 5 | Topic 5 Quiz | 110 |
| 6 |
Topic 6 Quiz | 110 |
| 7 | Graded Final Exam | 300 |
| 7 | Certification Attempt Submission | 40 |
| Total | 1000 |
This course is designed to provide the student with the necessary skills, knowledge and abilities (KSAs) to gain an entry level IT position working with databases. In this course you will learn how to administer a database, understands data storage, grasp core databases concepts, create database objects, and manipulate data. When done with this course not only will you gain these valuable skills you will also be prepared to take the Microsoft Technology Associate (MTA) exam 94-364 for Database Administration.