Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Advanced Transact-SQL Programming
Rating: 3.7 out of 5(53 ratings)
286 students
Created byMike West
Last updated 8/2016
English

What you'll 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.

Course content

3 sections • 25 lectures • 59m total length

  • Introduction1:33

    What are you going to learn in this course? 

  • Is this Course Right For You?1:40

    Are you at the right place? I want you to take all of my courses but I want them to be right for you. 

  • The Timestamp1:55

    What is a timestamp and when do we use it? 

  • Nulls and Functions1:11

    NULLS are strange creatures and there's a lot to learn surrounding their usage. 

  • SET ANSI_NULL OFF and ON Within a Batch1:31

    What does SET ANSI_NULLS on do? 

  • Seeds and Reseeding Our Identity Columns6:03

    What is seeding and how do we seed and reseed? 

  • Course Downloads0:01

    This is the location for all of the course downloads

  • Summary0:42
  • Quiz

Requirements

  • Students should already have their test environments set up and have written basic transact.
  • Students should have a solid foundations with SQL Server and transact-sql.

Description

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


Who this course is for:

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

Report abuse