98-364 Database Fundamentals Exam Guide: Scope, Retirement Status, and a Practical Study Plan
Exam 98-364 was Microsoft’s Database Fundamentals MTA exam, intended to validate entry-level understanding of relational databases, database management systems, database components, database objects, security requirements, graphical tools, T-SQL scripts, queries, and stored procedures. It served students, educators, and learners building a foundation before moving toward role-based Microsoft training. The immediate decision for a reader today is not how to book 98-364, but whether to use its database topics for study and choose a current Microsoft credential instead, because Microsoft retired the MTA exams on June 30, 2022.
Can you still take exam 98-364?
No. Microsoft retired the Microsoft Technology Associate exams, including 98-364 Database Fundamentals, on June 30, 2022. A new candidate cannot register for or take this retired exam, and the associated MTA credential is no longer available to earn. Treat this page as a subject guide and historical exam reference, not as a current scheduling page.
What the retirement means for a study plan
Do not spend money looking for a voucher or rely on a third-party claim that an appointment is available. Microsoft states that retired exams cannot be taken and that their associated certifications or credentials cannot be earned after the retirement date. If your goal is a current Microsoft credential, begin with Microsoft’s current certification catalog rather than trying to recreate the old MTA path.
Why older 98-364 material can still be useful
The exam’s subject areas remain a sensible foundation for learning database terminology and SQL Server concepts. They can help a beginner identify gaps in relational modeling, database objects, data manipulation, and administration. That educational value is separate from certification status: studying the old outline does not create eligibility to sit the retired exam or guarantee any current certification.
What did 98-364 validate?
98-364 was identified by Microsoft as “Database Fundamentals” and as an MTA exam. Its published learning series describes foundational knowledge of relational databases, database management systems, and database components, with practical coverage extending to objects, security, graphical tools, T-SQL, queries, and stored procedures.
The intended candidate profile
The material was aimed at people beginning in technology rather than specialists responsible for complex production database estates. A suitable learner might be a student, an educator planning introductory instruction, or an early-career candidate who needs a vocabulary for database work. The content is best approached as foundation building, not as evidence of advanced database administration experience.
What the credential was meant to support
Microsoft described MTA certifications as a starting point for learners and recommended moving toward newer, role-based certifications as technology and job responsibilities evolved. For a present-day learner, the practical use of 98-364 topics is therefore diagnostic: use them to build or test fundamentals, then select a current path that matches data, Azure, or another target role.
Which skill areas should you study?
The official Database Fundamentals series organizes the subject into core database concepts, relational concepts, creating databases and database objects, using DML statements, and SQL Server administration fundamentals. The series also mentions security requirements, graphical tools, T-SQL scripts, database queries, and stored procedures, giving you a workable study scope even though the supplied sources do not publish an exam percentage blueprint.
Core database concepts
Start by making the basic vocabulary precise. Distinguish a database from a database management system and identify the purpose of database components. Then connect the vocabulary to a simple business scenario: customers, orders, products, and payments are data entities with relationships and rules, not merely unrelated tables. Write your own definitions and test them against examples.
Relational concepts
Relational design deserves deliberate practice because it links structure to data quality. Microsoft’s relational-concepts module specifically covers normalization, referential integrity, and constraints. Study why related data is separated, how keys connect rows, and how rules prevent invalid relationships. Do not memorize labels without explaining the problem each design technique solves.
Creating databases and database objects
The database-objects module covers data types, database objects, DDL statements, and creating scripts. Practice choosing an appropriate type for each field, identifying common objects, and reading or writing schema-definition statements. Your goal is to predict the result of a definition before running it and to explain how a change affects dependent objects.
DML statements and querying
Treat data manipulation as a reasoning exercise rather than a syntax list. Work through inserting, changing, removing, and retrieving data in a controlled sample database. For every statement, state which rows should be affected and why. Then inspect the result and investigate unexpected changes instead of correcting them by guesswork.
SQL Server administration fundamentals
Reserve study time for administrative ideas alongside query writing. The official series includes SQL Server administration fundamentals and describes security requirements and graphical tools as part of the course scope. Learn the purpose of access control, administrative interfaces, and routine database management tasks at a fundamentals level, without assuming that this outline represents advanced operational coverage.
How should you sequence your preparation?
Use a dependency-first sequence: concepts, relational design, object creation, data manipulation, querying, and administration. This order reduces confusion because later work depends on earlier choices. Read the corresponding Microsoft learning episodes, reproduce the examples in a permitted practice environment, and keep a mistake log that records the concept behind each error.
Phase one: establish the mental model
Begin with a one-page map of database, table, row, column, key, relationship, constraint, query, and stored procedure. Add a short example for every term. If two terms seem interchangeable, write a contrast rather than another definition. This phase is complete when you can describe how a user request travels from stored data to a returned result.
Phase two: model a small relational system
Choose a modest scenario such as a library or service desk and sketch its entities, attributes, keys, and relationships. Normalize the design enough to avoid repeated facts, then identify where referential integrity and constraints matter. Review the design by asking what happens when a record is added, changed, or deleted.
Phase three: create and manipulate objects
Turn the model into a small script. Define the database objects and data types, load representative rows, and perform controlled data changes. Read the script from top to bottom before execution. When it fails, classify the problem as syntax, object dependency, data type, constraint, or permission-related; that classification is more valuable than simply copying a corrected line.
Phase four: query and explain results
Write queries that answer specific questions from your sample data. Before execution, predict the selected columns, row count, duplicate behavior, and effect of filtering or joining. After execution, explain whether the result matches the business question. This habit prepares you for scenario-based reasoning without depending on unauthorized question collections or recalled test items.
Phase five: consolidate administration and security
Finish by revisiting security requirements, graphical tools, scripts, queries, and stored procedures as connected tasks. For example, explain which object a user needs, how a query accesses data, and why a stored procedure might be used. Keep the explanation at the level supported by the fundamentals scope rather than inventing product-specific requirements.
What should a realistic weekly roadmap look like?
A useful roadmap alternates explanation with construction. Each study session should produce an artifact: a vocabulary sheet, relationship diagram, schema script, data-change exercise, query set, or administration checklist. Review the artifact the next session before adding new material. This makes progress visible and exposes weak areas earlier than passive video watching.
First study block: concepts and relationships
Use the Database Fundamentals series to establish terminology, then focus on relational concepts. Pause after normalization, referential integrity, and constraints and explain each in your own words. Create a diagram with deliberately invalid examples, such as an orphaned related row, and state which rule should prevent the problem.
Second study block: objects and definitions
Study the episode on creating databases and database objects. Build a glossary of data types, object categories, DDL, and scripts. Write a small definition script and review it line by line. Check whether each field’s type supports the data it is expected to hold and whether object names communicate purpose clearly.
Third study block: DML and queries
Use a small, disposable dataset to practice data manipulation and retrieval. Keep each exercise narrow so you can identify the effect of one statement. Add questions that require filtering, joining, or aggregation only after you can explain basic row selection. Record not just the correct result but the reason it is correct.
Final study block: retrieval and correction
Close the cycle by working without notes, then compare your answers with the learning material. Rebuild any topic you cannot explain. A strong readiness signal for database fundamentals is consistent reasoning: you can choose a structure, anticipate a constraint, predict a statement’s effect, and diagnose a mismatch using evidence from the schema and data.
Which official resources are worth using?
Start with Microsoft’s Database Fundamentals series because it directly presents the subject sequence and names the covered concepts. Use the relational-concepts episode for normalization, referential integrity, and constraints, and the database-objects episode for data types, objects, DDL statements, and scripts. Use Microsoft’s retirement guidance to verify status before making any registration or credential decision.
Use videos actively, not passively
Before each episode, write two questions you expect the material to answer. During the lesson, capture the rule or concept, not every spoken sentence. Afterward, recreate the idea with your own schema or query. If you cannot produce an example without replaying the episode, mark that topic for a second pass.
Separate official scope from your extension work
The official sources establish the learning themes listed above, but they do not supply a current 98-364 exam blueprint, question format, score requirement, duration, language list, or delivery method. You may extend your practice beyond the outline for general database learning, but label those additions as personal study choices rather than official exam requirements.
What common preparation mistakes should you avoid?
The most damaging mistake is preparing as though 98-364 were an active exam. Other problems include memorizing isolated SQL fragments, ignoring relational design, skipping security concepts, and using dumps as a substitute for understanding. Build and explain small database tasks instead; that approach develops transferable knowledge without relying on live or leaked exam content.
Mistake: trusting stale scheduling information
Old pages may mention vouchers, registration windows, or appointment processes that no longer apply. Microsoft states that MTA exams could not be retaken after June 30, 2022, and that MTA exams and certifications were retired on that date. Verify any current credential decision against Microsoft Learn rather than a cached training or voucher page.
Mistake: studying syntax without data reasoning
A statement can be syntactically valid and still answer the wrong question or change the wrong rows. Always define the intended result first. Use a small dataset, inspect affected records, and explain why the statement is safe or unsafe. This is especially important when learning DML, constraints, and relational joins.
Mistake: treating all database knowledge as one topic
Database concepts, relational modeling, object creation, DML, querying, and administration solve different problems. Mixing them too early makes errors difficult to diagnose. Keep separate notes and exercises, then connect them through one small project. This produces clearer revision targets and prevents a familiar term from being mistaken for demonstrated competence.
Mistake: using dumps or recalled questions
Dumps do not restore a retired exam, establish legitimate access, or prove understanding. Memorizing purported questions can also hide gaps in design, data integrity, and query reasoning. Use official learning material and original practice tasks instead, and never seek leaked content or claim that memorization guarantees a pass on any certification.
What should you do about the old MTA credential?
If you already earned an MTA certification, Microsoft says MTA certifications do not expire and remain on the certification transcript. Microsoft’s retirement guidance also explains that a retired credential remains available in the transcript, while the presentation of older credentials changes over time. If you never earned it, retirement prevents you from pursuing it now.
Previously earned certification
Microsoft states that an MTA certification already earned remains on the transcript and is printable after the exams retire. The retirement does not erase the achievement. For a credential without an expiration date, Microsoft’s policy says it remains in the Active section of the transcript for two years following retirement and then moves to Certification History.
Unfinished preparation or an unused voucher
An unfinished study plan cannot be converted into a new 98-364 attempt. Microsoft says candidates had until June 30, 2022, to register for and take an MTA exam, and previously purchased MTA vouchers could not be traded in for another exam. Contact Microsoft support for account-specific questions, but do not assume an old voucher has current value.
Choosing a replacement direction
Microsoft’s retirement FAQ points learners toward newer fundamentals and role-based offerings across areas including Azure, AI, Data, Power Platform, Microsoft 365, and Dynamics. Select among those areas by the work you want to perform. Use the 98-364 study topics as preparation for database literacy, not as a claim that it maps one-for-one to a replacement certification.
How can you tell whether your study is working?
Measure performance with explanations and small builds rather than with an unofficial percentage or a copied question score. You should be able to define the major terms, design related data, choose sensible data types, create objects, manipulate rows carefully, interpret query results, and discuss basic administration and security purposes.
A practical self-check
Close your notes and complete a short scenario from beginning to end. Identify entities and relationships, state integrity rules, choose data types, outline objects, write representative data operations, and explain the query result. Then inspect your own work for ambiguity, invalid relationships, unintended row changes, and permissions or security concerns.
How to interpret weak results
If definitions are weak, return to core concepts. If the schema is weak, revisit normalization and constraints. If statements are weak, use smaller datasets and predict effects before execution. If explanations are weak despite working code, write a plain-language interpretation of each result. Target the underlying skill instead of repeating an entire course indiscriminately.
What are the next actions for a 98-364 learner?
First, confirm whether you are learning database fundamentals or seeking an active credential; those are now different decisions. Next, study the official Database Fundamentals modules, build a small relational practice project, and document your gaps. Finally, consult Microsoft Learn for a current certification aligned with your intended role before paying for any exam or training product.
A short action checklist
Verify the retired status on Microsoft Learn. Save the official Database Fundamentals series and its relational-concepts and database-objects episodes. Create a study notebook with separate sections for concepts, relationships, objects, DML, queries, administration, and security. Build one small database exercise, review the mistakes, and then compare current Microsoft credential options with your career objective.
The sensible boundary for this guide
This guide can help you understand the old exam’s subject matter and make a responsible preparation decision. It cannot provide a current appointment, restore a retired certification route, or substitute for Microsoft’s live certification information. Keep checking official Microsoft pages for changes, especially when a credential’s retirement or availability affects your next investment of time or money.
Conclusion
Exam 98-364 is no longer a schedulable Microsoft exam, but its foundational database scope remains useful for structured learning. Study the concepts in dependency order, practice relational design and SQL-related tasks with your own data, and use Microsoft’s retirement and credential policies to avoid outdated registration assumptions. If your objective is certification rather than historical knowledge, move from the old MTA outline to a currently available Microsoft path that matches the database or technology role you want next.
