Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
An Abridged Introduction to Dynamic SQL
Rating: 3.9 out of 5(27 ratings)
155 students

An Abridged Introduction to Dynamic SQL

Learn Real World Techniques You can Apply Immediately
Created byMike West
Last updated 1/2017
English

What you'll learn

  • By the end of this course you'll be able to take what you've learned and immediately apply it to the real world.

Course content

4 sections • 26 lectures • 1h 5m total length

  • Introduction to Dynamic SQL1:30

    Let's learn what this course is about. 

  • The 3 Steps to any Dynamic SQL Statement4:09

    The big three. 

    What are they? 

    Let's find out. 

  • The Bit Debug Trick2:09

    We can use this tip inside larger code segments. 

  • Document dynamic SQL4:42

    Most people don't document their code but with dynamic SQL it's probably a really solid practice. 

  • Backing Up All AdventureWorks Databases6:17

    In this lecture let's add some more complexity.

  • Add a Date stamp to our Adventureworks Database3:39

    Let's add a date and time stamp to our adventureworks backup script. 

  • Course Downloads0:04
  • Summary0:30
  • Quiz

Requirements

  • Learners will need a strong foundation in Transact-SQL
  • You'll need an Instance of SQL Server
  • You'll need a copy of the adventureworks training database

Description

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

Who this course is for:

  • If you're a mid-level to senior level SQL Server Resource that wants to learn to harness the power of Dynamic SQL then this course is for you.

Report abuse