Spark SQL

#Databricks #SQL for Data Engineering ,Data Science and Machine Learning.

✅ The whole SQL lesson for DataBricks is provided here.

1️⃣ spark sql sessions as series.
https://lnkd.in/g77DE36a

2️⃣ How to register databricks community edition
https://lnkd.in/ggAqRgKJ

3️⃣ What is DataWarehouse? OLTP and OLAP?
https://lnkd.in/gzSuJCBC

4️⃣ how to create database in databricks?
https://lnkd.in/gzHNFZrv

5️⃣ databricks file system dbfs.
https://lnkd.in/dHAHkqd3

6️⃣ Spark SQL Table , Difference between Managed table and External table
https://lnkd.in/gYr_vu-k

7️⃣ Spark SQL Views, Different types of views, Temporary views
https://lnkd.in/gE27YG2W

8️⃣ Spark SQL Constraints NOT NULL and CHECK Constraints
https://lnkd.in/g7WcF8FH

9️⃣ Spark SQL DML Operations INSERT Statement
https://lnkd.in/gSXi9Y7K

🔟 Difference Between Truncate and Delete
https://lnkd.in/gY-YC_X6

1️⃣1️⃣ Spark SQL Delta Delete Operations and delete and restore
https://lnkd.in/g4kbKv7y

1️⃣2️⃣ Spark SQL Delta Update Operations
https://lnkd.in/gdEgZGgu

1️⃣3️⃣ Spark SQL Delta Restore Operations
https://lnkd.in/g8zfTxUf

1️⃣4️⃣ What is slowly changing dimension
https://lnkd.in/g7e9jqat

1️⃣5️⃣ What is SCD Type 0 and SCD Type 1
https://lnkd.in/g7H4kKH7

1️⃣6️⃣ What is slowly changing dimension Type 2 and Type 3
https://lnkd.in/gH3WncZx

1️⃣7️⃣ SQL Select Statement column alias and table alias
https://lnkd.in/gJsWMaeH

1️⃣8️⃣ SQL Order By and Sort By Clauses
https://lnkd.in/gGe2EBpT

1️⃣9️⃣ SQL Join Types inner join full join semi
https://lnkd.in/g3xeJhRy

2️⃣0️⃣ SQL Set Operators
https://lnkd.in/g4cWQZjz

2️⃣1️⃣ spark SQL group by clause and having clause
https://lnkd.in/drdAwD7d

2️⃣2️⃣Advanced Group By Grouping Sets Cube Rollup
https://lnkd.in/d27_Mh_7

2️⃣3️⃣Spark Sql window ranking functions
https://lnkd.in/dq_JGnTk

2️⃣4️⃣ Spark Sql window aggregate functions
https://lnkd.in/deMv-Fwy

📕 Learn , Lead and Make Leaders 🚀. Happy Learning 📖