98-364 Database Fundamentals Exam Guide: Scope, Retirement, and a Practical Study Plan
Exam 98-364, Database Fundamentals, was an MTA exam designed 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 learners beginning database or data careers, students, and educators. The most important decision now is not simply how to prepare: Microsoft retired MTA exams on June 30, 2022, so readers should first confirm whether they already hold the credential and then choose between studying its foundational topics for skills or pursuing a current Microsoft credential.
Is exam 98-364 still available?
No. Microsoft retired its Microsoft Technology Associate certifications and exams on June 30, 2022. Exam 98-364 should therefore be treated as a retired assessment, not as a currently schedulable Microsoft exam. Before buying study material or planning a test date, verify the current status through Microsoft’s retirement information rather than relying on an old exam listing or a third-party practice page.
The retirement has a practical consequence for anyone searching for a voucher, registration route, or delivery appointment: a retired exam cannot be taken, and its associated certification or credential cannot be earned after retirement. A page that presents 98-364 as an available live exam is not giving a reliable basis for a scheduling decision.
Candidates who already passed the required exam before the retirement deadline earned the associated certification, and Microsoft says previously earned MTA certifications remain on the certification transcript. They can move to Certification History after the applicable post-retirement period, but retirement does not erase the achievement.
What should a new learner do instead?
Use the 98-364 outline as a foundation-skills syllabus rather than as a live-exam booking plan. Study the database concepts that remain useful—relational design, objects, data manipulation, queries, and administration—and map those skills to a current Microsoft learning or certification path after checking Microsoft Learn for the option that matches your intended role. Microsoft’s retirement guidance recommends moving toward newer generations of certifications and fundamentals offerings.
What did 98-364 validate?
98-364 was identified by Microsoft as Database Fundamentals and as an MTA exam. Its associated learning series introduced the terminology, concepts, and skills needed to understand relational databases, database management systems, and database components. The scope was foundational: it was intended to establish a working vocabulary and basic understanding rather than certify an advanced database administrator.
The official Database Fundamentals series describes coverage of database objects, security requirements, graphical tools, T-SQL scripts, database queries, and executing stored procedures. Microsoft’s course outline also names core database concepts, relational concepts, creating databases and database objects, using DML statements, and SQL Server administration fundamentals.
That combination matters when deciding how to study. A learner who knows only SELECT syntax would have a narrow preparation profile. The intended foundation also includes how relational structures work, how objects are created, how data is changed, and how administrative and security concerns affect database use.
What kind of learner was the exam for?
The material was suited to people beginning with databases: students, educators, aspiring developers, junior data practitioners, and technology learners who needed a structured introduction. It could also help a professional test whether their knowledge covered more than isolated query writing. It was not evidence, by itself, of production-scale database architecture or senior administration experience.
What is not evidenced in the supplied research?
The supplied official research does not provide a current exam page with question count, duration, passing score, delivery method, language list, prerequisite, fee, or domain-weight percentages. Those details should not be inferred from archived listings or practice sites. This guide therefore focuses on the documented subject areas and on decisions that remain useful after retirement.
Which skills belong in a 98-364 study plan?
Organize preparation into five knowledge blocks named in Microsoft’s course outline: core database concepts, relational concepts, creating databases and database objects, using DML statements, and SQL Server administration fundamentals. The official series adds security requirements, graphical tools, T-SQL scripts, queries, and stored procedures. Treat the blocks as connected skills, not as isolated vocabulary lists.
The research does not supply blueprint percentages, so there are no verified domain weights to prioritize numerically. A sound plan should begin with concepts and relationships, move into object creation and data changes, then finish with administration, security, and mixed practice. That order reflects dependency between the ideas without claiming that one official domain carried more marks than another.
For each block, write a short explanation in your own words, perform a small hands-on exercise where possible, and record the reason an alternative would be wrong. The final step is particularly useful for fundamentals questions, where several options may sound technically plausible but differ in purpose or scope.
Core database concepts
Start with the role of a database management system and the difference between stored data, database structures, and the tools used to work with them. Build a glossary that connects terms instead of memorizing one-line definitions. For example, relate a table to rows and columns, a query to a request for data, and an object to a named database component. Keep examples generic and use a disposable practice database.
Relational concepts
The official relational-concepts module specifically covers normalization, referential integrity, and constraints. Practice identifying repeated data, deciding where an attribute belongs, and explaining why a relationship should be protected. Then connect primary-key and foreign-key reasoning to referential integrity. Do not stop at definitions: sketch a small customer-order model and identify what invalid relationship a constraint is intended to prevent.
Creating databases and objects
The database-objects module covers data types, database objects, DDL statements, and creating scripts. Study the difference between defining or changing structure and manipulating the rows inside that structure. Write small scripts that create a simple schema, inspect each data type choice, and explain why an object belongs in the design. Re-run scripts in a disposable environment and correct errors rather than copying them blindly.
DML statements, queries, and stored procedures
Practice reading and writing basic data-manipulation statements and queries against a small dataset. Before executing a change, state which rows should be affected and how you would verify the result. Include stored procedures in the same practice cycle so you can distinguish a reusable database routine from a one-off query. Focus on interpreting intent and output, not on memorizing snippets without context.
Administration, security, and tools
Reserve a separate study block for SQL Server administration fundamentals, security requirements, and graphical tools. Ask what a user or process is allowed to do, which database component is involved, and whether a graphical action corresponds to a scriptable operation. This prevents a common imbalance: becoming comfortable in a visual interface while being unable to explain the underlying object, permission, or T-SQL operation.
How should a beginner prepare efficiently?
Use a learn, build, explain, and review cycle. First study one concept from the official series; then build or inspect a small example; explain the result without notes; finally test yourself with a scenario that changes one condition. This approach exposes gaps earlier than passive video watching and keeps preparation tied to the skills Microsoft describes.
Begin with the official Database Fundamentals series because it provides the clearest supplied source for the intended scope. Use the relational-concepts episode to work on normalization, referential integrity, and constraints, and use the database-objects episode to work on data types, objects, DDL statements, and scripts. Keep a separate question log for terms you confuse or operations whose effects you cannot predict.
Do not organize preparation around dumps, leaked questions, or claims that memorization guarantees a pass. Such material cannot replace understanding and may be inaccurate, unauthorized, or based on a different version. Prepare from documented topics and legitimate practice instead; the goal is transferable database knowledge, especially now that 98-364 is retired.
A useful first-session diagnostic
Without looking up answers, try to explain normalization, referential integrity, a constraint, a database object, a DDL statement, a DML statement, a query, and a stored procedure. Then sketch two related tables and identify the rule that keeps their relationship valid. Your uncertainty, not your score on an unverified quiz, should determine the first study block.
How to use video lessons actively
Pause before each example and predict the result. Afterward, reproduce the idea in a smaller schema with different names and data. For the relational module, redraw the example after removing duplication. For the object-creation module, change a data type or object definition and explain the consequence. Active reconstruction is more revealing than replaying a lesson while taking verbatim notes.
How to use practice questions safely
Use questions as diagnosis, not as a substitute for the syllabus. For every missed item, classify the problem: unfamiliar term, incorrect relationship model, syntax misunderstanding, output-reading error, or careless reading. Then return to the relevant concept and create a new example. Avoid assuming that a third-party question reflects the retired exam’s exact wording, format, or coverage.
What mistakes make database fundamentals study less effective?
The most damaging mistake is treating 98-364 as a current exam and spending money or time on scheduling research before checking retirement status. The next is narrowing preparation to SQL syntax. A fundamentals learner also needs relational reasoning, object definitions, constraints, security considerations, tools, and administration concepts. Build a balanced checklist before selecting exercises.
Another frequent error is memorizing terminology without testing relationships. A learner may recite referential integrity yet fail to identify which change would create an invalid reference. Similarly, someone may know that DDL concerns structure but struggle to classify an operation in context. Convert every definition into a small scenario and ask what changes, what remains, and what should be rejected.
Do not confuse a successful script with a correct design. A script can execute while storing repeated data, choosing an unsuitable type, or exposing more access than intended. Review the model, object purpose, data integrity, and security implications separately. This habit develops judgment that remains valuable beyond an archived exam.
Mistake: relying on outdated scheduling information
Archived pages, old voucher instructions, and forum discussions can preserve historically accurate details that no longer apply. Microsoft’s retirement FAQ states that MTA licenses stopped being offered for purchase on June 30, 2021, and that candidates had until June 30, 2022 to register and take an exam. Those dates describe the retired program, not a future booking opportunity.
Mistake: learning only the interface
Graphical tools can make database work approachable, but clicking through an interface does not automatically demonstrate understanding. For each visual action, identify the underlying database object or statement and the permission it requires. If you cannot reproduce the reasoning in words or a script, return to the concept before moving on.
Mistake: treating every error as a syntax problem
Some failures arise from a flawed relationship, a constraint, an inappropriate data type, or an incorrect assumption about affected rows. When an exercise fails, read the intended result first, inspect the model, and then inspect the statement. This diagnostic order prevents repeated editing of syntax when the underlying design is the real issue.
What practical study roadmap should a learner follow?
A practical roadmap has four stages: establish vocabulary, model relationships, create and manipulate objects, then integrate administration and security. At each stage, produce something observable—a glossary, a relational diagram, a working script, or a written access-and-integrity review. Finish with mixed scenarios and a decision about whether your goal is database literacy or a current credential.
Stage one should cover the course introduction and core concepts. Define the role of a database management system, identify common database components, and distinguish data from the structures and tools used to manage it. Do not progress because the notes look complete; progress when you can explain a term and give a small example without copying a definition.
Stage two should focus on relational concepts. Work through normalization, referential integrity, and constraints using a two- or three-table model. Deliberately introduce duplicate data and an invalid reference, then explain how a better design or constraint addresses the problem. This stage is the bridge between abstract terminology and reliable database structure.
Stage three should combine data types, objects, DDL, DML, queries, and stored procedures. Build a disposable database, create its objects, insert representative rows, retrieve them, update a controlled subset, and verify the result. Separate structural changes from row-level changes in your notes. Save both the successful version and a corrected version of one exercise so you can explain the troubleshooting process.
Stage four should integrate administration fundamentals, security requirements, and graphical tools. Review who should access which object, how a tool action relates to a script, and what an administrator must protect or maintain. Then use mixed prompts that require you to choose a concept, object, statement type, or control and justify the choice.
The final review should be selective. Revisit your error log, redraw the relational model from memory, classify operations as structural or data-manipulation work, and explain the purpose of a stored procedure. If you are studying for a current credential rather than for historical knowledge, stop and verify the replacement path on Microsoft Learn before investing in an exam-specific course.
A compact weekly routine
For each study session, assign one concept objective, one hands-on task, and one explanation task. End by writing two questions you can now answer and one question that remains unresolved. This routine prevents broad but shallow coverage and gives you a visible list for the next session. Adjust the pace to your background rather than following an unsupported promise of readiness in a fixed number of days.
A readiness check based on capability
You are better prepared when you can inspect a small schema, explain its relationships and constraints, choose sensible object and data-type definitions, predict the effect of a query or data change, and discuss basic security or administrative concerns. If you can only recognize terms in a list, continue with examples. These are practical recommendations, not an official Microsoft passing standard.
What are the credential and transcript implications?
Microsoft says MTA certifications do not expire, but retirement changes their availability and transcript placement. A previously earned credential remains on the transcript and can be printable. For a credential without an expiration date, Microsoft’s policy says it remains in the Active section for two years following retirement before moving to the applicable history area.
That policy should not be confused with the ability to earn the credential today. Microsoft separately states that a retired credential is no longer available for new candidates to earn and that retired exams cannot be taken after the retirement date. Existing holders and new learners therefore face different decisions: preserve or document an existing achievement, versus select a current learning and certification route.
If you believe you passed 98-364 before retirement, sign in to the relevant Microsoft Learn profile and inspect your transcript rather than assuming that an old email or voucher proves the result. If the credential is absent or the record is unclear, use Microsoft’s current certification support channels. The supplied Microsoft Q&A pages direct certification questions toward Microsoft Training and Certification support rather than treating community Q&A as the authoritative exam-registration channel.
What if you had a voucher?
Microsoft’s retirement FAQ states that previously purchased MTA vouchers could not be traded in for another exam. Because the exam is retired, a historical voucher instruction should not be interpreted as a current scheduling route. Keep purchase records if you need to resolve an old transaction, but confirm any support action through Microsoft’s current official channels.
Should an existing MTA holder pursue another credential?
That depends on the role you want next. The database fundamentals topics can support further study, but an MTA achievement is not a substitute for a current role-based or fundamentals credential. Microsoft’s retirement guidance describes newer fundamentals certifications as a starting point for broader areas such as Azure, AI, Data, Power Platform, Microsoft 365, and Dynamics. Check the current catalog and select the path that matches your target work.
How can the official resources be used without overrelying on them?
Use the Microsoft Database Fundamentals series as the scope anchor, then turn each module into an activity. The series names the five-module outline and the skills it introduces; the relational and database-object episodes provide especially concrete study prompts. Use retirement and credential-policy pages for status and transcript questions, not for technical database instruction.
The relational-concepts episode covers normalization, referential integrity, and constraints. Watch it with a diagram open beside you, and translate each idea into a small relationship model. The database-objects episode covers data types, database objects, DDL statements, and creating scripts. Follow it by writing a minimal schema and classifying each operation you perform.
The retirement pages answer a different set of questions: whether the exam can still be taken, what happens to an earned credential, and how retirement affects transcript status. Keep those administrative notes separate from your technical notebook. Mixing old scheduling facts with current study advice is one way candidates end up treating an archived exam as live.
A source-checking habit for third-party pages
When a page states a score, question count, duration, delivery method, language, price, prerequisite, or domain percentage, look for an official Microsoft source that supports the exact claim. None of those details is provided in the supplied research. If the claim cannot be verified, omit it from your plan rather than filling the gap with a remembered value or an unattributed estimate.
Why official scope still has value after retirement
Retirement does not make relational design or basic database operations obsolete. It does mean the old exam label should not control your current certification decision. Keep the documented scope for learning, but check Microsoft’s current catalog for a live assessment, current objectives, and current registration information before treating any newer credential as the next step.
What should you do next?
First, decide whether you are checking an existing MTA record or learning database fundamentals from scratch. If you need a live exam, remove 98-364 from your scheduling shortlist because it was retired on June 30, 2022. If you need foundational knowledge, begin with the official series, create a small relational model, and compare your longer-term goal with Microsoft’s current offerings.
For an existing candidate record, review your Microsoft Learn transcript and retain any certification documentation. For a learner, make a five-block checklist from the official outline and start with core concepts and relational concepts before writing scripts. After each exercise, explain the result and log the error or misconception that required correction.
Finally, do not purchase an exam dump or rely on a page promising guaranteed success. No source supplied here supports such claims, and memorization cannot establish the database understanding described by Microsoft. Use the official resources for scope and retirement facts, use hands-on work for competence, and verify any current certification decision directly in Microsoft Learn.
Conclusion
98-364 remains useful as a map of introductory database knowledge, but it is not a current Microsoft exam. The sensible path is to separate historical exam research from present-day certification planning: study the documented database fundamentals if those skills fit your goal, confirm any existing MTA achievement in your transcript, and choose a current Microsoft option only after checking its official requirements and status. That approach avoids outdated scheduling assumptions while preserving the technical value of relational concepts, database objects, queries, scripts, and administration fundamentals.
