Advanced SQL
-
Updated
May 4, 2023
Advanced SQL
Get ready to boost your SQL proficiency, solve intriguing data problems, and earn a sense of accomplishment as you complete this 8-week journey. Whether you're a data analyst, a database administrator, or simply passionate about data, the '8 Weeks of SQL Challenge' will help you level up your SQL skills and open up new opportunities.
Instagram User Analytics
Advanced SQL
This repository is designed to document and explain in-detailed analysis of data, from concepts like mining or transforming to predictive analytics.
This is an Oracle DB Data Warehouse and ETL implementation on specially formatted Water Quality dataset from DEFRA, UK
Create views, simple and complex SQL queries to answer questions from the fictitious ForestQuery management about the deforestation’s global situation, regional outlook, and country-level details
SQL repository contains my answers to queries and challenges posed by numerous websites.
[SQL, Django & Heroku] Deployed a Heroku app that visualizes Maritime Energy Efficiency statistics.
Conducted data analysis for RSVP Movies, an Indian film production company, to inform their global release strategy. Analyzed data from movies released in the past three years to draw meaningful insights and help the company plan their next project.
Create a 3NF DB and manipulate data programmatically.
The goal of the project is to build a cohort transition analysis of a user base by month. On a high level, this analysis should show how users' engagement develops over time and how users come into and fall out of the platform again. A cohort by definition is a certain status that's affixed to both a user and a concrete month, depending on user
The projects are part of the graduate-level course CSE-560 : Data Models and Query Language [Fall 2019 @ UB_SUNY] ... Course Instructor : Jan Chomicki (https://cse.buffalo.edu/~chomicki/)
Problem Introduction RSVP Movies is an Indian film production company which has produced many super-hit movies. They have usually released movies for the Indian audience but for their next project, they are planning to release a movie for the global audience in 2022.
Independent Project - I joined and manipulated data from disparate tables of movie information using Python & SQLite; defined schema, created tables/views, queried data, etc. Utilized CTE's, Window Functions, and other DDL, DQL, DML, and DCL scripts.
Khan Academy is an American non-profit educational organization. This is a directory of links to coursework includes: SQL Basic, More Advanced SQL Queries, Relational Queries in SQL, Modifying Databases with SQL.
This is an MSSQL Data Warehouse and ETL implementation on specially formatted Water Quality dataset from DEFRA, UK
Add a description, image, and links to the advanced-sql topic page so that developers can more easily learn about it.
To associate your repository with the advanced-sql topic, visit your repo's landing page and select "manage topics."