Learn SQL with Databricks

Instructor: Edureka

Access provided by Taipei Medical University [TMU]

2,841 already enrolled

5 modules

Gain insight into a topic and learn the fundamentals.

3.5

(15 reviews)

Beginner level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

5 modules

Gain insight into a topic and learn the fundamentals.

3.5

(15 reviews)

Beginner level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Set up Databricks environments across AWS, Azure, and GCP.
Master SQL basics including SELECT, WHERE, GROUP BY, and aggregation.
Write advanced SQL queries with joins, subqueries, and transactions.
Optimize queries with indexes, views, and stored procedures.

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

20 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 5 modules in this course

This course will teach you how to use SQL, one of the most important tools in data analysis, along with Databricks, a popular platform used by data teams worldwide. Whether you're new to SQL or want to improve your skills, this course will guide you step by step.

You'll learn how to manage, analyze, and work with data using real-world examples all in a cloud-based environment that’s used by top companies. By the end of this course, you’ll be able to: - Grasp Databricks' features, architecture, and its role in data science and engineering. - Master SQL basics, querying data, and managing databases within Databricks. - Configure Databricks, optimize SQL processing, and utilize notebooks efficiently. - Learn loading, managing, preparing data, and sharing using Delta Sharing. - Explore joins, subqueries, aggregation, and optimization (indexing, views, procedures). - Apply SQL in Databricks through case studies, emphasizing efficient queries, maintenance, and data security. This course is tailored for individuals seeking to learn SQL with Databricks, providing comprehensive instruction and hands-on experience to master the essential skills for efficient data manipulation, analysis, and management within the Databricks environment. Basic understanding of databases & SQL, familiarity with data concepts, some programming knowledge are recommended for learning SQL with Databricks. Empower your data journey, unleash seamless manipulation, and elevate insights for data-driven success!

Explore Databricks' features, understand its role in data science and engineering, and learn SQL basics, emphasizing its importance in data analysis.

What's included

29 videos10 readings5 assignments4 discussion prompts1 plugin

29 videosTotal 136 minutes

Course Introductory3 minutes
Grasping the Databricks Platform5 minutes
Exploring Databricks Features and Benefits4 minutes
Data Science and Data Engineering with Databricks5 minutes
Introduction to SQL: Purpose and Applications7 minutes
Basics of Querying Data with SQL5 minutes
Importance of SQL in Data Analysis4 minutes
Creating a Databricks Account5 minutes
Creating a Databricks Account - Demo2 minutes
Navigating the Databricks Workspace - Part I4 minutes
Navigating the Databricks Workspace - Part II4 minutes
Configuring Clusters for SQL Processing4 minutes
Using Notebooks for Coding5 minutes
Databricks Architecture, Concepts and Functionalities - Part I6 minutes
Databricks Architecture, Concepts and Functionalities - Part II4 minutes
Loading and Managing Data in Databricks6 minutes
Exploring Data in Databricks Environment - Part I4 minutes
Exploring Data in Databricks Environment - Part II5 minutes
Data Preparation Techniques Using Databricks3 minutes
Monitoring Data and AI Assets in Databricks6 minutes
Sharing Data Using Delta Sharing in Databricks3 minutes
Exploring Databricks Marketplace2 minutes
Grasping Data Engineering in Databricks - Part I4 minutes
Grasping Data Engineering in Databricks - Part II4 minutes
Using Generative AI and LLMs on Databricks5 minutes
Introduction to Machine Learning with Databricks7 minutes
Data Warehousing Strategies with Databricks3 minutes
Proficiency in Delta Lake and Developer Tools4 minutes
Databricks Technology Partners Showcase3 minutes

10 readingsTotal 94 minutes

Query Cheat sheet10 minutes
Course Overview4 minutes
Databricks on Amazon Web Services (AWS)10 minutes
Databricks on Google Cloud Platform (GCP)10 minutes
Databricks on Azure Cloud Platform10 minutes
Apache Spark on Databricks10 minutes
Building Efficient Data Pipelines in Databricks10 minutes
Introduction to Databricks Repositories10 minutes
Ethical Considerations in Data Science and AI10 minutes
Module Synopsis: Introduction to SQL and Databricks10 minutes

5 assignmentsTotal 80 minutes

Module Wrap-Up Assessment: Introduction to SQL and Databricks40 minutes
Knowledge Check: Introduction to Databricks and SQL10 minutes
Knowledge Check: Setting Up Databricks Environment 10 minutes
Knowledge Check: Databricks Essentials and Data Loading10 minutes
Knowledge Check: Databricks Lakehouse Platform Overview10 minutes

4 discussion promptsTotal 40 minutes

Share your initial impressions of the Databricks platform. What features seem most useful?10 minutes
Describe your experience in setting up your Databricks account and environment. What challenges did you face?10 minutes
Share your strategies for efficient data loading and management in Databricks.10 minutes
How does the Databricks Lakehouse architecture innovate data warehousing and engineering?10 minutes

1 pluginTotal 10 minutes

Your SQL with Databricks Readiness Check10 minutes

Delve into SQL essentials: data types, database creation, data retrieval with SELECT, and data filtering using WHERE and GROUP BY clauses.

