98-364-VT : MTA: Database Fundamentals (Video Training)

MTA: Database Fundamentals (Video Training)
43+ Labs
Rating :
Kick-start your prep for Microsoft Database Fundamentals: 98-364 exam with MTA: Windows Database Fundamentals video training course. This course focuses on the objectives covered in the 98-364 exam and provides the skills to understand core database concepts, create database objects, manipulate data, understand data storage, and administer a database.

Here's what you will get

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.

Pre-assessment Questions
Post-Assessment Questions
Performance based lab
Video Tutorials
Video tutorials

Videos and How To..

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
Exam FAQs
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? Active screens, Best answers, Build list, Case study, and so on.
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the duration of the exam? 45 minutes
Where can I find more information about this exam? To know more about the 98-364-VT, click here.
What are the career opportunities after passing this exam?
  • Database Developer
  • Database Administrator

Here's what you will learn

Hands on Activities (Labs)

  • Creating a database
  • Deleting a database
  • Creating a 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
  • Adding a column to the table
  • Dropping a column from the table
  • Using Referential Integrity constraints in a table
  • Creating a function-based index
  • Using SELECT DISTINCT statement
  • Using the UNION operator
  • Using the INTERSECT operator
  • Using the NOT IN operator
  • Retrieving values of a table using nested queries I
  • Retrieving values of a table using nested queries II
  • Using substring pattern matching
  • Using Aggregate functions
  • Counting all the rows of a table
  • Using arithmetic operators
  • Using a function-based index
  • Retrieving the sorted data using the ORDER BY clause
  • Using select-project-join query
  • Specifying the cross product of the table
  • Retrieving values of a table using LEFT OUTER JOIN operator
  • Retrieving values of a table using the CROSS JOIN operator
  • Inserting values into a table from existing table
  • Updating the table
  • Using the CASE clause
  • Deleting the rows from 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
  • Adding a new login
  • Accessing the Database Roles
  • Creating a backup