MTA Database Administrator Fundamentals is the first step on the path to becoming a Microsoft Certified Database Administrator or Database Developer.
Quick EnquiryThis is an entry-level course is for anyone looking for a career in IT and will help you prepare for the Microsoft exam*, 98-364. On successful completion of this course, you will be ideally placed to become a Junior Database Administrator or Database Administrator.
* For details about vendor specific exams, please talk with your Course Advisor
Awarded 40 CPD points upon successful completion
Start Date
Study Type
Training Type
Duration
The MTA Database Administrator Fundamentals course is a great starting point from which to build your IT career.
It’s a flexible, online IT training course which is broken down into four sessions, all designed to help you learn and increase your knowledge on relational databases, queries and database security to name just a few topics. Included within the course is a pre-test and post-test which can help to identify any skills gap you may have and from there can ensure that you focus on the areas needed to achieve the course objective.
Once you’ve achieved your MTA Database Administrator Fundamentals certification, you’ll be ideally placed to go on to study for your MCTS, Microsoft Certified Technology Specialist.
Speak to a Course Advisor today to find out more about our flexible, online IT training course range.
Section A: Database Tables
Section B: Database Relationships
Section C: Understanding DML
Section D: Database Data Types
Section E: Creating and Manipulating Tables
Section F: Selecting Data
Section G: Filtering Data using Comparison
Section A: Filtering Data using Lists and Ranges
Section B: Filtering Data using Pattern Matching
Section C: Filtering Data with NULLs
Section D: Selecting Data using Functions
Section E: Sorting Data
Section F: Working with Duplicates
Section G: Joining Data
Section H: OUTER and CROSS JOINs
Section I: Combining and Limiting Result Sets
Section A: Adding Data
Section B: Updating and Deleting Data
Section C: Working with Views
Section D: Stored Procedures and Functions
Section E: Data Normalisation
Section F: First Normal Form
Section G: Second and Third Normal Forms
Section H: Fourth and Fifth Normal Forms
Section A: Primary, Foreign and Composite Keys
Section B: Clustered Indexes
Section C: Non-Clustered Indexes
Section D: Database Security Concepts
Section E: Database Backup and Restore
Section F: Incremental Backups
Request more details or call the team on 1800 532632
Simply enter your details below and we'll email you a copy of all the course details straightaway. One of our friendly course advisors will be in touch to see how we can help and answer all your questions.
We offer a range of training packages in a range of subject areas and can offer blended learning opportunities to best meet your needs.
Our courses are practical in nature and focus on a single subject and can last anywhere from a few hours to a few days.
Diplomas are designed to give you a complete skillset mapped to a specific career path and contain a number of core and elective courses.
Click below for more details or call us on 1800 532632.
Call us now and transform your career today
Connect with us on