Learning Plan for Database Administration Fundamentals (Exam 98-364)
– Understand core database concepts (DML, DDL, and RDBMS)
– Create database objects (TSQL, data types, tables, and views)
– Manipulate data (SELECT queries, update and delete data)
– Understand data storage
– Administer a database (security, backup, and restore)
This learning plan also helps students prepare for Microsoft exam 98-364 – Database Administration Fundamentals. By passing exam 98-364, candidates earn the Microsoft Technology Associate (MTA) certification.
Step 1 – Video Series: SQL Server 2005 Express Edition for Beginners
This video series includes almost 9 hours of video-based instruction that walks SQL Server beginners through the steps of learning about SQL Server databases to actually connecting a SQL Server database to a Web application.
Step 2 – Beginning Developer Learning Center: Windows Development Tier Three
In Tier Three of the Absolute Beginner’s Series for Windows Development you learn how to work with data in a database, connect that data to your user interface, work with XML, manage potential errors using exceptions, and step through two different sample applications to really see what makes things work.
Step 3 – SQL Server Samples and Starter Kits
These Samples and Starter Kits are fully functional sample applications. Each sample is complete and well-documented so that you can get started right away.
Step 4 – SQL Server 2008 Books Online (March 2009): Administration (Database Engine)
This section of Books Online provides information to help you get the best performance out of your database system and to protect your data against hardware failure or natural disaster. Topics include:
– Managing Servers
– DDL Triggers
– Logon Triggers
– Connecting to the SQL Server Database Engine
– Managing the Database Engine Services
– Managing Transaction Logs
– Backing Up and Restoring Databases in SQL Server
– Rebuilding System Databases
– Importing and Exporting Bulk Data
– Copying Databases to Other Servers
– Administering Servers by Using Policy-Based Management
– Administering Multiple Servers Using Central Management Servers
Step 5 – Collection 2778: Querying and Modifying Data in Microsoft SQL Server 2008 with Transact-SQL
This collection of nine two-hour courses provides database developers and administrators with the knowledge and skills to query and modify data in Microsoft SQL Server 2008 by using Transact-SQL.
Step 6 – Course 6231B: Maintaining a Microsoft SQL Server 2008 R2 Database
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database
Step 7 – Exam 98-364: Database Fundamentals
Register now to take Exam 98-364.