Shalon N. Ngiginjeri-ngigi.hashnode.dev·Feb 4, 2025The Basics of Relational DatabasesTypes of databases Relational databases (SQL) - data is stored in structured tables with columns and rows defined by schemas. Examples: PostgreSQL, MySQL, SQLite Why pick a relational database: If you have structured data with strong relationships...1 likeSoftware Engineering FundamentalsDatabases
Shivam Dubeycodefarms.in·Jan 28, 2025Mastering SQL Joins: A Beginner's Guide to INNER, LEFT, RIGHT, and FULL OUTER JoinsWhen working with relational databases, data is often split across multiple tables to reduce redundancy and improve organization. To retrieve meaningful information, you frequently need to combine data from these tables. This is where joins come into...PostgresPostgreSQL
Soyoola Sodunkesoyoolasodunke.hashnode.dev·Jan 23, 2025Joins in SQLSQL joins are used to combine rows from two or more tables based on a related column between them. Different types of joins are used depending on the desired output. Here are the main types of SQL joins and their use cases: 1. INNER JOIN Definition:...joins
Urh Srecnikblog.srecnik.info·Dec 7, 2024Introduction to JOIN LATERAL on OracleLateral join joins a subquery, which is executed as many times as there are rows in the leading table. Consider it as a kind of for-each loop. Most of, if not all, the problems it solves, can also be solved without lateral join (e.g. using analytic f...76 readsOracle
Steve Hatmaker Jr.stevehatmakerjr.com·Oct 29, 2024Understanding SQL Joins: A Simple GuideHave you ever tried to combine pieces of information from different sources? Maybe you have a list of your friends and another list of their favorite games. You might want to see who likes which game. In databases, we use something called joins to co...inner joins
DbVisualizerthetable.hashnode.dev·Oct 21, 2024A Quick Guide to SQL Inner JoinsSQL Inner Joins are a crucial technique for combining rows from multiple tables when they share a common value. This method is widely used in database management to integrate related information, such as linking products to orders or employees to dep...joins
Akshobya KLakshobya.hashnode.dev·Oct 16, 2024Part 2: Exploring Right Joins, Full Outer Joins, and Self JoinsIn the previous post, we got comfortable with inner joins and left joins. we will cover the remaining join types right join, full outer join, and self join which help us handle more complex data relationships. Let’s get started! 1. Right Join A right...SQL FundamentalsSQL
Akshobya KLakshobya.hashnode.dev·Oct 15, 2024Part 1: Understanding SQL Joins – Bringing Tables TogetherWhen working with relational databases, data often resides across multiple tables. That's where joins come into play! Joins allow us to combine data from two or more tables based on related columns, unlocking the full potential of our data. In this f...SQL FundamentalsSQL
Vaishnave Subbramanianvaishnave.page·Sep 29, 2024Sparking SolutionsIntroduction to Spark Optimization Optimizing Spark can dramatically improve performance and reduce resource consumption. Typically, optimization in Spark can be approached from three distinct levels: cluster level, code level, and CPU/memory level. ...1 like·285 readsDabbling with Apache Sparkspark
Fiyin Akinsikufiyinakinsiku.hashnode.dev·Sep 13, 2024PostgreSQL CROSS JOINThe PostgreSQL CROSS JOIN clause is a type of join that returns the Cartesian product of two tables. What is a Cartesian product? Image created on Canva.com A Cartesian product is the result of combining every entry in one dataset with every entry i...What I'm learning today