This library implements an efficient join function to join 2 (usually large) incrementally refreshed tables, taking into account the refresh timestamp of each table and the fact that data might arrive late.

In this course I learned how to use table joins and relational set theory on joining data. I have also learned how to work with more than one table in SQL, use inner joins, outer joins, and cross joins, leverage set theory, including unions, intersect, and except clauses, and create nested queries.

Learn about joining data table with R

A project using PostGreSQL to perform various kinds of query-based analyses. Tableau visualizations are also available.

Business questions were solved for Rockbuster Stealth LLC, a fictional movie rental company, through the use of SQL in this project. This project was completed as part of the CareerFoundry's curriculum.

Day 5 of Phase 2: AI System Building from the Databricks 14 Days AI Challenge – 2 (Advanced). Built a Binary Purchase Label, Joined it with Engineered Silver Features, Created a Supervised Training Dataset, Performed Reproducible Train/Test Split, and Validated Class Distribution for Model Readiness.

Analyzing TV data using Python

A comprehensive collection of SQL exercises and solutions focused on mastering data analysis using real-world datasets.