Syllabus

MySQL
  • Learn both MySQL & Adv. MySQL
  • MySQL & Database Basics
  • Installation
    • Server
    • Workbench (client)
  • DDL - Data Definition Language
    • Tables - Create, Alter, Drop, Auto Increment
    • Constraints - Not Null, Primary Key, Unique Key, Foreign Key
    • Index - Why required, Create, Drop
  • DML - Data Manipulation Language
    • Insert, Update, Delete & Truncate
  • Transactions (T SQL)
    • Commit
    • Rollback
  • DQL - Data Query Language (Select)
  • Filters
    • Operators - <, <=, >, >=, =, !=
    • BETWEEN
    • IN
    • LIKE
    • NOT
    • NULL
    • AND, OR, NOT
    • Multi conditions filtering
    • DISTINCT
    • Limit, offset
  • Sorting
    • Ascending Order
    • Descending Order
    • Multi Column Sorting
  • Functions
    • Data, number, characters, null values etc.
    • Case
  • Groups
    • Basics
    • Grouping functions - AVG, MIN, MAX, COUNT, DISTINCT COUNT
    • Grouping Filters - HAVING
  • Joins
    • Cartesian Product
    • Equi and Non-Equi Joins
    • Left Outer Join
    • Right Outer Join
    • Full Outer Join
    • Self Join
  • SET Operators
    • Union
    • Union All
    • Intersect
    • Minus
  • Subquery
    • Single Valued
    • Multi Valued
  • Views & Inline Views
  • Procedures
    • Programming basics - if..else, for loop
    • Procedures - create, drop
  • Functions
    • create, drop
  • Triggers
    • create, drop
  • Project

Web Designing
  • Overview
    • About Responsive Website Designing
    • VS Code Installation
  • HTML
    • Table Tags
    • Types of Lists
    • Forms
    • Head tag & Meta tag
    • Layout
    • Classes and ID
    • Div Tag
    • Paragraph Tag
    • Formatting Tags
    • Anchor Tag
    • Quotations Tags
    • Marquee Tag
    • Image Tag
  • HTML5 Elements
    • Section Tag
    • Article Tag
    • Source
    • Header
    • Video
    • Audio
  • HTML 5 Validations
  • Meta Tags
    • 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
  • CSS Media Query
    • Overview
    • Creating CSS Media Query Files
    • Device Width wise CSS Programming
  • JavaScript
    • Basics
    • Variables, Operators, Data Types etc
    • Programming
      • If-Else
      • Switch case
      • while
      • Do while
      • For Loops etc.
    • Logic Building Sessions
    • Creating Functions
    • Types of functions
      • Function Expression
      • anonymous function
      • Arrow Function(es6)
    • Inbuilt Functions
      • Date
        • getDate
        • getDay
        • getHours
        • getMinutes
        • getSeconds,etc
      • String
        • toUpperCase
        • toLowerCase
        • includes
        • slice
        • split,etc
      • Numeric
        • round
        • floor
        • ceil
        • random
        • PI,etc
    • Arrays
      • 1-D & 2-D Arrays
      • Array methods
        • push
        • pop
        • slice
        • splice
        • includes,etc
      • Array advance methods (HOF)
        • forEach
        • map
        • filter
        • reduce
    • Objects
    • HTML DOM (Working with Frontend)
      • getElementById
      • getElementByClassName
      • querySelector
      • querySelectorAll
      • document.write etc.
    • JavaScript dialog boxes
      • alert
      • prompt
      • confirm, etc.
    • Event Handling
      • On Click
      • On Keyup
      • On Change
      • On Submit
      • On Keydown, etc.
    • Regular Expressions
      • Delimiters
      • Literal Characters
      • test
      • match, etc.
    • Js Form Validation
  • jQuery
    • Basics
    • Effects
    • DOM Parsing
    • Form Validations
    • Events
    • Creating Functions
    • Inbuilt Functions
      • redirect
      • html
      • text
      • find
      • siblings
      • parents, etc
    • Dynamic CSS Programming
    • Hide and show element etc
  • Bootstrap
    • Basics
    • Introduction to Responsive Website Designing
    • Grid system
    • Card
    • Table & Table Classes
    • Texts & Text Classes
    • Image & Image Classes
    • Button & Button Classes
    • Creating Dropdown
    • Creating Loader
    • Creating Progressbar
    • Breadcrums
    • Pagination
    • List
    • Panel
    • Media Object
    • Font Awesome & Glyphy Icons
    • Forms
    • Menu & Navigation Bar
    • Carousel
    • Tooltip
    • Pop Hover
    • Scroll Spy
    • Affix
    • Bootstrap Modals - (pop ups)
    • Creating Responsive Websites in Bootstrap
    • Project
  • Project

