MTA Database Administrator Fundamentals

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