Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

MTA Database Fundamentals (98-364) Cert Prep: 3 Storage

via LinkedIn Learning

Go to class Write review

Details

Provider

LinkedIn Learning
Pricing

Free Trial Available
Languages

English
Certificate

Certificate Available
Duration & workload

1-2 hours
Sessions

On-Demand
Level

Intermediate

Found in

Coursera

Get Coursera Plus for 40% off

CourseHorse

Give the Gift That Unlocks Potential

Overview

Coursera Flash Sale

40% Off Coursera Plus for 3 Months!

Prep for MTA Exam 98-364 and get a baseline understanding of the core concepts of database storage: normalization, key fields, and indexing.

Syllabus

Introduction

Welcome
Preparing for MTA Exam 98-364
Using the exercise files
Challenges explained
What you should know

1. Creating Normalized Tables

Reducing redundancy with normalization
Understanding the first normal form (1NF)
Understanding the second normal form (2NF)
Fixing partial dependencies
Understanding the third normal form (3NF)
Exploring the fourth and fifth normal form (4NF) (5NF)
Challenge: Normalizing a dataset
Solution: Normalizing a dataset

2. Adding Key Fields

Understanding the role of key fields
Creating a table's primary key in SQL Server Management Studio
Understanding composite primary keys
Creating composite primary keys
Linking tables with foreign keys
Creating a foreign key relationship in SSMS

3. Indexing Records

Understanding clustered indexes
Adding a clustered index
Understanding nonclustered indexes
Creating a nonclustered index in SSMS
Creating a nonclustered index using DDL
Challenge: Creating table indexes
Solution: Creating table indexes

Conclusion

Next steps

Taught by

Adam Wilbert

Reviews

Start your review of MTA Database Fundamentals (98-364) Cert Prep: 3 Storage