Data Management with Databricks: Big Data with Delta Lakes
About this Course
In this 2-hour guided project, \"Data Management with Databricks: Big Data with Delta Lakes\" you will collaborate with the instructor to achieve the following objectives: 1-Create Delta Tables in Databricks and write data to them. Gain hands-on experience in setting up and managing Delta Tables, a powerful data storage format optimized for performance and reliability. 2-Transform a Delta table using Python and leverage SQL to query the data for creating a comprehensive dashboard. Learn how to apply Python-based transformations to Delta Tables, and use SQL queries to extract the necessary insights for building a Supply Chain dashboard. 3-Utilize Delta Lake\'s merge operation and version control capabilities to efficiently update Delta Tables. Explore the capabilities of Delta Lake\'s merge operation to perform upserts and other data updates efficiently. Additionally, learn how to leverage Delta Lake\'s built-in version control to track and access previous versions of Delta Tables as needed. Throughout a real-world business scenario, you will use Databricks to build an end-to-end data pipeline that integrates various JSON data files and applies transformations, ultimately providing valuable insights and analysis-ready data. This intermediate-level guided project is designed for data engineers who build data pipelines for their companies using Databricks. In order to be successful in this guided project, you need prior knowledge of writing Python scripts including importing libraries, setting-up variables, manipulating data frames, and using functions. You will also need to be familiar with writing SQL queries such as aggregating, filtering, and joining tables.Created by: Coursera Project Network
Related Online Courses
View the Specialization trailer: corporate decisions need cost accounting information. When you know the costs of your products, you will make better pricing decisions and you can better choose... more
This course will provide you with a basic, intuitive and practical introduction into Probability Theory. You will be able to learn how to apply Probability Theory in different scenarios and you... more
By the end of this course you will have a solid grasp of some of the most important hooks in React. We will start by understanding the tricky parts of hooks and spend time digging deeper than other... more
In an era where Artificial Intelligence (AI) is rapidly transforming high-risk domains like healthcare, finance, and criminal justice, the ability to develop AI systems that are not only accurate... more
This course offers an in-depth exploration of advanced framework development and integration for automation testing professionals. Starting with the Pytest framework, you\'ll learn its advantages,... more