Scroll to top button

MTA: Database Fundamentals Labs

ISBN : 9781616913571

Kick start your prep for Microsoft Database Fundamentals: 98-364 exam with MTA: Database Fundamentals performance-based labs. Performance-based labs are versatile - labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training. The labs provide you the knowledge and skills with databases, including relational databases, such as Microsoft SQL Server.

The MTA: Database Administration Fundamentals certification exam is a standalone certification from Microsoft with the exam code 98-364. The certification is for the candidates who want to prove their caliber in software development. The exam validates your expertise to understand core database concepts, create database objects, manipulate data, understand data storage, and administer a database.

Performance lab
Learn the real world skills using Live Labs.
Exam related FAQs
What is the exam registration fee? USD 127
Where do I take the exam? Certiport or Pearson VUE
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 MTA exam passing percentage varies from exam to exam.
What is the exam's retake policy?

Here are the retake policies:

  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 for 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 the day of the fifth unsuccessful exam retake. The candidate is then eligible to retake the exam 12 months from that date.
  5. If a candidate achieves a passing score on an MTA exam, the candidate cannot take it again.
Where can I find more information about this exam? To know more about the 98-364-lab-2018, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • Database Developer
  • Database Administrator

Hands on Activities (Labs)

  • Creating a database
  • Deleting a database
  • Creating a table
  • Adding a column to the table
  • Dropping a column from the table
  • Creating ER diagram
  • Inserting values into a table
  • Retrieving all the attribute values using asterisk
  • Retrieving the data using multiple conditions
  • Using Check constraints in a table
  • Creating view
  • Creating view using the CHECK OPTION clause
  • Altering view
  • Creating stored procedure
  • Creating stored procedure using output parameter
  • Altering a stored procedure
  • Inserting values into a table using stored procedure
  • Creating an inline table-valued function
  • Using SELECT DISTINCT statement
  • Retrieving the sorted data using the ORDER BY clause
  • Using select-project-join query
  • Retrieving values of a table using nested queries I
  • Retrieving values of a table using nested queries II
  • Retrieving values of a table using LEFT OUTER JOIN operator
  • Retrieving values of a table using the CROSS JOIN operator
  • Using the UNION operator
  • Using the INTERSECT operator
  • Using the NOT IN operator
  • Using Aggregate functions
  • Counting all the rows of a table
  • Specifying the cross product of the table
  • Using substring pattern matching
  • Using arithmetic operators
  • Inserting values into a table from existing table
  • Updating the table
  • Using the CASE clause
  • Deleting the rows from a table
  • Using Referential Integrity constraints in a table
  • Creating a function-based index
  • Using a function-based index
  • Adding a new login
  • Accessing the Database Roles
  • Creating a backup