MTA Database Administrator Fundamentals

MTA Database Administrator Fundamentals is the first step on the path to becoming a Microsoft Certified Database Administrator or Database Developer.

Enquire now

Is this for you?

This 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

Award and Associated Qualifications

Awarded 40 CPD points upon successful completion

Start Date


Study Type

In centre, online, or a combination

Training Type



40 hours

Request your Course Factsheet

For further information and pricing please fill in your details below and we will get back to you as soon as we can. Or, call the team on 0161 907 6724.

About this course

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.


See below for a bit more of a detailed breakdown of what's involved in the four sessions of this training course: - 


Session 1:

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

Session 2:

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

Session 3:

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

Session 4:

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"


Aims and Objectives

This course is designed to arm you with all the knowledge and skills necessary to prepare for the Microsoft Exam*, 98-364. 


* For details about vendor specific exams, please talk with your Course Advisor


There are no specific pre-requisites required before starting this course.

Finance Options

Wherever possible our training is tailored to your needs. The cost of our training programmes depend on the course(s) you choose and varies according to duration and breadth. Rest assured we have a number of payment options available to ensure the cost of training is affordable and can be worked alongside your other financial commitments. Common ways people fund their training include: - 



  • Flexible payment plans to help you spread the cost* available at many of our centres;
  • You could opt to pay upfront.



Company Funded:

Requesting funding from your employers needn’t be a daunting task. Many employers support and encourage their employees with their professional development and consider it a worthwhile investment to fund any training required.

What we can help with:

  • Providing a comprehensive training programme outlining learning outcomes
  • Tailored personnel letters
  • Communication with finance departments to arrange payment options (upfront or payment plan*).


Funding & Grants:

There may be the opportunity to apply for funded grants that can help towards the cost of training. These include the Skills Development Scotland ITAs and the ReAct programme in Wales. All schemes will have different terms and conditions that will need to be met in order to qualify for a grant and these are managed by each individual centre.

We’d recommend you speak to a Course Advisor in your local centre to find out whether they are registered to offer any such schemes and discuss your requirements further.


* Terms and Conditions apply. Speak to a Course Advisor for full information on the options available to you.



Career Path

This training can lead to jobs such as Junior Database Administrator, Junior IT Support or Junior Oracle admin. With further IT training, you could work towards roles such as Oracle Database Administrator, System Administrator, Systems Analyst, Data Analyst and Senior Database Administrator. 


MTA Database Administrator Fundamentals Course Training Centres

Region Training Centre Date
Scotland Aberdeen, Edinburgh, Glasgow, Inverness, Courses available
Enquire &
Book Now
Northern Ireland Belfast, Courses available
Enquire &
Book Now
Midlands Birmingham, Chesterfield, Northampton, Nottingham, Worcester, Leicester, Courses available
Enquire &
Book Now
East Anglia Bishop's Stortford, Cambridge, Chelmsford, Colchester, Ipswich, Peterborough, Courses available
Enquire &
Book Now
South East Brighton, Canterbury, Crawley, Dover, Guildford, Hastings, Reading, Southampton, Eastleigh, Milton Keynes, Maidstone, Courses available
Enquire &
Book Now
South West Bristol, Devon and Cornwall, Taunton, Courses available
Enquire &
Book Now
Wales Cardiff, Swansea, Courses available
Enquire &
Book Now
London City EC2, Clapham, Croydon, Enfield, Greenwich, Hendon, High Holborn, Hounslow, Oxford Circus, Stratford, Watford, Watford, Wembley, Bromley, Courses available
Enquire &
Book Now
North West Crewe and Nantwich, Liverpool, Manchester, Warrington, Courses available
Enquire &
Book Now
North East Leeds, Newcastle, Wetherby, York, Middlesbrough, Courses available
Enquire &
Book Now
Courses available Mon-Fri
Northern Ireland
Courses available Mon-Fri
South West
Courses available Mon-Fri
Courses available Mon-Fri
North West
Courses available Mon-Fri
North East
Courses available Mon-Fri

Looking for prices?

Request more details or call the team on 0161 907 6724

Download a Course Factsheet Now!

Simply enter your details below to download a copy of the course details straightaway. 

Whats the difference?

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.

Ready to improve your career?

Personal Training?

Enquire now

Group or Corporate?

Enquire now

Call us now and transform your career today

0161 907 6724

Connect with us on