Custom Course
This is a custom course that may have been designed with a specific client in mind. If you arrived here without being directed by a Webucator representative and are interested in learning more, please email sales@webucator.com.
MOC 40364 - Database Administration Fundamentals: Training for MTA Exam 98-364 (MOC40364)
Course Length: 3 days
This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database.
Register or Request Training
- Private class for your team
- Live expert instructor
- Online or on‑location
- Customizable agenda
- Proposal turnaround within 1–2 business days
Course Overview
This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database.
Course Benefits
- Learn to understand Core Database Concepts.
- Learn to create Database Objects.
- Learn to manipulate Data.
- Learn to understand Data Storage.
- Learn to administer a Database.
Delivery Methods
Microsoft Certified Partner
Webucator is a Microsoft Certified Partner. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).
Course Outline
- Core Database Concepts
- Database Concepts
- Data Manipulation Language (DML)
- Data Definition Language (DDL)
- Creating Database Objects
- Key Terms
- Data Types
- Creating and Using Tables
- Creating Views
- Creating Stored Procedures
- Manipulating Data
- Using Queries to Select Data
- Using Queries to Insert Data
- Updating Data and Databases
- Deleting Data
- Data Storage
- Normalizing a Database
- Primary, Foreign, and Composite Keys
- Clustered and Non-Clustered Indexes
- Administering a Database
- Securing Databases
- Backing Up and Restoring Databases
Class Materials
Each student receives a comprehensive set of materials, including course notes and all class examples.
Class Prerequisites
Experience in the following is required for this Microsoft SQL Server class:
- There are no prerequisites for this course.
Have questions about this course?
We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.
