Monitoring and Optimizing Queries in Databricks SQL

سرفصل های دوره

This course will teach you to monitor query executions in Databricks SQL, and also regulate access to query objects. You will learn how to optimize query executions with caches, encrypt queries, and configure alerts based on query results.

1. Course Overview

1. Course Overview

02. Monitoring and Administering Queries

01. Course Prerequisites and Outline

02. An Overview of Databricks SQL

03. The Need to Monitor Queries

04. Demo - Setting up a Databricks Workspace

05. Demo - Adding a User to a Databricks Workspace

06. Demo - Creating Databricks SQL Queries

07. Demo - Granting Access to SQL Queries

08. Demo - Granting Access to Databases

09. Demo - Regulating Access to Tables

10. Demo - Tracking Query Executions

11. Demo - Monitoring SQL Endpoint Usage

03. Optimizing Query Executions

01. Delta Lakes

02. Optimizing Delta Tables

03. Demo - Viewing Details of Delta Tables

04. Demo - Restoring a Delta Table

05. Query Caching in Databricks

06. Demo - Delta Cache Accelerated Nodes

07. Demo - Using Delta Caches

08. Demo - Querying Data from a Delta Cache

09. Demo - Creating a Spark Cache

10. Demo - Testing the Effects of Spark Caching

4. Creating and Configuring Query Alerts

1. Encrypting Queries

2. Demo - Configuring a Key Vault for a Databricks Workspace

3. Demo - Linking a Custom Encryption Key with Databricks

4. Query Alerts

5. Demo - Setting a Query to Run on a Schedule

6. Demo - Defining a Query Alert

7. Demo - Testing an Alert

8. Course Summary and Related Content

“Python Network Programming for Network Engineers (Python 3)” به سبد خرید شما اضافه شد. مشاهده سبد خرید

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight