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.

Quick Enquiry

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

Optional Qualifications and Certification*

Awarded 40 CPD points upon successful completion

* not available to those on funded or TSG-supported programmes

Start Date

Flexible

Study Type

In centre, online, or a combination

Training Type

course

Duration

40 hours

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*.

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

Pre-Requisites

There are no pre-requisites required for 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: - 

 

Self-Funded: 

  • 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*).

* 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. 

 

Additional Information

MTA Database Administrator Fundamentals Course Training Centres

Location Address Region
Athlone Pitman Training Athlone, C/O Athlone Chamber, Unit 12, Inis Oir, Golden Island, Athlone Enquire &
Book Now
Carlow Pitman Training Carlow, Unit 1, Deerpark Business Complex, Dublin Road, Carlow Enquire &
Book Now
Clare Pitman Training Clare, Unit 10, Tracklands Business Park, Ennis, Co. Clare Enquire &
Book Now
Cork Pitman Training Cork, Unit 4, Airport East Business & Technology Park, Cork Enquire &
Book Now
Dublin Pitman Training Dublin, 3 Westland Square, Pearse Street, Dublin 2 Enquire &
Book Now
Dundalk Pitman Training Dundalk, First Floor, Ramparts Shopping Centre, The Ramparts, Dundalk, Co Louth Enquire &
Book Now
Galway Pitman Training Galway, Centrepoint, Liosban Business Park, Tuam Road, Galway Enquire &
Book Now
Kerry Pitman Training Kerry, 2nd Floor Davcon Building, Monavalley Business Park, Tralee, Co. Kerry Enquire &
Book Now
Laois Pitman Training Laois, Kea-Lew Business Park, Mountrath Road, Portlaoise, Co Laois, Enquire &
Book Now
Limerick Pitman Training Limerick, Unit 8 Chapel Court, Cathedral Place, Limerick Enquire &
Book Now
Maynooth Pitman Training Maynooth, Unit H 11 - First Floor, Maynooth Business Campus, Straffan Road, Maynooth Enquire &
Book Now
Mullingar Pitman Training Mullingar, Castle House, Castle Street, Mullingar, Co. Westmeath, Enquire &
Book Now
Naas Pitman Training Naas, Monread Shopping Centre, Monread Road, Naas Enquire &
Book Now
Sligo Pitman Training Sligo, Abbey House, JFK Parade, Sligo Enquire &
Book Now
Swords Pitman Training Dublin-Swords, Chamber Buildings, North Street, Swords, Co.Dublin Enquire &
Book Now
Waterford Pitman Training Waterford, Unit 630C, Northern Extension, IDA Business Park, Cleaboy Road, Waterford Enquire &
Book Now
Waterford Pitman Training Waterford, Unit 630C, Northern Extension, IDA Business Park, Cleaboy Road, Waterford Enquire &
Book Now
Wexford Pitman Training Wexford, Unit 10, Westpoint Business Park, Clonard, Wexford Town Enquire &
Book Now
Wicklow Pitman Training Wicklow, 10 Bullford Business Campus, Kilcoole, Co. Wicklow Enquire &
Book Now
Carlow
Pitman Training Carlow, Unit 1, Deerpark Business Complex, Dublin Road, Carlow R93 K409
Cork
Pitman Training Cork, Unit 4, Airport East Business & Technology Park, Cork T12 KW88
Dublin
Pitman Training Dublin, 3 Westland Square, Pearse Street, Dublin 2 D02 N567
Dundalk
Pitman Training Dundalk, First Floor, Ramparts Shopping Centre, The Ramparts, Dundalk, Co Louth A91 R820
Galway
Pitman Training Galway, Centrepoint, Liosban Business Park, Tuam Road, Galway H91 RYD2
Kerry
Pitman Training Kerry, 2nd Floor Davcon Building, Monavalley Business Park, Tralee, Co. Kerry V92 XY58
Limerick
Pitman Training Limerick, Unit 8 Chapel Court, Cathedral Place, Limerick V94 F6K2
Maynooth
Pitman Training Maynooth, Unit H 11 - First Floor, Maynooth Business Campus, Straffan Road, Maynooth W23 R9V4
Mullingar
Pitman Training Mullingar, Castle House, Castle Street, Mullingar, Co. Westmeath, N91 Y896
Naas
Pitman Training Naas, Monread Shopping Centre, Monread Road, Naas W91 YR12
Sligo
Pitman Training Sligo, Abbey House, JFK Parade, Sligo V94 YH6Y
Swords
Pitman Training Dublin-Swords, Chamber Buildings, North Street, Swords, Co.Dublin K67 A347
Wexford
Pitman Training Wexford, Unit 10, Westpoint Business Park, Clonard, Wexford Town Y35 YX60
Waterford
Pitman Training Waterford, Unit 630C, Northern Extension, IDA Business Park, Cleaboy Road, Waterford X91 HY58
Waterford
Pitman Training Waterford, Unit 630C, Northern Extension, IDA Business Park, Cleaboy Road, Waterford X91 HY58
Laois
Pitman Training Laois, Kea-Lew Business Park, Mountrath Road, Portlaoise, Co Laois, R32 W0DT
Athlone
Pitman Training Athlone, C/O Athlone Chamber, Unit 12, Inis Oir, Golden Island, Athlone H91 RYD2
Clare
Pitman Training Clare, Unit 10, Tracklands Business Park, Ennis, Co. Clare V95 F3C5
Wicklow
Pitman Training Wicklow, 10 Bullford Business Campus, Kilcoole, Co. Wicklow A63 TP65

Looking for prices?

Request more details or call the team on 1800 532632

Download a Course Factsheet Now!

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.

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.

Course

Our courses are practical in nature and focus on a single subject and can last anywhere from a few hours to a few days.

Diploma

Diplomas are designed to give you a complete skillset mapped to a specific career path and contain a number of core and elective courses.

Course Fees?

Click below for more details or call us on 1800 532632.

Ready to improve your career?

Personal Training?

Quick Enquiry

Group or Corporate?

Quick Enquiry

Call us now and transform your career today

1800 532632

Connect with us on