StellieTech
  • Home
  • About
  • Courses
    • Microsoft Office Courses >
      • Word All
      • Word Expert
      • Excel All
      • Excel Expert
      • Excel Pivot Table Course
      • Access All
      • PowerPoint All
      • Outlook All
    • Computer Literacy >
      • Typing Course
      • Introduction to Computers
      • Digital Literacy Course
    • Office Administration Course
    • Marketing Courses >
      • Google Digital Marketing Course
      • Google Analytics
    • MTA Courses >
      • MTA - Mobility and Devices Fundamentals
      • MTA - Database Administration Fundamentals
      • MTA - Networking Fundamentals
      • MTA - Software Development Fundamentals
      • MTA Security Fundamentals
      • MTA- Introduction to Programming using Python Course
      • MTA- Introduction to Programming using JavaScript Course
      • MTA- Introduction to Programming using HTML and CSS Course
      • MTA- Introduction to Programming using Java Course
      • MTA- HTML5 Application Development Fundamentals
      • MTA- Windows Operating System Fundamentals
      • MTA- Cloud Fundamentals
    • Adobe Courses >
      • Adobe Photoshop CC
      • Adobe Illustrator CC
      • Adobe InDesign CC
      • Adobe Premiere Pro CC
    • CompTIA Courses >
      • CompTIA A+ Course 220-1001 Series
      • CompTIA Network+ Course
      • CompTIA Security+ Course
    • Tests and Examination >
      • MTA-Windows Server Administration Fundamentals
    • Practice Tests >
      • 77-725 Word 2016
      • 77-727 Excel 2016
  • e-Learning
  • Course Creation
  • Contact

MTA: Database Administration Fundamentals

Excel 2016 Beginner Course - Online
INTERNATIONALLY ACCREDITED
Picture
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

    Request A Quote

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

Back to All Courses
STAFF TRAINING

Microsoft Courses

Excel
Word
Access Beginners
PowerPoint
Outlook

Certification Practice Exams

Gmetrix Practice Exams

AVAILABLE Training Dates

Dates

Office Admin Courses

Office Assistant
Office Administration

Adobe Courses

Photoshop Courses 
InDesign Courses
Flash Courses
​ Illustrator Courses

Staff Training

Staff Training

Computer Literacy Courses

Digital Literacy Course

Become Certified

CompTIA Exams
HP Accredited Technical Associate Exams
Autodesk Certified User Exams
QuickBooks Certified Exams
IC3 Digital Computer
Literacy Exams

Microsoft Technology
Associate Exams
​
Pastel Beginners Course
Pastel Partner Intermediate Course
​Contact Us
Monday - Friday  09:00 - 16:00
Saturday s 09:00 - 16:00

Contact Details
Tel: 021 879 2679
Email: info@stellietech.co.za
Opening Hours
​
Monday - Thursday  09:00- 16:00

Saturdays 09:00- 16:00
​
​​Stellenbosch
UNIT B12 Carpe Diem Building
26 Quantum Street, Techno Park
7600


Picture
Picture
Picture
Picture
Picture
Picture
© All rights reserved 2019 StellieTech. 

BOOKING SITE: sTELLIETECH.COM

Payment T&C's | PrivacyPolicy
Picture
Picture
Picture
Picture
  • Home
  • About
  • Courses
    • Microsoft Office Courses >
      • Word All
      • Word Expert
      • Excel All
      • Excel Expert
      • Excel Pivot Table Course
      • Access All
      • PowerPoint All
      • Outlook All
    • Computer Literacy >
      • Typing Course
      • Introduction to Computers
      • Digital Literacy Course
    • Office Administration Course
    • Marketing Courses >
      • Google Digital Marketing Course
      • Google Analytics
    • MTA Courses >
      • MTA - Mobility and Devices Fundamentals
      • MTA - Database Administration Fundamentals
      • MTA - Networking Fundamentals
      • MTA - Software Development Fundamentals
      • MTA Security Fundamentals
      • MTA- Introduction to Programming using Python Course
      • MTA- Introduction to Programming using JavaScript Course
      • MTA- Introduction to Programming using HTML and CSS Course
      • MTA- Introduction to Programming using Java Course
      • MTA- HTML5 Application Development Fundamentals
      • MTA- Windows Operating System Fundamentals
      • MTA- Cloud Fundamentals
    • Adobe Courses >
      • Adobe Photoshop CC
      • Adobe Illustrator CC
      • Adobe InDesign CC
      • Adobe Premiere Pro CC
    • CompTIA Courses >
      • CompTIA A+ Course 220-1001 Series
      • CompTIA Network+ Course
      • CompTIA Security+ Course
    • Tests and Examination >
      • MTA-Windows Server Administration Fundamentals
    • Practice Tests >
      • 77-725 Word 2016
      • 77-727 Excel 2016
  • e-Learning
  • Course Creation
  • Contact