LEARNING FOR LIFE

Get Yourself a Better Life! Free eLearning Download

PluralSight – Combining and Filtering Data With T-SQL

Leave a Comment

PluralSight – Combining and Filtering Data With T-SQL-JGTiSO
English | Size: 517.42 MB
Category: Tutorial


Are you looking to start out or brush up on your skills in T-SQL? In this course, Combining and Filtering Data with T-SQL, you will learn foundational knowledge of how to work with data and T-SQL. First, you will learn how to format and calculate data, and about logic functions. Next, you will discover how to join data from two or more tables Finally, you will explore how to aggregate data to find the sum, minimum, maximum, count, and average values, as well as learn about intermediary tables. When you are finished with this course, you will have the skills and knowledge to write queries, validate results from a query, and work with variables [Read more…]

PluralSight – Capturing Logic with Stored Procedures in T-SQL

Leave a Comment

PluralSight – Capturing Logic with Stored Procedures in T-SQL-BOOKWARE-KNiSO
English | Size: 295.38 MB
Category: Tutorial


Do you have experience writing T-SQL but want to start creating stored procedures? Well, this course is for you! Take your skills to the next level by learning all the in and outs of designing and optimizing stored procedures. [Read more…]

PluralSight – Querying JSON XML and Temporal Data with T SQL

Leave a Comment

PluralSight – Querying JSON XML and Temporal Data with T SQL
English | Size: 419.82 MB
Category: CBTs


The most common scenario with SQL Server is querying structured data. But many do not know that it also allows storing and querying semi-structured data using XML and JSON; as well as obtaining values from any point in time with temporal tables. [Read more…]

PluralSight – Handling Errors in T SQL

Leave a Comment

PluralSight – Handling Errors in T SQL-BOOKWARE-KNiSO
English | Size: 266.51 MB
Category: Tutorial


Release Notes: Perhaps you re starting out or have been putting off learning error handling for years. Maybe you want to take your understanding of error handling in SQL Server to the next level. In this course, Handling Errors in T-SQL, you will gain the ability to handle exceptions in SQL Server. First you will learn why handling errors in T-SQL is critical to writing quality code. Along the way, learning why you want to control the outcome of your scripts. Next, you will discover how transactions are woven into the fabric of SQL Server and how to manage them efficiently. Finally, you will explore the most important error handling methods. When you re finished with this course, you will have the skills and knowledge necessary to consistently handle exceptions in T-SQL [Read more…]

PLURALSIGHT Troubleshooting Your First Low-performing T-SQL Query

Leave a Comment

PLURALSIGHT TROUBLESHOOTING YOUR FIRST LOW PERFORMING T SQL QUERY-JGTiSO
English | Size: 351.80 MB
Category: Tutorial


Perhaps you re starting out or low performing T-SQL queries have been plaguing you for years. Maybe you have been appointed the new SQL expert but your query tuning skills are lacking. In this course, Troubleshooting Your First Low performing T-SQL Query, you will gain foundational knowledge of improving query performance. First, you will hear what vital questions can be asked about a query. Understanding the intent of what data your query is returning back is paramount in improving performance. Along the way, you will learn the internals of how SQL Server stores and retrieves data. Next, you will discover tools built into SQL Server Management Studio. These tools are vital for exploring the SQL Server internals. Finally, you will explore several low performing queries utilizing your newly acquired skills to
improve performance. When you re finished with this course you will have the skills and knowledge necessary to consistently improve low performing queries [Read more…]