Full Stack Web Development with C# OOP, MS SQL & ASP.NET MVC

Hello there,

Welcome to Full Stack Web Development with C# OOP, MS SQL & ASP.NET MVC course.
Web development with C#, ASP.NET MVC, MS SQL, C# OOP. All gathered for full stack web development in one course!

• Do you want to build web apps, mobile apps, games

  or

• Do you want to succeed with clean coding, agile, and design patterns?

If your answer is Yes then you have to master Web Development. And you are definitely at the right place.

C# Object-oriented programming is the foundation of many current application development approaches. Interfaces and principles of object-oriented programming are crucial. During my course, you will learn everything, from A to Z, about C# Object-Oriented Programming on real C# projects.

In this course, we use interactive programming techniques; which means we will be building applications together, and furthermore there will be lots of work to be done, of course, followed by answers. You will also learn tips and tricks regarding beautiful and efficient coding techniques.

In this course, you will make an excellent introduction to SQL with MS Management Studio which allows to manage database and retrieve data from the database with a graphical interface.

You will also learn MVC so you will need basic C# knowledge to get the most efficient from this training. But of course, I will explain all codes in detail.

You will start learning MVC from scratch and you will examine all concepts one by one with real-world projects. Then together we will make a dynamic web project with 4 tier architecture page by page.

You will also learn to use ready-made templates with our project. When you finished the project, you will be learning how to use GitHub with Visual Studio and how to publish a project on the web. Besides that, you will learn how to make an Android App from a web site with a web view.

That`s why you are at a great place to start with OOP with C#

What you will learn?

• Applying the OOP concepts using C#

• How to apply each subject on real projects

• You will have an infrastructure to learn programming languages like Java or Python in a very short time

• N- tier Architecture

• How to make a professional project with 3 tier architecture and LINQ

• Solid Principles

• Using of Abstract Factory , Observer and Facade Design Patterns

• Using of Entity Framework

• Using of N- tier architecture, design patterns, and Entity framework together

• How to develop professional apps

• How to Create Personnel Tracking systems algorithm

• How to Create Stock Tracking systems algorithm

• How to use facade design pattern on a real app

• Using basic SQL commands

• Using Folder and File Operations

• How to Delegate methods and use events

• How to Handled errors and exceptions in your apps

• How to use coding techniques to make efficient development

• How to install and setup these requirements.

• You will learn the basics of SQL such as data, database, DBMS or SSMS, SQL, tables, and so on.

• Database normalization,

• Manipulating data,

• Retrieving data from the database with different scenarios,

• You will also learn SQL transactions and transaction commands,

• Schema and schema objects and

• User privileges, permission commands, and roles.

• How to apply each subject on real projects

• Understand the MVC architectural pattern

• Using of MVC Concepts with all details

• Using of Partial, Begin Form, Json

• Using of Data Transfer Objects as ViewBag, ViewData, TempData

• Using of ready-made templates

• Create real-world projects using Asp .Net MVC and Entity Framework

• Understand how to use the database-first approach with using Entity Framework

• Use Entity Framework to SQL Operations

• N- tier Architecture

• How to Separate projects parts

• How to Create Dynamic web project algorithm

• How to make a professional web project with 4 tier architecture and Entity Framework

• How to Change your Projects Front Pages Easily

• Using of basic SQL commands

• Using Triggers

• Make Log Operations

• How to Handled errors and exceptions in your apps

• How to use coding techniques to make efficient development

• How to Make SEO Operations for google

• How to Get feedback like message or comment

• Have a basic understanding of working with GitHub

• How to Publish a web Project

• How to Make an Android APK from a web site

• What You Will Learn in C# For Complete Beginners Section 10:11

  • 1: Here is the C# Course Program 05:15
  • 2: No experience on C#_ Don`t Worry! 02:00
  • 3: C# .NET Framework 02:56

• Set Up Visual Studio 14:44

  • 4: Development Environments 06:34
  • 5: How To Install Visual Studion On Windows_ 02:22
  • 6: Installing visual studio on mac 05:48

• Console Environment for C# 08:59

  • 7: What is Console App_ 00:46
  • 8: Functions Used in Console Environment to Write and Read 04:58
  • 9: Read _ Readline 03:15

