Advanced Transact-SQL Programming

Advanced Transact-SQL Programming

Transact-SQL is integral to the power of SQL Server. 

Transact-SQL features allow developers to create scalable, distributed applications to meet the demanding requirements of modern organizations.

In this course we will move beyond the basics of Transact and learn advanced coding techniques that you can immediately integrate into your real world code. 

The code for each lesson will be available in the course download lecture so you can cut and paste example into your learning environment. 

This isn’t a structured course that walks you through all the basics categories of the language. 

This course will be a hodgepodge of real world questions taken from sundry SQL Server forums that answer real world problems specific to transact-sql. 

For example, did you know you can use the CASE statement in the ORDER BY clause? I have a short lesson on how to do just that. 

While this course isn’t a true expert level course I would highly recommend you have some basic experience with transact or have taken my introductory level course and worked through the example. 

Thanks for your interest in “Advanced Transact-SQL Programming.”

The first 10 minutes are free on every Udemy course. Please take a moment to watch all ten minutes to ensure this course is right for you. 

It's also a good idea to read over the lecture titles. The titles will provide you with insight into what's really in the course.

See you in the course!!!

Moving Beyond the Basics

Url: View Details

What you will learn

• You'll learn more than the basics of of how to manipulate SQL Server data.
• You'll be able to begin crafting more complex stored procedures with hands on exercises.
• You'll learn how to craft cleaner code that's properly optimized.

Rating: 3.7

Level: Intermediate Level

Duration: 1 hour

Instructor: Mike West