Databases, Tables, and Views on Databricks

Summary

Learn the basics for creating and managing databases, tables, and views with Databricks.

Description

In this short course, you’ll learn how to create databases, tables, and views on Databricks. Special attention will be given to differences in scope and persistence for these various entities, allowing any user responsible for creating or managing databases, tables, or views to make informed decisions for their organization. While the syntax for creating and working with databases, tables, and views will be familiar to most SQL users, some default behaviors may surprise users new to Databricks.

Learning objectives

  • Describe persistence and scope of databases, tables, and views on Databricks.

  • Compare and contrast the behavior of managed and unmanaged tables.

  • Summarize best practices for creating and managing databases, tables, and views on Databricks.

Prerequisites

  • Beginning knowledge of SQL

  • Beginning knowledge of loading and interacting with sample data from Databricks.

  • Beginning knowledge of using Databricks notebooks

Learning path

  • This course is part of the Data Analyst, Data Scientist, and Data Engineer learning paths.

Proof of completion

  • Upon 80% completion of this course, you will receive a proof of completion.