Study material for exam 98-364 Database Fundamentals

Problem

I would like to pass Microsoft exam 98-364 Database Fundamentals.  What study materials are available to help me pass this exam?

Solution

This tip covers several links you can use to help study for this exam.

What is the Microsoft 70-364 certification exam?

This is a basic exam related to databases and is the first Microsoft exam to certify your database knowledge.

Who should take the exam?

This exam is oriented to students or professionals who want to show that they have introductory knowledge about databases.

Is the exam oriented to SQL Server?

There are some generic skills that can be applied to any relational database, but in general it is oriented to SQL Server.

Is this exam difficult?

No, this is the easiest SQL Server exam.

Which books would you recommend for this exam?

Here are some recommended books:

• Microsoft 98-364 Exam: Database Fundamentals Kindle
• SQL: The Ultimate Guide From Beginner To Expert – Learn And Master SQL In No Time! (2017 Edition)
• SQL : The Ultimate Beginners Guide To SQL Server – Start With And Master SQL Programming Fast!
• SQL: QuickStart Guide – The Simplified Beginner’s Guide To SQL (SQL, SQL Server, Structured Query Language)

Are there some courses for this exam?

Yes, here are a few:

• Developer’s T-SQL Playbook
• DeepDive T-SQL Fundamentals: How to Start with Database Querying

Can you provide some links to study?

Here are recommended links for each section of the test:

Understanding Core Database Concepts

• Understand how data is stored in tables
  • Tables
  • Tables, Records, and Fields
• Understand relational database concepts
  • A Relational Database Overview
  • Relational Database Model
  • Integrity Rules In Relational Database Model
  • Primary and Foreign Key Constraints
  • Designing Tables
  • Implementing a Relational Database
• Understand data manipulation language
  • Data Manipulation Language (DML)
  • Data Manipulation Language (DML) Statements (Transact-SQL)
• Understand data definition language (DDL)
  • Data Definition Language (DDL) Statements (Transact-SQL)
  • Data Definition Language (DDL)

Create Database Objects

• Choose data types
  • SQL General Data Types
  • Data type
  • Data Types (Transact-SQL)
• Understand tables and how to create them
  • Table
  • SQL CREATE TABLE Statement
  • CREATE TABLE (Transact-SQL)
  • Publishing Data and Database Objects
• Create views
  • Views
  • How to create a view using Microsoft SQL Server Management Studio
  • How to: Create Views (Visual Database Tools)
• Create stored procedures and functions
  • SQL Server Date Functions and SQL Server String Functions
  • SQL Server Stored Procedure Tutorial
  • Stored procedure

Manipulate Data

• Select data
  • Walkthrough: Retrieving, Updating, Inserting, and Deleting Data with the LinqDataSource and DetailsView Controls
  • Selecting Data Using the SqlDataSource Control
  • SELECT Column Example
  • SELECT Examples (Transact-SQL)
  • Types of Joins
  • SQL Joins
  • UNION (Transact-SQL)
  • EXCEPT and INTERSECT (Transact-SQL)
• Insert data
  • SQL INSERT INTO Statement
  • INSERT (Transact-SQL)
• Update data
  • SQL UPDATE Statement
  • UPDATE (Transact-SQL)
• Delete data
  • SQL DELETE Statement
  • DELETE (Transact-SQL)
  • How to: Delete Rows From the Database (LINQ to SQL)

Understand Data Storage

• Understand normalization
  • Database Normalization Basics
  • Database normalization
• Understand primary, foreign, and composite keys
  • Primary and Foreign Key Constraints
  • Working with keys
  • SQL PRIMARY KEY Constraint
  • SQL FOREIGN KEY Constraint
  • SQL by Design: How to Choose a Primary Key
  • Composite Key In SQL
  • How to: Handle composite keys in queries (LINQ to SQL)
• Understand indexes
  • Defining a Clustered Index
  • Clustered and Nonclustered Indexes Described
  • Choosing Non-Clustered Indexes
  • Stairway to indexes
  • Working with Indexes

Administer a Database

• Understand database security concepts
  • Database Security
  • Permissions (Database Engine)
  • Server-Level Roles
  • Database-Level Roles
  • CREATE USER (Transact-SQL)
  • Security considerations for a SQL Server installation
  • SQL Server Security (ADO.NET)
• Understand database backups and restore
  • Backing Up and Restoring Databases in SQL Server
  • Types of SQL Server Backups
  • World Backup Day: Best practices to back up your data

Next Steps

Here are several links that could be useful to you:

• Exam 98-364
• Exam policies and FAQ