11

SQL Commands – Part 1

Databricks SQL supports ANSI SQL and all standard SQL commands are available and applicable. It also exposes additional commands for Lakehouse-specific capabilities. In this chapter, we will focus on these Lakehouse-specific SQL commands and learn their practical usage with scenario-based examples. We will start by exploring the commands for the data definition language (DDL). Then, we will explore commands for the data manipulation language. Finally, we will learn about functions that handle semi-structured data and unlock advanced data manipulation.

In this chapter, we will cover the following topics:

  • Working with data definition language commands
  • Working with data manipulation language commands
  • Working with the built-in ...

Get Business Intelligence with Databricks SQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.