SQL Level 3

Training for Your Group

Training for Individuals

$600

Upcoming Dates

Course Overview

This advanced Transact-SQL course focuses on using SQL concepts to help optimize queries.The course will also focus on writing queries that will effectively present data in reports. Target Audience: Individuals with SQL knowledge looking to write faster queries and thus more efficiently retrieve data from databases

Course Length: 1 Day

Prerequisites: SQL Level 2 or equivalent working knowledge

Audience: Users should have a working knowledge of SQL

What You're Going To Learn

Variables
IF-THEN-ELSE Conditions
CASE Structures
Stored Procedures
Database Views
COALESCE
WHILE Loops
Triggers
User Defined Functions
Windowing Functions
Mathematical Functions
Date Manipulation
Cursors

Register for an Upcoming Date

Course Outline

Lesson 1: Conditional Queries

Using an IF Statement
Using a CASE Statement

Lesson 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

Lesson 3: User-Defined Functions

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

Lesson 4: Common Table Expressions

Creating and Using Common Table Expressions (CTEs)

Lesson 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

Lesson 6: Full-Text Indexes

Setting Up Full-Text Indexing
Using the CONTAINS Keyword
Using the FREETEXT Keyword

What to Expect at LeapFox

Knowledgeable Instructors

Our instructors are certified professionals. They are trained on the latest features and how to get the most out of software programs.

Hands-on Labs

No boring lectures! Our courses are designed to give students lots of time to practice what they are learning with hands-on exercises and projects.

Certificate of Completion

Receive a certificate of completion at the end of every course.

Up-to-date Curriculum

Each course comes with a helpful and up-to-date ebook which will contain instruction and practice exercises.

Time Saving Tips N Tricks

In each course, your instructor will show you tips and tricks that will save you time and make you more efficient.

Friendly and Helpful Staff

Our staff is dedicated to your success. Each team member is trained to provide the absolute best customer service possible.

Satisfaction Guarantee

If you aren't 100% satisfied with your experience at LeapFox, simply let us know, and we will make it right.