Course Length: 1 day

Course Description

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.
                                                                                                                                                    

Course Objective: You will work learn how to write conditional queries, stored procedures, triggers, and other types of SQL statements to become more proficient at writing effective SQL statements.

Target Student: Students should have basic introductory SQL skills, basic computer skills, and be familiar with concepts related to database structure and terminology.

Prerequisites: To ensure your success, we recommend you first take the following Element K courses, or have equivalent skills and knowledge:

• SQL : Fundamentals of Querying
• SQL: Advanced Querying
  

 

See Dates for this class

 

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

 

• Write conditional queries to control and enhance data output
• Write and execute stored procedures
• Write and use user-defined functions
• Create and use Common Table Expressions (CTEs)
• Create and execute triggers
• Use Full-Text Indexing to speed up queries with incomplete criteria

 

 

 

Course Content

Conditional Queries

• Using an IF Statement
• Using a CASE Statement    

Stored Procedures

• Creating and Executing Stored Procedures
• Using Parameters in Stored Procedures
• Altering a Stored Procedure
• Dropping a Stored Procedure

User-Defined Functions 

• Scalar-Valued Functions
• Table-Valued Functions            
               

 

 

 

Common Table Expressions

• Creating And Using Common Table Expressions
  

Triggers      

• Using AFTER Triggers
• Using INSTEAD OF Triggers          
  

Full-Text Indexes

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