Query

Egghead.io – Graphql Query Language-APoLLo

Egghead.io – Graphql Query Language-APoLLo
English | Size: 100.82 MB
Category: Tutorial


GraphQL is gaining traction as one of the most popular ways to create an API. Regardless of which GraphQL implementation you pick, you’ll use the QL in GraphQL – the query language – to query data, change data with mutations, and listen for data changes with subscriptions.

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

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