-
MS SQL Server 2022
13 Lessons-
PreviewInstalling SQL Server 2022
-
PreviewDay 3 - Introduction To RDMS An Create - Database - Table - Primary key - Unique Key - Identity Column - Default Value - Check Constraint
-
StartDay 4 - Data Types In SQL Server - Table Design Techniques
-
StartDay 5 - Foreign Key - Database Design Techniques - one to many - Many to many relation ship - Task
-
StartDay 6 - Database Design Techniques - Heart Of Db - Users And Roles
-
StartDay 7 - T-SQL - DDL - DML - Insert - Delete - Delete Vs Truncate - Update - Concurrency Control - Dummy Data Generation
-
StartDay 8 - Select - Aliasing - Derived Columns - Sorting(Order by multiple cols, Top) - Filtering(Where, in, not in, between, not between, is null, soundex)
-
StartDay 9 - Scalar Functions - String - Casting - Others - Mathematical - Aggregate - DateTime - Convert
-
StartDay 10 - Group By - Having - Inner Join - Outter Join - Left - Right - Full
-
StartDay 11 - Joining multiple tables - Selfjoin - Union(Set) - Simple Sub Queries(Scalar, Multi Valued) - Nested Sub Queries
-
StartDay 12 - Correlated SubQueries - CTE - Views On Single And Multiple Tables - Stored Procs With Input And Output Params - if else in Proc
-
StartDay 13 - Functions (Scalar - Table Valued) - Transactions (Try Catch) - Scope_Identity() - Triggers
-
StartDay 14 - Triggers(inserted and deleted Tables) - Maintan History Trigger - Script Database - Backup Database - Restore Database
-
-
C#.Net
13 Lessons-
PreviewDay 15 - Introduction to C# With Basic Operations - Type Casting - Nullable Types - All The Data Types
-
StartDay 16 - var Vs dynamic - Control Structures (if, if else, else if ladder, swith case default,for, while,do while) - Ternary Operator
-
StartDay 17 - for - foreach - Arrays - Arrays Methods(Sort, Reverse) - 2DArrays - sum Logic - max Logic
-
StartDay 18 - Jagged Arrays - Structures - Array Of Structures
-
StartDay 19 ( Part - 1 & 2) - Class, Fields, Methods, Object, Access Specifiers - Constructors - Default Constructor - Constructor Overloading - Param With Name
-
StartDay 20 - Static Polymorphism - two Uses this Keyword - Properties - Latest Style Of Writing Classes - Lambda Expression For Derived Property - Writting Methods with return types - Writting Classes in
-
StartDay 21 - Static (variables, constructors, methods, classes, properties) - namespaces - nested namespaces
-
StartDay 22 - Creating DLL - Using DLL - In Console and Windows - ExeVsDll -Net FW Vs Net Core - CLR - CTS
-
StartDay 23 - Call By Value - Call By Ref - Out Parameters - Passing Arrays as Parameters - Passing Objects As Parameters - Tuples - Returning Objects As Parameters
-
StartDay 24 - is-a/an Relationship - Inheritance - Generalization & Specialization - has-A Relationship - Association - Single Level - Multi Level - C# Does Not Support Multiple Inheritance
-
StartDay 25 - Constructor Chaining With base Keyword - Method Overriding - Other Use Of base Keyword - sealed method and sealed class - abstract method And abstract class - Runtime Polymorphism - Diagram C
-
StartDay 26 - interfaces - Multiple Inheritance - RealTime Implementation Of Interfaces - Dynamic Interfaces - Generic Interfaces - object Class - partial Classes - anonymous type
-
StartDay 27 - System.Collections - Stack, Queue & ArrayList - System.Collections.Generic - Stack, Queue & List - LINQ - Query Expression - Lamda Expression - Exception - try, catch and finally
-
Full Stack ASP.Net Core 8 and Angular 17 Web Developer Coding Bootcamp 1 of 3
Accelerate Your Base For Web Development Journey: From SQL Server and C#.Net
Unlock Your Future in Tech with Our Full-Stack ASP.NET Core 8 and Angular 17 Web Developer Coding Bootcamp!
Are you ready to elevate your career and master the art of full-stack development? ManzoorTheTrainer brings you an immersive and highly practical video course designed to transform you into a skilled web developer. Introducing the Full-Stack ASP.NET Core 8 and Angular 17 Web Developer Coding Bootcamp!
Why Choose This Bootcamp?
- Comprehensive Curriculum: Dive deep into the world of web development with a course that covers everything from the fundamentals to advanced topics in ASP.NET Core 8 and Angular 17.
- Hands-On Learning: Learn by doing. Our bootcamp is packed with real-world projects and examples that ensure you can apply what you've learned immediately.
- Expert Guidance: Gain insights and knowledge from Manzoor Ahmed, a seasoned trainer with years of industry experience and a passion for teaching.
- Flexible Learning: Access high-quality video content at your own pace, enabling you to learn whenever and wherever you want.
Days 1-2: ASP.Net Core Web Development Coding Bootcamp
- Introduction to ASP.Net Core
- Creating and deploying a static web site using plain HTML
- Developing your first portfolio and making it live online
Days 3-14: MS SQL Server 2022
- Installing and working with SQL Server 2022
- Understanding relational database management systems (RDMS)
- Database design techniques including primary keys, foreign keys, and data types
- T-SQL fundamentals such as DDL, DML, and data manipulation operations
- Advanced topics like subqueries, views, stored procedures, transactions, and triggers
- Database maintenance tasks including backup, restore, and script database operations
Days 15-27: C#.Net
- Introduction to C# programming language
- Basic operations, data types, and control structures
- Arrays, structures, classes, inheritance, and polymorphism
- Working with interfaces, collections, LINQ, and exception handling
- Exploring advanced C# concepts such as generics, partial classes, and object-oriented principles
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
Disclaimer: Recorded Live Session
Please note that the content presented in this video course is a direct recording of a live session and has not undergone any editing or modifications. The purpose of this recording is to provide an authentic representation of the original session, including any interactions, discussions, and presentations as they occurred in real-time.
While efforts have been made to ensure the accuracy and clarity of the material presented, please be aware that occasional technical issues, interruptions, or other unforeseen circumstances may have occurred during the live recording.
The views, opinions, and information shared in this course are those of the speakers and participants involved in the original live session and do not necessarily reflect the views of the organizers or hosts of this recording. We appreciate your understanding and encourage you to reach out if you have any questions or concerns regarding the content presented in this video course.
Thank you for your interest and participation.
Reviews