Full-Stack Web Development

This course teaches all topics like HTML, CSS, Bootstrap, JavaScript, Node.js, Express.js, MySQL, React and AJAX that enable you to develop a Full-Stack Web Application using Node + Express + MySQL + React.

At the end of this course, you will have acquired the skills to build a complete web application where Front-end developed using React connects to Back-end developed using Node + Express + MySQL.

Detailed Syllabus:

• JavaScript
• What is JavaScript
• Versions of JavaScript
• Language Elements
• Conditional statements
• Loops
• Strings
• Regular Expression
• Arrays
• Dates
• Functions
• Arrow Functions
• Classes
• Inheritance
• Spread Operator
• Destructuring
• JSON
• Error Handling - try, catch and finally
• Browser Object Model
• HTML DOM
• jQuery
• AJAX
• MySQL
• Installing MySQL Community Edition and MySQL WorkBench
• Creating Tables
• Working with SQL commands - INSERT, DELETE, UPDATE and SELECT
• Using MySQL functions
• Grouping and Joining
• Node.js
• How to install Node.js
• Using Node CLI - REPL
• Exporting and Importing Modules
• Using argments to node modules
• Understanding blocking and non-blocking code
• Understanding async pattern - callbacks and promises
• Understanding event loop
• Using async and await keywords
• Using Node.js Built-in Modules - path, fs, os etc.
• File handling using sync, callbacks and promises
• Working with Events and EventEmitter
• Connecting to MySQL Database using mysql module
• Handling request and response - http module
• Express.js
• Install Express, NodeMon etc.
• Handling Http Request and Response
• Understanding Routing and creating Routers
• Understanding middleware
• Creating middleware
• How to handle static files
• Working with Template Engine - EJS
• Processing data sent from HTML Forms
• Working with cookies
• Working with sessions
• Database Access - CRUD operations
• Creating and testing REST API
• Understanding and enabling CORS
• React
• What is React
• Function components
• Class components
• Rendering HTML
• Using Bootstrap with React
• Using JSX
• Passing data using Props
• Validating props using PropTypes
• Lists and Keys
• Parent and Child relationship
• Handling events
• Handling state
• Hooks - useState() and useEffect()
• Using Context
• Lifting state up
• Form handling
• Uncontrolled Components
• Making AJAX calls using Fetch API and jQuery
• Routing using Router
• Project
• Understanding Project requirements
• Creating Tables in Database
• Create required REST API using Express (Back-End)
• Create React Application (Front-End) to connect REST API (Back-End)
• How to build and deploy application