Candidates for this exam are seeking to prove introductory knowledge of and skills with databases, including relational databases, such as Microsoft SQL Server. It is recommended that candidates be familiar with the concepts of and have hands-on experience with the technologies described here, either by taking relevant training courses or by working with tutorials and samples available on MSDN and in Microsoft Visual Studio. Although minimal hands-on experience with the technologies is recommended, job experience is not assumed for these exams.
Description
MTA Database Fundamentals is designed to provide students with an explanation and understanding of fundamental security concepts. This training course prepares students for Microsoft exam 98-364.
This course provides you with interactive videos that meet the needs of multiple styles of learning from auditory to visual, and it includes a pre-test and post-test that accurately identifies your skill gap.
MTA is an entry-level credential from Microsoft that validates the foundational knowledge needed to take the first step toward building a successful career in technology. The MTA certification programs cover the baseline knowledge of building and managing Microsoft Windows Servers, Windows-based network operating systems, Active Directory, account management, and system recovery tools.
Session 1
- Database Tables
- Database Relationships
- Understanding DML
- Database Data Types
- Creating and Manipulating Tables
- Selecting Data
- Filtering Data using Comparisons
Session 2
- 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
Session 3
- 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
Session 4
- Primary, Foreign, and Composite Keys
- Clustered Indexes
- Non-Clustered Indexes
- Database Security Concepts
- Database Backup and Restore
- Incremental Backups
A more detailed list of topics can be found here.
Aims
- 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
Format
Online videos
- 24/7 Live Help included
- Live Practice Labs included