A series of projects and tasks where I practice my skills in working with a MySQL database and visualizing data using Tableau.
-
SQL Languages
- MySQL
-
Tools
- MySQL Workbench
- PhpStorm
The goal of this project is to develop proficiency in working with MySQL, starting from the beginner level and progressively advancing through intermediate and advanced stages.
-
Beginner Level: At the beginner level, we will focus on laying a strong foundation in MySQL. This includes mastering the fundamental concepts of Structured Query Language (SQL), creating databases and tables, and performing essential CRUD (Create, Read, Update, Delete) operations.
-
Intermediate Level: As we progress to the intermediate level, the emphasis shifts towards more intricate SQL techniques. We will explore complex query construction, data filtering, and sorting strategies, enabling us to extract precise information from databases.
-
Advanced Level: At the advanced level, we aim to elevate our MySQL skills to the highest tier. This phase involves delving into advanced SQL concepts, such as subqueries, JOIN operations, and optimizing query performance through efficient index usage. Mastery of these advanced techniques will empower us to tackle complex tasks and analyze data with precision.