Components, Procedures, & Functions

SQL Server 2014
  • 8 Videos | 1h 4m 38s
  • Includes Assessment
  • Earns a Badge
Likes 29 Likes 29
The Data Definition Language (DDL) is used to create databases and their components. Discover how to create databases, tables, views, and stored procedures using DDL.

WHAT YOU WILL LEARN

  • using SMSS and DDL, create a new SQL Server database with its specific syntax and parameters and review its schema
    using SMSS and DDL, use, alter, and drop SQL Server databases
    using SMSS and DDL, create SQL Server tables and define their properties
    using SMSS and DDL, alter and drop SQL Server tables
  • compare TRUNCATE to DELETE and use the TRUNCATE command to remove data from a SQL Server table
    describe the purpose and performance impact of views and create a view in a SQL Server database by using SMSS graphical designer or by using T-SQL
    create and use stored procedures in SQL Server databases
    compare stored functions with stored procedures and create and use a stored function within a SQL Server database

IN THIS COURSE

  • Playable
    1. 
    Creating Databases
    9m 4s
    UP NEXT
  • Playable
    2. 
    Altering and Dropping Databases
    6m 26s
  • Locked
    3. 
    Creating Tables
    6m 1s
  • Locked
    4. 
    Altering and Dropping Tables
    5m 55s
  • Locked
    5. 
    Truncating Tables
    8m 36s
  • Locked
    6. 
    Creating Views
    9m 27s
  • Locked
    7. 
    Creating and Using Stored Procedures
    8m 51s
  • Locked
    8. 
    Creating and Using Stored Functions
    7m 18s

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

Likes 27 Likes 27  
Likes 69 Likes 69  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 166 Likes 166  
Likes 141 Likes 141  
Likes 36 Likes 36