• Variables 17:31

  • 10: What Is Variables_ 09:18
  • 11: Type Conversions in Variables 08:13

• Windows Form 14:38

  • 12: Introduction to Windows Form 01:28
  • 13: Review Necessary Windows 07:51
  • 14: Review Form Properties 05:19

• Review Objects in Toolbox 56:05

  • 15: Using MessageBox 05:13
  • 16: Button 09:09
  • 17: Label 03:40
  • 18: Textbox 06:29
  • 19: GroupBox 02:24
  • 20: RadioButton 03:55
  • 21: Checbox 03:58
  • 22: Combobox 09:21
  • 23: Datetimepicker 05:54
  • 24: Switch and Data Transfer Between Forms 06:02

• Operators 05:08

  • 25: Using Operators 05:08

• Before Starting Know-How 21:34

  • 26: Using Comment Line 03:51
  • 27: Using Region 02:02
  • 28: Naming Conventions 04:21
  • 29: Using Breakpoint 07:43
  • 30: Keyboard Shortcuts in Visual Studio 03:37

• Condition Controls 19:17

  • 31: If -Else Statement 12:55
  • 32: Switch Case Statement 06:22

• Loops 26:54

  • 33: While DoWhile 11:06
  • 34: For Loop 05:33
  • 35: Jump Statements 09:15
  • 36: quiz 01:00

• Project 20:57

  • 37: Make an Example With What We Learn 20:57

• Arrays 09:44

  • 38: Arrays 09:44

• Methods 17:38

  • 39: Methods 16:38
  • 40: quiz 01:00

• Classes 50:07

  • 41: Class and Object 13:06
  • 42: Using Random Class 09:08
  • 43: Using Timer Class 07:29
  • 44: Using Math Class 20:24

• C# Object- Oriented Programming ( OOP ) 1:19:59

  • 45: What’s C# OOP_ 02:46
  • 46: Class and Object 06:26
  • 47: Encapsulation 10:55
  • 48: Static Using 06:00
  • 49: Inheritance 13:26
  • 50: 7 -Interface 07:13
  • 51: Polymorphism 15:33
  • 52: Abstract 06:19
  • 53: Nested Class 03:18
  • 54: Partial and Sealed Class 08:03

• Enum Using 05:07

  • 55: Enum Using 05:07

• Delegate Using 06:39

  • 56: Delegate Using 06:39

• Exception Handling 09:00

  • 57: Exception Handling 09:00

• Folder and File Operations 31:34

  • 58: System IO Class 02:09
  • 59: Directory and Directory Classes ( Folder Operations ) 09:46
  • 60: File and File Info Classes ( File Operations ) 16:01
  • 61: Path Class 03:38

• N-Tier Architecture 03:24

  • 62: N-Tier Architecture 03:24

• MS SQL Introduction 08:32

  • 63: What is database 03:19
  • 64: RDBMS (Relational Database Management System) 02:24
  • 65: What is SQLQuery 02:49

• Database Normalization 10:54

  • 66: Normalization 02:58
  • 67: Normal Forms (NF) 07:56

• Installation for MS SQL 04:35

  • 68: Install MS SQL Server Express Edition 2019 04:35

• Starting to SSMS 45:12

  • 69: Starting To SSMS (SQL Server Management Studio) 05:08
  • 70: Create, Alter and Drop Database 08:46
  • 71: Create, Rename and Drop Table 13:42
  • 72: Data Types and Constraints 05:52
  • 73: Foreign Key Constraint 05:14
  • 74: Unique & Check Constraint 05:30
  • 75: quiz 01:00

• Manipulating Data 22:04

  • 76: Insert Data to Table 10:05
  • 77: Update Data in A Table 05:42
  • 78: Delete Data and AdventureWorks 06:17

• Basic Select Statement 18:58

  • 79: Select Statement and Alias 07:09
  • 80: Where Clause and Operators 10:49
  • 81: Quiz 01:00

• Sorting and Grouping Data 14:28

  • 82: Sorting and Grouping Data 13:28
  • 83: Quiz 01:00

• Wildcard Operations 08:03

  • 84: Like Clause 08:03

• IF-THEN Statement 04:37

  • 85: Case Function 04:37

• Conversion Functions 08:32

  • 86: Convert and Cast Function 08:32

