Back
Getting Started with MySQL
2023-11
After MongoDB, I wanted to understand relational databases too. MySQL taught me structured schemas, table relationships, and the power of SQL queries.
What I Learned
- Tables & Schemas — defining columns, data types, and constraints before inserting data
- SQL Queries — SELECT, INSERT, UPDATE, DELETE with WHERE, JOIN, and GROUP BY
- Relationships — one-to-many and many-to-many with foreign keys
- Normalization — organizing data to reduce redundancy and maintain integrity
Building Real Projects
I used MySQL alongside MongoDB in my full-stack work. Understanding both databases helped me choose the right tool — relational for structured data with clear relationships, document-based for flexible schemas.
Where I Am Now
I can model relational data, write SQL queries with joins and aggregations, and decide when MySQL is the better choice over MongoDB for a given use case.