MTA: Database Fundamentals (98-364)

(98-364-2018) / ISBN: 9781644590782
This course includes
Lessons
TestPrep
LiveLab
Share
$279.99
Try This Course
Are you an instructor?
Request a free evaluation copy

MTA: Database Fundamentals (98-364)

Start your prep for the MTA 98-364 exam with the MTA Database Fundamentals (98-364) course and lab. The lab is cloud-based, device-enabled, and can be easily integrated with an LMS. This MTA 98-364 practice tests course covers the 98-364 exam objectives and provides the skills that are necessary to work with databases, including relational databases, such as Microsoft SQL Server.
Here's what you will get

The MTA Database Fundamentals certification exam is a standalone certification from Microsoft with the exam code 98-364. The MTA certification is for the candidates who want to prove their caliber in software development. The MTA certification provides an appropriate entry point to a future career in technology.

Lessons
  • 6+ Lessons
  • 50+ Quizzes
  • 76+ Flashcards
  • 76+ Glossary of terms
TestPrep
  • 50+ Pre Assessment Questions
  • 2+ Full Length Tests
  • 54+ Post Assessment Questions
  • 108+ Practice Test Questions
Lab
  • 42+ Performance lab
  • 42+ Video tutorials
  • 39+ Minutes
Video Lessons
  • 319+ Videos
  • 06:03+ Hours
Here's what you will learn
Download Course Outline
  • Understand How Data is Stored in Tables
  • Understand Relational Database Concepts
  • Understand Data Manipulation Language (DML)
  • Understand Data Definition Language (DDL)
  • Summary
  • Choose Data Types
  • Understand Tables and How to Create them
  • Create Views
  • Create Stored Procedures and Functions
  • Summary
  • Select Data
  • Insert Data
  • Update Data
  • Delete Data
  • Transaction Controls
  • Summary
  • Understand Normalization
  • Understand Primary, Foreign, and Composite keys
  • Understand Indexes
  • Summary
  • Understand Database Security Concepts
  • Understand Database Backups and Restore
  • Summary

Hands on Activities (Performance Labs)

  • 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
Exam FAQs
What are the prerequisites for this exam? Candidates for the exam should be familiar with the concepts of and have hands-on experience with the technologies covered in the exam, either by taking relevant training courses or by working with tutorials and samples available on MSDN and in Microsoft Visual Studio.
What is the exam registration fee? USD 127
Where do I take the exam? Certiport or Pearson VUE
What is the format of the exam? Single choice, multiple choice, drag-and-drop, active screen, build list, case studies, and short answer.
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the duration of the exam? 45 minutes
What is the passing score? The passing score varies from exam to exam and is provided on the score report.
What is the exam's retake policy?

Microsoft Technology Associate (MTA) and Microsoft Certified Educator (MCE) exam retake policy:

  1. 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.
  2. 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.
  3. A seven-day waiting period is imposed between each subsequent exam retake.
  4. 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? For life
Where can I find more information about this exam? To know more about the , click here.
What are the career opportunities after passing this exam?
  • Database Developer
  • Database Administrator
×