• Retrieve Data From Multiple Tables 20:35

  • 87: Inner Join 07:05
  • 88: Left and Right Join 07:29
  • 89: Full and Self Join 06:01

• Set Operations 12:00

  • 90: Union Operators 05:35
  • 91: Intersect and Except Operators 06:25

• Subqueries 21:32

  • 92: Subqueries With Select Statement 08:44
  • 93: Single Row & Multiple Row Subqueries 05:25
  • 94: Insert, Update and Delete Statement 07:23

• DateTime Functions 22:18

  • 95: DateTime Function 14:39
  • 96: Converting DateTime 07:39

• String Functions 08:58

  • 97: String Functions 08:58

• Math Functions 13:24

  • 98: Math Functions 13:24

• SQL Transactions 14:10

  • 99: SQL Transactions 06:10
  • 100: SQL Transactions Commands 08:00

• Schema Objects and Managing Schema 22:24

  • 101: Create Schema and View 12:09
  • 102: Create Sequence 10:15

• User Management 37:49

  • 103: Create Logins 08:42
  • 104: Users & User Permissions 10:57
  • 105: Permissions & Roles 18:10

• Personnel Tracking App with N- Tier - Architecture, LINQ and Triggers 21:29

  • 106: Final version of App 05:59
  • 107: Project Construction Stages 01:50
  • 108: Creating Database 10:41
  • 109: Creating Project Structure 02:59

• Design of Project Forms 55:07

  • 110: Login Form Design 04:06
  • 111: Main Form Design 03:54
  • 112: Department Forms Design 04:17
  • 113: Positions Form Design 03:52
  • 114: Employee Forms Design 08:07
  • 115: Task Forms Design 08:53
  • 116: Permission Forms Design 05:43
  • 117: Salary Forms Design 05:37
  • 118: Connect Forms 06:53
  • 119: Connect to Database - LINQ to SQL 03:45

• Add and Listing Operations 2:13:23

  • 120: Add Department 07:08
  • 121: Listing Departments 04:19
  • 122: Add Position 06:15
  • 123: Listing Positions 06:44
  • 124: Add Employee 18:45
  • 125: Listing Employees 13:54
  • 126: Add Task 14:27
  • 127: Listing Tasks 11:40
  • 128: Add Salary 11:49
  • 129: Listing Salaries 09:42
  • 130: Login with UserNo and Password 07:01
  • 131: Add Permission 07:45
  • 132: Listing Permissions 13:54

• Update Operations 1:00:32

  • 133: Update Permission 12:46
  • 134: Update Task 09:48
  • 135: Update Salary 12:15
  • 136: Update Employee 11:56
  • 137: Update Department 05:09
  • 138: Update Position 08:38

• Delete Operations ( Trigger Using ) 52:17

  • 139: Delete Permission 03:25
  • 140: Delete Task 02:18
  • 141: Delete Salary 02:22
  • 142: Delete Employee with Using Trigger 09:26
  • 143: Delete Position with Using Trigger 05:00
  • 144: Delete Department with using Trigger 03:45
  • 145: User Authorization Operations 18:44
  • 146: Export to Excel 07:17

• SOLID Principles and Design Patterns 43:02

  • 147: What’s SOLID 03:09
  • 148: S- Single Responsibility 03:18
  • 149: O- Open Closed 03:41
  • 150: L- Liskov Substitution 01:59
  • 151: I-Interface Segregation 06:19
  • 152: D- Dependency Inversion 04:44
  • 153: Design Patterns 02:05
  • 154: Abstract Factory Pattern 06:13
  • 155: Observer Pattern 06:40
  • 156: Facade Pattern 04:54

• Stock Tracking App with N-Tier Architecture Facade Design Pattern& Entity Frame 23:07

  • 157: Stock Tracking Construction Stages 02:34
  • 158: Final Version of Stock Tracking 04:28
  • 159: Design Database of Stock Tracking 04:55
  • 160: Creating Project Structure of Stock Tracking 11:10

• Design of Project Forms 40:20

  • 161: Category Forms Design 04:43
  • 162: Product Forms Design 11:54
  • 163: Customer Forms Design 03:06
  • 164: Sales Form Design 10:24
  • 165: Deleted and Stock Alert Forms Design 03:35
  • 166: Main Form Design and Connect Pages 06:38

