01
Database creation
Database & ORM
MySQL.
Working with relational databases, SQL queries and structured data storage.
My
01 / OVERVIEW
Understanding MySQL
A brief introduction to the technology and its role in development.
01
What is MySQL?
MySQL is a relational database management system used to store and retrieve application data.
02 / LEARNING
What I've learned
The concepts and fundamentals I have explored while learning MySQL.
02
Table creation
03
CRUD operations
04
Primary and foreign keys
05
Joins
06
Database connectivity
03 / KNOWLEDGE
Topics I've explored
An overview of the major areas covered in my learning journey.
TOPIC 01
Database Fundamentals
Exploring database fundamentals as part of my MySQL learning journey.
TOPIC 02
Tables
Exploring tables as part of my MySQL learning journey.
TOPIC 03
CRUD Operations
Exploring crud operations as part of my MySQL learning journey.
TOPIC 04
Relationships
Exploring relationships as part of my MySQL learning journey.
TOPIC 05
Joins
Exploring joins as part of my MySQL learning journey.
TOPIC 06
Database Connectivity
Exploring database connectivity as part of my MySQL learning journey.
04 / PRACTICAL EXPERIENCE
Projects using MySQL.
A collection of projects where I've explored and applied MySQL.
E-Commerce / Web
Prototype
Styaio
An e-commerce web application developed with a focus on product management, shopping workflows and web application development.
HTML
CSS
JavaScript
Flask
ML
MySQL
Explore project ↗
Bizboy
Data Analysis/ WEB
Prototype
Bizboy
An business analytics web application developed with a focus on sales or summary of product management, shopping workflows and trends , market tracking.
HTML
CSS
JavaScript
Flask
ML
MySQL
Pandas
Plotly
Explore project ↗
Web Development
Completed
To-Do App
A task management web application developed with a Flask backend and MySQL database.
HTML
CSS
Flask
MySQL
Explore project ↗