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
    • 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

C# & ADO.Net
  • 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

ASP.Net
  • 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.

Entity Framework (EF)
  • Introduction
  • EF Core & EF 6
  • Types of Approaches:
    • DataBase First
    • Code First
  • Migrations
  • CRUD Operations
  • LinQ with EF

Web API (REST API)
  • 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

ASP.NET MVC
  • 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

.Net Core (addon)
  • 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

Duration
  • Weekdays (MTTF, Wed Off) :
    Option 1 - 6 months - 1.5 to 2hrs/day
    Option 2 - 4 months - 2.5hrs/day (including 10 mins break)

  • Weekends(Sat & Sun):
    Option 1 - 6 to 6.5 months - 2 to 2.5hrs/day
    Option 2 - 4 to 4.5 months - 2.5 to 3hrs/day (including 10 mins break)

Fees
  • Live Online:
  • C# - ₹8000 - ₹6000
  • Dot Net Developer - ₹21000 - ₹17000 (Limited Period)
  • Classroom - Get Fees
  • Individual courses / customized training available
  • Upcoming Batches
Show More