MTA Database Administration Fundamentals

Course Content from Wiley
Course Number: MTA_Database
Download Course Syllabus

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.

Coming Soon

new
Course Type Icon
Self Paced
Course Department Icon
Computer Science
Publisher Icon
FREE eTextBook

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
  • Introduction to Course
  • Computer Certifications
  • Microsoft Technology Associate Certificate
  • MTA Database Administration
  • Testing: What to Expect
2 Understanding Core Database Concepts
  • Understanding Database Concepts
  • Understanding Data Manipulation Language
  • Understanding Data Definition Language
3 Creating Database Objects
  • Defining Data Types
  • Creating and Using Tables
  • Creating Views
  • Creating Stored Procedures
4 Manipulating Data
  • Using Queries to Select Data
  • Using Queries to Insert Data
  • Updating Data and Databases
  • Deleting Data
5 Understanding Data Storage
  • Normalizing a Database
  • Understanding Primary, Foreign, and Composite Keys
  • Understanding Clustered and Non-Clustered Indexes
6 Administering a Database
  • Securing Databases
  • Backing Up and Restoring Databases
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.

textbook cover imageStudents 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 Partner College 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.

Create your own custom MTA Database Administration Fundamentals ! Select up to courses from the list below.

MTA Database Administration Fundamentals   +$59.00
MTA_Database eTextbook (a $83.95 value)   +$0.00

Subtotal

As low as: $59.00

plus subscription
MTA Database Administration Fundamentals

MTA Database Administration Fundamentals

$0.00

Your Courses

  • {{label}}:{{options}}
{{qty}} x {{name}}
{{qty}} x {{name}}
  •  
Plus Membership [?]

Only registered users can write reviews. Please, log in or register