This repository showcases the hands-on assessments I completed during my IBM's "Databases and SQL for Data Science with Python" certification. It includes work done using MySQL, Python with SQL, and the datasets used in various assignments and exercises.
MySQL_Assessments/– Contains SQL scripts, queries, and exercises done in MySQL.Python_SQL_Assessments/– Includes Python scripts and Jupyter Notebooks where SQL was used with libraries likesqlite3orpandas.Datasets/– The CSV or Excel files used in the assessments.
- Writing and optimizing SQL queries
- Using joins, subqueries, and aggregate functions
- Database creation and normalization
- Using Python to interact with databases
- Data analysis with SQL and Python
- Working with real-world datasets
- MySQL
- Python
- Jupyter Notebook
- SQLite /
sqlite3 - Pandas
This portfolio is meant to demonstrate my proficiency in SQL and related tools, as part of my learning journey in data and database management.
Feel free to explore the folders and review the code!