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.

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

Find duplicates users in Sybase within Sisis Sunrise

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

[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.

No description provided.

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).

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.

No description provided.

Human Resources database

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

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).