Normalization & Indexes
SQL Server 2014
| Beginner
- 7 Videos | 44m 23s
- Includes Assessment
- Earns a Badge
Data redundancy negatively affects storage, scalability, and responsiveness. Learn how to use database normalization and indexes in SQL Server to counter these negative effects.
WHAT YOU WILL LEARN
-
describe the purpose of normalizing relational databasesdescribe the normalization guidelines for relational databases and define the first normal form (1NF)describe the normalization guidelines for relational databases and define the second normal form (2NF)describe the normalization guidelines for relational databases and define the third normal form (3NF)
-
describe clustered and nonclustered indexes in the context of their use in a SQL Server databasecreate clustered and nonclustered indexes in SQL Server databasesuse the appropriate commands to create and normalize tables in a SQL Server database
IN THIS COURSE
-
1.Overview of Normalization5m 32sUP NEXT
-
2.Normalization Guidelines - 1NF7m 39s
-
3.Normalization Guidelines - 2NF5m 34s
-
4.Normalization Guidelines - 3NF4m 31s
-
5.Indexes8m 18s
-
6.Creating Indexes7m 40s
-
7.Exercise: Creating and Normalizing Tables5m 10s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.YOU MIGHT ALSO LIKE
CHANNEL
Wintellect NoSQL
Likes 2