Syllabus
Syllabus
- 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
- Keygen
- Canvas
- 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
- Inbuilt Functions
- Date
- String
- Numeric
- Arrays
- 1-D & 2-D Arrays
- Methods
- Objects
- Event Handling
- On Click
- On Keyup
- On Change
- On Keypress
- On Keydown, etc.
- Regular Expressions
- HTML DOM (Working with Frontend)
- getElementById
- getElementByClassName
- document.write etc.
- Js Form Validation
- Alert box, Prompt, Confirm etc
- 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
- MySQL Server Installation
- MySQL Workbench Installation
- MySQL Basics
- Database models
- ER Model Overview
- Data types
- Understanding Test Database
- Basics Queries
- DDL
- Tables - Create, Alter, Drop
- Constraints - Not Null, Primary Key, Unique Key, Foreign Key
- Indexes - Types, Create, Drop
- DML operations - Insert, Update & Delete
- Insert, Update, Delete & Truncate
- Common Operations
- Writing Queries
- Filters
- DISTINCT
- BETWEEN
- IN
- LIKE
- NOT
- NULL
- AND, OR, NOT etc
- Using Complex Data Filtering Techniques
- Limit, offset
- Sorting
- Ascending Order
- Descending Order
- Complex Sorting
- Functions
- String Functions - lower case, uppercase, substring, instring, trim, group_concat etc.
- Number Functions - round and trunc
- Date Functions - datepart etc
- Null Functions - NULLIF
- Case
- Groups
- Basics
- Grouping functions - AVG, MIN, MAX, COUNT, DISTINCT COUNT etc
- Grouping Filters - HAVING
- Rollups & Cubes
- Analytic (Window) Functions (Bonus)
- 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 Sub Query
- Multi Valued Sub Query
- Views
- Inline Views
- TOP N Analysis
- Bulk Operations
- Required to create test data:
- Creating Tables using queries
- Bulk Data Inserts using Queries
- Updating Data using Queries
- Deleting Data using Queries
- Transactions ( T SQL)
- Commit
- Rollback
- Savepoint
- Procedures and Functions basics
- Project
- 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
- 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
- Pre-requisite: Web Designing
- Introduction
- Installing Node.js
- VS Code Configuration Creating React App
- Folder Structure
- JSX Syntax
- Creating Components
- Class & Functional Components
- Using Components
- Event Handling
- On Click
- On keyup
- On change
- On keypress
- On keydown, etc.
- Adding CSS
- Adding Bootstrap
- Properties
- Router
- Hooks
- useState
- useEffect
- useParam
- useLocation etc
- Working with Forms
- Rest API with React
- React with Backend (php / Node.js)
- CRUD Operations
- Redux
- AXIOS
- Taiwind CSS
- Project
- 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
- 6 months (can be completed little earlier, please contact with our counsellors for more info)
- Upcoming Batches
- Get Fees
