MOC 40364 - Database Administration Fundamentals: Training for MTA Exam 98-364

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.

  Microsoft Certified Partner

Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Goals
  1. Learn to understand Core Database Concepts.
  2. Learn to create Database Objects.
  3. Learn to manipulate Data.
  4. Learn to understand Data Storage.
  5. Learn to administer a Database.
Outline
  1. Core Database Concepts
    1. Database Concepts
    2. Data Manipulation Language (DML)
    3. Data Definition Language (DDL)
  2. Creating Database Objects
    1. Key Terms
    2. Data Types
    3. Creating and Using Tables
    4. Creating Views
    5. Creating Stored Procedures
  3. Manipulating Data
    1. Using Queries to Select Data
    2. Using Queries to Insert Data
    3. Updating Data and Databases
    4. Deleting Data
  4. Data Storage
    1. Normalizing a Database
    2. Primary, Foreign, and Composite Keys
    3. Clustered and Non-Clustered Indexes
  5. Administering a Database
    1. Securing Databases
    2. Backing Up and Restoring Databases
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this SQL Server class:

  • There are no prerequisites for this course.
Certifications

Training for your Team

Length: 3 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

What people say about our training

This was my first time using Webucator. I really liked the personalized attention and that the instructor was able to incorporate my website into the classroom demos. It made it much easier to apply some of the concepts as it relates to how I will be using them.
Tammy Rosen
Fur-Get Me Not
Webucator as a whole exceeded my expectations. Signing up for the course and accessing the site the day of the event was easy. The course content was well thought out and I really enjoyed working within the online lab environment. The instructor was flexible with adjusting to my learning pace and style and was very knowledgeable on the topic as a whole.
Kristine Hicks
ManTech
The class was a great introduction to Premiere. The instructor adapted the content to the student level, which was great.
Arran Liddel
St Stephen's Community House
I found this course to be well worth taking, and I also found the instructor to be extremely knowledgeable and an excellent teacher. The course material and topics covered are a great start to learning Java.
Scott Helfrich
Signet Jewelers

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

61,868

Students who have taken Instructor-led Training

11,795

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.29

Students rated our trainers 9.29 out of 10 based on 28,793 reviews

Contact Us or call 1-877-932-8228