Somasekhar KSQL Fundamental Syntax/Commands |BASIC SQL SYNTAX |Use of Semicolon |SQL Order of ExecutionThe semicolon is the standard way to separate each SQL statement in database systems that allow more than one SQL statement to be executed…Oct 26, 2021Oct 26, 2021
Somasekhar K1.Problem: Write a SQL query to find employees who have the highest salary in each of the…Do suggest any if there is better way to solve this problem without window functionOct 26, 2021Oct 26, 2021
Somasekhar KSQL Joins, Group By,Order byIntro to relational Databases (Entity Relationship Diagrams(ERD)Oct 26, 2021Oct 26, 2021
Somasekhar KHow the data stored in spark?->The basic unit which holds the data in spark is called RDD -> Resilient Distributed Dataset — in simpler terms, in-memory distributed…Oct 26, 2021Oct 26, 2021
Somasekhar KSlowly Changing Dimensions (SCD) — Types | Data WarehouseSlowly Changing Dimensions: Slowly changing dimensions are the dimensions in which the data changes slowly, rather than changing regularly…Oct 26, 2021Oct 26, 2021
Somasekhar KPyspark installation on Windows and Machttps://www.datacamp.com/community/tutorials/installation-of-pysparkSep 29, 2021Sep 29, 2021
Somasekhar KSpark install on window and Machttps://www.datacamp.com/community/tutorials/installation-of-pysparkSep 29, 2021Sep 29, 2021