Kenya - Enquire Now +254 (0)743144753

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. 

 

 

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

Flexible

Study Type

or a combination, Online, in centre

Training Type

course

Duration

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 +254 (0)743144753.

    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

    Pre-Requisites

    Finance Options

    Career Path

    Request a Course Factsheet Now!

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

      Please enter your email address


      What's 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