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

Tree Utils is the library to convert and manipulate with tree-like structures.

Lab SQL Self and cross join

Примеры кода SQL-запросов из наиболее сложных решённых задач. Есть полное описание задач и ссылки на источники.

End-to-end data cleaning and exploratory data analysis (EDA) project using MySQL. Includes duplicate detection using window functions, data standardization, null handling, data transformation, and structured SQL-based analysis on real-world layoff datasets.

SQL laboratory project demonstrating table classification, aggregation, filtering with GROUP BY / HAVING, and relational joins including self-joins, multiple joins, and equi-joins using a personnel management database (Databases I, UNIWA).

[PYTHON, FLASK, MYSQL] Connects a flask application to a MySQL database. Uses self join relationships. Shows understanding of validation with users and usernames. Demonstrates CRUD SQL manipulation and execution.

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

A repository of more advanced SQL Server queries, including Common Table Expressions (CTEs) and self-joins.

Human Resources database

Find duplicates users in Sybase within Sisis Sunrise

ActiveRecord Self-Join Association

[MySQL ERD, DB, and quieries] Demonstrates understanding of self join relationship in ERD. SELF JOIN: many to many to same table. In this case.. A user can have a friend (another user from the same table).