Data

MTA - Database Fundamentals (40364)


Description
This MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-366, and build an and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database.

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.
Content
  • Essential Resources
  • Digital Courseware
  • Module 1: Core Database Concepts
  • Lesson 1: Understanding Core Database Concepts
  • VIDEO 1: Core Database Concepts (30 min)
  • Quiz 1 - Core Database Concepts
  • Module 2: Creating Database Objects
  • Lesson 2: Creating Database Objects
  • VIDEO 2: Relational Concepts (44 min)
  • Quiz 2 - Database Objects
  • Module 3: Manipulating Data
  • Lesson 3: Manipulating Data
  • VIDEO 3: Creating Databases and Database Objects (48 min)
  • Quiz 3 - Manipulating Data
  • Module 4: Understanding Data Storage
  • Lesson 4: Understanding Data Storage
  • VIDEO 4: Using DML Statements (51 min)
  • Quiz 4 - Data Storage
  • Module 5: Administering a Database
  • Lesson 5: Administrating a Database
  • VIDEO 5: SQL Server Administration Fundamentals (37 min)
  • Quiz 5 - Database Admin
  • Exam Prep
  • 98-364 Exam Study Guide
Completion rules
  • All units must be completed
  • Leads to a certification with a duration: Forever