Web Design and Application Development (NodeJS + React + MySQL + MongoDB) (MERN)

Lecturer
fitimanager
0 Reviews
Apply For This Course

Course Description

Course fee  – ₦ 200,000

WEB DESIGN AND APPLICATION DEVELOPMENT (NODEJS + REACTJS + MYSQL + MONGODB)

WEEK 1

  • Introduction to Web Development.
  • Introduction to Version Control (GIT)
  • Introduction to HTML, Tags and Attributes.
  • HTML Style Guide
  • HTML Forms
  • HTML Media
  • HTML Graphics

WEEK 2

  • Introduction to CSS, types of CSS and using CSS Selectors.
  • CSS properties and variables.
  • Web design project using HTML and CSS.
  • Responsive CSS and CSS Media Queries.
  • Version Control (GIT)

WEEK 3

  • Introduction to JavaScript.
  • Data types and Variables.
  • JavaScript Operators.
  • Objects and Arrays.

WEEK 4

  • Condition Statement in JavaScript.
  • Looping in JavaScript (while loop, for loop, for-each loop etc.).
  • JavaScript Functions.
  • JavaScript Classes.
  • Destructuring
  • Import & Export
  • Filter & Map Methods
  • Spread syntax

 

 

 

WEEK 5

  • Template String
  • Arrow function
  • DOM Manipulation in JavaScript.
  • JavaScript Event Handlers.
  • Handling HTML Forms in JavaScript.
  • Session and Local storage in JavaScript.
  • Promises in JavaScript (Async / Await).
  • Project on Web Design and development using Html, CSS and JavaScript.

WEEK 6

  • NodeJs and NPM
  • Introduction to ExpressJs.
  • Installing ExpressJs and Building a Web Server.
  • Routes in ExpressJs
  • Static Files and Middleware.
  • Templates and Template Engine.

WEEK 7

  • Form Handling and Validation in ExpressJs.
  • Sessions and Cookies in ExpressJs.
  • RESTful APIs and JSON, GET and POST requests.
  • User Authentication using cookies and session.
  • Structuring and Managing an ExpressJs Application.

 

WEEK 8

  • Database Fundamentals (Databases, Relational Database and Basic SQL)
  • MySQL Database.
  • Installation and Setup
  • Database Tables and Relationships.
  • Database Queries.
  • Implementing Node Js and MySQL
  • Basic CRUD

 

 

 

 

WEEK 9

  • MongoDB
  • Installation and Setup
  • Basic CRUD of MongoDB : Creating, reading, updating, and deleting documents.
  • Understanding the basic syntax for MongoDB CRUD operations.
  • Designing MongoDB schema for efficient data retrieval.
  • Choosing between embedded and referenced data models.
  • Querying documents using the MongoDB Query Language (MQL).
  • Authentication and authorization in MongoDB.
  • Configuring user roles and permissions.
  • Exploring MongoDB’s cloud-based database service.
  • Setting up and managing databases on MongoDB Atlas.
  • Implementing NodeJs and MongoDB
  • Basic CRUD

WEEK 10

  • Introduction to ReactJs.
  • Using react using a CDN.
  • Installing Nodejs.
  • Creating a react app/website.
  • JSX & React component structure.
  • Class based and Function based React components.
  • Introduction to props.

WEEK 11

  • CSS Styling and Inline Styling in ReactJs.
  • Life-cycles in ReactJs.
  • Introduction to React Hooks (useState and useEffect).
  • Custom React Hooks.

 

Context API and Redux (Redux ToolKit)

  • Managing state with Context API
  • Introduction to Redux for state management
  • Actions, Reducers, and the Store in Redux
  • Higher Order Components.
  • Working with forms in ReactJs.

 

 

WEEK 12

  • Event Handling in ReactJs.
  • Using useCallback, useMemo and useRef Hook.
  • Introduction to React Router.
  • React Router Setup.

 

WEEK 13

  • Links and NavLinks.
  • Multi Page React Sites.
  • Unit testing with Jest and React Testing Library
  • Deploying React app to popular platforms (Vercel, Netlify, etc.).
  • Best practices for optimizing performance
  • Introduction to code splitting and lazy loading

 

WEEK 14

Portfolio Projects

  • Create LinkedIn Account
  • Create Fiverr Account
  • Project 1 (Personal Portfolio): Build a portfolio website showcasing your skills, projects, and contact information.
  • Project 2 (Weather App): Build a weather application that fetches data from a weather API and displays current conditions.

WEEK 15

  • Project 3 (TO-DO-LIST): Develop a to-do list app with the ability to add tasks, mark them as complete, and filter by status.
  • Project 4 (Blog Platform): Build a simple blog platform where users can create, edit, and delete blog posts.

WEEK 16

  • Capstone Project
  • Examination
  • Project Presentation

 

Course Info

  • Course Duration: 16 Weeks
  • Skill Level: intermediate