sql-subqueries

DBMS SQL with MySQL and Oracle Database Express Edition 21c XE213 (SQL Plus)

An ode to how Oracle SQL got me interested in the world of DBMS.

Analyzing CIA Factbook Data Using SQL

Exercises on SQL proposed in the book "SQL Curso Prático" by the author Celso Henrique Poderoso de Oliveira and the publisher NOVATEC

A structured, beginner-to-advanced Oracle SQL learning and revision repository covering SQL concepts, queries, joins, subqueries, database objects, database design, normalization, best practices, and interview preparation.

Two SQL-based data analysis projects, demonstrating skills in querying, aggregating, and transforming structured datasets. Projects include creating complex queries, joining multiple tables, filtering and grouping data, calculating key business metrics, and generating insights for decision-making.

Ejercicios del curso: MySQL Workbench.

Query a Digital Music Store Database, For this project, you will be assisting the Chinook team with understanding the media in their store, their customers and employees, and their invoice information.

JOINS - SUBCONSULTAS - CTEs

DataCamp project (SQL) - When Was the Golden Age of Video Games?

Applied MySQL to solve business problems.

Using advanced SQL queries (e.g., subqueries, window functions) to perform more complex data manipulations and analysis. Ironhack Data Analytics Bootcamp.

A collection of SQL practice, problem-solving exercises, and completion achievements from SQL-Practice.com, W3Schools, HackerRank, DataLemur, and LeetCode.