Category: database

All the articles in the category "database".

• problem-solving

  19 Dec, 2023

  175 - Combine Two Tables

  Solving LeetCode's Combine Two Tables problem with a SQL LEFT JOIN to report person details even when address data is missing.

• problem-solving

  19 Dec, 2023

  181 - Employees Earning More Than Their Managers

  Solving LeetCode's Employees Earning More Than Their Managers problem using a SQL self join.

• notes

  19 Dec, 2023

  SQL Notes

  Comprehensive SQL notes covering DDL, DML, DCL, table operations, joins, subqueries, and aggregate functions.