Learn SQL with Databricks

位教师：Edureka

访问权限由 New York State Department of Labor 提供

3,664 人已注册

5个模块

深入了解一个主题并学习基础知识。

19 条评论

初级等级

推荐体验

2 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

5个模块

深入了解一个主题并学习基础知识。

19 条评论

初级等级

推荐体验

2 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

您将学到什么

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.

您将获得的技能

您将学习的工具

Apache Spark

要了解的详细信息

可分享的证书

添加到您的领英档案

作业

20 项作业

授课语言：英语（English）

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

该课程共有5个模块

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.

涵盖的内容

29个视频10篇阅读材料5个作业4个讨论话题

29个视频总计137分钟

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

10篇阅读材料总计94分钟

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

5个作业总计80分钟

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

4个讨论话题总计40分钟

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

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

涵盖的内容

17个视频3篇阅读材料5个作业4个讨论话题

17个视频总计75分钟

Exploring SQL Data Types5分钟
Creating Databases in Databricks - Part I7分钟
Creating Databases in Databricks - Part II2分钟
Creating Tables with Specific Data Types 6分钟
Creating Tables with Specific Data Types - Demo5分钟
Managing Database Schemas4分钟
Basics of the SELECT Statement - Part I4分钟
Basics of the SELECT Statement - Part II4分钟
Filtering Data with WHERE Clause4分钟
Sorting Results with ORDER BY5分钟
Limiting Query Results with LIMIT4分钟
Conditional Operators in WHERE Clause 4分钟
Using Comparison Operators for Filtering4分钟
Applying Multiple Conditions in WHERE Clause4分钟
Filtering with NULL and IS NULL Conditions3分钟
Introduction to GROUP BY for Data Aggregation4分钟
Using Aggregate Functions4分钟

3篇阅读材料总计25分钟

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

5个作业总计80分钟

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

4个讨论话题总计40分钟

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

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

涵盖的内容

11个视频2篇阅读材料4个作业

11个视频总计49分钟

Exploring Different Types of Joins5分钟
Relationships between Tables 5分钟
Joining Tables using Multiple Columns6分钟
Using Aliases in Joins for Better Readability4分钟
Subqueries for Filtering and Data Retrieval4分钟
Creating Nested Queries for Complex Analysis4分钟
Using Subqueries in WHERE and SELECT Clauses2分钟
Optimizing Queries with Subqueries5分钟
Inserting Data into Tables using INSERT Statement4分钟
Deleting Data with DELETE Statement5分钟
Managing Transactions and Rollback Operations5分钟

2篇阅读材料总计20分钟

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

4个作业总计70分钟

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

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.

涵盖的内容

14个视频5篇阅读材料5个作业

14个视频总计43分钟

Modifying Table Structures with ALTER TABLE2分钟
Dropping Tables and Databases using DROP2分钟
Renaming Columns and Tables with ALTER5分钟
Managing Constraints using ALTER TABLE2分钟
Exploring Indexes and their Types3分钟
Creating and Managing Indexes for Faster Queries4分钟
Optimizing Queries using Indexes3分钟
Creating and Using Views in SQL3分钟
Advantages of using Views and Stored Procedures3分钟
Modifying and Dropping Views2分钟
Real-world Case Studies of SQL Applications in Databricks3分钟
Database Maintenance and Optimization Strategies - Part I2分钟
Database Maintenance and Optimization Strategies - Part II3分钟
Data Security Best Practices in Databricks SQL Databases5分钟

5篇阅读材料总计50分钟

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

5个作业总计60分钟

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

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.