Microsoft Technical Associate (MTA): Database Fundamentals (98-364) (Online) OnlineNewSpecial£
MTA Database Fundamentals is designed to provide students with an explanation and understanding of fundamental security concepts. This training course prepares students for Microsoft exam 98-364.
This fee based course provides you with interactive videos that meet the needs of multiple styles of learning from auditory to visual and it includes a pre test and post test that accurately identifies your skill gap. The course is supplemented by a Microsoft Official Academic Course textbook and a practice and exam voucher is included.
MTA is a entry-level credential from Microsoft that validates the foundational knowledge needed to take the first step toward building a successful career in technology. The MTA certification programs cover the baseline knowledge of building and managing Microsoft Windows Servers, Windows-based network operating systems, Active Directory, account management, and system recovery tools.
Achieving MTA certifications is an optional first step to achieving the Microsoft Certified Solutions Associate (MCSA) certification.
View a Microsoft Certification Roadmap
Why MTA? Watch students, instructors and professionals explain why MTA makes a difference.
- All current Cambridge University members (departments and colleges) who are starting their career path or are looking to enhance their understanding of IT fundamentals
- All current Cambridge University IT professionals who want to consolidate their core knowledge before commencing the Microsoft Certified Solutions Associate (MCSA) certification
- Further details regarding eligibility criteria are available
Session 1
- Database Tables
- Database Relationships
- Understanding DML
- Database Data Types
- Creating and Manipulating Tables
- Selecting Data
- Filtering Data using Comparisons
Session 2
- Filtering Data using Lists and Ranges
- Filtering Data using Pattern Matching
- Filtering Data with NULLs
- Selecting Data using Functions
- Sorting Data
- Working with Duplicates
- Joining Data
- OUTER and CROSS JOINs
- Combining and Limiting Result Sets
Session 3
- Adding Data
- Updating and Deleting Data
- Working with Views
- Stored Procedures and Functions
- Data Normalization
- First Normal Form
- Second and Third Normal Forms
- Fourth and Fifth Normal Forms
Session 4
- Primary, Foreign, and Composite Keys
- Clustered Indexes
- Non-Clustered Indexes
- Database Security Concepts
- Database Backup and Restore
- Incremental Backups
A more detailed list of topics can be found here.
- Understand core database concepts like relationships, tables, and SQL (Structured Query Language)
- Learn to filter, sort, and update data
- Become familiar with data normalization and the common levels of normalization
Online videos
Please see the following minimum hardware and software requirements to run this course.
- University departments £225
- Colleges and private payments from University members are charged £225 + Vat = £270
The fee includes:
- One year online access to instructor-led video training (Watch a sample clip)
- Demos and lab learning
- Multi-media presentations
- Self-paced navigation
- Activation starts from date of purchase
- Microsoft Official Academic Course book
- A MeasureUp practice exam
- Award winning practice exams view a demo
- Three modes
- Test mode - designed to be like a true test
- Study mode - provides feedback throughout with reference to external text, learning and articles on the Microsoft site
- Custom mode - allows candidates to select a series of questions from the curriculum to focus on selected areas
- From date of purchase candidates have 356 days to activate online, thereafter candidates have 180 days of unlimited access
- A Certiport exam voucher
- Candidates have one year from the date of purchase to take their exam
Please Note: Please allow a few days to receive your purchases
Please note that payment is non-refundable
The exam can be taken with your voucher at a local exam centre.
A full list of exam topics can be viewed under Skills measured on the following exam information page.
Exam Preparation
In addition to the material on this course please refer to the section labelled Preparing for the exam in the exam page.
Additionally the Microsoft Virtual Academy has a Database Fundamentals course to consolidate your knowledge.
Ten hours of interactive training
- Access 2016: Creating a Simple Database
- Access 2016: Fast Track Introduction
- Access 2016: Further Use
- MySQL: Implementing a Relational Database Design
Booking / availability