Synapse Book review 2 min.

// Business Intelligence With Databricks SQL

Business Intelligence With Databricks SQL

Do you want to learn Databricks and do you want to read only one book about it? Then you should read the book by Vihag Gupta (Li/Tw) - Business Intelligence with Databricks SQL.

The writer

Vihag Gupta is Solutions Architect in Data & AI at the Databricks company. He shows a great knowledge in the book around Databricks and the way of working with SQL in the services. With a good match of text, downloadable demos and easy to understand illustrations, Vihag Gupta makes it an easy read.

The content

You’ll find a packed book with a huge amount of new stuff and learning. The book’s content:

  1. Introduction to Databricks
  2. The Databricks Product Suite - A Visual Tour
  3. The Data Catalog
  4. The Security Model
  5. The Workbench
  6. The SQL Warehouses
  7. Using Busines Intelligence Tools with Databricks SQL
  8. The Delta Lake
  9. The Photon Engine
  10. Warehouse on the Lakehouse
  11. SQL Commands
  12. Playing with the TPC-DS Dataset

The book covers the entire environment around Databricks - from a brief introduction to the application and an overview of the Data Lakehouse approach to a data platform; through the internals of the engine; to a very geeky deepdive into the SQL commands and the TPC-DS (Transaction Processing Perfromance Council Decision Support) - read more of the subject here.

I’ve read all around 300 pages - and I found it to be a great source for learning and is also usable as a book to have to look up specific topics around Databricks.

Why read the book

You need to read the book because:

  1. You want to learn Databricks
  2. You are working with data and are looking for the next step for yourself
  3. You already have basic knowledge of the sphere of data, SQL and ETL
  4. You want a book to read once and then have as a lookup tool when you need it

Where to get the book

The book is released by Packt and can be found on Amazon right here:

Happy reading ☕