INTERNATIONALLY ACCREDITED

Duration: 4 Days Dates and Times:  Monday - Friday (09h00 - 16h00)	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.
Venue: Stellenbosch  UNIT B12, Carpe Diem Building 26 Quantum Street, Techno Park ​Stellenbosch 7600 ​​OR Online Training  100% Remote	Follow Up Courses: Other MTA courses

• Course Overview
• Detailed 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 Technology intenationally certified exam. This MTA training will help you become familiar with concepts and technologies pertaining to Database Administration and you will learn about relational databases, queries, stored procedures, and the security requirement for databases and the data stored in them. 

Benefits

• 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 NO

Filtering Data using Pattern Matching

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

Filter Data using Lists and Ranges

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

​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​

Fourth and Fifth Normal Forms

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

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
  

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.” 

---