SQL 2016 Tables

SQL Server 2016    |    Intermediate
  • 9 videos | 46m 12s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 473 users Rating 4.5 of 473 users (473)
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
Rating 4.5 of 41 users Rating 4.5 of 41 users (41)
Book Database Performance at Scale: A Practical Guide
Book Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Designing & Implementing Views
Rating 4.6 of 70 users Rating 4.6 of 70 users (70)
Course Generative AI and Its Impact to Everyday Business
Rating 4.6 of 893 users Rating 4.6 of 893 users (893)
Course Database Fundamentals: Getting Started with SQL
Rating 4.5 of 272 users Rating 4.5 of 272 users (272)