MTA Database Fundamentals 98-364


comp name

MTA Database Fundamentals is an entry level Certifications for those who are interested to start their career with Microsoft's SQL Server. This Certification will measure your skills in administering Database. You have to pass 98-364 Exam to earn MTA Database fundamentals certification . Find the complete details of MTA Database Fundamentals below.

Exam Details


Required Exam(s) Exam 98-364
Durations 120 Minutes (40 - 60 Questions)
Question Types Multiple choice, drag and drop, Fill in the blanks and simulation types.
Exam Fees Rs.3700(Approx)
Prerequired Exams There is no prerequired Exams to attend MTA
Exam Policy Click here to read the Exam policies.
Recommended Training Database Fundamentals 98-364

Exam Pattern

Below the exam objectives for Querying Microsoft SQL Server 2012/2014.

This exam will measure your skills and knowledge in the following areas and you must score necessary % in all areas.

1.0 Understanding core database concepts (20 - 25%)
  • 1.1 Understand how data is stored in tables
  • 1.2 Understand relational database concepts
  • 1.3 Understand data manipulation language (DML)
  • 1.4 Understand data definition language (DDL)
  • 1.5 Create and alter DML triggers
2.0 Create database objects (20 - 25%)
  • 2.1 Choose data types
  • 2.2 Understand tables and how to create them
  • 2.3 Create views
  • 2.4 Create stored procedures and functions
3.0 Manipulate data (25 - 30%)
  • 3.1 Select data
  • 3.2 Insert data
  • 3.3 Update data
  • 3.4 Delete data
4.0 Understand data storage (15 - 20%)
  • 4.1 Understand normalization
  • 4.2 Understand primary, foreign, and composite keys
  • 4.3 Understand indexes
5.0 Administer a database (10 - 15%)
  • 5.1 Understand database security concepts
  • 5.2 Understand database backups and restore

Books to Prepare

You can Easily pass the exams by preparing the following books.

Mcsa win 12 Cover Image

Book Name : Exam 98-364 MTA Database Administration Fundamentals

Author Name :

Publisher : MOAC (Microsoft Official Academic Course)

Topics Covered in this book:

  • Lesson 1 : Understanding Core Database Objects
    • Understanding Database Concepts
    • Understading Data Manipulation Language (DML)
    • Understanding Data Definition Language (DDL)
  • Lesson 2 : Creating Database Objects
    • Defining Data types
    • Creating and Using Tables
    • Creating Stored Procedures
  • Lesson 3 : Manipulating Data
    • Using Quries To select Data
    • Using Quries To Inserting Data
    • Updating Data and Databases
    • Deleting Data
  • Lesson 4 : Understanding Data Storage
    • Normalizing a Database
    • Understanding Primary, Foreign and Composite Keys
    • Understading Clustered and non clustered Indexes
  • Lesson 5 : Administrating a Database
    • Securing Databases
    • Backing up and Restoring Databases

Softwares for Practice

You can practice your exams by using below tools

Also You can pratice some basics with Microsoft's free Sql server Editions.

Software : MS SQL Server 2012 Express Edition and Management Studio

License : Free

Click here to download the free copy of SQL server Express Editions


Other Microsoft certifications



Quick Links Of Others