MTA: Database Administration Fundamentals - 98-364

The MTA: Database Administration Fundamentals exam is a standalone certification from Microsoft with the exam code 98-364. Candidates for this exam are seeking to prove 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.

Product Features

Authored by Industry Experts

uCertify uses content from the finest publishers and only the IT industry’s finest instructors. They have a minimum of 15 years real-world experience and are subject matter experts in their fields. Unlike a live class, you can study at your own pace. This creates a personal learning experience and gives you all the benefits of hands-on training with the flexibility of doing it around your schedule 24/7.

Exercises, Quizzes & Flashcards

uCertify’s 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.

Practice Test Sets

uCertify courses also 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.

Exam Simulators

Online labs to supplement your training. uCertify labs are an inexpensive & safe way to explore and learn. uCertify labs are versatile - labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training.

State of the Art Educator Tools

uCertify knows the importance of instructors and provide tools to help them do their job effectively. Instructors are able to clone and customize course. Do ability grouping. Create sections. Design grade scale and grade formula. Create and schedule assignments. Educators can also move a student from self-paced to mentor-guided to instructor-led mode in three clicks.

Award Winning Learning Platform (LMS)

uCertify has developed an award winning, highly interactive yet simple to use platform. uCertify understands that it is critical to help student focus on learning the subject and not learning the LMS. uCertify helps student retain and recall the knowledge by teaching students using interactive exercises. Features such as actionable analytics and study planner help in keeping students focused.

Prepare for the following certifications

• MTA: Microsoft Technology Associate
• Microsoft SQL Server
• Core Database Concepts
• Database Objects
• Manipulating Data
• Data Storage
• Administering a Database

Skills Measured

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

Syllabus

• 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).
• Creating Database Objects
  • Choose data types
  • Understand tables and how to create them.
  • Create views.
  • Create stored procedures and functions.
• Manipulating Data
  • Select data
  • Inserting data
  • Updating data
  • Deleting data
• Understanding Data Storage
  • Understand normalization
  • Understand primary, foreign, and composite keys.
  • Understand indexes
• Administering a Database
  • Understand database security concepts

Understand database backups and

Currently there are no Q&As for this course. Be the first to ask a question.