MTA Database Administrator Fundamentals - Exam 98-364 - Online

Course

In Wembley

Price on request

Description

  • Type

    Course

  • Location

    Wembley

  • Start date

    Different dates available

The MTA Database Administrator Fundamentals course is a great starting point from which to build your IT career. 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. This is a beginner level course so there are no specific prerequisites required before you commence your training.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.

Facilities

Location

Start date

Wembley (Middlesex)
Hazel House 1-3 Lancelot Road, HA0 2AL

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • IT
  • Database
  • Database training
  • Communication Skills
  • Skills and Training
  • C
  • Database Administration Fundamental
  • Online IT training
  • Database Relationships Section
  • Database Tables Section

Course programme

Database Administration Fundamentals: MTA Exam 98-364

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.

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

MTA Database Administrator Fundamentals - Exam 98-364 - Online

Price on request