Class / Schedule

Information Technology

SQL Level 2: Stored Procedures and More (2 Days)

01-04-T830
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 2012, but is useful for those using 2008 and previous versions.

    Performance Objectives: 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

    Competencies covered in this course: Covers T-SQL programming

      Intended Audience: EAdministrators and Developers who use the T-SQL language on SQL Server

        Recommended Pre-requisite: Basic knowledge of T-SQL and familiarity with Windows

        Scheduled Class Location and Dates
        City Facility Date and Time Course Cost Cancel Date Instructor
        Lacey SPSCC - LACEY
        4220 6th Ave SE Bldg. 1
        Lacey, WA 98503
        • Aug 2 2017 8:00am-4:30pm
        • Aug 3 2017 8:00am-4:30pm
        $595.00 Sun, 07/16/2017 - 17:00 Jim Parshall