This class is intended for analysts, developers,
designers, administrators, and managers new to the SQL
programming language. Upon completion, participants will
understand SQL functions, join techniques, database
objects and constraints, and will be able to write
useful stored procedures and views as well as complex
queries and updates. Comprehensive hands on exercises
are integrated throughout to reinforce learning and
develop real competency.

Course Prerequisites:

General
computer knowledge. Familiarity with relational database
concepts is helpful but not required.

T-SQL Code ConstructsExploiting the Programming Features of T-SQL
Conditional Constructs
Looping Constructs
Building Multi-Batch Scripts
Invoking System Functions
Using Variables in Scripts
Using Temporary Tables in Scripts
Handling Errors
Using TRY...CATCH Blocks
Using System Variables and Functions

Working with Data Types and FunctionsEffective Use of Data Types in SQL
String
Numeric
Time/Date
Other
Substitution of Non-null Values with the COALESCE and
ISNULL Functions
Analyzing Data Points Using Ranking Functions

Using T-SQL CursorsOverview of Cursors
Declaring a Cursor
Using OPEN CURSOR, CLOSE CURSOR, DEALLOCATE CURSOR
Statements
FETCHing Results
Testing @@FETCH_STATUS and @@CURSOR_ROWS
Updating Records with Cursors

Working with ViewsBenefits of Using Views
Creating Views
Modifying Data with an Updateable View
ALTER and DROP VIEW

2KO is an IT consulting and training company, that offers business services and training for multiple IT platforms. 2KO Africa's courses are available as full time hands-on classes, or as online e-learning..