Type to search LearningTree.com

Do you mean "{{response.correctedQuery}}" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.

 

SQL Server Training









Preferred method of contact?

SQL Server Transact-SQL Programming

COURSE TYPE

Practitioner

Course Number

532

Duration

4 Days

Enroll

About This Course: Transact-SQL is integral to the power of SQL Server. Transact-SQL features allow developers to create scalable, distributed applications to meet the demanding requirements of modern organizations. This course provides extensive experience creating stored procedures and triggers, and developing T-SQL that utilizes SQL Server to the fullest.

You Will Learn How To

  • Develop scalable, distributed applications with Transact-SQL to meet organizational requirements
  • Create modular code with stored procedures and formulate triggers
  • Develop reusable code with scalar- and table-valued functions
  • Handle Transact-SQL runtime errors to create robust software
  • Audit data changes using AFTER triggers

Important Course Information

Requirements:

  • Experience with the Windows user interface

Recommended Experience:

  • Familiarity with the basic features of SQL Server or DBMS

Software:

  • This course includes exercises based on SQL Server 2012

Course Outline

  • SQL Server Architecture
  • SQL Server edition overview
  • SQL Server Management Studio
  • Managing Tables with DDL

Creating schemas

  • Referencing schemas versus using the default schema
  • Hiding schemas with synonyms

Building tables

  • Selecting appropriate SQL Server data types
  • Constructing tables with CREATE TABLE

Adding constraints

  • Enforcing uniqueness using PRIMARY KEY and UNIQUE constraints
  • Validating relationships using FOREIGN KEY
  • Retrieving Data with Transact-SQL Stored Procedures

Batch and stored procedure processing

  • Minimizing network traffic using batches and procedures
  • Stored procedure compilation and execution
  • Using scalar functions

Selecting data

  • Developing stored procedures that extract data from multiple servers
  • Executing dynamic queries using OPENROWSET and OPENQUERY
  • Executing remote procedures
  • Capturing RETURN values from stored procedures

Declaring variables and parameters

  • Creating and utilizing local variables
  • Passing input and output parameters

Calling built-in scalar functions

  • Converting data using CAST and CONVERT
  • Ordering data with ranking functions
  • Maintaining Data

Modifying data

  • Ensuring data consistency with transactions and distributed transactions
  • Managing concurrency with isolation levels
  • SQL Server locking fundamentals
  • Avoiding blocking problems with read-committed snapshot isolation

Programming procedural statements

  • Implementing conditions with IF...ELSE
  • Looping with WHILE and GOTO
  • Creating code blocks with BEGIN...END
  • Debugging T-SQL in Management Studio

Handling errors

  • Communicating problems to the client with RAISERROR
  • Intercepting errors with TRY ... CATCH
  • Dealing with open transactions

Producing server-side result sets

  • Building and using temporary tables
  • Processing rows on the server with a cursor
  • Taking advantage of table variables
  • Developing Views, Functions and Triggers

Storing queries on the server

  • Concealing complexity with views
  • Solving business problems using multistatement table-valued functions

Creating user-defined functions

  • Calculating values with scalar functions
  • Taking advantage of schema binding

Formulating triggers

  • INSTEAD OF vs. AFTER triggers
  • Detecting row changes using the inserted/deleted tables
  • Tracing metadata changes with DDL triggers
  • Auditing user access using a LOGON trigger
  • Tracking data changes with the OUTPUT clause
Show complete outline
Show Less

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

Feb 21 - 24 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Mar 14 - 17 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Apr 11 - 14 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

May 16 - 19 AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Jun 20 - 23 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Jul 11 - 14 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Aug 8 - 11 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Sep 26 - 29 AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Nov 6 - 9 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Nov 28 - Dec 1 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Guaranteed to Run

Bring this Course to Your Organization and Train Your Entire Team
For more information, call 1-888-843-8733 or click here

Tuition

Standard

$2990

Government

$2659

Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

After-Course Computing Sandbox
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.

Free Course Exam
You can take your course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."

Prev
Next

Questions

Call 1-888-843-8733 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm


FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results.
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)
  • Make progress toward one or more Learning Tree Specialist & Expert Certifications (if applicable)

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

Earn 23 Credits from NASBA

This course qualifies for 23 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...

“Our Transact-SQL programming instructor was a technically sophisticated and experienced resource. He was terrific in the class.”

- J. Abbott, Senior Quality Engineer
Allscripts

Prev
Next
s