Normalization & Indexes

SQL Server    |    Beginner
  • 7 videos | 44m 23s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 18 users Rating 4.6 of 18 users (18)
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 databases
    Describe 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 database
    Create clustered and nonclustered indexes in sql server databases
    Use the appropriate commands to create and normalize tables in a sql server database

IN THIS COURSE

  • 5m 32s
    Upon completion of this video, you will be able to describe the purpose of normalizing relational databases. FREE ACCESS
  • 7m 39s
    After completing this video, you will be able to describe the normalization guidelines for relational databases and define the first normal form. FREE ACCESS
  • Locked
    3.  Normalization Guidelines - 2NF
    5m 34s
    Upon completion of this video, you will be able to describe the normalization guidelines for relational databases and define the second normal form. FREE ACCESS
  • Locked
    4.  Normalization Guidelines - 3NF
    4m 31s
    Upon completion of this video, you will be able to describe the normalization guidelines for relational databases and define the third normal form. FREE ACCESS
  • Locked
    5.  Indexes
    8m 18s
    Upon completion of this video, you will be able to describe clustered and nonclustered indexes and how they are used in a SQL Server database. FREE ACCESS
  • Locked
    6.  Creating Indexes
    7m 40s
    In this video, learn how to create clustered and nonclustered indexes in SQL Server databases. FREE ACCESS
  • Locked
    7.  Exercise: Creating and Normalizing Tables
    5m 10s
    During this video, you will learn how to use the appropriate commands to create and normalize tables in a SQL Server database. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course MySQL Database Development: Query & Performance Optimization
Rating 4.6 of 33 users Rating 4.6 of 33 users (33)
Course CompTIA Data+: Query Optimization
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)
Course Querying SQL Databases: Learning SQL Using Prompt Engineering
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Project Management Introduction (PMBOK(r) Guide Sixth Edition)
Rating 4.2 of 2232 users Rating 4.2 of 2232 users (2232)
Course SQL Programming with MariaDB: Analyzing Relational Data
Rating 4.5 of 24 users Rating 4.5 of 24 users (24)
Course Non-relational Data: Non-relational Databases
Rating 4.5 of 41 users Rating 4.5 of 41 users (41)