INTERNATIONALLY ACCREDITED

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
Official Exam: MTA Exam: 98-364 Preparation: Practice Tests	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

• Tables
• Representing Data with Tables
• SQL Server Management Studio

Database Relationships

• Flat File Databases
• Relational Databases
• RDBMS Benefits
• Related Tables
• Review
• Recursive Relationships
• M:N Relationships

Understanding DML

• Structured Query Language
• DDL/DML
• Data Control Language

Database Data Types

• Data Types
• Choosing a Data Type
• SQL Data Types
• Integers
• Exact Numbers
• Money Data Types
• Exceeding Data Type Limits
• Approximate Numerics
• Character Data Types
• Variable vs. Fixed
• Dates and Times
• Numeric and Alphabetic Date Formats
• DateTime2(n)
• ISO 8601 Format
• DateTimeOffset(n)

Creating and Manipulating Tables

• Table Types
• Simple Syntax
• NULL or NOT NULL
• Creating a Table
• Adding Columns using ALTER TABLE
• Adding Columns with Default Values
• Changing Columns using ALTER TABLE
• UNIQUE Constraints
• Adding UNIQUE Contraints

Selecting Data

• SELECT Statement
• Performing a SELECT
• Selecting Data using Expressions
• Specifiying Column Order and Aliases
• Special Character Considerations
• Using Operators and Expressions
• Schema Defined
• Character Operators
• Arithmetic Expressions
• Using Table Aliases

Filtering Data using Comparisons

• WHERE Clauses
• Comparison Operators
• Logical Operators
• Using WHERE Clauses
• Using Comparison Operators
• Combining using AND
• Combining using OR and NOT

Filtering Data using Lists and Ranges

• Range of Values
• Selecting a Range of Values
• Selecting Values in a List

Filtering Data using Pattern Matching

• Understanding String Pattern Matching
• String Comparison Operators
• Using LIKE Operators
• Percent (%) Wildcards
• Underscore (_)Wildcards
• Braces ([]) Wildcards

​Filtering Data with NULLs

• NULLs Defined
• NULL Handling

Selecting Data using Functions

• Aggregate Function Types

Sorting Data

• Sorting Data with ORDER BY
• Ordinal Column Position
• Using ORDER BY
• ORDER BY Ordinal Column Position

Working with Duplicates

• Eliminating Duplicates
• Using DISTINCT

Joining Data

• Introduction to JOINs
• JOIN Process
• INNER JOIN
• INNER JOIN Example
• Joining Data with Table Aliases
• INNER JOIN with DISTINCT

OUTER and CROSS JOINs

• OUTER JOIN Defined
• OUTER JOIN Example
• FULL OUTER JOIN Example
• CROSS JOIN Defined
• CROSS JOIN Example

​Combining and Limiting Result Sets

• UNIONs
• UNION ALL vs. UNION
• UNION Correct Syntax
• Limiting Rows using TOPN
• INTERSECT Defined
• EXCEPT Defined
• INTERSECT and EXCEPT Example

Adding Data

• Inserting Data
• INSERT Example
• Inserting Multiple Rows
• Inserting Partial Values

Updating and Deleting Data

• Updating Data
• UPDATE Example
• Updating Multiple Rows and Columns
• UPDATE Example Continued
• Deleting Data
• DELETE Example
• Deleting Data using Subqueries
• Understanding Transactions
• Creating and Commiting a Transaction

Working with Views

• View Defined
• View Types
• Standard Views
• CREATE VIEW Example
• Using a View to Rename Columns
• Filtering Data with Views
• Creating Views Graphically

Stored Procedures and Functions

• Stored Procedures Defined
• SP Parameters and Best Practices
• CREATE PROC Example
• Late Binding
• Using Parameters with Stored Procedures
• Built-in vs. User-Defined Functions
• Function Parameters
• Sample Scalar Function Syntax
• Proper Function Body Syntax
• Calling Scalar Functions
• Table-Valued Functions
• Scalar Function Example

Data Normalization

• Database Design Phases
• Understanding Database Normalization
• Design Problems
• Row INSERT Anomalies
• DELETE Anomalies
• UPDATE Anomalies

First Normal Form

• Overview of Normal Forms
• First Normal Form Rules
• First Normal Form Example 1
• Candidate Keys Defined
• Primary Keys Defined
• Non-Prime Attributes Defined
• First Normal Form Example 2
• First Normal Form Anomalies

Second and Third Normal Forms

• Functional Dependency Defined
• Second Normal Form Rules
• Second Normal Form Example
• Second Normal Form Rules Continued
• Transitive Dependencies
• Third Normal Form

Fourth and Fifth Normal Forms

• BCNF
• Fourth Normal Form Example
• Fifth Normal Form Example

Primary, Foreign, and Composite Keys

• Primary Keys Defined
• Foreign Keys
• Composite Keys
• Creating a Table with a Primary Key

Clustered Indexes

• Overview
• Indexes Improve Table Scans
• Seek
• Clustered Index Benefits
• Data Storage Considerations
• Clustered Index on a Heap Table

Non-Clustered Indexes

• Non-Clustered Index Basics
• Non-Clustered Index on a Heap Table
• Non-Clustered Index Benefits
• Index Creation
• Dropping an Index
• Non-Indexed Table Execution Plan
• Indexed Table Execution Plan

Database Security Concepts

• SQL Security Steps
• Fixed Server Roles
• Permissions Hierarchy
• Adding Database Users
• Special Database Users
• Permissions
• Database Roles
• Creating a Role
• Role Usage

Database Backup and Restore

• SQL Backup Methods
• Backup Rights and Permissions
• Backing Up to Disk
• Backup Frequency Considerations
• Full Backups
• Full Backup Syntax
• Restore vs. Recovery
• Automatic Recovery
• Performing a Full Backup
• Backup with Compression
• Restore Types
• Restore Process
• Simple Restore

​Incremental Backups

• Incremental Backup Usage
• Incremental Backups Defined
• Normal Log Backup
• Backup Log Options
• Restoring the Log
• Transaction Log Backup Example
• Transaction Log Restore Example

Investing in South Africa's future: 

​“South African employers need a workforce that is skilled, adaptable, creative, and equipped for success in the global marketplace.” 

---