• Add and Listing Operations 1:29:43

  • 167: Category Add and Listing Operations 16:24
  • 168: Customer Add and List Operations 10:49
  • 169: Product Add and Listing Operations 21:39
  • 170: Add Product Stock and Adjust Stock Alert 13:37
  • 171: Sales Add and Listing Operations 27:14

• Update Operations 30:48

  • 172: Category and Customer Update Operations 12:25
  • 173: Product and Sales Update Operations 18:23

• Delete Operations 47:13

  • 174: Delete Sales 04:41
  • 175: Delete Products 06:07
  • 176: Delete Customers 05:23
  • 177: Delete Category 06:44
  • 178: Deleted Form and Get Back Deleted Files Training Evaluation 24:18

• Model-View-Controller (MVC) 1:44:09

  • 179: What’s MVC? 03:57
  • 180: First MVC Project 03:44
  • 181: Action Result 09:07
  • 182: View in MVC 05:56
  • 183: Usage of Layout 05:47
  • 184: Partial View 06:20
  • 185: Model in MVC 12:04
  • 186: HttpGet & HttpPost 09:27
  • 187: Begin Form 07:06
  • 188: JSON 06:32
  • 189: ViewBag, ViewData and TempData 06:46
  • 190: Validations 07:49
  • 191: Routing in MVC 13:26
  • 192: Action Filters 05:08
  • 193: Quiz 01:00

• Starting a Web Project 1:40:57

  • 194: Final version of Project 14:13
  • 195: Downloading Admin LTE Template 02:25
  • 196: Creating Database Part 1 15:22
  • 197: Creating Database Part 2 13:07
  • 198: Creating Database Part 3 11:13
  • 199: Creating Project Structure 09:31
  • 200: Connecting Database to Project (Entity Framework) 05:19
  • 201: Dress Template to Login Page 09:27
  • 202: Login Operation 07:26
  • 203: SQL Operations for Login 12:54

• Add, Update and Listing Operations 6:28:27

  • 204: First Log Operation 16:07
  • 205: Add Admin Layout 09:57
  • 206: Add Meta Part 1 17:38
  • 207: Add Meta Part 2 09:53
  • 208: Define Message Form 08:39
  • 209: Meta List Page 18:24
  • 210: Update Meta 13:15
  • 211: Add Social Media Part 1 16:26
  • 212: Add Social Media Part 2 15:04
  • 213: Social Media List 09:14
  • 214: Update Social Media 15:12
  • 215: Add User 18:20
  • 216: User List Page 06:52
  • 217: Add Ads 15:34
  • 218: Ads List Page 06:20
  • 219: Update Ads 09:53
  • 220: Update Fav Icon Logo and Title 20:38
  • 221: Add Address 16:44
  • 222: Address List Page 05:11
  • 223: Update Address 06:25
  • 224: Add Video 14:08
  • 225: Video List Page 05:25
  • 226: Update Video 07:23
  • 227: Add Category 10:08
  • 228: Category List Page 04:24
  • 229: Update Category 06:39
  • 230: Add Post Part 1 20:10
  • 231: Add Post Part 2 23:38
  • 232: Update User 12:13
  • 233: Post List Page 07:30
  • 234: Update Post 21:03

• Delete Operations 1:02:58

  • 235: Add Modal and Delete Record Script 08:30
  • 236: Delete Meta 04:56
  • 237: Delete Address 04:39
  • 238: Delete Video 03:21
  • 239: Delete Ads 05:45
  • 240: Delete Social Media 05:15
  • 241: Delete Post Image in Update Post Page 05:02
  • 242: Delete Post with Using Trigger 10:29
  • 243: Delete Category 09:27
  • 244: Delete User 05:34

• Adjust Admin Layout 08:39

  • 245: Adjust Admin Layout Page for Menu Buttons 08:39

• Adjust User Menu Settings 13:32

  • 246: Adjust User Menu Settings 06:37
  • 247: User Control Operation 06:55

• Adding Trainings and videos 15:56

  • 248: Adding Trainings and Videos for show in front page 15:56

