Components, Procedures, & Functions

SQL Server    |    Beginner
  • 8 videos | 1h 1m 38s
  • Includes Assessment
  • Earns a Badge
Rating 3.7 of 10 users Rating 3.7 of 10 users (10)
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

  • 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
  • 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

Course Visualizing Data for Impact: Introduction to Data Visualization
Rating 4.5 of 78 users Rating 4.5 of 78 users (78)
Course CompTIA Data+: Understanding Data
Rating 4.8 of 12 users Rating 4.8 of 12 users (12)
Channel R for Data Science
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Non-relational Data: Non-relational Databases
Rating 4.5 of 41 users Rating 4.5 of 41 users (41)
Course Fundamentals of AI & ML: Introduction to Artificial Intelligence
Rating 4.4 of 2070 users Rating 4.4 of 2070 users (2070)
Course CompTIA A+ 220-1001: Basic Cable Types
Rating 4.6 of 178 users Rating 4.6 of 178 users (178)