Microsoft 98-364 - Database Fundamentals

Hours: 40 / Access Length: 12 Months / Delivery: Online, Self-Paced
Retail Price: $599.00

Course Overview:

Prepare for the 98-364 exam with the MTA: Windows Database Fundamentals course and lab. This complete course covers the 98-364 exam objectives and provides the skills that are necessary to work with databases, including relational databases, such as Microsoft SQL Server.

This course includes FREE access for 12 months to a cloud based lab platform to assist students in developing the practical information technology (IT) skills necessary to succeed in high in demand IT jobs. This cloud based lab solution uses real equipment that enables our students to execute each practical task in a safe environment that is accessible from anywhere without needing to buy their own hardware or risk damage to their own system.

Along with providing the necessary hardware in a virtual environment, students gain access to high quality practical exercises that cover many of the exam topics they will encounter on their certifying exams.

This course prepares students to take the Microsoft 98-364 - Database Fundamentals national certification exam.

Course Outline:

Lesson 1: Understand Core Database Concepts
  • Understand How Data is Stored in Tables
  • Understand Relational Database Concepts
  • Understand Data Manipulation Language (DML)
  • Understand Data Definition Language (DDL)
  • Summary
Lesson 2: Create Database Objects
  • Choose Data Types
  • Understand Tables and How to Create them
  • Create Views
  • Create Stored Procedures and Functions
  • Summary
Lesson 3: Manipulate Data
  • Select Data
  • Insert Data
  • Update Data
  • Delete Data
  • Transaction Controls
  • Summary
Lesson 4: Understand Data Storage
  • Understand Normalization
  • Understand Primary, Foreign, and Composite keys
  • Understand Indexes
  • Summary
Lesson 5: Administer a Database
  • Understand Database Security Concepts
  • Understand Database Backups and Restore
  • Summary
Lesson 6: Appendix

All necessary course materials are included.

Certification(s):

This course prepares students to take the Microsoft 98-364 - Database Fundamentals national certification exam.


System Requirements:

Internet Connectivity Requirements:
  • Cable and DSL internet connections are recommended.

Hardware Requirements:
  • Minimum Pentium 400 Mhz CPU or G3 Macintosh. 1 GHz or greater CPU recommended.
  • 256MB RAM minimum. 1 GB RAM recommended.
  • 800x600 video resolution minimum. 1025x768 recommended.
  • Speakers/Headphones to listen to Dialogue steaming audio sessions.
  • A microphone to speak in Dialogue streaming audio sessions.
Operating System Requirements:
  • Windows Vista, 7, 8, 8.1, 9, 10
  • Mac OSX 10 or higher.
  • OpenSUSE Linux 9.2 or higher.
Web Browser Requirements:
  • Google Chrome is recommended.
  • Firefox 13.x or greater.
  • Internet Explorer 6.x or greater.
  • Safari 3.2.2 or greater.
Software Requirements:
  • Adobe Flash Player 6 or greater.
  • Oracle Java 7 or greater.
  • Adobe Reader 7 or greater.
Web Browser Settings:
  • Accept Cookies
  • Disable Pop-up Blocker.


**Outlines are subject to change, as courses and materials are updated.**