By: Daniel Calbimonte | Comments (6) | Related: More > Professional Development Certifications
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:
- 40364A: Database Administration Fundamentals: MTA Exam 98-364
- 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
- Understand relational database concepts
- A Relational Database Overview
- Introduction to RDBMS
- 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)
- Basic SQL statements: DDL and DML
- Data Manipulation Language (DML) Statements (Transact-SQL)
- Understand data definition language (DDL)
Create Database Objects
- Choose data types
- Understand tables and how to create them
- 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
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
- Update data
- Delete data
Understand Data Storage
- Understand 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
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
Next Steps
Here are several links that could be useful to you:
About the author
Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and 6-time Microsoft Certified IT Professional. Daniel started his career in 2001 and has worked with SQL Server 6.0 to 2022. Daniel is a DBA as well as specializes in Business Intelligence (SSIS, SSAS, SSRS) technologies.This author pledges the content of this article is based on professional experience and not AI generated.
View all my tips