What's included

17 videos3 readings5 assignments4 discussion prompts

17 videosTotal 75 minutes

Exploring SQL Data Types5 minutes
Creating Databases in Databricks - Part I7 minutes
Creating Databases in Databricks - Part II1 minute
Creating Tables with Specific Data Types 5 minutes
Creating Tables with Specific Data Types - Demo4 minutes
Managing Database Schemas4 minutes
Basics of the SELECT Statement - Part I4 minutes
Basics of the SELECT Statement - Part II4 minutes
Filtering Data with WHERE Clause4 minutes
Sorting Results with ORDER BY4 minutes
Limiting Query Results with LIMIT3 minutes
Conditional Operators in WHERE Clause 4 minutes
Using Comparison Operators for Filtering3 minutes
Applying Multiple Conditions in WHERE Clause4 minutes
Filtering with NULL and IS NULL Conditions3 minutes
Introduction to GROUP BY for Data Aggregation4 minutes
Using Aggregate Functions4 minutes

3 readingsTotal 25 minutes

Performing Aggregation on Grouped Data10 minutes
Using GROUP BY with HAVING Clause for Filtering Grouped Data10 minutes
Module Synopsis: SQL Fundamentals 5 minutes

5 assignmentsTotal 80 minutes

Module Wrap-Up Assessment: SQL Fundamentals40 minutes
Knowledge Check: Data Types and Databases10 minutes
Knowledge Check: Retrieving Data with SELECT Statement 10 minutes
Knowledge Check: Filtering Data with WHERE Clause10 minutes
Knowledge Check: Aggregating Data with GROUP BY and Aggregate Functions10 minutes

4 discussion promptsTotal 40 minutes

Share your experience in creating and managing databases and tables in Databricks.10 minutes
Discuss the versatility of the SELECT statement in data retrieval. Share an example.10 minutes
Discuss the importance of precision in using the WHERE clause for data analysis.10 minutes
How does data aggregation using GROUP BY contribute to data analysis?10 minutes

Advance to complex SQL queries, covering joins, subqueries, and data modification techniques, alongside transaction management and rollback operations.

What's included

11 videos2 readings4 assignments

11 videosTotal 48 minutes

Exploring Different Types of Joins5 minutes
Relationships between Tables 4 minutes
Joining Tables using Multiple Columns5 minutes
Using Aliases in Joins for Better Readability3 minutes
Subqueries for Filtering and Data Retrieval3 minutes
Creating Nested Queries for Complex Analysis4 minutes
Using Subqueries in WHERE and SELECT Clauses2 minutes
Optimizing Queries with Subqueries5 minutes
Inserting Data into Tables using INSERT Statement4 minutes
Deleting Data with DELETE Statement4 minutes
Managing Transactions and Rollback Operations4 minutes

2 readingsTotal 20 minutes

Updating Existing Data with UPDATE Statement10 minutes
Module Synopsis: Advanced SQL Queries10 minutes

4 assignmentsTotal 70 minutes

Module Wrap-Up Assessment: Advanced SQL Queries40 minutes
Knowledge Check: Joins and Relationships10 minutes
Knowledge Check: Subqueries and Nested Queries10 minutes
Knowledge Check: Data Modification with INSERT, UPDATE, DELETE10 minutes

Focus on advanced data manipulation, including altering data structures, optimizing queries with indexes, and utilizing views and stored procedures, supplemented with real-world case studies.

What's included

14 videos5 readings5 assignments

14 videosTotal 43 minutes

Modifying Table Structures with ALTER TABLE1 minute
Dropping Tables and Databases using DROP1 minute
Renaming Columns and Tables with ALTER4 minutes
Managing Constraints using ALTER TABLE2 minutes
Exploring Indexes and their Types2 minutes
Creating and Managing Indexes for Faster Queries4 minutes
Optimizing Queries using Indexes3 minutes
Creating and Using Views in SQL2 minutes
Advantages of using Views and Stored Procedures3 minutes
Modifying and Dropping Views2 minutes
Real-world Case Studies of SQL Applications in Databricks3 minutes
Database Maintenance and Optimization Strategies - Part I2 minutes
Database Maintenance and Optimization Strategies - Part II2 minutes
Data Security Best Practices in Databricks SQL Databases5 minutes

5 readingsTotal 50 minutes

Best Practices for Index Implementation10 minutes
Implementing Stored Procedures for Repetitive Tasks10 minutes
Best Practices for Writing Efficient SQL Queries10 minutes
Introduction to Data Governance Best Practices10 minutes
Module Synopsis: Data Manipulation and Optimization10 minutes

5 assignmentsTotal 60 minutes

Module Wrap-Up Assessment: Data Manipulation and Optimization20 minutes
Knowledge Check: Modifying Data with ALTER and DROP10 minutes
Knowledge Check: Indexes and Optimization10 minutes
Knowledge Check: Views and Stored Procedures10 minutes
Knowledge Check: Case Studies and Best Practices10 minutes

Conclude the course with a comprehensive assessment, testing knowledge across all modules, from SQL basics to advanced data manipulation and optimization in Databricks, ensuring a solid understanding and practical application of the learned concepts.