MTA Database Administrator Fundamentals

The MTA Database Administrator training course is available at the Edinburgh, Glasgow, Aberdeen and Inverness Pitman Training Centres or via Online Distance Learning through our Pitman Campus.

The MTA Database Administrator Fundamentals course is a great starting point from which to build your IT career.

This course is designed to help you learn and increase your knowledge on relational databases, queries and database security to name just a few topics.Once you have achieved your MTA Database Administrator Fundamentals certification, you will be ideally placed to go on to study for your MCTS, Microsoft Certified Technology Specialist.

Course Duration: 40 hours

CPD Points: 40

Enquire Now!

Course Content

There are a total of 4 sessions:

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

Designed For

This is an entry-level course is for anyone looking for 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.

Objectives

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

Testimonials

"Two years ago I was at a crossroads in my career as a Textile CAD designer and decided to expand my IT knowledge in the hope of broadening my job options. Knowing the cost involved I began my research and found plenty of organizations who offe...

IL – IT Technical, ,

|
"After 12 years working for an airline I decided to make a career change and started looking into various training companies. I selected Pitman Training based on their helpfulness and support. I started studying in August of 2007 and initially...

MM – IT Technical, ,

|
"I have completed a number of with Pitman Training since 2007, including ECDL course and the MCSA. I have always found the staff at the training centre to be very helpful, friendly and supportive, in particular John whose help, advice and tech...

SH – IT Assistant, ,

|

Prerequisites

This is a beginner level course so there are no specific prerequisites required before you commence your training.

Funding

Flexible Workforce Development Fund (FWDF)

Claim up to £15,000 for Training your employees

This fund provides Levy Paying Companies an opportunity to up-skill or re-skill Employees and in turn, support economic growth.

Eligibility Criteria:

You must be a Levy Paying Employer
The Company must be based or operate in Scotland, wholly or partially
Employees must reside in Scotland

For more information on applying for this funding, contact our Course Advisors by clicking below:

———–

A funded training opportunity is now available to those facing redundancy or those who have been made redundant from March 2020 onward.

The National Transition Training Fund aims to tackle the rise in unemployment caused by Covid-19 by offering short sharp training opportunities for people to learn in-demand skills.

If you are currently under threat of redundancy, or have been made redundant at any time from the 1st March 2020 and are aged 25 or over, you can access an industry recognised qualification to help you gain employment.

For further information on how to proceed then contact us referencing the course(s) you are interested in.

Course Content

Designed For

Objectives

Testimonials

Prerequisites

Funding

Enquire Now

For more information on this or any of our courses complete the form

Register for a course