Here is a list of many of my SQL Server Training Classes available at Stedmans SQL School.
This complete course will help you determine if you have a sufficient backup strategy and restore plan OR will help you build one from scratch.
In this course we dive into real life stories, RTO and RPO lesson with examples, what might you need to restore from, types of backups, configuring backups with maintenance plans, restoring from backups, ransomware considerations, building restore script and other backup tools.
The Performance Tuning Class at Stedman SQL School is designed to transform the way you optimize SQL Server databases. This hands-on course focuses on identifying and addressing performance bottlenecks, from poorly written queries to inefficient indexing strategies. You’ll learn techniques to analyze execution plans, optimize long-running queries, and leverage tools like Database Health Monitor to pinpoint issues before they impact users. Whether you’re dealing with slow applications, high CPU usage, or excessive I/O, this class equips you with practical strategies to enhance database performance.
Led by SQL Server expert Steve Stedman, this class combines real-world examples with actionable insights to give you a deeper understanding of performance tuning. You’ll explore advanced indexing techniques, parameter sniffing mitigation, tempdb optimization, and strategies for handling blocking and deadlocks. The course also covers best practices for database maintenance to ensure consistent performance over time. If you’re ready to take control of your SQL Server environment and maximize its potential, sign up for our Performance Tuning Class today! Learn more and register here.
In this course you will first gain an understanding of the differences between each of these types of SQL JOIN types, 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. Signup today!
This course is designed to provide an in-depth understanding of SQL Server Replication, a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency.
Using practical examples and interactive exercises, students will explore the key concepts, configurations, and management techniques involved in implementing and maintaining replication in SQL Server environments. The course will cover all three primary replication types: Transactional Replication, Merge Replication, and Snapshot Replication, each addressing different requirements for data distribution and synchronization.
In this course we cover the steps you need to monitor your SQL Server using the Database Health Monitor application.
Learn how to monitor your wait statistics, you blocking queries, and to find out the best ways to improve performance with what you learn.
Don’t wait for disaster to strike—be proactive with our Preparing for Corruption on SQL Server course! This essential training equips you with the knowledge and tools to safeguard your databases against corruption before it happens. Learn to identify early warning signs, implement best practices for backup and restore, and master proven strategies for detecting and repairing corruption. With real-world examples and hands-on exercises, you’ll gain the confidence to handle critical situations and keep your data safe. Protect your career and your company’s assets—register today and be ready for anything SQL Server throws your way!
Preparing for an SQL DBA or Developer role requires more than just technical knowledge; it demands a clear understanding of real-world challenges and the ability to solve them under pressure. Our SQL DBA and Developer Interview Prep Class is designed to bridge the gap between theoretical concepts and practical expertise. This comprehensive course covers essential topics like database upgrades, backup and recovery strategies, query optimization, and advanced SQL features such as replication and sharding. You’ll also gain insights into managing multiple SQL Server instances, handling transaction logs, and resolving common challenges like deadlocks. By focusing on both technical skills and situational problem-solving, the class ensures you’re ready for even the toughest interview questions.
This program is tailored for both aspiring SQL professionals and seasoned experts looking to refine their skills. Through interactive sessions, hands-on exercises, and real-world scenarios, you’ll build the confidence needed to navigate the interview process with ease. With guidance from experienced instructors and access to study guides, mock interviews, and a wealth of practical tips, you’ll be well-prepared to showcase your expertise. Whether you’re stepping into the industry for the first time or advancing your career, this class provides the tools you need to succeed.
If you’re ready to take your SQL Server skills to the next level, our Common Table Expression (CTE) class is the perfect opportunity. Designed for database professionals, developers, and SQL enthusiasts, this class delves deep into the power and versatility of CTEs in SQL Server. You’ll learn how to simplify complex queries, enhance readability, and tackle challenging problems like hierarchical data traversal. Through hands-on exercises and real-world examples, we’ll cover the essentials of both recursive and non-recursive CTEs, showcasing techniques that you can immediately apply to optimize your database solutions.
The CTE class doesn’t just teach you the syntax—it empowers you with the practical knowledge to make an impact on your SQL Server environment. Whether you’re managing reporting systems, developing dynamic applications, or tackling performance bottlenecks, mastering CTEs can transform the way you approach query writing. By the end of the class, you’ll have a clear understanding of where and when to use CTEs, as well as strategies to avoid common pitfalls. Ready to enhance your SQL skills? Enroll today and elevate your querying expertise!
Unlock the full potential of SQL Server with our Aggregating Data class, designed to help you master the art of summarizing and analyzing data efficiently. This class dives deep into techniques for leveraging aggregation functions like SUM, AVG, COUNT, and GROUP BY, as well as advanced methods like window functions and rollups, to extract meaningful insights from your datasets. Whether you’re building reports, analyzing trends, or optimizing large-scale queries, this class equips you with the tools and knowledge to handle even the most complex aggregation challenges. Join us and take your data skills to the next level—register today and start transforming raw data into actionable intelligence!
Take your SQL Server skills up a notch with our Using the T-SQL OUTPUT Clause course, where you’ll discover the secret to capturing and tracking data changes efficiently. This course dives into the power of the OUTPUT clause, showing how to retrieve inserted, updated, or deleted data during DML operations without extra queries. Learn to simplify audit trails, enhance data logging, and streamline application workflows with practical, real-world examples. By the end, you’ll have the confidence to implement the OUTPUT clause effectively in your projects, saving time and reducing complexity. Don’t miss this chance—enroll now and revolutionize your T-SQL expertise!
This is an introductory class that will help you get SQL Server and all the tools you need to access the databases installed and running on your computer.
By the end of this course you will be proficient in using the tools to access SQL Server, browsing data in databases, and writing some basic queries.
At Stedman Solutions, we offer a free ransomware class designed to help IT professionals and business leaders understand how to protect their SQL Server environments from ransomware attacks. This course covers critical topics such as identifying vulnerabilities, implementing robust backup strategies, testing your recovery plans, and ensuring your database remains secure even in the face of evolving threats. Don’t let ransomware catch you off guard—gain the knowledge you need to safeguard your data and ensure business continuity. Learn more and sign up for free today at Stedman Solutions.
SQL Server Training Classes Offered by Steve Stedman
- SQL Server Replication Course
- Introduction to SQL Server
- Using Database Health Monitor
- Performance Tuning for DBA’s
- Common Table Expressions
I am available to travel to present SQL Server Training Classes. Contact me to check availability.
Getting Help from Steve and the Team
Contact us for your Free 30 minute consultation ORschedule your appointment now.