📘 ALX Backend Development – SQL & MySQL Fundamentals

This repository contains my work and practice files from the ALX Backend Development program, focusing on SQL and MySQL concepts. Throughout this project, I explored how to create databases, manage tables, insert data, and interact with databases using Python and MySQL Connector.

🚀 What I Learned

Fundamentals of SQL (Structured Query Language)

How to create and manage databases in MySQL

Writing queries to select, update, and delete data

Using INFORMATION_SCHEMA to get database metadata

Connecting Python to MySQL using MySQL Connector

Managing and testing databases with DataGrip

📂 Repository Structure File Name Description alx_book_store.sql Script to create the database if it doesn’t exist task_2.sql Creates a new database task_3.sql Displays database information task_4.sql Shows all tables in the alx_book_store database task_5.sql Corrects table name case from uppercase to lowercase task_6.sql Inserts multiple records into the customer table MySQLServer.py Python script to create a database using MySQL Connector README.md Project documentation 🧠 Tools & Technologies

MySQL Server

Python 3

MySQL Connector for Python

DataGrip

Command Line / Terminal

💡 About the Project

This project helped me build a strong foundation in database management — from designing schemas to interacting with data programmatically using Python. It’s a key step in my journey to becoming a backend developer.

🔖 Author

Paul Promise Backend Developer in training — ALX Africa