Browsing Tag
sql
106 posts
SQL Subquery and CTEs( Common Table Expressions)
What is a subquery? Subquery is a query nested inside another query statement. It allows the query to…
Coding Cat Oran Ep3, Five Tables Changed Everything
Oran spent two weeks doing something that felt like not working. He sat with the warehouse team during…
From Scratch to Queries: Building a School Database with SQL – My Nairobi Academy Project.
Transitioning from viewing data as simple lists to managing it within a relational database is a milestone for…
How I Learned SQL by Creating a Simple School Database
Introduction When I first started learning data analytics, I spent most of my time working with tools like…
Azure SQL Database: Cross-Database Queries on the Same Server
If you have two databases on the same Azure SQL logical server and try a three-part name query…
Alter Queries
In this assignment, I worked on modifying existing tables using ALTER TABLE. This helped me understand how to…
PostgreSQL(Alternations)
-ALTER TABLE → modify existing table structure. -Operations: add/drop column, change datatype, rename column/table, add/drop constraints. Common ALTER…
SurrealDB: The “One-Size-Fits-All” Database for Lazy Developers (Part 1)
*Intro: * We need to talk about your “Modern Stack” Let’s be real for a second. We’ve all…
SQL Joins & Window Functions
JOINS They allow us to work with multiple tables and allows us to join data in different tables.…
EXPLORING SQL JOINS AND WINDOWS
In real world analytics, data rarely exists in isolation, rather it is usually stored in separate but related…