Duration: 4 days |
Price: R3465.00 per person. (excl VAT) |
Certificate of training: Yes |
Recommended Prerequisites: Learners are required to have knowledge, comprehension and application of English at Grade 10 or equivalent. |
Dates: Courses are run all year round. Training is conducted every week (Mon - Thurs & Sat ). |
Follow Up Courses: Other MTA courses |
Venue: Stellenbosch UNIT B12, Carpe Diem Building 26 Quantum Street, Techno Park Stellenbosch 7600 |
-
Course Overview
-
Benefits
-
Course Outline
<
>
MTA Database Administrator Fundamentals (98-364)
MTA Database Administrator Fundamentals is the first step on the path to becoming a Microsoft Certified Database Administrator or Database Developer. This training course prepares students for Microsoft exam 98-364. MTA is a new entry-level credential from Microsoft that validates the foundational knowledge needed to take the first step toward building a successful career in technology. This MTA training will help you become familiar with concepts and technologies pertaining to Database Administration. In this course you will learn about relational databases, queries, stored procedures, and the security requirement for databases and the data stored in them. If a career in database administration is what you are looking for, then this is the first step on your certification journey. Expert Wayne Snyder guides you through each exam objective seamlessly, all the while preparing you for Microsoft exam 98-264. This course provides you with interactive videos that meet the needs of multiple learning styles from auditory to visual. The MTA Database Administrator Fundamentals eLearning course includes a pre test and post test that accurately identifies your skill gap. Snyder will come in and help you close the skill gap with content concentrating on each exam objective. Achieving MTA certifications is the first step toward becoming a Microsoft Certified Technology Specialist (MCTS).
- Understand core database concepts like relationships, tables, and SQL (Structured Query Language)
- Learn to filter, sort, and update data
- Become familiar with data normalization and the common levels of normalization
Database Tables
Database Relationships
Understanding DML
Database Data Types
Creating and Manipulating Tables
Selecting Data
Filtering Data using Comparisons
Filtering Data using Lists and Ranges
Filtering Data using Pattern Matching
Filtering Data with NULLs
Selecting Data using Functions
Sorting Data
Working with Duplicates
Joining Data
OUTER and CROSS JOINs
Combining and Limiting Result Sets
|
Adding Data
Updating and Deleting Data
Working with Views
Stored Procedures and Functions
Data Normalization
First Normal Form
Second and Third Normal Forms
Fourth and Fifth Normal Forms
Primary, Foreign, and Composite Keys
Clustered Indexes
Non-Clustered Indexes
Database Security Concepts
Database Backup and Restore
Incremental Backups
|