An Abridged Introduction to Dynamic SQL

About this course

"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 c