100 Days of SQL: Beginner to Advance

Contents

• Introduction
• Why MySQL and Oracle?
• Roadmap
• Log - click here to see my progress

Introduction 🚀

Consistency they say conquers all things. Thus, I have made it an habit to always learn something every day, no matter how small. In this vein, I joined the 100 days of code challenge and completed a few free courses online. To keep up the momentum, my next challenge is to learn SQL from scratch up to an advanced level. The motivation behind this journey is my very friend and role model, Ivuelekwa Stephen, whose coding consistency is absolutely iconic ! 🥺🙏

Why MySql and Oracle?

I chose to channel my learning towards relational databases, especially MySQL and Oracle due to their popularity and demand. Currently, these two relational database management systems are arguably the most used by data scientists, engineers and analysts. What can I say? I followed the flow 😇

Roadmap 📈

My first 100 days of code challenge was dedicated to practicing algorithms and data structures. Looking back at this journey, though I have learnt quite a lot, I am not very happy with how it's disorganized. No roadmap or log to track my progress or a strict learning plan. Today, I learn little about recursion, the next day, I'm studying binary search and the next hashmap. It is hard to measure how far I have come. Hence, I think I should follow a different schema and take a more holistic approach to learning SQL. To this end, I have created a roadmap for myself which would be like a guide. The first stage is dedicated to the mastery of MySQL from scratch (Beginner to Intermediate) while the second is dedicated to learning Oracle (Intermediate to Advance) by building on what I've learned during the first stage. Also, I would like to point out that the roadmap is inspired by official documentations of MySQL and Oracle. Lastly, you can find all practice questions and solutions here. All learn and no practice they say make a bad data scientist 🙂.

Start Date: 15th of August 2022 🏁
Assumed End Date: 25th of November 2022 🎉

Check images folder for image file of challenge roadmap.

Week 7

• Triggers
• Utility Statements
• Globalization
• Regular Expressions 1
• Regular Expressions 2
• Practice
• Summarize and Iterate

Week 14

• Queries and Subqueries: Joins (conclusion)
• Automatic and Manual Locking Mechanisms During SQL Operations
• Oracle Regular Expression 1
• Oracle Regular Expression 2
• Oracle SQL Reserved Words and Keywords
• Practice
• Summarize and Iterate