SQL from Zero to Pro #1: Course Introduction

Welcome to this new series where we dive into the world of SQL, the essential language for managing and querying databases. Whether you’re a beginner, want to refresh your knowledge, or just want to understand why SQL is everywhere in tech, you’re in the right place. What you'll learn ...

November 19, 2026 · 2 min · 304 words · Naimi

SQL from Zero to Pro #2: What Is SQL? Installing MySQL

In this chapter, we answer the question “what is SQL?”, see why it’s used everywhere, then install MySQL. What you'll learn What SQL is, and what a DBMS like MySQL is Why SQL is still a must-have for a developer Install MySQL with WAMP and open phpMyAdmin What is SQL? SQL stands for Structured Query Language. It’s a language designed to query, manipulate and manage data in relational databases. ...

November 19, 2026 · 3 min · 578 words · Naimi

SQL from Zero to Pro #3: Create, Delete and Rename a Database

In this chapter, we learn to manage databases: create them, delete them, rename them and switch from one to another. What you'll learn Connect to MySQL from the command line Create, delete, list and select a database Rename a database (there’s no command for that!) Pick the right encoding from the start The two basic commands -- Create a database CREATE DATABASE database_name; -- Delete a database DROP DATABASE database_name; You can do the same with a GUI (phpMyAdmin, Workbench…). Here, though, we use the command line: the terminal on Linux, the Command Prompt (CMD) on Windows. ...

November 19, 2026 · 4 min · 701 words · Naimi

Mini Library Course #3: Database, Entities & Migrations with Doctrine

Our app runs and has a template. Now it needs data. In this chapter we connect Symfony to a MySQL database, create our three entities (Author, Category and Book), link them together, and create the tables with migrations. What you'll learn Configure the MySQL connection in Symfony Create entities with make:entity, field by field Link entities: ManyToOne and ManyToMany Turn entities into tables with migrations Configuring the Database The connection is configured in the .env file at the root of the project. Symfony already ships with a few commented examples (SQLite, MySQL, MariaDB, PostgreSQL). We use MySQL, so we uncomment the MySQL line and comment out the others. ...

November 18, 2026 · 5 min · 968 words · Naimi

SQL from Zero to Pro #4: Tables, Relationships and Data Manipulation

A database without tables is an empty box. In this chapter, we create and modify tables, link them together, then insert, update and delete data. What you'll learn Create, modify and delete tables Link tables: one to one, one to many, many to many Name your constraints Insert, update and delete data safely Anatomy of a table Take a user table with four columns: ...

November 19, 2026 · 7 min · 1330 words · Naimi

SQL from Zero to Pro #5: Querying Data with SELECT

Let’s tackle one of the most fundamental concepts in SQL: SELECT queries. With them, you can extract data, filter results, sort them, and even run calculations. What you'll learn Read data with SELECT Filter, group, sort and paginate with clauses Compute with aggregate functions Understand the order in which MySQL runs a query Basic syntax -- Get some columns SELECT name, city FROM user; -- Get every column SELECT * FROM user; Both queries return every row of the table. To filter, organize or group, we add clauses. ...

November 19, 2026 · 5 min · 942 words · Naimi

SQL from Zero to Pro #6: Subqueries (Nested Queries)

Time for advanced SQL with a super useful concept: subqueries. What you'll learn What a subquery is, and where you can use one Add a computed column, replace a table, filter with IN Copy, update or delete rows based on a result Work around MySQL error 1093 What’s a subquery? A subquery is a SQL query nested inside another query, between parentheses. You can use it in SELECT, FROM, WHERE, HAVING, and even in INSERT, UPDATE or DELETE. ...

November 19, 2026 · 4 min · 698 words · Naimi

SQL from Zero to Pro #7: Joins (INNER, LEFT, RIGHT, FULL JOIN)

If you’ve ever worked with several tables, you’ve surely needed to cross-reference their data. That’s exactly what joins do: they link information spread across different tables to get useful results. What you'll learn Visualize joins before writing them INNER JOIN, LEFT JOIN and RIGHT JOIN, with prefixes and aliases Emulate a FULL OUTER JOIN in MySQL with UNION Replace a subquery with a join Visualizing joins The easiest way to understand joins is a circle diagram (like the ones on sql.sh), before you even write the query. With two tables A and B: ...

November 19, 2026 · 5 min · 935 words · Naimi

SQL from Zero to Pro #8: Hands-On LeetCode Exercises (Part 1)

Time to practice! We solve SQL problems on LeetCode, one of the best platforms to train and prepare for technical interviews. It offers problems in algorithms, databases, shell, concurrency and JavaScript. Here, we pick the Database category, Easy level. What you'll learn ...

November 19, 2026 · 4 min · 780 words · Naimi

SQL from Zero to Pro #9: Hands-On LeetCode Exercises (Part 2)

A second round of LeetCode SQL problems! On the menu: joins, NULL, grouping, subqueries and a first look at IF and CASE. What you'll learn Handle NULL in a condition Filter groups with HAVING Handle ties with a subquery Discover IF and CASE to transform values 1. Employee Bonus Tables: ...

November 19, 2026 · 4 min · 736 words · Naimi