Learn R and Tidyverse for reproducible data analysis. Intro to data wrangling, intro to visualization with ggplot2,

Conteúdo sobre Join em SQL, com explicação, exemplos e exercícios em MySQL

This project involved converting an Excel spreadsheet system for a hotel to a relational database. The database was designed to satisfy 3NF using the data provided. An ERD diagram was created to represent the database as well as the script to create and populate the tables and SQL queries.

CodeIgniter 4 with methods using Mysql Joins

Basics-of-R Tutorial 3

My solutions to leetcode SQL Study Plan.

R3 - Joins and Appling Functions in R

This project contains sample SQL commands that create different tables and insert values into them. It also includes various join queries, including INNER JOIN and LEFT OUTER JOIN, to get the results from multiple tables.

"IPL Match Bidding App - Pie-in-the-Sky" is a SQL tool decoding IPL match data. It analyzes bidder success, popular stadiums, and toss impact. Tailored for IPL decision-makers, it simplifies complex data for strategic insights in just a few clicks.

This project demonstrates end-to-end data analysis of an online bookstore using SQL. It covers data modeling, importing CSV files into PostgreSQL, and writing queries for business intelligence insights. The project showcases skills in SQL querying, joins, aggregation, window functions, and real-world data problem-solving.

Examples of SQL join techniques applied in real-world analytics projects, including inner join, left join, right join, full join, and self join.

Hotel revenue of course of 3 years

SQL Bolt Exercise

It contains Database-MySQL-Day 3-Task-Queries Exercises

This repo is abandoned. See new code and website with link below....

Querying a baseball database to find some of the most notable achievements throughout baseball history

PostgreSQL database with create script, insert script, queries, and description 📑

Join datasets on store database to obtain particular information