Главная
Study mode:
on
1
- Introduction
2
0: - Understand how data is stored in tables
3
- Understand relational database concepts
4
- Understand data manipulation language DML
5
- Understand data definition language DDL
6
- Choose data types - Part 1
7
- Choose data types - Part 2
8
- Understand tables and how to create them
9
- Create views
10
- Create stored procedures and functions
11
- Select data - Part 1
12
- Select data - Part 2
13
- Insert and update data
14
- Delete data
15
- Understand normalization
16
- Understand primary, foreign and composite keys
17
- Understand indexes
18
- Understand database security concepts
19
- Understand database backups and restore
Description:
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.

Microsoft Database Fundamentals - Complete Course MTA 98-364

Paul Browning
Add to list