LeapFox Learning Boise

40364 - Database Administration Fundamentals

Training for your Group

  • Private class for your team
  • Online or on-location
  • Fully customizable course material
  • Onsite testing available
  • Learning more about custom training

Training for Individuals

$1500

  • Live, Instructor-led training
  • Expert instructors
  • Hands-on instruction
Upcoming Dates
See All Course Dates

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 Length: 3 days

Audience: Beginning IT people with some hands-on experience or training 

Prerequisites: None

What You're Going To Learn

  • 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.

Register for an Upcoming Date

Date Location Price Register
Oct 28, 2019 Remote LIVE $1,500.00 Register
Jan 13, 2020 Remote LIVE $1,500.00 Register

Course 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

What to Expect at LeapFox

Knowledgeable Instructors

Our Microsoft Office instructors are certified professionals. They are trained on the latest Office features and how to get the most out of Microsoft Office.

Hands on Labs

No boring lectures! Our courses are designed to give students lots of time to practice what they are learning with hands on excercises and projects

Bounce Back Pass

Retake any public course as many times as you like for up to one year for classroom live classes and six months for remote live courses.

Certificate of Completion

Receive a certification of completion at the end of every course.

Up to Date Curriculum

Each course comes with a helpful and up to date ebook which will contain instruction and practice excercises.

Time Saving Tips N Tricks

In each course your instructor will show you tips and trips that will save you time and make you more efficient.

Friendly and Helpful Staff

Our staff is dediated to your success. Each team member is trained provide the absolute best customer service possible.

Satisfaction Guarantee

If you aren't 100% satisfied wtih your experience with LeapFox, simply let us know and we will give you a full refund.

Look who Else is Using LeapFox

See What Our Customers Say

Close Menu