PHP
  • XAMPP Server Installation
  • About PHP Web Development
  • PHP Basics
  • Variables, Constants etc
  • Control Structures
    • If Else
    • Do While
    • While loops
    • For Loops
    • For Each Loops etc.
  • Functions
  • Arrays
  • Logic Building
  • PHP Forms - Get & Post
  • Global Variables
  • Validation
  • Required
  • Date & Time functions
  • File Include
  • Headers & Footers
  • Creating Mini Project
  • Frontend integration with PHP
  • PHP File Handling
  • Image & File Upload
  • Sessions
  • Cookies
  • Error & Exception Handling - Try - Catch Block
  • Creating Functions

Adv. PHP & Rest API
  • PHP OOPs
    • Classes
    • Objects
    • OOPs Concepts
    • Methods etc.
  • MySQL
    • Using PHP MyAdmin
    • CRUD Operations (create, read, insert, update, delete)
  • PHP MySQL Integration
    • Integrating MySQL & PHP
    • Data Display on PHP Forms
    • CRUD Operations using PHP Forms
    • Building a Application using PHP MySQL
  • AJAX & JSON
    • Overview
    • Ajax JSON Integration
    • Select & DML Operations using AJAX JSON with MySQL
    • Display data from JSON on Form
  • REST API
    • Overview
    • Creating REST Api
    • JSON Response
    • Using REST Api
  • Project

Wordpress
  • Installation
  • Configuration
  • Categories
  • Forms/Blogs
  • Blog Posts, Featured Images etc
  • Plugins
  • Project

React.js
  • Pre-requisite: Web Designing + JavaScript(ES6+)
  • Introduction
  • Installing Node.js
  • VS Code Configuration
  • Creating React App
  • Folder Structure
  • JSX Syntax
  • Creating Components
  • Class Components (for understanding older React projects)
  • Functional Components (modern React standard.)
  • Using Components
  • Adding CSS
  • Adding Bootstrap
  • Hooks
    • useState
    • useEffect
    • useParam
    • useLocation etc
  • Event Handling
    • On Click
    • On keyup
    • On change
    • On keypress
    • On keydown, etc.
  • Properties (Props)
    • props destructuring
    • props children
    • props drilling
  • Context API
  • React Router Dom
    • CreateBrowserRoute
    • Routes
    • Route,etc.
  • Working with Forms
  • Rest API with React
  • React with Backend (php / Node.js)
  • CRUD Operations
  • Advance hooks
    • useReducer
    • useMemo
    • useRef
    • useCallback
  • Redux
    • create store
    • useSelector
    • useDispatch , etc
  • AXIOS
  • Taiwind CSS
    • modern styling library
    • breakpoints (layouts)
    • UI first approach
    • Customizing
    • Properties
    • & more...
  • Projects
    • 1. Counter App
    • 2. Password Generator
    • 3. E-Commerce

Addon : Next.js
  • Pre-requisite: React. Duration 3 weeks to 1 month
  • Introduction
    • What is Next.js?
    • Next.js vs React
    • What is SSR in Next.js?
    • Core Features
    • Pre-Rendering (SSG vs SSR overview)
  • Installation & Project Setup
    • Install Node.js
    • Install Next.js
    • Starting Next.js Server
    • Folder Structure
  • Routing
  • Data Fetching & Rendering
  • Functions & APIs
    • NextRequest
    • NextResponse
    • API Routes
  • Metadata & SEO
    • generateMetadata()
    • generateImageMetadata
  • Image Imports & Optimization
  • Database Integration With MongDB & Perform CRUD Operations
  • Styling Support
  • Project

Duration
  • 6 months
  • Looking to complete training quickly? option available, please inquire for more info.
  • more info

Fees
  • Live Online: ₹30000 - ₹25000 (Limited Period)
  • Classroom: ₹35000 - ₹30000 (Limited Period)
  • Individual courses / customized training available - check links in header
  • Classroom - Get Fees
  • Upcoming Batches
Show More