Tutorials

November 16, 2024
PySpark architecture cheat sheet- How to Know Which parts of your PySpark ETL script are executed on the driver, master (YARN), or executors
Team AHT
November 7, 2024
Quick Spark SQL reference- Spark SQL cheatsheet for Revising in One Go
Team AHT
November 7, 2024
Functions in Spark SQL- Cheatsheets, Complex Examples
Team AHT
November 6, 2024
CRUD in SQL – Create Database, Create Table, Insert, Select, Update, Alter table, Delete
Team AHT
November 2, 2024
Pyspark, Spark SQL and Python Pandas- Collection of Various Useful cheatsheets, cheatcodes for revising
Team AHT
November 1, 2024
Types of SQL /Spark SQL commands- DDL,DML,DCL,TCL,DQL
Team AHT
October 27, 2024
Python Pandas Series Tutorial- Usecases, Cheatcode Sheet to revise
Team AHT
October 24, 2024
Pandas operations, functions, and use cases ranging from basic operations like filtering, merging, and sorting, to more advanced topics like handling missing data, error handling
Team AHT
October 22, 2024
PySpark Projects:- Scenario Based Complex ETL projects Part3
Team AHT
October 22, 2024
PySpark Projects:- Scenario Based Complex ETL projects Part2
Team AHT
October 21, 2024
PySpark Control Statements- Conditional Statements, Loop, Exception Handling
Team AHT
October 20, 2024
TroubleShoot Pyspark Issues- Error Handling in Pyspark, Debugging and custom Log table, status table generation in Pyspark
Team AHT
October 11, 2024
Pyspark Memory Management, Partition & Join Strategy – Scenario Based Questions
Team AHT
October 11, 2024
CPU Cores, executors, executor memory in pyspark- Explain Memory Management in Pyspark
Team AHT
October 2, 2024
Partitioning a Table in SQL , Hive QL, Spark SQL
Team AHT
October 2, 2024
Pivot & unpivot in Spark SQL – How to translate SAS Proc Transpose to Spark SQL
Team AHT
September 6, 2024
Oracle Query Execution phases- How query flows?
Team AHT
August 29, 2024
Pyspark -Introduction, Components, Compared With Hadoop, PySpark Architecture- (Driver- Executor)
Team AHT
August 26, 2024
Deploying a PySpark job- Explain Various Methods and Processes Involved
Team AHT
August 26, 2024
What is Hive?
Team AHT