An Abridged Introduction to Dynamic SQL

"First impressions are "Finally, a practicing educator" Course delivery is smooth and spot on. Right before you lose hope a gem like this pops up - thanks."  - Don Councill

Welcome to An Abridged Introduction to Dynamic SQL.

Dynamic SQL is a programming technique that enables you to build SQL statements dynamically at runtime. You can create more general purpose, flexible applications by using dynamic SQL because the full text of a SQL statement may be unknown at compilation.

Dynamic SQL is often underused, misused, or overused.

If you are completely unfamiliar with Dynamic SQL, this will be an opportunity to learn, practice, and immediately apply it.

If you already have experience in writing and using Dynamic SQL, this will be a chance to learn new applications while getting a refresher on those you have worked with in the past. 

Anyone with a healthy interest in database administration or development can benefit from the topics covered in this course.

Dynamic SQL seeks to solve scenarios where you want to operate on one or many objects, but do not know all the details but don’t know all the details as your write the code.

Dynamic SQL gives us an opportunity to customize statements to match performance needs.

Removing excess objects, removing joins and subqueries, and reducing the size of a SQL statement can result in faster executions times and reduce resource consumption.

The course will be exercise laden. Because Dynamic SQL is unfamiliar to many we will start of basic and transition into more detailed examples.

There are many reasons why you would want to incorporate Dynamic SQL into your everyday arsenal of SQL Server tools and in the course we will demonstrate several real world example.

I’d also like to add that an automated software engine I’ve authored called sqlblackbox relies heavily on Dynamic SQl and in the course I’ll show you a few simple lines I use in the application.

Thank you for your interest in An Abridged Introduction to Dynamic SQL and we will see you in the course.