Oracle: Aggregate Functions for Databases
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 noteTechnical notes / editorial archive
Technical notes for understanding, testing, and operating better.
Practical notes, explainers, comparisons, and explorations about Linux, Docker, databases, networking, Python, and more.
Flask: The Definitive Guide to Getting Started with Web Development in Python
Did you know that just a few lines of code can turn your idea into a working web application? If you are curious about web development with Python, Flask may be the perfect tool for you.
Read note01 / notes
Explore from a problem, a question, or a curiosity.
Technical notes with examples, code, context, and stable individual URLs.
Uses of the LIKE Statement in Oracle
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
How to Use and Optimize Indexes in Oracle
Have you ever felt that your Oracle queries are slower than they should be? Indexes might be the solution you are looking for. This article explains how to use and optimize them.
Read note
Understanding System Resource Limits with Docker
Imagine managing a critical application and wanting to ensure it never runs out of resources. This is where Docker system resource limits come in.
Read note
View Open Ports on a Linux Server
Have you ever wondered how to find out which ports are open on your Linux server? You may need this information to secure your server or troubleshoot connectivity problems.
Read note
Effective Uses of the TRUNC Function in Oracle
The Oracle TRUNC function is a powerful tool that many database professionals underestimate. Have you ever wondered how to simplify complex data, such as dates and numbers, to create clearer and more accurate reports?
Read note
Docker Container States
Understanding these states will help you manage containers better and troubleshoot problems more efficiently. This article explains the different states a Docker container can have.
Read note
RPM Command in Linux: A Complete Guide for Sysadmins
This article reveals the mystery behind the RPM command, an essential tool for package management in Linux. By the end, you will have a clear and practical understanding of how to use RPM.
Read note
How Does a Graphics Engine Work? What You Need to Know
Have you ever wondered how the incredible graphics in video games and applications are created? This article takes you on a fascinating journey to discover how graphics engines work.
Read note
Kubernetes: A Guide to Using Persistence Correctly
Persistence in Kubernetes may seem complicated at first, but it is essential for keeping your data safe and available even when containers restart or move between nodes.
Read note02 / map
Topics to get started.
A clear structure for finding answers without losing the context.