Notes from SQL Server Classes
Happy Thanksgiving to all those who celebrate. Todays coupon code is BACK60 As black Friday approaches, we are kicking things off with another great class promotion. My goal is to sell as many classes as I can this month at the lowest price we will set them at all year long. If you are thinking about singing up for one of …
Thanksgiving Special 60% off SQL Server Backup and Restore Read more »
This is perhaps the lowest price that we ever sell this course for, which includes the following. Database Health Monitor training. Database Health Monitor licensing for up to 20 SQL Servers for 1 year. The blocking query monitor with email notification for 1 year license. If you are using Database Health Monitor and you are tired of the limitations of …
30% off Bundle Database Health Monitor + Blocking Query Monitor Read more »
There are only a couple days left on this weeks SQL Server class discounts. These both expire in the next couple days and will be replaced with different promotions for Thanksgiving, black Friday, cyber Monday and more. Track Blocking Queries with Email Alerts This is more than just a course, enrollment in the course also gets you access to our …
The Getting Started with SQL Server course is great for people who have never used SQL Serve before and need a jump start to get SQL Server and the tools needed to run queries installed. This is the most basic SQL Server course intended for the beginner. Here is the direct link to the class using the coupon code, valid …
This is more than just a course, enrollment in the course also gets you access to our track blocking queries script, and training on how to use it. This is script that runs as a SQL Server agent job and over time catches blocking and logs it to a table. With this it gives you the ability to go back …
60% off Track Blocking Queries with Email Alerts Read more »
There are only a couple days left on this weeks SQL Server class discounts. These both expire in the next couple days and will be replaced with different promotions for next week. First the Common Table Expressions class deal Here is the direct link to the class using the coupon code, valid through November 15. https://stedmans-sql-school.teachable.com/p/unleash-common-table-expression-in-sql-server?coupon_code=CTENOV Coupon Code CTENOV Then …
The Aggregating Your Data in SQL Server course is our newest course. This promotion marks the price down to just $3 from now until November 15th. You will learn about basic aggregation as well as aggregation with windowing using the over clause. You will gain a good understanding of how the group by works in a standard query and how …
Aggregating your data in SQL Server course for just $3. Read more »
Learning Common Table Expressions is one of my favorite classes, with over 8 years of prep time for this course, including presentations at live conferences, writing a book on CTE’s and number online presentations. This course will cover most everything you would ever want to know about common table expressions. Have you ever wanted to create a recursive query but …
40% off Learning Common Table Expressions in SQL Server Read more »
There are only a couple days left on first SQL Server class discounts for November. These both expire in the next couple days and will be replaced with different promotions for next week. 40% off SQL Joins Type Class The JOINS Type class is one of our best selling classes. The standard price is $29.99 USD which is a great …
For just 2$ you can get my TSQL Output Clause class with coupon code OUTPUT2. The SQL Server output clause is a great way to get data back from an insert, update or delete statement, and it cause be used for auditing, or tracking of changes. It is also a great way to capture changes for a type of undo …