23 results for “topic:sql-joins”
An ode to how Oracle SQL got me interested in the world of DBMS.
🚀 Comprehensive Rust systems programming portfolio featuring 10 high-performance projects: Redis-compatible database, web framework, Kafka message queue, P2P file sharing, search engine, compiler/interpreter, Docker container runtime, Git VCS, TensorFlow ML library & graph database with SQL joins
Step-by-step SQL tutorials and practical examples covering queries, constraints, transactions, and more. Ideal for beginners, interview prep, and anyone looking to master SQL—from basics to advanced.
In this project I queried Chinook database by extracting, aggregating, and analyzing data. By competing my analysis, I was able to make suggestions on business optimization practices.
End-to-end SQL case study analyzing e-commerce sales data using joins, subqueries, procedures, triggers, and performance optimization
mariadbanalyst :woman_mechanic::seal::oil_drum: : MariaDB # SQL # JOIN # Relational Database
This project is done as part of Codebasics Data Analyst Bootcamp
🧠 Structured SQL Learning Repository | Beginner to Advanced Topics + Real Projects 🎯 Covers core SQL skills, window functions, performance tuning, and hands-on data warehousing/EDA projects
Repository for managing SQL queries using concepts of Joins, Procedures and Triggers
Collection of basic‑level SQL projects from DataCamp’s Real‑World Projects, applying query logic, filtering, joins, and aggregation to explore real‑world datasets and practice SQL fundamentals.
This project highlights my SQL problem solving skills on advanced concepts like views, stored procedure, ACID transaction and Joins.
This repository highlights the use of various SQL window functions on the imaginary data of the well known SG-Entreprise URWIBUTSO inc./ Rwanda. It is a part of the scholar assignment and it is dedicated for educational purposes only.
The Chinook database is a relational database that models a digital music store. It stores information about artists, albums, tracks, media types, genres, customers, employees, invoices, and playlists. The schema supports realistic business operations such as music purchases, customer billing, playlist creation, and employee support management.
This repository focuses on the database design concepts for the backend of the Airbnb Booking Management System
This repository contains structured SQL notes, practice queries, and interview questions. Covers DDL, DML, Joins, Subqueries, Constraints, Views, and more. Ideal for beginners, students, and developers to learn, practice, and revise SQL with real-world examples and sample database schemas.
An employee database where I applied multiple SQL queries during my learning phase. It is a detailed learning project which includes applications of fundamental DDL and DML queries.
SQL project analyzing MLB schools, salaries, careers, and comparisons. Explores top schools, team spending, player career spans, team loyalty, batting hand trends, and decade-by-decade height/weight changes using advanced queries and analytics.
A simple test of concept for both MySQL and PostgreSQL
SQL Data Exploration
In this course, you will learn what Structured Query Language (SQL) and databases are, the basics of database management, how to set up and configure MySQL, and how to get MySQL client to connect to a MySQL Server.
Explore a diverse collection of MS SQL projects showcasing advanced query writing, data manipulation, and complex querying techniques, all solving real-world challenges. Demonstrates expertise in hierarchical queries, window functions, joins, and more.
This is a Simple project to practice email verification and Authentication. I used SQL Joins and Transactions to improve our code.
No description provided.