Join Adam Wilbert for an in-depth discussion in this video Preparing for MTA Exam 98-364, part of Database Fundamentals: Storage.
- Obtaining an official certification of your skills and knowledge is a great way to stand out in a crowded jobs market. Microsoft offers several certification tracks that can help you secure your next job or earn a promotion in your current career. The Microsoft Technology Associate, or MTA certification, helps people validate their understanding of core information technologies concepts. The MTA certification has three different tracks. The Database track, which you can access here, includes Exam 364, which focuses on the systems required to store and retrieve data.
I specifically organized this Database Fundamentals series of courses here on lynda.com to follow along with the requirements of passing MTA 98-364. Go ahead and click here in order to find out some more information about the exam. At the top is some information on how to register to take the exam and the current pricing. And if we scroll down here on this page, we'll find a section called Skills Measured. We can see here that the exam covers five different competency categories. This course will go through material in the fourth competency category called Understanding Data Storage, which accounts for about 15 to 20 percent of the exam material.
We can see here that it covers the topics of normalization, primary and foreign keys, and indexes. Other courses in this Database Fundamentals series will cover material from the other four competency categories. So keep your eye out for them in the library, and consider adding them to your learning playlist as well. Now, if you're not planning on seeking a certification but do want a solid foundational understanding of how databases work, then this course is still for you. Though I use the MTA exam as a guide, the material is applicable to a wide range of database systems and environments.
I'm sure you'll find the course beneficial whether you'll be pursuing the Microsoft Technology Associate certification or not.
Note: This course will also prepare certification candidates for the "Understanding data storage" domain of the Microsoft Technology Associate (MTA) Exam 98-364, Database Administration Fundamentals. Find out more at https://www.microsoft.com/learning/en-us/exam-98-364.aspx.
- Reducing redundancy with normalization
- Fixing partial dependencies
- Creating primary keys
- Linking tables with foreign keys
- Creating clustered and nonclustered indexes