|
|
Course Description
|
|
|
||
|
Course
name |
SQL Server 2008 Stored
Procedures |
|
|
|
||
|
Course
code |
SQLSERVERSTOPROC |
|
|
|
||
|
Audience |
People who wish to use SQL
Server Transact-SQL to create queries and simple reports using SQL Server
2008. |
|
|
|
||
|
Prerequisites |
Introduction to SQL Server
2008 or equivalent SQL Server experience. |
|
|
|
||
|
Objectives |
Upon successful completion, the
participant will be able to: ·
Discuss the what’s and
whys of SQL Server. ·
Discuss the many features
of SQL Server Management Studio. ·
Review the SQL basics as
implemented by SQL Server such as: tables and their characteristics, column data types,
nulls, constraints and
referential integrity. ·
Use the SQL Editor Toolbar
of the SQL Server Management Studio. ·
Create and execute simple
Stored Procedures. ·
Debug a stored procedure
using the Development Center. ·
Code Stored Procedures
using Control-of-Flow Statements such as: BEGIN...END, BREAK, CONTINUE, GOTO label, IF...ELSE, RETURN, TRY...CATCH, WAITFOR and WHILE. ·
Use Print and RAISEERROR
within Stored Procedures. ·
Code Transact SQL and
Stored Procedures using a Cursor. |
|
|
|
||
|
Duration |
2 Days |
|
|
|
||