Are you new to SQL Server programming and development? Do you want to build expertise in SQL Server from the fundamentals? If so, then the Joes 2 Pros SQL Server Learning series is perfect for you!

In this series, author Rick Morelan takes you on a journey from the simplest concepts, such as how to open SQL Server Management Studio, to more advanced topics like query tuning and core architecture. The series is designed to help you prepare for SQL Server Exam 70-433, but it goes beyond just exam preparation. It focuses on thoroughly learning the important concepts of SQL Server programming and development.

One of the best features of this series is the companion videos that explain the concepts in a quick and easy-to-understand manner. Every Wednesday, a new video is posted to provide additional insights and explanations. In this blog post, we will go over five videos that were posted earlier in the series.

Introduction to XML Data Type Methods

The XML data type was first introduced with SQL Server 2005 and continues to be available in SQL Server 2008. This data type offers expanded XML features, including the power of the XQuery language to analyze and query XML values. In this video, you will learn about the five XML data type methods available in SQL Server 2008: query(), value(), exist(), modify(), and node().

Introduction to SQL Error Actions

Have you ever wondered what happens when SQL Server encounters an error? In this video, you will learn about the four ways SQL Error Actions can react to error severity levels 11-16. Understanding these error actions is crucial for achieving consistent results in your SQL code.

Introduction to Basics of a Query Hint

Query hints allow you to specify certain optimizations or behaviors for your queries. However, it is important to use query hints as a last resort, as the SQL Server Query Optimizer typically selects the best execution plan for a query. In this video, you will learn about the cautionary note associated with using query hints and when they should be used.

Introduction to Hierarchical Query

Common Table Expressions (CTEs) are temporary result sets that provide a more readable alternative to derived tables. In this video, you will learn about the power of CTEs, including their ability to be self-referencing or referenced multiple times in the same query. You will also discover the four elements required for a recursive CTE to work properly.

Introduction to SQL Server Security

Understanding SQL Server security is essential for protecting your data. In this video, you will learn about the basic definitions of securables, principals, and permissions. This knowledge will help you control access to your SQL Server resources effectively.

We hope you enjoyed these videos from the Joes 2 Pros SQL Server Learning series. Please leave a comment to let us know which video was your favorite and what improvements you would like to see in future videos. Your feedback is valuable to us!