MTA: Database Administration Fundamentals - 98-364
Certification Partners
Summary
Overview
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
Description
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
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.