Scroll to top button

MTA: Database Fundamentals

ISBN : 9781644590782

Prepare for the 98-364 exam with the MTA: Windows Database Fundamentals course and lab. The lab is cloud-based, device-enabled, and can be easily integrated with an LMS. This complete 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.

The MTA: Database 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 MTA certification provides an appropriate entry point to a future career in technology.

Lessons
Lessons
6+
Quizzes
50+
Flashcards
76+
Glossary of terms
76+
TestPrep
Pre Assessment Questions
50+
Full Length Tests
2+
Post Assessment Questions
54+
Lab
Performance lab
Learn the real world skills using LiveLab.
42+
Video tutorials
Get interactive learning videos with transcripts and voice-over.
42+
Minutes
Signify the duration of video tutorials in labs.
39+

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
Videos
319+
Hours
06:03+
Exam related 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-2018, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • Database Developer
  • Database Administrator
  • 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 (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
×