SQL 2016 Tables

SQL Server 2016    |    Intermediate
  • 9 Videos | 50m 12s
  • Includes Assessment
  • Earns a Badge
Likes 166 Likes 166
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

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 1602 Likes 1602  
Likes 78 Likes 78  
COURSE SQL Views
Likes 60 Likes 60