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.