SQL

Pluralsight – Azure Sql Data Warehouse Query Performance Tuning

Pluralsight – Azure Sql Data Warehouse Query Performance Tuning-NOLEDGE
English | Size: 118.88 MB
Category: Tutorial


Notes: Microsoft Ignite 2019 | Azure SQL Data Warehouse: Query Performance Tuning | Chris Testa-O’Neill
Over the course of this experience, look for inefficiencies that are causing sub optimal performance

Lynda – Advanced SQL Window Functions

Lynda – Advanced SQL Window Functions-APoLLo
English | Size: 372.71 MB
Category: Tutorial


Window functions are one of the most radical, fundamental enhancements to modern SQL. They allow access to neighboring rows without using subqueries, thus enabling amazing opportunities for concise, elegant, high-performing solutions.

Lynda – SQL Server Machine Learning Services R

Lynda – SQL Server Machine Learning Services R-APoLLo
English | Size: 266.61 MB
Category: CBTs


SQL Server now includes support for direct execution of R code. This integration allows complex data science analyses to be performed quickly in a secure environment, without having to export data sets first. In this course, database expert Adam Wilbert walks through the steps of enabling the required components-including Machine Learning Services for R-and writing basic R scripts. He also shows how to retrieve and work with data stored in SQL Server tables, create data visualizations with external R libraries, and package scripts as stored procedures. At the end of the course, traditional SQL Server users will be able to dive deeper into using R and traditional R developers will be able to take advantage of using SQL Server as the source of data to create higher-performing analyses.

Linux Academy – Microsoft SQL Server on Linux in Azure

Linux Academy – Microsoft SQL Server on Linux in Azure-BiFiSO
English | Size: 1.18 GB
Category: Tutorial

Microsoft SQL Server is a robust relational database management system with a number of intriguing features. Starting with SQL Server 2017, it is now available on many people’s favorite operating system, Linux! In this course, we go over how to install, configure, and manage SQL Server on Linux. We do this within Azure and highlight some of the key benefits that Azure brings to the table for our SQL Server strategy.

Linux Academy – AmAZon Aurora Cloud SQL DB Essentials

Linux Academy – Amazon Aurora Cloud SQL DB Essentials-APoLLo
English | Size: 2.40 GB
Category: Tutorial

Hi, and welcome to this course on Amazon Aurora! In this course we will be covering all of the essentials that you need to know for Amazon Aurora with some deeper dives into Aurora’s features, management, security, storage, and reliability, data management, performance, and also troubleshooting topics.