Tag: SQL

April 3, 2023

SQL Query Design Patterns and Best Practices A practical guide to writing readable and maintainable SQL queries

By  E-Books  0 Comments

Free Download SQL Query Design Patterns and Best Practices: A practical guide to writing readable and maintainable SQL queries
English | 2023 | ISBN: 1837633282 | 325 pages | True EPUB | 21.94 MB
Enhance your SQL query writing skills to provide greater business value using advanced techniques such as common table expressions, window functions, and JSON

(more…)

March 31, 2023

Acloud Guru – Managing Azure SQL Database for the SQL Server DBA

By  Other Tutorials  0 Comments

Free Download Acloud Guru – Managing Azure SQL Database for the SQL Server DBA
Released 3/2023
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 47 Lessons (4h 22m) | Size: 2.2 GB
This course will teach you how to take advantage of your existing SQL Server skills and learn about the service and consumption models, security configurations, common management tasks, high availability and disaster recovery, and performance monitoring of Azure SQL Database.

(more…)

March 31, 2023

Learning Path – Databricks SQL

By  Other Tutorials  0 Comments

Free Download Learning Path – Databricks SQL
Last updated 3/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + vtt | Duration: 7h 56m | Size: 950 MB
In this path you will learn structure and architecture of Databricks SQL, performing administrative tasks, extracting insights from data, running queries and visualizing data, monitoring and optimizing queries and connecting to SQL Server.

(more…)

March 30, 2023

Learning Path – Querying Data with SQL from PostgreSQL

By  Other Tutorials  0 Comments

Free Download Learning Path – Querying Data with SQL from PostgreSQL
Last updated 3/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + vtt | Duration: 9h | Size: 1.2 GB
SQL (“sequel” or Structured Query Language) is a common language used to query and manage data in relational database and data stream management systems. This skill will teach you how to use SQL to query data from the PostgreSQL relational database.

(more…)