Vendors

In this course, you'll learn how to effectively use Databricks for data analytics, with a specific focus on Databricks SQL. As a Databricks Data Analyst, your responsibilities will include finding relevant data, analyzing it for potential applications, and transforming it into formats that provide valuable business insights. 

You will also understand your role in managing data objects and how to manipulate them within the Databricks Data Intelligence Platform, using tools such as Notebooks, the SQL Editor, and Databricks SQL. 

Additionally, you will learn about the importance of Unity Catalog in managing data assets and the overall platform. Finally, the course will provide an overview of how Databricks facilitates performance optimization and teach you how to access Query Insights to understand the processes occurring behind the scenes when executing SQL analytics on Databricks.

img-course-overview.jpg

What You'll Learn

  • Data Discovery
  • Data Importing
  • SQL Execution
  • Query Analysis

Who Should Attend

• N/A
img-who-should-learn.png

Prerequisites

  • A working knowledge of using SQL for data analysis purposes. 
  • Be familiar with how data is created, stored, and managed. 
  • A basic understanding of statistical analysis.
  • Understand the structure and defining characteristics of specific data formats such as CSV, JSON, TXT, and Parquet.
  • Be familiar with the user interface of the Databricks Data Intelligence Platform.

Learning Journey

Coming Soon...

Data Discovery

  • Using Unity Catalog as a Data Discovery Tool
  • Understanding Data Object Ownership
  • Lab: Use Unity Catalog to Locate and Inspect Datasets

Data Importing

  • Ingesting Data into Databricks
  • Demo: Uploading Data to Databricks Using the UI
  • Demo: Programmatic Exploration and Data Ingestion to Unity Catalog
  • Lab: Import Data into Databricks

SQL Execution

  • Databricks SQL and Databricks SQL Warehouses
  • Demo: The Unified SQL Editor
  • Demo: Manipulate and Transform Data with Databricks SQL
  • Demo: Creating Views with Databricks SQL
  • Lab: Manipulate and Analyze a Table

Query Analysis

  • Databricks Photon and Optimization in Databricks
  • Demo: Query Insights
  • Best Practices for SQL Analytics

img-exam-cert

Frequently Asked Questions (FAQs)

None

Keep Exploring

Course Curriculum

Course Curriculum

Training Schedule

Training Schedule

Exam & Certification

Exam & Certification

FAQs

Frequently Asked Questions

img-improve-career.jpg

Improve yourself and your career by taking this course.

img-get-info.jpg

Ready to Take Your Business from Great to Awesome?

Level-up by partnering with Trainocate. Get in touch today.

Name
Email
Phone
I'm inquiring for
Inquiry Details

By submitting this form, you consent to Trainocate processing your data to respond to your inquiry and provide you with relevant information about our training programs, including occasional emails with the latest news, exclusive events, and special offers.

You can unsubscribe from our marketing emails at any time. Our data handling practices are in accordance with our Privacy Policy.