Components, Procedures, & Functions

SQL Server 2014    |    Beginner
  • 8 videos | 1h 1m 38s
  • Includes Assessment
  • Earns a Badge
Likes 41 Likes 41
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
    In this video, you will create a new SQL Server database using SMSS and DDL, review its schema, and learn its specific syntax and parameters. FREE ACCESS
  • Playable
    2.  Altering and Dropping Databases
    6m 26s
    In this video, find out how to use, alter, and drop SQL Server databases using SMSS and DDL. FREE ACCESS
  • Locked
    3.  Creating Tables
    6m 1s
    Find out how to create SQL Server tables using SMSS and DDL, and how to define their properties. FREE ACCESS
  • Locked
    4.  Altering and Dropping Tables
    5m 55s
    During this video, you will learn how to alter and drop SQL Server tables using SMSS and DDL. FREE ACCESS
  • Locked
    5.  Truncating Tables
    8m 36s
    In this video, you will learn how to compare TRUNCATE to DELETE and use the TRUNCATE command to remove data from a SQL Server table. FREE ACCESS
  • Locked
    6.  Creating Views
    9m 27s
    Upon completion of this video, you will be able to 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. FREE ACCESS
  • Locked
    7.  Creating and Using Stored Procedures
    8m 51s
    During this video, you will learn how to create and use stored procedures in SQL Server databases. FREE ACCESS
  • Locked
    8.  Creating and Using Stored Functions
    7m 18s
    In this video, you will compare stored functions with stored procedures and create and use a stored procedure within 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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 544 Likes 544  
Likes 2186 Likes 2186  
Course SQL Views
Likes 107 Likes 107