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.

Linux Academy – Microsoft SQL Server on Linux Quick Start

Linux Academy – Microsoft SQL Server on Linux Quick Start-BiFiSO
English | Size: 511.15 MB
Category: Tutorial

Microsoft SQL Server is a leading relational database management system (RDMS), and now it’s available on Linux! Let’s take a quick look at how to install and configure SQL Server on Linux, whether we’re using a traditional machine, containers, or an Azure SQL VM. We cover how to connect to and manage this popular RDMS using a variety of tools running on our favorite operating system.

Packt – Learning the FOSS4G Stack Spatial SQL with Postgres PostGIS

Packt – Learning the FOSS4G Stack Spatial SQL with Postgres PostGIS-XQZT
English | Size: 1.13 GB
Category: Tutorial

This course is part of an entire curriculum based on free and open source GIS (FOSS4g) software. The curriculum is grouped into different categories of the FOSS4g stack – Desktop, Server, and Developer. As part of this course, you will learn the most popular open source database – Postgres 11.

Cloud Academy – SQL Master Class

Cloud Academy – SQL Master Class-STM
English | Size: 347.01 MB
Category: CBTs

In this course, we go beyond the basics to empower you with the skills, how-to knowledge, and hands-on expertise to work through and solve complex business issues with SQL. We go deep and hands-on with transactions, subqueries, inline views, summarized queries, the exists predicate and set operations.This course is built from content created and delivered by Ian Wallington of QA

Linkedin Learning – Advanced SQL Logical Query Processing

Linkedin Learning – Advanced SQL Logical Query Processing-XQZT
English | Size: 283.57 MB
Category: Tutorial

SQL has been the dominant data processing language for the past five decades. This course takes you beyond the syntax fundamentals, and into a new world of understanding how relational database management systems process SQL queries, and how that impacts your coding practices. Learn about logical query processing, and avoid most common pitfalls and processing limitations. Discover advanced JOIN techniques and how to deal with missing data. Understand the subtleties of ternary logic SELECT expression evaluation, grouping logic, and how to implement efficient paging and ordering. By the end of the course, you ll be able to take advantage of the nuances of logical query processing to easily troubleshoot and solve daunting SQL challenges elegantly