Database Administration Fundamentals

Blended & eLearning

  • Overview
  • Entry Requirements
  • Principal Areas of Study
  • Assessment & Award
  • Career/Academic Progression
  • Resources & Lab Tests

This MTA Database Administration Fundamentals course introduces and defines the terminology, concepts, and skills you need to understand database objects, security requirements, graphical tools, T-SQL scripts, and writing database queries, in addition to executing stored procedures. The course is designed for individuals seeking to learn the fundamentals of relational databases, database management systems, and database components.

On Completion of this course learners will:
Understand Core Database Concepts
Create Database Objects
Manipulate Data
Understand Data Storage
Administer a Database

Learner Profile
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.

There are no specific entry requirements.
 

Microsoft Technology Associate (MTA) is a recommended entry point into IT certification and job preparation. If you are just starting your IT career path or are looking to enhance your understanding of IT fundamentals, MTA certification can validate your core knowledge and as an industry-recognised credential, it can also enhance your credibility.

Unit 1: Understanding Core Database Concepts

  • Understand how data is stored in tables
  • Understand relational database concepts.
  • Understand data manipulation language (DML)
  • Understand data definition language (DDL).

Unit 2: Creating Database Objects

  • Choose data types
  • Understand tables and how to create them.
  • Create views.
  • Create stored procedures and functions.

Unit 3: Manipulating Data

  • Select data
  • Inserting data
  • Updating data
  • Deleting data

Unit 4: Understanding Data Storage

  • Understand normalization
  • Understand primary, foreign, and composite keys.
  • Understand indexes

Unit 5: Administering a Database

  • Understand database security concepts
  • Understand database backups and restore

Microsoft Certification can take you from the start of your career to its pinnacle. Certification can increase your visibility, differentiate you from your peers, and bring you recognition for your knowledge and skills.

This course will provide the 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.   

Assessment
Learners take the  Database Administration Fundamentals: MTA Exam 98-364.  Assessment of this valuable qualification is carried out Online.  On Completion of the Course the learner will have the requisite knowledge to sit the Professional Examination at any PearsonVue testing center or for Local learners at: 7 Belvedere Place, Dublin 1. 

Award
MTA: Database Administration Fundamentals Certificate

The MTA certification provides the foundational knowledge necessary to pursue other Microsoft certifications.  Having a validated certification from Microsoft can help you launch a successful career - create a new entry point to help those who are new to IT to jump start their careers.  Earning an MTA certification helps prove your knowledge of fundamental technology concepts.

Skills Measured

Core Database Concepts Manipulating Data
Database Objects Data Storage
Administering a Database  

When you earn an MTA certification, you become a member of our Microsoft Certified Professional (MCP) community. You get access to members-only benefits, such as special offers, a transcript tool, and private newsgroups where you can network, find peer support, and share your accomplishments with millions of MCPs worldwide.

Expert Instructor-Led Training using only the IT industry’s finest instructors. This elearning course provides a personal learning experience that gives you all the benefit of hands-on training with the flexibility of doing it around your schedule 24/7.  Unlike a live class, you can study at your own pace.

Interactive Exercises
The courseware includes real world, interactive exercises that always focus on real world scenarios and skill-set development. 

The course is structured to enable learners to retain and recall the knowledge by teaching learners using interactive exercises.  Features such as actionable analytics and study planner help in keeping students focused.

Practice Test Sets 
Course include full length practice test sets designed to test your knowledge under real exam conditions. Each course has a number of test sets consisting of hundreds of items to ensure you are 100% prepared before taking your certification exam.

Exercises, Quizzes & Flashcards
Exercises, quizzes and flashcards prepare you for your exams differently and more effectively than the traditional exam preps on the market. You will have practice quizzes, flashcards and exercises after each module to ensure you are confident on the topic you have completed before proceeding. This will allow you to gauge your effectiveness before moving to the next module in your course.