How to: August 16, 2025
1. freeCodeCamp just published this full length book on how to architect a database using SQL and relational database management systems. This book is aimed at beginners, and includes a Jupyter Notebook you can interact with as you follow along. It will teach you Postgres and a bit of SQL. Then you'll learn how to design and maintain efficient, secure databases that support complex data-driven apps. (Full length book): https://www.freecodecamp.org/news/how-to-design-structured-database-systems-using-sql-full-book/

2. freeCodeCamp also published this comprehensive data science course on Time Series Forecasting with Python. You'll learn about key Time Series components like trend, seasonality, and residuals. You'll start by building some baseline models. Then you'll dive into Cross-Validation, Exogenous Features, Prediction Interval Generation, and more. (2 hour YouTube course): https://www.freecodecamp.org/news/learn-time-series-forecasting-in-python/

3. On this week's freeCodeCamp podcast, I interview Edidiong Asikpo about her journey from medical school into software engineering. She talks about Nigeria's tech scene, how to break into tech when you live outside the Silicon Valley ecosystem, and how she transitioned from mobile app development to DevOps. Tons of actionable tips here. (1 hour watch or listen in your favorite podcast app): https://www.freecodecamp.org/news/abandoning-med-school-to-become-a-software-engineer-with-edidiong-asikpo-podcast-182/

4. freeCodeCamp also published this in-depth guide to passing the Google Cloud Associate Engineer certification exam. Andrew Brown will teach you about Infrastructure as Code, Serverless, Google Kubernetes Engine, data storage solutions, and more. If you're interested in a career in DevOps, take a gander. (11 hour YouTube course): https://www.freecodecamp.org/news/pass-the-google-cloud-associate-cloud-engineer-exam/

5. Learn how the popular Next.js web development framework handles caching and rendering. This course uses the latest version of Next.js – version 15. It will teach you all about Static Site Generation, Server-Side Rendering, Incremental Static Regeneration, and other important concepts. (2 hour YouTube course): https://www.freecodecamp.org/news/learn-nextjs-15-caching-and-rendering/

Quote of the Week:
*"To this day, I remember when my first open source pull request got merged. It was one of the best days of my life. I was so, so happy. I couldn't believe that a code contribution that I made was now part of an application used by thousands of people."* — Software Engineer Edidiong Asikpo on this week's freeCodeCamp podcast