Embark on a comprehensive 7-hour journey through Microsoft Database Fundamentals, preparing for the MTA 98-364 exam. Dive deep into core database concepts, including data storage in tables, relational database principles, and SQL fundamentals. Learn to create and manipulate database objects, master data types, and construct tables, views, stored procedures, and functions. Explore data manipulation techniques, covering SELECT, INSERT, UPDATE, and DELETE operations. Gain insights into data storage optimization through normalization, key concepts, and indexing. Conclude with essential database administration skills, focusing on security measures and backup/restore procedures. Equip yourself with the knowledge and skills needed to excel in database management and pass the Microsoft certification exam.
Overview
Syllabus
- Introduction
0: - Understand how data is stored in tables
- Understand relational database concepts
- Understand data manipulation language DML
- Understand data definition language DDL
- Choose data types - Part 1
- Choose data types - Part 2
- Understand tables and how to create them
- Create views
- Create stored procedures and functions
- Select data - Part 1
- Select data - Part 2
- Insert and update data
- Delete data
- Understand normalization
- Understand primary, foreign and composite keys
- Understand indexes
- Understand database security concepts
- Understand database backups and restore
Taught by
Paul Browning
