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.
您将学到什么
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.
要了解的详细信息

添加到您的领英档案
20 项作业
了解顶级公司的员工如何掌握热门技能

该课程共有5个模块
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个讨论话题1个插件
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个讨论话题
Advance to complex SQL queries, covering joins, subqueries, and data modification techniques, alongside transaction management and rollback operations.
涵盖的内容
11个视频2篇阅读材料4个作业
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个作业
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.
涵盖的内容
1个视频1篇阅读材料1个作业1个插件
从 Software Development 浏览更多内容
- 状态:预览
- 状态:免费试用
University of California, Davis
- 状态:免费试用
University of California, Davis
人们为什么选择 Coursera 来帮助自己实现职业发展




常见问题
Databricks is a cloud-based platform designed for big data analytics and artificial intelligence. It integrates with Apache Spark and provides a unified analytics platform to process large datasets.
While knowledge of Apache Spark can be beneficial, it's not typically required for a SQL-focused course. Databricks abstracts many Spark complexities, allowing users to work with SQL directly.
The course likely covers basic to advanced SQL concepts, including querying data, aggregations, joins, and perhaps specific Databricks SQL extensions or functions.
更多问题
提供助学金,