Topic / queries
Technical notes related to queries.
01 / notes
Technical notes with examples, code, context, and stable individual URLs.
When working with databases in web applications or software, an important question arises: is it better to write SQL queries directly or use an abstraction layer such as SQLAlchemy?
Read note
Aggregate functions are essential for summarizing and analyzing large data sets. This article guides you from basic to advanced concepts, exploring how to use them with GROUP BY.
Read note
Have you ever needed to find specific data in an Oracle database but were unsure how to do it effectively? The LIKE statement is a powerful tool for flexible searches.
Read note
Subqueries are a fundamental tool in Oracle databases, allowing you to perform complex queries and obtain precise results. This article explains single-value and multi-value subqueries.
Read note
Have you ever felt like a juggler trying to untangle your data in Oracle SQL? Do not worry!
Read noteHave you ever experienced the frustration of running SQL queries that consume too many resources in your Oracle database?
Read noteWhen working with Oracle SQL, you may find yourself needing to combine the results of several queries into a single output.
Read note02 / map
A clear structure for finding answers without losing the context.
