Sign In   |   View Cart   |     |   Help
 
Course Catalog
 
Print Course information
E-mail to a friend
Return to Course Catalog

Courses and Programs > Community Education > New Classes!

SQL Level 2: Stored Procedures and More  

This course builds upon the basics of T-SQL (Transact-SQL) and covers Stored Procedures, Triggers, User Defined Functions and Indexing. We will do a deeper exploration into Data Types and their uses. The basics of performance tuning queries and error handling are covered as well.

Course taught using 2014, but is applicable and useful for previous versions.

Upon completion of this course, you should be able to:
  • Create and use User Defined Functions
  • Describe why Stored Procedures are used and why they might NOT be used
  • Create and use Stored Procedures
  • Describe why Triggers are used and why they might NOT be used
  • Create and use Triggers
  • Understand how indexes work in SQL Server
  • Describe the difference between clustered, nonclustered and covering indexes
  • Compare, contrast and use different data types in SQL Server
  • Execute basic performance tuning to get better query speed and efficiency
  • Implement basic error handling in your T-SQL code

 

SQL Level 2: Stored Procedures and More

Item: C167 Bernie Benson
8:00 AM - 4:30 PM ONLINE
Sessions: 2 Tu W Location: ONLINE
, WA
10/27/2020 - 10/28/2020 Fee: $595.00

This class is offered online using Zoom and Remote Desktop.

Zoom Requirements:

  • Access to a computer with speakers & microphone (or the ability to call in via phone).
  • A web camera (suggested but not required).
  • Access to high-speed internet.

  • Zoom link will be sent prior to the start of class. You must have the ability to connect via Remote Desktop on your computer to participate in the class. A second monitor is recommended.

    Refund Policy: Cancellations must be received 5 business days prior to the 1st day of class in order to receive a full refund.

     

    SQL Level 2: Stored Procedures and More

    Item: C202 Bernie Benson
    8:00 AM - 4:30 PM ONLINE
    Sessions: 2 W Th Location: ONLINE
    , WA
    11/18/2020 - 11/19/2020 Fee: $595.00

    This class is offered online using Zoom and Remote Desktop.

    Zoom Requirements:

  • Access to a computer with speakers & microphone (or the ability to call in via phone).
  • A web camera (suggested but not required).
  • Access to high-speed internet.

  • Zoom link will be sent prior to the start of class. You must have the ability to connect via Remote Desktop on your computer to participate in the class. A second monitor is recommended.

    Refund Policy: Cancellations must be received 5 business days prior to the 1st day of class in order to receive a full refund.

     

    SQL Level 2: Stored Procedures and More

    Item: C504
    Bernie Benson
    8:00 AM - 4:30 PM ONLINE
    Sessions: 2 Tu W Location: ONLINE
    , WA
    3/30/2021 - 3/31/2021 Fee: $595.00
    This class is offered online using Zoom and Remote Desktop.

    Zoom Requirements:
  • Access to a computer with speakers & microphone (or the ability to call in via phone).
  • A web camera (suggested but not required).
  • Access to high-speed internet.


  • Zoom link will be sent prior to the start of class. You must have the ability to connect via Remote Desktop on your computer to participate in the class. A second monitor is recommended.


    Registration for this class will open soon.