Advanced Sql Interview Questions that covers topics like CTE, Analytics Window Functions, Aggregation Functions, Subqueries these topics will help you to boost your interview questions

The aim of this analysis was to extract valuable insights and answer a variety of question related to movie, genre, most successful actor etc. This project demonstrates my proficiency in Data Analysis, SQL Querying using advance functions like CTE, Joins, CASE, Pivot.

Solution for SQL SQL Zoo Beginner to Advanced Level challenges

Mini SprintBoot RestApi - PLpgSQL project

These are advance SQL codes I learnt from my mentor @luke Barousse

Catching culprit who stole the DATA in an org

Performing analysis using SQL to find answers to the questions provided

Revisiting SQL skills, enhancing with CTEs, functions, and window functions. Analyzing IMDB and Magist databases, expanding with web-scraped data.

The Czechoslovakia bank analysis is done by using SQL queries. Data extraction and Data cleaning are done by using SQL. The main concepts used in analysis are Joins, CTEs, Window functions (Rank, Dense Rank, Row Number)