In this course you will learn advanced Transact-SQL using SQL concepts to help optimize queries. Additional focus is on writing queries that will effectively present data in reports.

starstarstarstarstar_half

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

Upon successful completion the student will be able to perform Variables, IF-THEN-ELSE Conditions, CASE Structures, Stored Procedures, Database View, COALESCE, WHILE Loops, Triggers User Defined Functions Windowing Functions, Mathematical Functions, Date Manipulation, Cursors.

1

  • Conditional Queries

  • Using an IF Statement

    Using a CASE Statement

2

  • Stored Procedures

  • Creating and Executing Stored Procedures

    Finding the Stored Procedure in the Object Explorer

    Using Parameters in Stored Procedures

    Altering a Stored Procedure

    Dropping a Stored Procedure

3

  • User-Defined Functions


  • Scalar-Valued Functions
    Creating the Scalar-Valued Function
    Running a Function
    Table-Valued Functions


4

  • Common Table Expressions

  • Creating and Using Common Table Expressions (CTEs)

5

  • Triggers

  • After Trigger

    Using an AFTER Trigger to Display a Message

    Using an AFTER Trigger to Rollback an Action

    Using INSTEAD OF Triggers

    Looking At Triggers in Object Explorer

    Disabling, Re-Enabling and Dropping a Trigger

6

  • Full-Text Indexes

  • Setting Up Full-Text Indexing

    Using the CONTAINS Keyword

    Using the FREETEXT Keyword

Audience

This course is intended for individuals with SQL knowledge looking to write faster queries and thus more efficiently retrieve data from databases

Language

English

Prerequisites

Course Info

Not Your Location? Change

Cost: $ 600

Length: 1.0 day (8 hours)

Level:

For scheduling options, please chat with an expert below.

Loading...