NODE

• Introduction & Development Environment Setup
  • What is the MERN Stack (with MySQL)?
  • Architecture overview and component interaction
  • Industry applications and career opportunities
  • Installing Node.js and npm
  • Installing MySQL Server and MySQL Workbench
  • Setting up VS Code with extensions
  • Introduction to Git and GitHub
  • Installing Postman for API testing
• JavaScript ES6+ Refresher
  • let, const, and block scoping
  • Template literals
  • Destructuring arrays and objects
  • Spread and rest operators
  • Default parameters
  • Arrow functions and lexical this
  • Array methods: map, filter, reduce, find, forEach
  • Promises and async/await
  • Modules: import and export
  • Classes and inheritance
  • Error handling with try/catch
• Node.js Fundamentals
  • What is Node.js and how it works
  • Event-driven architecture
  • Node.js runtime and V8 engine
  • Global objects and modules
  • npm and package.json
  • File System (fs) module
  • Path module
  • HTTP module basics
  • Events and EventEmitter
  • Streams and buffers
  • Creating an HTTP server from scratch
  • Handling requests and responses
  • Routing basics without frameworks
  • Serving static files
  • Understanding middleware concepts
• Express.js Framework
  • Introduction to Express.js
  • Setting up an Express application
  • Understanding middleware
  • Routing fundamentals
  • Request and response objects
  • Route parameters and query strings
  • Router modules for modular routing
  • Route handlers and chaining
  • Handling different HTTP methods
  • Error handling middleware
  • Built-in middleware (express.json, express.static)
  • Third-party middleware (cors, morgan, helmet)
  • Custom middleware creation
  • Application-level vs router-level middleware
  • REST architecture principles
  • Designing RESTful endpoints
  • CRUD operations structure
  • API versioning strategies
  • Response formatting and status codes
• MySQL & Sequelize ORM
  • Introduction to relational databases
  • MySQL architecture and concepts
  • Tables, rows, columns, and relationships
  • MySQL Workbench setup and usage
  • Cloud MySQL setup (PlanetScale/AWS RDS)
  • SQL basics: SELECT, INSERT, UPDATE, DELETE
  • WHERE clauses and operators
  • JOINs: INNER, LEFT, RIGHT, FULL
  • GROUP BY, ORDER BY, HAVING
  • Aggregate functions (COUNT, SUM, AVG, MAX, MIN)
  • Introduction to Sequelize ORM
  • Connecting to MySQL with Sequelize
  • Defining models and data types
  • Model validations and constraints
  • Primary keys and auto-increment
  • Sequelize queries and finders
  • Associations: One-to-One, One-to-Many, Many-to-Many
  • Eager loading and lazy loading
  • Migrations and seeders
  • Indexing for performance
• Authentication & Authorization
  • Authentication vs authorization
  • Password hashing with bcrypt
  • User registration flow
  • User login flow
  • Session-based vs token-based authentication
  • Understanding JWT structure
  • Creating and signing tokens
  • Verifying and decoding tokens
  • Token expiration and refresh tokens
  • Storing tokens securely
  • Protecting routes with middleware
  • Role-based access control (RBAC)
  • Permission-based authorization
  • Handling unauthorized access
  • Best practices for secure authentication
• React.js Fundamentals
  • What is React and why use it
  • Setting up a React project (Vite/Create React App)
  • Understanding JSX
  • Components: functional vs class
  • Rendering elements
  • Creating functional components
  • Props and prop types
  • Component composition
  • Children props
  • Conditional rendering
  • Understanding state in React
  • useState hook
  • useEffect hook for side effects
  • Dependency arrays
  • Cleanup functions
  • Event handling in React
  • Synthetic events
  • Controlled components
  • Form handling and validation
  • Multiple input handling
  • Rendering lists with map
  • Understanding keys
  • Conditional rendering patterns
  • Short-circuit evaluation
  • Ternary operators in JSX
• Advanced React Concepts
  • useContext for state management
  • useReducer for complex state
  • useRef for DOM references
  • useMemo and useCallback for optimization
  • Custom hooks creation
  • Setting up React Router
  • Route configuration
  • Navigation with Link and NavLink
  • URL parameters and query strings
  • Nested routes and layouts
  • Protected routes implementation
  • Creating context
  • Context providers and consumers
  • useContext hook
  • Global state patterns
  • When to use Context vs props
  • Fetching data with fetch API
  • Using Axios for HTTP requests
  • Handling loading and error states
  • useEffect for data fetching
  • Custom hooks for API calls
• Full Stack Integration
  • CORS configuration
  • Environment variables (.env)
  • API service layer in React
  • Proxy setup for development
  • Base URL configuration
  • Login and registration forms
  • Storing tokens in localStorage/cookies
  • Auth context for global auth state
  • Protected routes in React
  • Handling token expiration
• Capstone Project (Project Management - Clone of Jira)
  • Project requirements analysis
  • Database schema design (ER diagrams)
  • Table relationships and normalization
  • API endpoint planning
  • Folder structure setup
  • Git repository initialization
  • Setting up Express server
  • Creating Sequelize models
  • Setting up migrations
  • Implementing CRUD APIs
  • User authentication endpoints
  • Input validation and error handling
  • API testing with Postman
  • React project setup
  • Component architecture
  • Implementing UI components
  • State management setup
  • API integration
  • Form handling and validation
  • Connecting frontend to backend
  • End-to-end testing
  • Bug fixing and optimization
  • UI/UX improvements
  • Code review and refactoring
• Deployment & Best Practices
  • Preparing for production
  • Deploying backend to Render/Railway
  • Deploying frontend to Vercel/Netlify
  • Environment variables in production
  • MySQL cloud deployment
  • Code organization patterns
  • Security best practices
  • Performance optimization tips
  • Testing introduction (Jest, React Testing Library)
  • Further learning paths (TypeScript, Redux, Next.js)
• Recommended Tools
  • VS Code with extensions (ES7 React Snippets, Prettier, ESLint)
  • MySQL Workbench or shell for database management
  • Postman / Thunder Client for API testing
  • Git & GitHub for version control
  • Chrome DevTools & React Developer Tools

• Basic HTML
• CSS
• Programming Fundamentals

• Recorded  Videos will be accessible till 30th June 2026.