Advanced Transact-SQL Programming

Advanced Transact-SQL Programming, available at $19.99, has an average rating of 3.7, with 25 lectures, 2 quizzes, based on 51 reviews, and has 283 subscribers.

You will learn about Youll learn more than the basics of of how to manipulate SQL Server data. Youll be able to begin crafting more complex stored procedures with hands on exercises. Youll learn how to craft cleaner code thats properly optimized. This course is ideal for individuals who are If you understand the basics of Transact-SQL and want to dive deeper into learning transact then this course is for you. It is particularly useful for If you understand the basics of Transact-SQL and want to dive deeper into learning transact then this course is for you.

Enroll now: Advanced Transact-SQL Programming

Summary

Title: Advanced Transact-SQL Programming

Price: $19.99

Average Rating: 3.7

Number of Lectures: 25

Number of Quizzes: 2

Number of Published Lectures: 25

Number of Published Quizzes: 2

Number of Curriculum Items: 27

Number of Published Curriculum Objects: 27

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Youll learn more than the basics of of how to manipulate SQL Server data.

Youll be able to begin crafting more complex stored procedures with hands on exercises.

Youll learn how to craft cleaner code thats properly optimized.

Who Should Attend

If you understand the basics of Transact-SQL and want to dive deeper into learning transact then this course is for you.

Target Audiences

If you understand the basics of Transact-SQL and want to dive deeper into learning transact then this course is for you.

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!!!

Course Curriculum

Chapter 1: Course Overview

Lecture 1: Introduction

Lecture 2: Is this Course Right For You?

Lecture 3: The Timestamp

Lecture 4: Nulls and Functions

Lecture 5: SET ANSI_NULL OFF and ON Within a Batch

Lecture 6: Seeds and Reseeding Our Identity Columns

Lecture 7: Course Downloads

Lecture 8: Summary

Chapter 2: Advanced Tips

Lecture 1: The Right Date Data Type

Lecture 2: The Try Catch Block

Lecture 3: Using Case In The ORDER BY Clause

Lecture 4: UPDATE TOP 10 Using a CTE

Lecture 5: DELETE TOP 10 Rows

Lecture 6: The CHOOSE Function. The New Case?

Lecture 7: Forcing an Index Hint

Lecture 8: UDFs in Joins. Its Possible. Not Recommended.

Lecture 9: Variables and sp_executeSQL

Lecture 10: Quick Tip: Custom Errors Using RAISERROR

Lecture 11: THROWING out RAISERROR

Lecture 12: The Synonym Versus the View

Lecture 13: Single Value Declarations

Lecture 14: Control Flow

Lecture 15: ORDER BY

Lecture 16: Summary

Chapter 3: Conclusion

Lecture 1: Final Thoughts

Instructors

Mike West
Creator of LogikBot

Rating Distribution

1 stars: 4 votes

2 stars: 2 votes

3 stars: 12 votes

4 stars: 26 votes

5 stars: 7 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!