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 functions in Databricks SQL
Note
This chapter is not intended as a complete SQL command reference. We will cover the practical usage of SQL commands that are specific to Databricks SQL and Lakehouse. The rest...
