Start: March 24
End: May 18
Goal: Brush up on React & backend, learn cloud fundamentals, and understand DataStage & ETL workflows.
β Week 1β2: Deepen React + Modern Patterns
π― Goals
- Refactor component structure using best practices
- Practice hooks, context, and React testing
π Topics
- Custom Hooks
- Context API for global state
- Error boundaries
- Component patterns (container/presentational, compound)
- Unit testing with Jest + React Testing Library
π οΈ Mini Project
- Build a Task Manager App
- Add Firebase Auth for user login
- Use custom hooks for state management
- Test components with Jest
π Resources
- React Docs β Advanced Guides
- useHooks
- Kent C. Doddsβ Blog
β Week 3: Backend β Express.js + REST API Mastery
π― Goals
- Build and test robust REST APIs
- Master routing, middleware, and authentication
π Topics
- Express routing and middleware
- RESTful design principles
- Error handling and status codes
- JWT Authentication
- PostgreSQL integration (via Prisma or Sequelize)
π οΈ Mini Project
- Build a Book Store API with:
- CRUD operations for books
- JWT-based user auth
π Resources
β Week 4: Databases β PostgreSQL & IBM Db2
π― Goals
- Get comfortable with relational databases
- Understand Db2 basics for IBM tooling
π Topics
- SQL basics, joins, indexes
- Schema design
- ORM usage (Prisma or Sequelize)
- Explore IBM Db2 on IBM Cloud Lite
π οΈ Challenge
- Refactor Grocery Tracker App to use PostgreSQL backend
π Resources
- SQLBolt Tutorial
- IBM Db2 Documentation
β Week 5: Cloud 101 β IBM Cloud + AWS Basics
π― Goals
- Understand core cloud services and deployments
- Get comfortable with cloud app hosting
π Topics
- IaaS vs PaaS vs SaaS
- IBM Cloud Functions, Code Engine, Db2 setup
- AWS EC2, S3 basics (just for comparison)
- CI/CD with GitHub Actions
π οΈ Task
- Deploy your React + Express app to IBM Cloud or Render.com
π Resources
β Week 6: ETL Concepts + Intro to DataStage
π― Goals
- Grasp ETL pipeline basics
- Understand what DataStage does
π Topics
- What is ETL/ELT
- Data pipeline components (Extract β Transform β Load)
- Parallelism and job types in DataStage
- DataStage architecture
π οΈ Task
- Build a simple ETL script in Python
- Extract data from CSV
- Clean & transform
- Load into PostgreSQL
π Resources
β Week 7: Microservices + API Gateway Concepts
π― Goals
- Learn microservice structure and API integration
π Topics
- Microservices vs monoliths
- REST vs gRPC (high-level)
- API Gateway concepts (e.g., IBM API Connect)
- Rate limiting and service auth
- Event-driven overview (Kafka/RabbitMQ basics)
π οΈ Task
- Split Book Store API:
- Auth service
- Book service
π Resources
β Week 8: Final Project β School Inventory Manager (Full Stack)
π― Goal
Build a full-stack app that simulates a real-world DataStage-like workflow in a school setting.
π οΈ Features
- React frontend with reusable components
- Express.js backend with PostgreSQL
- Firebase Auth (or JWT)
- Inventory dashboard with:
- Add/View/Edit/Delete school items
- Track quantity and expiration (e.g., lab equipment, supplies)
- Low stock alerts
- Simple ETL logic:
- Nightly script checks for low stock or expired items
- Sends alerts or logs into a separate table
- Deployment to IBM Cloud or Render
π Bonus Learning
- Read case studies of DataStage in data warehousing
- Check out IBM Developer Blog for examples
- Browse IBM Redbooks for ETL and integration best practices