Syllabus
Syllabus
- 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
- 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
- VS Installation
- Visual Studio (community edition) Installation
- Understanding IDE Features and Shortcuts
- Creating First Project
-
Basics
- Introduction
- History of C#, .Net Framework, .Net Core etc.
- Variable, Keywords & DataTypes
- Expression & Operators
- Methods & Parameters
- Call by value/reference, ref, out, params
-
Control Statements
- if-else
- switch-case
- while & do while
- for loops, for-each
- break, continue, goto etc
- Arrays & Collections
- 1D, 2D, Jagged Arrays
- Structures (struct)
- Enum
- Type Conversion (Casting)
- Boxing & Unboxing
- String & DateTime Methods
- Logic Building & Programs
- Pattern Programs
- Factorial
- Prime number
- Palindrome
- Swap two variables (with/without temp)
- Recursion
- Armstrong Number
- Object-Oriented Programming (OOPs)
- Class & Object
- Constructor, Destructor
- Inheritance (IS-A)
- Composition / Aggregation (HAS-A)
-
Polymorphism
- Method Overloading
- Method Overriding
- Access Specifiers
- Encapsulation >> Properties - SET/GET
-
Abstraction
- Abstract Class
- Interface
- Static Keyword, Static Constructor
- Nested Classes
- Advanced C#
- Delegates
- Events
- Exception Handling
- Try, Catch, Finally, Throw
- Custom Exceptions
- Anonymous Methods
- Lambda Expressions
- Extension Methods
-
Collections
- System.Collections
- Hashtable
- ArrayList
- Stack, Queue
-
System.Collections.Generics
- Stack
- Queue
- HashSet, SortedSet
- List
- SortedList
- LinkedList
- Dictionary
- SortedDictionary
- Generics
- Generic Methods & Classes
- Constraints
- Multi Threading
- Thread Class
- ThreadPool
- Locking
- Task-based Asynchronous Programming
- async/await
- File IO
- Read/Write Text File
- Read/Write Binary File
- FileStream, StreamReader, StreamWriter
- Serialization
- XML Serialization
- JSON Serialization (using System.Text.Json, Newtonsoft.Json)
- Deserialization
- LINQ (Language Integrated Query)
- LINQ to Objects
- LINQ Methods: Where, Select, OrderBy, GroupBy, Join
- Query vs Method Syntax
- Anonymous Types, Projection
- SQL Server
- SQL Server Installation & SSMS
- Data Types
- CRUD Operations (create, read, insert, update, delete)
-
ADO.NET (Database Integration)
- Connected Architecture:
- SqlConnection, SqlCommand
- SqlDataReader
- Disconnected Architecture:
- DataSet, DataTable
- DataAdapter
- CommandBuilder
- ExecuteScalar, ExecuteReader, ExecuteNonQuery
- Introduction
- Page LifeCycle
- HTML, CSS as required
- Controls and Properties
- WebConfig & Global.aspx File
- Master Page, Themes
- Session, Cookies, ViewState
- Authentication & Authorization
- Note - ASP.net is now not much used in industry, however basics are required to learn Asp.net MVC hence covered here as required.
- Introduction
- EF Core & EF 6
-
Types of Approaches:
- DataBase First
- Code First
- Migrations
- CRUD Operations
- LinQ with EF
- Introduction
- Introduction to REST
- HTTP Verbs (GET, POST, PUT, DELETE)
- C# with Web API
- Route Configuration
- Consuming APIs with Postman
- Return Types (IHttpActionResult, IActionResult)
- Token-Based Authentication (JWT)
- Calling APIs from JavaScript / jQuery
- Introduction
- Architecture
- Setup
- HTML & CSS Form designing
- Building First Application
- Creating basic project
- Creating forms using HTML, CSS, Bootstrap.
- Routing
- Controllers, Actions
- Views & Razor Syntax
- ViewModel
- HTML Helpers
- State Management - Cookies, Sessions, Query String etc
- TempData, ViewData, ViewBag
- Model Binding
- Validation
- Partial Views, Layouts
- CRUD with EF (Code First/Database First)
- Filters: ActionFilter, Authorization
- Dependency Injection
- AJAX JSON Integration
- Web API (REST API) integration with Ajax and Json
- Project
- Pre-requisite - .Net MVC
- Introduction
- Setup
- Building First Application
- Understanding Main Method
- Startup Class
- Middleware
- Request Processing Pipeline
- wwwroot folder
- Built-In Middleware
- Configuring Default Page & Custom Default Page
- Exception Page
- Exception Handling
- Static files
- Bootstrap Integration
-
MVC
- Creating Models
- Creating Controller
- Creating Views
- Razor view
- Tag Helpers
-
Binding Model with Views
- Working with ViewBag,ViewData and TempData
-
Input Validation
- Server Side Validation
- Client Side Validation
- Built-In Tag Helpers
- Http Verbs - Get, POST, PUT, DELETE
-
URL Routing
- Endpoint Routing
- Attribute Routing
- Creating Partial View
- Import View
- Layout View
-
State Management
- Hidden Field
- Cookies
- QueryString
- Session
- Temp Data
- Basic Form Based Authentication and Authorization
-
Dependency Injection
- UnderStanding DI
- Implementing
- Using ADO.Net to communicate with DataBase
- Creating CRUD Application
- Live Project
- 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
- 7 to 8 months (can be completed little earlier, please contact with our counsellors for more info)
- Upcoming Batches
- Get Fees
