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