Books for MTA 98-364 Database Fundamentals RRS feed

  • Question

  • Hi,

    Looking for reference book for MTA 98-364 exam.

    Please suggest a book for MTA 98-364 Database fundamentals exam.

    Thanks in advance

    Monday, November 3, 2014 1:04 PM


All replies

  • Have you tried the Google?

    Best Regards,Uri Dimant SQL Server MVP,

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Monday, November 3, 2014 1:51 PM
  • Try this link:

    Also, try this free course on Database Fundamental

    Monday, November 3, 2014 2:03 PM
  • Exam 98-364 site link:

    Your best approach is to practice with the AdventureWorks database.  Here are some practice T-SQL scripts:

    You should aim for hands-on experience not just passing an exam.  Best to get SQL Server 2014 Developer Edition (around $50). You can also use the free Express Edition, but that has restrictions.

    QUOTE: "

    Understanding core database concepts (20–25%)
    • Understand how data is stored in tables

      • Understand what a table is and how it relates to the data that will be stored in the database; columns/fields, rows/records

    • Understand relational database concepts

      • Understand what a relational database is, the need for relational database management systems (RDBMS), and how relations are established

    • Understand data manipulation language (DML)

      • Understand what DML is and its role in databases

    • Understand data definition language (DDL)

      • Understand how T-SQL can be used to create database objects, such as tables and views

    Create database objects (20–25%)
    • Choose data types

      • Understand what data types are, why they are important, and how they affect storage requirements

    • Understand tables and how to create them

      • Purpose of tables; create tables in a database by using proper ANSI SQL syntax

    • Create views

      • Understand when to use views and how to create a view by using T-SQL or a graphical designer

    • Create stored procedures and functions

      • Select, insert, update, or delete data

    Manipulate data (25–30%)
    • Select data

      • Utilize SELECT queries to extract data from one table, extract data by using joins, combine result sets by using UNION and INTERSECT

    • Insert data

      • Understand how data is inserted into a database, how to use INSERT statements

    • Update data

      • Understand how data is updated in a database and how to write the updated data to the database by using the appropriate UPDATE statements, update by using a table

    • Delete data

      • Delete data from single or multiple tables, ensure data and referential integrity by using transactions

    Understand data storage (15–20%)
    • Understand normalization

      • Understand the reasons for normalization, the five most common levels of normalization, how to normalize a database to third normal form

    • Understand primary, foreign, and composite keys

      • Understand the reason for keys in a database, choose appropriate primary keys, select appropriate data type for keys, select appropriate fields for composite keys, understand the relationship between foreign and primary keys

    • Understand indexes

      • Understand clustered and non-clustered indexes and their purpose in a database

    Administer a database (10–15%)
    • Understand database security concepts

      • Understand the need to secure a database, what objects can be secured, what objects should be secured, user accounts, and roles

    • Understand database backups and restore

      • Understand various backup types, such as full and incremental, importance of backups, how to restore a database


    Kalman Toth Database & OLAP Architect SQL Server 2014 Database Design
    New Book / Kindle: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2014

    Wednesday, November 5, 2014 1:27 AM
  • That book doesn't completely works. Even though is the "official" book, it has a lot of errors. Learn online, save your money.

    Citing J.C. Bartleon (December 8, 2012) at Amazon Top Reviews for the book (I cannot insert the URL for the moment, sorry):

    Overall, the information in the book is useful; however, unless you already have a great deal of knowledge related to databases, I fear you will find yourself confused or, possibly, completely lost. The primary issues with this book are:

    Insufficient elaboration of concepts. The author will often state something about a topic as if it is common knowledge, giving little detail, such as his treatment of non-clustered indexes. For example, the concept of "Using Queries to Select Data" is a full 13 pages (and fairly well done). The concept of both clustered and non-clustered indexes is only five pages, most of which is nothing more than screenshots from SSMS.

    Confusion of terms. The author will often write one term when meaning another, such as inserting "database" when the actual word should be "table". Typos of this kind would introduce much confusion unless you already know enough to think "The author is wrong; I think he means insert-whatever-he-should-mean-here."

    Poor example code. Some code examples are incomplete or incorrect. Again, not a big deal if you already understand T-SQL, but a big problem if you don't and are relying on the author to be correct.

    Extremely poor end-of-chapter questions. Many of the after-chapter questions are unanswerable based solely on the information from the book. For example, if you were new to SQL, and had only read this book, you would not be able to answer the Chapter 1 question "What does SQL stand for?" The answer is nowhere in the text. Google and MSDN will be your friends while going through this book's concepts.

    Overall, many of the issues with this book could be ameliorated by a competent error-checking team. That would eliminate the poor code examples, typos, confused terms, and questions to which there are no answers. However, the cursory treatment of more complex topics is difficult to explain without coming to the conclusion that the author was not overly concerned with whether or not his readers truly understood the subject under discussion.

    Wednesday, March 29, 2017 3:22 PM