SQL

Skillshare – Database Management System and Commands of SQL Oracle

Skillshare – Database Management System and Commands of SQL Oracle-ViGOROUS
English | Size: 1.10 GB
Category: Tutorial


Learn how to write SQL (Structured Query Language) from scratch with the SQL Essentials training course. This course will easily step you through writing SQL using an online editor. SQL allows you to retrieve, sort, filter, group, aggregate and calculate data stored in a SQL Server database. This course is designed for people wanting to learn how to interrogate data from a relational database, how to manipulate this data (Insert, update, and delete records).

Apress – PowerShell Core for SQL Server – Automating Your Transact-SQL Scripts

Apress – PowerShell Core for SQL Server – Automating Your Transact-SQL Scripts
English | Size: 549.17 MB
Category: Programming


Get up and running with accessing SQL Server from PowerShell Core. By the end of this video you’ll have learned how to issue Transact-SQL statements and get results back, how to insert, modify, and delete data in the database, and how to import and export data to and from SQL Server. You’ll be equipped to automate database administration and other maintenance tasks through using PowerShell to automate the execution of Transact-SQL scripts that are stored in files that you can easily edit to keep up with changing business needs.

Pluralsight – Raising The Bar Again For Azure Sql Database With Centrally Managed Encryption

Pluralsight – Raising The Bar Again For Azure Sql Database With Centrally Managed Encryption-NOLEDGE
English | Size: 193.91 MB
Category: Tutorial


Notes: Microsoft Ignite 2019 | Raising the Bar Again for Azure SQL Database with Centrally Managed Encryption | Jakub Szymaszek, Joachim Hammer Customers are increasingly asking for better controls to secure their data as it moves across platforms and organizational boundaries.

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.