SQL

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.

Linux Academy – Google Cloud SQL Deep Dive

Linux Academy – Google Cloud SQL Deep Dive-BiFiSO
English | Size: 597.12 MB
Category: Tutorial

Welcome to the Google Cloud AI Services Deep Dive course. I’m Joe Lowery, and I’ll be your guide through this amazing collection of technology that will, without a doubt leave you wide-eyed in wonder at the possibilities of what you can accomplish at this very moment.