-
MS SQL Server 2019
11 Lessons-
PreviewDay 2 - Introduction To RDMS An Create - Database - Table - Primary key - Unique Key - Identity Column - Default Value - Check Constraint
-
PreviewDay 3 - DataTypes - ForeignKey - FKConstraints - Identifying Objects And Relationships
-
StartDay 4 - Three Key Rules Of Db Design - Task - Insert - Parameterized Query - Update - Delete
-
StartDay 5 - Task IT Workshop DB Design - Select - Aliasing - Derived Columns - Sorting(Order by multiple cols, Top) - Filtering(Where, in, not in, between, not between, is null, soundex)
-
StartDay 6 - Scalar Functions - String - Casting - Others - Mathematical - Aggregate - DateTime - Convert - Group By
-
StartDay 7 - Group By In-depth - Joins - Joining Two Tables - Joining Multiple Tables
-
StartDay 8 - Self Join - Union - Simple Sub Query - Correlated Sub Query - Views
-
StartDay 9 - CTE - Strored Procedures In depth - if else - Scalar Functions - InLine Fuctions - TopperFromEverySubject
-
StartDay 10 - Transactions - Scope Identity - Slowly Changing Dimensions
-
StartDay 11 - Update Salary Transactions - Case Group By - Triggers
-
StartDay 12 - Triggers Implementation - DbScript - BackUp - Restore
-
-
C# On .Net 6
11 Lessons-
PreviewDay 13 - Introduction To C# - .Net Framework Vs .Net Core - dll Vs exe - Top Level Statement - Introduction To VS2022 (Edited)
-
StartDay 14 - String Formatting - Parsing - Type Casting - DataTypes - var Vs Dynamic - Nullable Types - Common Type System - Introduction To Control Structure (Edited)
-
StartDay 15 - If Else - Else If Ladder - Switch Case Default - For Loop - While Loop - Do While Loop (Edited)
-
StartDay 16 - Arrays - Foreach Loop - Array Class - 2D Arrays - Issues With Arrays - Structures - Methods - Array Of Structures (Edited)
-
StartDay 17 - Object - Class - Fields - Methods - Public - Private - Access Specifiers - Constructor - Constructor Over Loading - Method Overloading - Topper Student From Array (Edited)
-
StartDay 18 - this Keyword - Optional Parameters - Why Do We Need Properties - Properties - Auto Properties (As is)
-
StartDay 19 -Static Fields - Static Constructor - Static Properties - Static Methods - Static Classes - namespaces - Creating And consuming dll in Console And WindowsUI (As Is)
-
StartDay 20 - Inheritance - Protected - Single and Multilevel Inheritance - Constructor Chaining Using Base Keyword - Method Overriding and Other Use of base keyword (As Is)
-
StartDay 21 - sealed Methods and sealed Classes - abstract Method And abstract Class - Diagram - Runtime Polymorphism - Method Overriding - Employee - Runtime Polymorphism - Method Overriding (As Is)
-
StartDay 22 - Interfaces - Multiple inheritance - Partial Classes and Partial Methods - Value Type Vs Ref Type - Call By Value and Call By Ref - ref Vs out Parameters (As Is)
-
StartDay 23 - Collection Classes - Generic Collection - List - Intro To LINQ - Exception Handling (As Is)
-
-
EF Core 6
8 Lessons-
PreviewDay 24 - Introduction To EF Core Code First And 6 - Step Process To Create DB Structure (As Is)
-
StartDay 25 - Basics Of EF Core - DatabaseStructureUpdates-DataAnnotations-CRUD-LINQ-QueryVsLamdaExpression (As Is)
-
StartDay 26 - Class Design Techniques - Is-A and Has-A Relationship - 1 to 1, 1 to many and many to many Relationship (As Is)
-
StartDay 27 - First() Vs FirstOrDefault() - Single() Vs SingleOrDefault() - NavigationProperty - IEnumerable Vs IList (As Is)
-
StartDay 28 - Immediate Mode Vs Differed Mode Of query Execution - Eager Loading Vs Explicit Loading Vs Lazy Loading (As Is)
-
StartDay 29 - Eager Loading - Include() and ThenInclude() - Raw SQL - Working With SPs in EFCore - Auto Transactions (As Is)
-
StartDay 30 - Manual Transactions (As Is)
-
StartDay 31 - n Layered Architecture (As Is)
-
-
ASP.Net Core Web APIs
10 Lessons-
PreviewDay 32 - Introduction To ASP.Net Core 6 - Creating Static Website - Template Editing - Hosting It Live (As Is)
-
StartDay 33 - Introduction To SOA - ResTfull - Web APIs (As Is)
-
StartDay 34 - Creating First Web API - Get Method Oer Loading - Parameter Passing Mechanism - Return JSON Result (As Is)
-
StartDay 35 - CRUD EF Dll Use In Web API - Fiddler - Response Codes - ActionResult - IActionResult (As Is)
-
StartDay 36 - async - await - Dispose() Method - using(resource) - IDisposable Interface - DI - Model Validations - Exception Handling (As Is)
-
StartDay 37 - Custom Validator - 2 Solutions For Reference Looping Problem - Generating Data As XML (As Is)
-
StartDay 38 - Swagger - OpenAPI - Exception Handling In Middleware - Intro to Authentication And Authorization (As Is)
-
StartDay 39: InitialSecuritySetupIn5Steps-AuthenticationAtAllLevels-Register-SignIn-SignOut (As Is)
-
StartDay 40 - Creating Roles - Assigning Roles Dynamically - Authorization - Getting LoggedIn UserId (As Is)
-
StartDay 41 - Complete JWT Authentication And Authorization
-
-
Angular 13
9 Lessons-
PreviewDay 1 - Getting Started With Angular 13 (As-Is)
-
StartDay 2 - Angular 13 on VS 2022 - app.component - app.module - Basic Terminologies (As-Is)
-
StartDay 3 - Data Binding - Two way Binding ngModel - Create Component - *ngIf and *ngFor - Types Of Data (As-Is)
-
StartDay 4 - Adding Bootstrap 5 To Angular - Bootswatch Theme - Paging - Searching - Sorting -Dynamic Page Size - In Data Grid (As-Is)
-
StartDay 5 - Creating WebAPI From Scratch - HttpClientModule - Making API calls with HttpClient Object (As-Is)
-
StartDay 6 - Dropdown List Cascade With Grid - Template Driven Forms - Insert Employee (As-Is)
-
StartDay 7 - Models In Angular Project - Class Designing On Client Side - Server Side Form Validations And Exceptions (As-Is)
-
StartDay 8 - Client Side Validation - Delete - Update - Services - Nav Bar - Routing - Full App Integration (As-Is)
-
StartDay 9 - Web Storage Or State Management - cookies -sessionStorage - localStorage (As-Is)
-
-
Angular 13 Live Project
10 Lessons-
StartDay 1 - Introduction To Project Architecture - Creating BOL (Customizing ASP.Net Identity User) - DAL - Web API (Back-end Initial Setup)
-
StartDay 2 - Creating UI - Project Setup - Creating The Complete Directory Structure - Conf Routing With Batch Files For All Commands
-
StartDay 3 - Adding New actions To Web APIs - UI APIs Service Implementation - Reactive Forms - Post Story Implementation - Form Validation Both Server Side And Client Side
-
StartDay 4 - Approve Story - Read Story - Configuring Authentication And Authorization On Server - User Register With Dynamic css Class Binding
-
StartDay 5 - Login On Sever Side - Login On Client Side - Display Logged In User Name And Role - Complete Authentication And Authorization Implementation
-
StartDay 6 - Securing UI With AuthGuard Services - JWT Security Configuring On Server Side And Client Side - Creating Category Screen Flow (As-Is)
-
StartDay 7 - HTTPInterceptor - Profile Pic Upload To Web API- Profile Pic Display - Passing Model And File In FormData
-
StartDay 8 - Loading Bar - Angular CSV File Download - Bar Charts - Pie Charts - Reports
-
StartDay 9 - appsetting File In Web API - Moving And Accessing ConStr And JWT From appSetting - Creating Roles And Admin At Runtime - Implementing Complete Google Login
-
StartDay 10 - Enhancing The Architecture With Repository And Unit Of Word Design Patterns
-
Full Stack ASP.Net Core 6 and Angular 13 Web Developer - Coding Bootcamp
From Scratch To Advanced Level
Course Description
Answering couple of questions for you...
Who is The ASP.Net Full Stack Web Developer?
A Full Stack Developer has knowledge of both front end and back end technologies. The front end is the visible part of the application that users interact with which includes HTML5, Bootstrap 5, Typescript And Angular 13. The back end includes the server ASP.Net Core 6 Web APIs, database EF Core 6 On MS SQL Server, and application programming language C#.Net Core that power the front end. You may think of a ‘stack,’ in the term full stack, as the layers of technology used to create a complete application.
How To Become A Full Stack Web Developer?
Our 12-Week Coding Bootcamp is the fastest and most efficient way to become a Full Stack Web Developer. Coding bootcamps typically teach both technical skills and career success skills which help you secure and grow in your jobs after bootcamp. Our Passout students are earning between 7000$ (5 Lacs) to 16000$(12 Lacs) Per Annum in India and between 15,000$ to 90,000$ Per Annum in overseas. (The average base salary in the L.A. area is $72,309, according to Glassdoor.com)
Is this a recorded session?
Yes, this is the recorded session from previous bootcamp batch.
What you will learn?
We’ve been teaching people how to code since 2007 and are committed to excellence. you will be able to:
- Use MS SQL with real time database designing techniques, Writing complex Joins Queries, Stored Procedures, Functions, Views, Transactions, Triggers and lot more.
- Code using C#.Net Core Programming with .Net Framework, ,Net Core And .Net Standard Libraries. Implement Inheritance, Runtime Polymorphism, dlls, Generic Collections with LINQ.
- Write data access logic using Entity Framework Core Code First Approach with Class Design Techniques Using 3 Layered Approach for accessing database using Unit of Work, Iterator, repository, dependency injections, design patterns.
- Learn Basics Of Web Development With HTML5, Bootstrap 5, JavaScript, TypeScript On Visual Studio, Various Events, Stand Alone Object/s And JSON List.
- Implement And Consume First ASP.Net Core Web API, CRUD Operations With Entity Framework, Enhancing CRUD Operations using HttpMessageHandler, IHttpActionResult, Action Filters And Routing, Exception Handling, Dependency Injections And Identity Server For Authentication And Authorization,Cookies and JSON Web Token (JWT) based.
- Design beautiful responsive single page app UI with Angular 13: TypeScript, Angular-CLI designing Components, project structure,Observables,HttpClient, Http requests (GET, PUT, POST), Configuring headers, Interceptors, Progress events, Angular Router, Angular Modules, directives and Pipes, Reactive Forms, State management.
- Implement a live project with all the above technologies learnt with google social login and our full support using all of the above technologies that you have coded. Finally, we will host it live on Azure Cloud Services.
See what our bootcamp students have to say
Course Curriculum
Manzoor Ahmed Mohammed
Manzoor is a Microsoft Certified Trainer who has been working on MS .Net technologies for more than a decade. Apart from development he is also passionate about delivering training on various MS .Net technologies and he has 10+ years of experience as a software development teacher. He writes articles for code-project as well. His YouTube channel has 1 million hits. He is the founder of ManzoorTheTrainer portal.
"I focus on simplifying, complex concepts..." - ManzoorTheTrainer