Syllabus

Full 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

Python & Advanced Python

Introduction & Installation
- Introdution
- Installing Python
- Installing Pycharm
- Configurations
Programming Basics
- Variables
- Data Types
- User Inputs
- Unpacking
- Boolean Practice
- What If, Else and If, Making Decisions
- For Loops
- Break Continue Pass
- Break Vs Continue Vs Pass
Data Structures
- List
- Tuple
- Set
Logic Building & Programming
- Pattern Programs
- Prime Number
- Fibonacci Sequence
- Factorial
- Recursion
- Swap 2 Variables
Data Structures
- Linear Search
- Bubble Sort
Functions
- Creating Functions
- Functions Arguments
- Type of Arguments
- Keyworded Variable Length Arguments
- Using Built in Functions
- Global Keywords
- Passing List to Functions
Anonymous Functions / Lambda
Filter / Map Reduce
Decorators
Modules
OOPs Programming
- Modules
- Special variable _name_
- Class & Object
- _init_ method
- Constructor, Self and Comparing Objects
- Types of Variables
- Types of Method
- Inner Class
- Inheritance
- Constructor in Inheritance
- Introduction to Polymorphism
- Duck Typing
- Method Overloading
- Method Overriding
- Iterator
- Generators
Exception Handling
File handling
MySQL Server Setup
- Installing and Configuring MySQL Server
- Creating Database
- CRUD Operations
- Create Tables
  - Insert
  - Update
  - Delete
Database Integration with Python
- Connection to Database from Python
- Writing functions to handle database operations
- CRUD Operations in python
Web Scrapping
- Beautiful SOUP library
- Parsing HTML files
- Getting Data from Any Website
Data Analytics (NumPy & Pandas)
- Installing & Understanding Analytics Packages
- NumPy Array Operations
- Pandas Data Frame Operations
- Data Acquisition (Import & Export)
- Indexing
- Selection
- Sorting
- Filtering
- Group By
- Binning
- Concatenation
- Merge
- Append
- Drop
Data Visualization
- Installing Matplotlib & Seaborne libraries
- Charts & Plots
  - Histogram
  - Scatter Plots
  - Box Plots
  - Line Chart
  - Bar Chart
  - Pie Chart etc.

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

PHP, MySQL, REST API & WordPress

Technologies
- PHP, MySQL, React & WordPress
XAMPP Server Configuration
- XAMPP Server Setup
- Configuring PHP & MySQL Admin
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
Advanced PHP
- File Includes
- Headers & Footers Implementation
- Creating Mini Project o Integrate Website designed in Web Designing Course with PHP o Implementing Common Headers & Footers in Website Using PHP o Integrate CSS, Javascript, JQuery etc with PHP o Integrating Google APIs etc.
- PHP File Handling
- Image & File Upload
- Sessions
- Cookies
- Error & Exception Handling - Try - Catch Block
- Creating Functions & Routines
PHP OOPs
- Classes
- Objects
- OOPs Concepts
- Methods etc.
Creating Web Development Project
- Using Session and all Above Concepts
PHP MySQL
- Using PHPMyAdmin
- MySQL Configuration
- CRUD Operations
  - Create
  - Drop
  - Select
  - Insert
  - Update
  - Delete etc.
  - 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
- Wordpress
  - Installing Wordpress
  - Configuring Wordpress
  - Creating Categories
  - Creating Forms/Blogs
  - Deployment
- Live Project

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

Duration

Full Stack Developer - 6 months
Upcoming Batches
Get Fees

Fees

6 months:
Live Online - ~~₹30000~~ - ₹25000 (Limited Period)
Classroom - Get Fees
Upcoming Batches

Full Stack Developer Course | Full Stack Developer Career Path