• Front Pages of Project 4:12:29

  • 249: Download Vizew Template 01:41
  • 250: Adjust Home Layout 08:32
  • 251: Adjust Menu Buttons in Home Layout 11:55
  • 252: Adjust Social Media in Home Layout 08:23
  • 253: Adjust Fav icon Logo and Title in Home Layout 04:16
  • 254: Adjust Meta in Home Layout 02:41
  • 255: Adjust Address in Home Layout 04:49
  • 256: Adjust Hot News in Home Layout 05:32
  • 257: Adjust Main Page Part 1 06:11
  • 258: Adjust Main Page Part 2 13:07
  • 259: Adjust Breaking Trainings in Main Page 04:05
  • 260: Adjust Popular Trainings in Main Page 04:06
  • 261: Adjust Most Viewed Trainings in Main Page 04:11
  • 262: Adjust Videos in Main Page 06:19
  • 263: Adjust Ads in Main Page 03:40
  • 264: Routing Operations Part 1 11:54
  • 265: Routing Operations Part 2 08:25
  • 266: Add Post Detail Page 24:02
  • 267: Add Comment Operation with Using Toastr 13:29
  • 268: Unapproved Comment List Page in Admin Area 15:46
  • 269: All Comments List Page in Admin Area 06:40
  • 270: Category Post List Page Part 1 09:04
  • 271: Category Post List Page Part 2 06:52
  • 272: Contact Page 13:49
  • 273: Unread Messages Page in Admin Area 14:12
  • 274: All Messages Page in Admin Area 04:53
  • 275: Using Timer for Show Momentary Messages and Comments count in Admin Layout 10:11
  • 276: Log List Page in Admin Layout 10:44
  • 277: Add Count Areas to Post List Page in Admin Area 06:01
  • 278: Search Page 06:59

• Publish Operations 16:41

  • 279: Using GitHub with Visual Studio 03:37
  • 280: Publish Site on Web 13:04

• Android Application 08:51

  • 281: Making an Android App for Project with Android Studio 08:51

• Change Template 1:03:43

  • 282: Download Mag Template 03:20
  • 283: Add New Layout 12:00
  • 284: Add Index View 19:48
  • 285: Add Post Detail View 12:03
  • 286: Add Category Post List View 08:09
  • 287: Add Contact View 04:48
  • 288: Add Search View 03:35

• Performance Operations 58:49

  • 289: Performance Operations Introduction 01:38
  • 290: Database Connections 08:37
  • 291: Select Command in LINQ 07:14
  • 292: Cookie & Session 03:03
  • 293: Add Session to Project Part 1 19:15
  • 294: Add Session to Project Part 2 19:02

• Explanation Videos 07:43

  • 295: Break Point Using 07:43

Hello there,

Welcome to Full Stack Web Development with C# OOP, MS SQL & ASP.NET MVC course.
Web development with C#, ASP.NET MVC, MS SQL, C# OOP. All gathered for full stack web development in one course!

• Do you want to build web apps, mobile apps, games

  or

• Do you want to succeed with clean coding, agile, and design patterns?

If your answer is Yes then you have to master Web Development. And you are definitely at the right place.

C# Object-oriented programming is the foundation of many current application development approaches. Interfaces and principles of object-oriented programming are crucial. During my course, you will learn everything, from A to Z, about C# Object-Oriented Programming on real C# projects.

In this course, we use interactive programming techniques; which means we will be building applications together, and furthermore there will be lots of work to be done, of course, followed by answers. You will also learn tips and tricks regarding beautiful and efficient coding techniques.

SQL is the standard language for Relation Database System. All relational database management systems like SQL Server, MySQL, MS Access, Oracle, Sybase, and others use SQL as the standard database language. SQL is used to communicate with a database.

In this course, you will make an excellent introduction to SQL with MS Management Studio which allows to manage database and retrieve data from the database with a graphical interface.

You will also learn MVC so you will need basic C# knowledge to get the most efficient from this training. But of course, I will explain all codes in detail.

You will start learning MVC from scratch and you will examine all concepts one by one with real-world projects. Then together we will make a dynamic web project with 4 tier architecture page by page.

You will also learn to use ready-made templates with our project. When you finished the project, you will be learning how to use GitHub with Visual Studio and how to publish a project on the web. Besides that, you will learn how to make an Android App from a web site with a web view.

