Working with a real world data-set using SQL (SQLite) and Python

Built a data pipeline by creating tables in MySQL DB, ingested tables to Hadoop for data warehousing and built HiveQL views. Hive views in Linux VM were connected to Power BI application in Windows to create visualizations.

SQL Queries from CareerFoundry's Project. Designed to utilize multiple joins, CTE's, subqueries, and other SQL tools.

Analysis of Covid-19 related deaths and vaccinations using SQL

College assignments from Bryan University over creating relational databases (e.g. using MySQL or PostgreSQL) in connection with Express servers using both direct SQL statements and Object Relational Mapping approaches.

Retail_superstore_data_analysis using SQL

Data Analysis project to analyze modern Olympic Games, including all the Games from Athens 1896 to Rio 2016 which helps to ask questions about how the Olympics have evolved over time, including questions about the participation and performance of women, different nations, and different sports and events.

Database Management Systems and Application Lab work done during III Semester

A data science project that analyzes real world datasets relating to crime, census and publics schools in Chicago

E-commerce dataset, SQL query extraction using Big Query

Provide answers to business requirements using SQL

SQL

Data Exploration and analysis using MySQL

DVD_Rental

data-modeling-analysis-sql

Target SQL query extraction using Google Big Query

Repository with files that I worked upon during the DBS311 (Advanced Database Services) course.

Explores an E-Commerce dataset and generate various analytics and insights from customers' past purchase behavior.

classicmodels DB queries. From easy to advanced