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:

System Requirements:

Internet Connectivity Requirements:
  • Cable and DSL internet connections are recommended for the best experience.
Hardware Requirements:
  • CPU: 1 GHz or higher
  • RAM: 2 GB or higher
  • Resolution: 1280 x 720 or higher
  • Speakers / Headphones
  • Microphone (Webinar / Live Online sessions)
Operating System Requirements:
  • Microsoft Windows 7 or 10 (Home, Pro)
  • Mac OSX 10 or higher.
  • Latest Chrome OS
  • Latest Linux Distributions

NOTE: While we understand that our courses can be viewed on Android and iPhone devices, we do not recommend the use of these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online based courses.

Web Browser Requirements:
  • Latest Google Chrome is recommended for the best experience.
  • Latest Mozilla FireFox
  • Latest Microsoft Edge
  • Latest Apple Safari
Basic Software Requirements (These are recommendations of software to use):
  • Office suite software (Microsoft Office, OpenOffice, or LibreOffice)
  • PDF reader program (Adobe Reader, FoxIt)
  • Courses may require other software that is denoted in the above course outline.