I've been diving into SQL recently and managed to create quite a few tables. However, while practicing on a random website, I realized this might not be the right path for my full stack development journey. Currently, I'm working with Python for full stack development. I asked an AI for advice, and it suggested learning MySQL or SQLite, which are libraries that help make data manageable and useful through commands. I'm feeling a bit stuck and need clarity on whether I should focus on learning a database first or jump into Flask and API development. Also, how can I determine if my SQL skills are solid? I've discovered some new things while practicing SQL, but I'm unsure where I stand or where to go next. Any guidance would be appreciated!
1 Answer
I’d suggest you flip a coin between PostgreSQL and SQLite to see which one you want to dive into. Build a simple CRUD application using Python where you can create, read, update, and delete records in your database. After getting the hang of it with basic queries, explore stored procedures and views to make it even more interesting. This hands-on practice really helps solidify your understanding!
Okay, got it! I guess I don't need to focus on APIs and Flask yet then.