VTEC Training
Course Code: 930
40364 Database Administration Fundamentals
VTEC Training
Portland,
ME
Class Dates:
1/20/2020
Length:
3 Days
Cost:
$1050.00
Class Time:
Technology:
Database
Delivery:
Overview
- 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.
- Audience
- The Microsoft Technology Associate (MTA) is Microsoft’s newest suite of technology certification exams that validate fundamental knowledge needed to begin building a career using Microsoft technologies. This program provides an appropriate entry point to a future career in technology and assumes some hands-on experience or training but does not assume on-the-job experience.
Prerequisites
- There are no prerequisites for this course.
Course Details
- Module 1: Understanding Core Database Concepts
- Understanding Core Database Concepts
- Understanding Data Manipulation
- Understanding Data Definition Language
- Lab
- Module 2: Creating Database Objects
- Understanding Database Concepts
- Defining Data Manipulation
- Understanding Data Definition Language
- Lab
- Module 3: Manipulating Data
- Using Queries to Select Data
- Using Queries to Insert Data
- Updating Data and Databases
- Deleting Data
- Lab
- Module 4: Understanding Data Storage
- Normalizing a Database
- Understanding Primary, Foreign, and Composite Keys
- Understanding Clustered and Non-clustered Indexes
- Lab
- Module 5: Administering a Database
- Securing Databases
- Backing Up and Restoring Databases
- Lab