Welcome to your official course repository for the Python + SQL + APIs Intensive, hosted by CodingNomads. This repo contains all the files and resources you’ll need during the 9-week program — including:
✅ Lecture notes
✅ Quizzes
✅ Coding challenges
✅ Capstone guidance
After accepting the email invite to join the GitHub repo:
git clone https://github.com/CodingNomads/Python-Summer-Session
cd Python-Summer-SessionWe recommend using Visual Studio Code with the Python extension installed.
For each project or week, run:
python -m venv venv
source venv/bin/activate # or venv\Scripts\activate on Windows
pip install -r requirements.txt # if applicable| Week | Topics |
|---|---|
| 1 | Python setup, CLI, GitHub, variables, data types |
| 2 | Numbers, strings, user input, conditionals, loops |
| 3 | Lists, dictionaries, files, functions, scope |
| 4 | Virtual environments, packages, lambdas, comprehensions |
| 5 | REST APIs with requests, SQLAlchemy, debugging |
| 6 | Object-Oriented Programming: classes, methods, inheritance |
| 7 | Web scraping, exception handling, unit testing |
| 8 | Decorators, stacks, queues, idiomatic Python |
| 9 | Capstone project: full app using Python + APIs + SQL |
Each week, you will have exercises aimed at reinforcing the skills learned that week, as well activities to prepare you for the week upcoming. You should use your mentor time to review the exercises, as well as any issues you may have with the preparatory activities.
To prepare for Week One, you should:
- Ensure Python is installed on your machine. Check out How to Install Python for step by step instructions, if you are unsure.
- Ensure Visual Studio Code is installed on your machine. Check out How to Get Started with Visual Studio Code for step by step instructions.
If you have any issues with either of these steps, reach out to Ryan or Jon on Discord or via the email addresses below -- we're here to help!
Your final project should demonstrate what you've learned:
- A real-world Python app
- Uses an external API
- Stores data in a SQL database
- Interacts via command-line or simple interface
- Optional: include testing & decorators!
- Ask the instructor during live sessions
- Ask your mentor during 1:1 sessions
- Use the various Discord channels for quick questions
- Email us anytime: [email protected] and [email protected]
- Weekly challenges completed
- Weekly exercises completed
- Quiz questions reviewed
- Capstone project submitted
- GitHub repo updated with your work
- Certificate requested
- You’re feeling confident!
Happy coding, and welcome to the world of Python 🐍
– The CodingNomads Team