That`s why you are at a great place to start with OOP with C#

What you will learn?

• Applying the OOP concepts using C#

• How to apply each subject on real projects

• You will have an infrastructure to learn programming languages like Java or Python in a very short time

• N- tier Architecture

• How to make a professional project with 3 tier architecture and LINQ

• Solid Principles

• Using of Abstract Factory , Observer and Facade Design Patterns

• Using of Entity Framework

• Using of N- tier architecture, design patterns, and Entity framework together

• How to develop professional apps

• How to Create Personnel Tracking systems algorithm

• How to Create Stock Tracking systems algorithm

• How to use facade design pattern on a real app

• Using basic SQL commands

• Using Folder and File Operations

• How to Delegate methods and use events

• How to Handled errors and exceptions in your apps

• How to use coding techniques to make efficient development

• How to install and setup these requirements.

• You will learn the basics of SQL such as data, database, DBMS or SSMS, SQL, tables, and so on.

• Database normalization,

• Manipulating data,

• Retrieving data from the database with different scenarios,

• You will also learn SQL transactions and transaction commands,

• Schema and schema objects and

• User privileges, permission commands, and roles.

• How to apply each subject on real projects

• Understand the MVC architectural pattern

• Using of MVC Concepts with all details

• Using of Partial, Begin Form, Json

• Using of Data Transfer Objects as ViewBag, ViewData, TempData

• Using of ready-made templates

• Create real-world projects using Asp .Net MVC and Entity Framework

• Understand how to use the database-first approach with using Entity Framework

• Use Entity Framework to SQL Operations

• N- tier Architecture

• How to Separate projects parts

• How to Create Dynamic web project algorithm

• How to make a professional web project with 4 tier architecture and Entity Framework

• How to Change your Projects Front Pages Easily

• Using of basic SQL commands

• Using Triggers

• Make Log Operations

• How to Handled errors and exceptions in your apps

• How to use coding techniques to make efficient development

• How to Make SEO Operations for google

• How to Get feedback like message or comment

• Have a basic understanding of working with GitHub

• How to Publish a web Project

• How to Make an Android APK from a web site

• By the end of this course, you will be in a position to build any professional web application with all details using MVC and Entity Framework

Why would you want to take this course?

Our answer is simple: The quality of teaching.

When you enroll, you will feel the OAK Academy`s seasoned instructors' expertise.

This course starts with very basics. You will learn everything with hands-on practices. I'll also teach you the best practices and shortcuts.

Video and Audio Production Quality

All our videos are created/produced as high-quality video and audio to provide you the best learning experience.

You will be,

• Seeing clearly

• Hearing clearly

• Moving through the course without distractions

You'll also get:

• Lifetime Access to The Course

• Fast & Friendly Support in the Q&A section

Are you ready to dive in now to my Full Stack Web Development with C# OOP, MS SQL & ASP.NET MVC course

We offer full support, answering any questions.

See you in the course!

• Nothing else! It’s just you, your computer and your ambition to get started today
• Anyone who wants to improve their C# OOP, MS SQL & ASP. NET MVC programming skills
• Anyone who wants to build OOP object oriented and / or windows forms applications
• Anyone who is interested in developing MS SQL software with a design pattern
• Anyone who wants to understand the elements of full-stack software development
• Anyone who wants to start learning SQL Server Basics
• Anyone who wants to better understand how databases work
• Anyone who plans a career in Microsoft SQL Server database
• People who wants to learn MVC
• Anyone who wants to develop .NET applications
• Students who want to make a professional web project
• People who want to apply N- tier architecture in a project
• Anyone who want to learn a web backend to use in mobile programming

• Desire to learn C# OOP, MS SQL and ASP. NET MVC
• A Windows or Mac for installing all the free software and tools needed to practice
• Basic C# Knowledge
• Visual Studio 2019
• SQL Server Management Studio
• No Prior Database OR SQL experience is required.
• Nothing else! It’s just you, your computer and your ambition to get started today
• Desire to learn C# Web Development
• Desire to learn Full Stack C#
• Desire to learn C# Web

Currently there are no Q&As for this course. Be the first to ask a question.

Reed Courses Certificate of Completion

Digital certificate - Included