98-364-2018
MTA: Database Fundamentals (98-364)
Gain hands-on experience to pass the MTA 98-364 exam with the MTA Database Fundamentals (98-364) course and lab. Lab simulates real-world, hardware, software, and command-line interface environments and can be mapped to any textbook, course, or training. This MTA Training course and lab cover the 98-364 exam objectives and provide the skills that are necessary to work with databases, including relational databases, such as Microsoft SQL Server.
- Practice in 42 Hands-On Labs — nothing to install
- 6 Interactive Lessons and 23 topics mapped to the official exam objectives
- 200 Practice Test Questions and 2 Full Length Tests
Beginner Self-paced · 1 year access 4.6/5 (24 Reviews)
42 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Skills you'll get
What you will be able to do
Target Career Roles
- Database Developer
- Database Administrator
02 / Lessons & labs
See exactly what you will learn and practice
Lessons
6 Interactive Lessons · 23 topics01 Understand Core Database Concepts 5 topics · 9 LiveLab +
- Understand How Data is Stored in Tables
- Understand Relational Database Concepts
- Understand Data Manipulation Language (DML)
- Understand Data Definition Language (DDL)
- Summary
9 LiveLab in this lesson — see the labs panel →
02 Create Database Objects 5 topics · 10 LiveLab +
- Choose Data Types
- Understand Tables and How to Create them
- Create Views
- Create Stored Procedures and Functions
- Summary
10 LiveLab in this lesson — see the labs panel →
03 Manipulate Data 6 topics · 16 LiveLab +
- Select Data
- Insert Data
- Update Data
- Delete Data
- Transaction Controls
- Summary
16 LiveLab in this lesson — see the labs panel →
04 Understand Data Storage 4 topics · 4 LiveLab +
- Understand Normalization
- Understand Primary, Foreign, and Composite keys
- Understand Indexes
- Summary
4 LiveLab in this lesson — see the labs panel →
05 Administer a Database 3 topics · 3 LiveLab +
- Understand Database Security Concepts
- Understand Database Backups and Restore
- Summary
3 LiveLab in this lesson — see the labs panel →
06 Appendix +
Hands-On Labs Our edge
42 LiveLabs- Creating a Database
- Deleting a Database
- Adding a Column to a Table
- Renaming a Table
- Modifying a Column in a Table
- Dropping a Column from a Table
- Using the SELECT Command
- Creating an ER Diagram
- Using the CREATE Command
- Exceeding Data Type Limit
- Handling NULL Values
- Inserting Values into a Table using the Stored Procedure
- Creating an Inline Table-Valued Function
- Using the CREATE VIEW Syntax
- Using the ALTER VIEW Statement
- Creating a View using the WITH CHECK OPTION Clause
- Creating a Stored Procedure
- Altering a Stored Procedure
- Modifying Stored Proc Definitions
- Using the SELECT DISTINCT Statement
- Using the SELECT, FROM, and WHERE Clauses
- Using the ORDER BY Keyword
- Using the UNION Operator
- Using the INTERSECT Operator
- Using the EXCEPT Operator
- Using LEFT OUTER JOIN
- Using RIGHT OUTER JOIN
- Using FULL OUTER JOIN
- Using CROSS JOIN
- Using a Simple Inner Join
- Using a Complex Inner Join
- Using the INSERT statement
- Using the UPDATE Statement
- Using the DELETE Statement
- Using Transaction Controls
- Using Referential Integrity Constraints
- Creating a Function-Based Index
- Using a Function-Based Index
- Creating a Non-Clustered Index
- Adding a New Login
- Accessing the Database Roles
- Creating a Backup
03 / Exam details
MTA: Database Fundamentals (98-364) Details
Gain hands-on experience to pass the MTA 98-364 exam with the MTA Database Fundamentals (98-364) course and lab. Lab simulates real-world, hardware, software, and command-line interface environments and can be mapped to any textbook, course, or training. This MTA Training course and lab cover the 98-364 exam objectives and provide the skills that are necessary to work with databases, including relational databases, such as Microsoft SQL Server.
Ready to take the exam?
Add your official 98-364-2018 exam voucher to your order.
Official Voucher · Fast delivery · Retake bundle available04 / FAQs
Questions before you start
What are the prerequisites for this exam?+
What is the exam registration fee?+
Where do I take the exam?+
What is the format of the exam?+
How many questions are asked in the exam?+
What is the duration of the exam?+
What is the passing score?+
What is the exam's retake policy?+
Microsoft Technology Associate (MTA) and Microsoft Certified Educator (MCE) exam retake policy:
- If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam.
- If a candidate does not achieve a passing score the second time, the candidate must wait seven days before retaking the exam a third time.
- A seven-day waiting period is imposed between each subsequent exam retake.
- A candidate may not take a given exam any more than five times per year (12 months). This 12-month period starts from the first attempt. The candidate is then eligible to retake the exam 12 months from the date of the first attempt.
What is the validity of the certification?+
Where can I find more information about this exam?+
Prepare for MTA: Database Fundamentals (98-364)
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 42 LiveLab included
- Certificate of completion
No credit card required