SQL

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 1, 2024
Types of SQL /Spark SQL commands- DDL,DML,DCL,TCL,DQL
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 2, 2024
Mysql or Pyspark SQL query- The placement of subqueries
Team AHT
June 26, 2024
Spark SQL Join Types- Syntax examples, Comparision
Team AHT
June 26, 2024
Temporary Functions in PL/Sql Vs Spark Sql
Team AHT
June 26, 2024
Spark SQL windows Function and Best Usecases
Team AHT
June 6, 2024
Window functions in Oracle Pl/Sql and Hive explained and compared with examples
Team AHT
June 6, 2024
Common Table Expressions (CTEs) in Oracle Pl/Sql / Hive / Spark SQL explained and Compared
Team AHT
June 5, 2024
String/Character Manipulation functions in Oracle PL/SQL, Apache Hive
Team AHT
June 2, 2024
Date and Time manipulation in Oracle SQL, Apache Hive QL, Mysql
Team AHT
April 15, 2024
Database Structures,managing Databases, Schemas, Tablespaces
Team AHT
April 15, 2024
SQL Data Types(Numeric, String & Date)- Default Values- PL/SQL, Hive
Team AHT
April 15, 2024
What is SQL, Data Database, DBMS , RDBMS, SQL Commands Categories
Team AHT
April 8, 2024
Indexing in SQL- Explain with examples
Team AHT
April 7, 2024
Pattern matching in SQL- Like Operator
Team AHT