Microsoft SQL Server Advanced Programming Techniques

Course:  MSSAPT
Duration:  4 Days
Level:  II
Course Summary

The Microsoft SQL Server Advanced Programming Techniques class will teach students methods to utilize in order to write highly efficient and effective stored procedures, batches, transactions, cursors, and ad hoc queries. Participants will be shown how to properly code functions, joins, subqueries, Case statements, and grouping facilities. Additionally, students will learn the structure of locking, search arguments, optimizations, and stored procedure compilations.

« Hide The Details
Topics Covered In This Course

Using Functions for

  • PresentationPaddingSignsSortingDecodingDate processingStringsArithmetic facilitiesLockingConceptsSchemesIsolation levelsDeadlocksTable locking

CASE processing

  • SelectUpdatesFrequency tablesTable pivotingTable folding

CURSORS

  • Read cursorsUpdate cursorsCoding techniques

Joins

  • Inner joinsOuter joinsSelf joinsTable lookupsMerge joinsHash Joins

Subqueries

  • Non-correlatedCorrelatedException reporting

Coding

  • UnionsGroup byCumulative totalsNumbering rowsMissing dataRanking

Stored procedures

  • CreatingExecutingTestingTransaction modesError processing

Effective coding

  • Search argumentsIndexesOptimizationsPlansVariablesParameters
What You Can Expect

Upon successful completion of this course, participants will be able to code advanced techniques of the Microsoft SQL Server with relative ease and understanding. Students will understand the most advantage method of coding to be performed in various situations.

Who Should Take This Course

This course is recommended for Microsoft SQL Server Application Programmers who require an in depth knowledge of advanced programming techniques.

Recommended Prerequisites

Students should have an understanding of the facilities of the Microsoft SQL Server Relational Database Management System. Students should also have attended the Introduction to Microsoft SQL Server and Transact_SQL facilities class.

« Hide The Details
Related Courses
Code Course Title Duration Level
SSQE
Microsoft SQL Server 2008 Introduction to Querying
2 Days
I
Details
SSPRG
Microsoft SQL Server 2008 Programming
5 Days
I
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com