This is the last week of the year and this is the last post in the new technology week. While we learn about SQL Server entire year, the first four blogs we discussed different technology. There are many who reached out to me that they would love to know SQL Server courses on the Pluralsight. Today we will discuss where we can learn SQL Server.
SQL Server Technology Week
- Course 1: Analyzing SQL Server Query Plans
Every database server runs different workloads and queries, and it’s important for a SQL Server Performance Tuning Expert to identify queries that are negatively impacting performance. In this course, Analyzing SQL Server Query Plans, you will gain the ability to identify performance bottlenecks on your database. First, you will learn to analyze query plans. Next, you will discover and understand query execution plans. Finally, you will explore how to resolve the performance bottleneck. When you are finished with this course, you will have the skills and knowledge of analyzing the query plans needed to troubleshoot SQL Server performance problems.
- Course 2: Play by Play: SQL Server Administration with Pinal Dave
Geoffrey Grosenbach sits down with Pinal Dave to see what a SQL Server Admin does in the real world. This Play-by-Play will focus on SQL Server performance tuning. Pinal goes over-optimizing queries and fine-tuning the server.
- Course 3: Using Memory-optimized Tables and Native Stored Procedures
The In-Memory OLTP feature adds a new memory-optimized RDBMS engine and a native compiled stored procedure. This new edition adds higher concurrency to the SQL Server and enables it to process a much higher amount of the workload than before. In this course, we will learn about how to get started with the memory-optimized tables and build a use case around its effectiveness. Additionally, we will also understand how the efficiency of the stored procedure is increased when we use the Native Stored Procedure along with Memory-Optimized Tables.
- Course 4: SQL Server Performance: Indexing Basics
Indexes are the most crucial objects of the database. They are the first stop for any DBA and Developer when it is about performance tuning. There is a good side as well evil side of the indexes. To master the art of performance tuning one has to understand the fundamentals of the indexes and the best practices associated with the same. This course is for every DBA and Developer who deals with performance tuning and wants to use indexes to improve the performance of the server.
- Course 5: SQL Server Performance: Introduction to Query Tuning
SQL Server performance tuning is an in-depth topic, and art to master. A key component of overall application performance tuning is query tuning. Writing queries in an efficient manner, and making sure they execute in the most optimal way possible, is always a challenge. The basics revolve around the details of how SQL Server carries out query execution, so the optimizations explored in this course follow along the same lines.
- Course 6: SQL Server Questions and Answers
This course is designed to help you better understand how to use SQL Server effectively. The course presents many of the common misconceptions about SQL Server, and then carefully debunks those misconceptions with clear explanations and short but compelling demos, showing you how SQL Server really works. This course is for anyone working with SQL Server databases who wants to improve her knowledge and understanding of this complex platform.
- Course 7: SQL Server 2014 Administration New Features
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. This course takes a tour of the basic new features that were introduced, including backup, security, column store enhancements, Resource Governor, General Administration, Azure integration, extensions with SQL Server 2014 and more. To get the most out of this course, viewers should be familiar with SQL Server and database concepts.
I hope you find this SQL Server Learning Path helpful. If you have a Pluralsight subscription, you can watch it for free. If you do not have a Pluralsight subscription, you can still watch the course for FREE by signing up for a trial account.
Reference: Pinal Dave (https://blog.sqlauthority.com)