M40364A: MTA: Database Fundamentals

$1,295.00


  • Virtual Classroom

  • Onsite

← Continue Searching

Duration: 3 Days

In this course, you will be introduced to database design and administration. You will gain an understanding of core database concepts, creation of database objects, manipulation of data, data storage, and administration of a database.

This course assists you in preparation for Microsoft Technology Associate Exam 98-364.

Proven Impact Exclusive!

Continue developing your skills after class with 24/7 access to our live remote labs for six months, providing you with valuable extra time for hands-on practice.

What You Will Learn

 

  • Data types
  • Data manipulation language
  • Database queries
  • Primary keys
  • Database backups.

Audience

 

Business or IT professionals who need to understand core database concepts and how databases can be used to store, manipulate, and analyze data

Prerequistes

 

  • General office computer skills
  • Business knowledge around the use of database systems

Course Outline

 

1. Core Database Concepts

  • Database Concepts
  • Data Manipulation Language (DML)
  • Data Definition Language (DDL)

2. Creating Database Objects

  • Key Terms
  • Data Types
  • Creating and Using Tables
  • Creating Views
  • Creating Stored Procedures

3. Manipulating Data

  • Using Queries to Select Data
  • Using Queries to Insert Data
  • Updating Data and Databases
  • Deleting Data

4. Data Storage

  • Normalizing a Database
  • Primary, Foreign, and Composite Keys
  • Clustered and Non-Clustered Indexes

5. Administering a Database

  • Securing Databases
  • Backing Up and Restoring Databases

Course Labs