Syllabus

Job Opportunity

MERN Stack Developer Course

SQL
  • Oracle 18/21c Installation
  • Basics
    • Oracle Basics
    • Database models
    • ER Model Overview
    • Data types
    • Understanding Test Database
    • Basics Queries
    • Arithmetic and String functions
    • DML Operations - Insert, Update and Delete
    • FETCH command - Top N, Top % Rows
  • Writing Queries
  • Filters
    • DISTINCT
    • BETWEEN
    • IN
    • LIKE
    • NOT
    • NULL
    • AND, OR, NOT etc
    • Using Complex Data Filtering Techniques
  • Sorting
    • Ascending Order
    • Descending Order
    • Complex Sorting
  • Functions
    • String Functions - lower case, uppercase, substring, instring, trim etc.
    • Number Functions
    • Date Manipulation
    • Null Value Functions - NVL, NVL2, NULLIF, COALESCE
    • Conditional Expressions - Case and Decode
  • Groups
    • Basics
    • Grouping functions - AVG, MIN, MAX, COUNT, DISTINCT COUNT etc
    • Grouping Filters - HAVING
    • Rollups & Cubes
  • Analytic (Window) Functions
    • Over() with summary functions
    • Partition By Queries
    • ROW_NUMBER()
    • RANK()
    • DENSE_RANK()
  • Joins
    • Cartesian Product
    • Equi and Non-Equi Joins
    • Left Outer Join
    • Right Outer Join
    • Full Outer Join
    • Self Join
    • Complex Queries - Joins & Groups Integration
  • SET Operators
    • Union
    • Union All
    • Intersect
    • Minus
  • Subquery
    • Single Valued Row Sub Query
    • Multi Valued Sub Query
  • Views
  • Inline Views
  • ROWID & ROWNUM
  • TOP N Analysis or Complex Inline View
  • DDL
    • Tables - Create, Alter, Drop
    • Indexes - Types, Create, Drop
    • Constraints - Not Null, Primary Key, Unique Key, Foreign Key
    • Sequence
    • Synonyms
  • Foreign Keys
  • DML operations - Insert, Update & Delete
    • Insert, Update, Delete & Truncate
    • Common Operations
    • Creating Tables using queries
    • Bulk Data Inserts using Queries
  • Transactions ( T SQL)
    • Commit
    • Rollback
    • Savepoint
  • DCL - Grant & Revoke
  • Project

Web Designing (Frontend)
  • Overview
    • About Responsive Website Designing
    • VS Code Installation
  • HTML & HTML 5
    • Table
    • Types of Lists
    • Forms
    • Head tag & Meta tag
    • Layout
    • Classes and ID
    • Div Tags
    • Section Tags
    • HTML 5 new element
    • HTML 5 Validations
  • On-page SEO Techniques
    • Meta Tags - Title, Description, tags etc.
    • Header Tags - H1, H2, H3, H4, H5 etc.
  • CSS & CSS3
    • Basics
    • Background Image & Colors
    • Selectors
    • Declaration & Types
    • Fonts & Text Properties
    • Text Shadow, Gradients etc.
    • Overflow & Display Properties etc.
    • Effects - Border Raidus, Box Shadow etc
    • Box Model - Border, Margin etc
    • Units in css
    • Positions - Static, Absolute, Relative, Fixed, Sticky etc
    • Transforms - 2d & 3d Effects
    • Transitions - Color Effects
    • Animations
    • Menu & Navigation Bar
    • Chrome's Inspect Element for Desktop & Mobile for Runtime CSS Manipulations
  • SASS OR SCSS
    • Introduction
    • Installation
    • Variables
    • Nesting
    • Import
    • Mixin
    • Extends
    • Functions
  • CSS Media Query
    • Overview
    • Creating CSS Media Query Files
    • Device Width wise CSS Programming
  • JavaScript
    • Basics
    • Variables, Operators, Data Types etc
    • Control Structures - If-Else, while, Do while, For Loops
    • Logic Building Sessions
    • Creating Functions
    • Inbuilt Functions - Dates, Strings, Numerics etc
    • Arrays
    • Objects
    • Events
    • Regular Expressions
    • HTML DOM
    • Alert box etc
  • jQuery
    • Basics
    • Effects
    • DOM Parsing
    • Form Validations
    • Events
    • functions
    • Creating Images
    • Dynamic CSS Programming
    • Hide and show element etc
  • Bootstrap
    • Basics
    • Grid system
    • Tables
    • Images & Buttons
    • Font Awesome & Glyphy Icons
    • Pagination
    • Forms
    • Menu & Navigation Bar
    • Carousel Plugin
    • Bootstrap Modals - (pop ups)
    • Creating Responsive Websites in Bootstrap
  • Project

MongoDB
  • MongoDB
    • What is MongoDB?
    • Use of MongoDB
    • Queries in MongoDB
    • CRUD Operation in MongoDB
    • MongoDB Compass in Reactjs
    • How to connect MongoDB with NodeJs
    • MongoDB create Database
    • MongoDb Insert
    • MongoDb Find
    • MongoDb Sort
    • MongoDb Delete
    • MongoDb Update
    • MongoDb Limit

Node.js
  • Node.js
    • What is Node.js?
    • Installation
    • Features of NodeJS
    • Use of NodeJS
    • Event loop in NodeJS
    • Express in Nodejs
    • Api in NodeJS
    • SetTimeout and Promises in NodeJS
    • Folder Structure of NodeJS
    • Get Post Put Delete Method in Reactjs
    • How to connect Reactjs With NodeJs
    • Streams in NodeJS
    • Modules in NodeJS
    • Http
    • fs etc.

Express.js
  • Express.js
    • What is ExpressJS?
    • Use of ExpressJS
    • Get Post Update Delete Method in ExpressJS
    • Routing in ExpressJS
    • URL Building
    • Middleware
    • Database
    • Cookies
    • Sessions
    • Authentication
    • Restful APIs
    • JSON response

React.js
  • Why use ReactJs
  • Download & Install VS Code IDE for React
  • Folder Structure
  • Modal Javascript
  • JSX Syntax
  • SASS or SCSS
  • Module Import Export
  • Create Reusable Components
  • Props
  • React Developer Tools Debug
  • Hooks (useState, useEffect, useParam, useLocation,etc)
  • Memorize for performance boost
  • Working with Forms
  • NPM
  • Adding Bootstrap and Material UI
  • Call Rest API in React and CRUD operations
  • React with Backend (php / Node.js)
  • React Router
  • Project
Show More
MERN Stack Developer Course & Career Path

Syllabus