The following SQL Freebies are available from Stedman Solutions, LLC.
T-SQL JOIN Types Poster (Free Download)
Quite often I get asked for help with confusing JOINs. I created this poster to help show what is happening with different JOIN types, and to better communicate the difference between different JOIN types. More Info >>>
MySQL JOIN Types Poster (Free Download)
After creating the T-SQL JOIN poster, I received many requests to create a similar poster for MySQL. With MySQL some of the ways of completing a specific join type are slightly different. More Info >>>
Ransomware Awareness Course (Free)
This course relates to databases and how you can better prepare your SQL Server for a ransomware attack. Statistics are saying ransomware attacks are at an all time high and it’s not if but WHEN you’ll get hit. More Info >>>
Free Video Training
Available on my YouTube Channel
SQL Server Common Table Expressions Book – by Steve Stedman
You get full access to my Common Table Expressions book, along with sample code to support the queries shown in the book. You can download this as a PDF and start reading today. Over 250 pages of content all about TSQL and Common Table Expressions.
Once you have mastered the CTE you may never look at a query the same again.
Weekly SQL Performance Training Tips
Weekly training emails with tips and tricks to help you get more out of your SQL Server.
Each week Stedman Solutions will send out a short training tip on how to make your SQL queries run faster and increase your SQL Server performance. More info >>>
Securing SQL Server – Free White Paper
With ransomware and spyware being more common every day, being sure that your SQL Server is secure is an import part of any DBA’s job. This whitepaper will help guide you through some common steps to harden your SQL Server.
Take the steps we teach to make your SQL Server more secure and less vulnerable to attackers.
Related Content:
In this course you will first gain an understanding of the differences between each of these types of joins and when they should be used. Then we’ll explore some common uses for joins, such as replacing a not in clause with join to get the same results with better performance. You will take home the right foundations to get at the data that you want.
You will learn to use CTE’s for recursive queries, as temporary views, and to use the result set multiple times in the same query. Learn how simplify query syntax using CTE’s.
One of the most overlooked features of SQL Server is the CTE which not only simplifies the query, but gives you the ability to do things that would otherwise be impossible (or at least very challenging) with SQL Server.
Need help?
Contact us today for your free 30 minute consult to find out how Stedman Solutions can help with your SQL Server needs.