From developers to DBAs, everyone who codes against SQL Server databases use Transact-SQL in one way or another. This four-day class covers Transact-SQL and only Transact-SQL in both its individual SQL statement and procedural code (stored procedures, functions, triggers) forms, on SQL Server versions 2005-2012.
You will learn how to properly phrase SQL queries and use the right T-SQL constructs and data types for best performance, enforced by viewing and comparing query plans. You’ll also learn best practices for some of SQL Server’s enhancements to SQL that allow you to recognize, diagnose, and solve knotty problems in your own application, including dealing with data modification statements, summarization, windowing, and analysis queries as well as complex problem solving with hierarchies and entity attribute values. We’ll target appropriate data type usage, writing effective queries,
This class is based on real-world problems and programming challenges, not academic scenarios, and the instructor, Bob Beauchemin, is a recognized expert in T-SQL development. It’s chock-full of practical knowledge which will be immediately applicable in your work environment. Also feel free to BYOP (bring your own problem)!
For a detailed agenda click HERE.
If you need help justifying training to your organization, we can help you:
Click HERE to go to our events registration page.
If you have any questions, please contact us.