SQL 2016 Tables

SQL Server 2016    |    Intermediate
  • 9 videos | 46m 12s
  • Includes Assessment
  • Earns a Badge
Likes 405 Likes 405
In order to properly design and implement a relational database schema, it's important to have an understanding of the fundamentals of SQL Server 2016. Explore the creation and altering of tables, including constraints.

WHAT YOU WILL LEARN

  • create tables in SQL Server 2016
    use the DROP TABLE statement to drop a table from a database
    use the ALTER TABLE statement to modify a table
    add and removing columns from a table
    duplicate a table
  • rename a table
    use constraints to ensure integrity of data
    describe the best practices to follow when selecting a naming convention
    describe the numeric data type category in SQL Server 2016

IN THIS COURSE

  • 7m 10s
    Learn how to create tables in SQL Server 2016. FREE ACCESS
  • 2m 56s
    In this video, you will learn how to use the DROP TABLE statement to drop a table from a database. FREE ACCESS
  • Locked
    3.  Altering Tables
    5m 10s
    In this video, you will learn how to use the ALTER TABLE statement to modify a table. FREE ACCESS
  • Locked
    4.  Adding and Removing Columns
    3m 55s
    In this video, find out how to add and remove columns from a table. FREE ACCESS
  • Locked
    5.  Duplicating Tables
    4m 26s
    In this video, you will learn how to duplicate a table. FREE ACCESS
  • Locked
    6.  Renaming Tables
    3m 23s
    To learn how to rename a table, follow these steps. FREE ACCESS
  • Locked
    7.  Constraints
    10m 16s
    Learn how to use constraints to ensure the integrity of data. FREE ACCESS
  • Locked
    8.  Naming Conventions
    5m 14s
    After completing this video, you will be able to describe the best practices to follow when selecting a naming convention. FREE ACCESS
  • Locked
    9.  Exercise: Create a SQL Table
    3m 44s
    Upon completion of this video, you will be able to describe the numeric data type category in SQL Server 2016. 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 Non-relational Data: Non-relational Databases
Likes 22 Likes 22  
Course Database Fundamentals: Getting Started with SQL
Course Microsoft Azure Fundamentals: Databases & Data Analytics
Likes 229 Likes 229  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SQL Tables
Likes 190 Likes 190  
Course Database Fundamentals: Getting Started with SQL
Course Data Types & Normalization
Likes 67 Likes 67