WEBSITE DEVELOPMENT WITH C# AND ASP.NET

Full Stack Web Development Desktop and Asp.net MVC

Course Details

Prerequisites: HTML, CSS, Bootstrap, JavaScript, OOP​

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

1. Course Objective:

This course provides a comprehensive overview of ASP.NET MVC and desktop application development, emphasizing practical skills and industry techniques. You will explore MVC architecture, responsive web app creation, and data management with Entity Framework. The curriculum covers hands-on coding, authentication, client-side scripting, and testing, deployment, and GitHub integration for version control. The desktop app section focuses on UI design, event-driven programming, and database integration. By the course end, students gain proficiency in ASP.NET MVC and desktop app development, supported by real-world GitHub practices, empowering them to create modern and robust solutions

2. Course contents:

1. What you will learn in C # for complete beginner’s section

  • Here is the C # section program
  • No experience on C #? Don’t worry.
  • C #.net framework
  • project file and course document
  • FAQ’s regarding and C #

2. Set up visual studio

  • Development environments
  • How to install visual studio on windows?
  • How to install visual studio on mac?
  • How to install visual studio 2022 on windows?

3. Console environment on C #

  • What is a console app?
  • Function used in console environments write and read
  • Read and lines

4. Variables in C #

  • What are variables in C #
  • Type conversions in C #

5. Windows form

  • In C # introduction to windows form
  • Review necessary windows
  • Review from properties in C # for beginners

6. Review objects in tool box

  • Using message box
  • Button
  • Label
  • Textbox in C #
  • Group box in C #
  • Radio button
  • Check box in c sharp
  • Combo box in c sharp programing
  • Date time picker in c sharp for beginners
  • Switch and data transfer in C #

7. Operators in c sharp from scratch

  • Using operators

8. Before starting know how

  • Using breakpoint
  • Using region
  • Naming conventions in oak academy C #
  • Using breakpoint
  • Keyboard shortcuts in visual studio

9. Conditions controls

  • If else statement
  • Switch case statement

10. Loops

  • While do while
  • For loop
  • Jump statements
  • C # coding quiz

11. Project in c #

  • Make an example what we learn

12. Arrays in C #

  • Arrays in C #

13. Methods

  • Methods
  • Quiz 2 C # quiz

14. Classes

  • Class, and object
  • Using list class
  • Using random class
  • Using timer class
  • Using math class

15. C # project-oriented programming

  • What is C # oop?
  • FAQ regarding c # oop
  • Project files and course and documents
  • Class and object
  • Encapsulation
  • Static using
  • Inheritance
  • Interface
  • Polymorphism
  • Abstract
  • Nested class
  • Partial ve sealed class

16. Enum using

  • Enum using

18. Exception handling

  • Exception handling

19. Folder and file operation

  • System io class
  • Directory and directory classes
  • File and file info class
  • Path class

20. N tier architecture

  • N tier architecture

21. MS SQL introduction

  • What is a database?
  • Rdms
  • What is SQL query?

22. Database normalization

  • Normalizations
  • Normal forms (nf)

23. Installation

  • Install MS SQL server express 2017

24. Starting to ssms

  • Starting to ssms
  • Create alter and drop data base
  • Create rename and drop tables
  • Data type and constraints
  • Foreign key constraints
  • Unique and check constraints
  • Quiz3: quiz

25. Manipulating data

  • insert data to table
  • Update data in a table
  • Delete data and adventure works

26. Basic select statement

  • Select statements and alias
  • Where clause and operators
  • Quiz 4: quiz

27. Sorting and grouping data

  • Sorting and grouping data
  • Quiz 5: quiz

28. Wild card operation

  • Like clause

29. If then statements

  • Case function

30. Conversion functions

  • Convert and cast function

31. Retrieving data from multiple tables

  • Inner join
  • Left and right join
  • Full and self-join

32. Set operation

  • Union operators
  • Intersect and except operators

33. Sub queries

  • Subqueries with select statements
  • Single row & multiple queries
  • Insert, update and delete statement

34. Date time functions

  • Date time function
  • Converting date time

35. String function

  • String function

36. Math functions

  • Math functions

37. SQL transaction

  • SQL transactions
  • SQL transactions commands

38. Schema objects and managing schema

  • Create schema and view
  • Create sequence

39. User managements

  • Create logins
  • User and user permissions
  • Permissions and roles

40. Personal tracking app with n tier architecture

  • Final version of app
  • Project construction stages
  • Create database
  • Creating project structure

41. Designs of projects forms

  • Login form design
  • Main form design
  • Department form design
  • Position form design
  • Employee form design
  • Task form design
  • Permission form design
  • Salary form design
  • Connect form
  • Connect to database LINQ to SQL

42. Add and listing operations

  • Add department
  • Listing department
  • Add position
  • Listing positions
  • Add employees
  • Listing employee
  • Add task
  • Listing task
  • Add salary
  • Listing salary
  • Login with user no and password
  • Add permissions
  • Listing permission

43. Update operation

  • Update permissions
  • Update task
  • Update salary
  • Update employe
  • Update position
  • Update department

44. Delete operation

  • Delete permissions
  • Delete task
  • Delete salary
  • Delete employe using trigger
  • Delete position using trigger
  • Delete department using trigger
  • Delete authorization operators
  • Export excels

45. Solid principles and design patterns

  • What’s solid?
  • S-single responsibility
  • O-open closed
  • l-liskov substitution
  • I-interface segregation
  • D-dependency inversion
  • Design patterns
  • Abstract patterns
  • Observer patterns
  • Façade patterns

46. Stock tracking app with entire architectures façade design patterns entity frame wire

  • Stock tracking constructions stages
  • Final version of stock tracking
  • Design database of stock tracking
  • Creating project structure of stock tracking

47. Design of project forms

  • Category form design
  • Product form design
  • Customer form design
  • Sales form design
  • Deleted and alert form design
  • Main form design and connect pages

48. Add and listing operation

  • Category add and listing operation
  • Customer add and listing operation
  • Product add and list operation
  • Add product stock and list stock alert
  • Sales add and listing operation

49. Update operation

  • Category and customer operation
  • Product and sales update operation

50. Delete operation

  • Delete sales
  • Delete products
  • Delete customers
  • Delete category
  • Deleted form and get back deleted files training evolution

51. Model view controller

  • What’s mvc?
  • First mvc project
  • Action result
  • What’s mvc?
  • View in mvc
  • Usage of layout
  • Partial view
  • Model in mvc
  • Http gets and https post
  • Begin form
  • Json
  • View bag, viewdata and temp data
  • Validation
  • Routing in mvc
  • Action filters

52. Starting a web project

  • Final version of project
  • Downloading admin lte template
  • Creating database part 1
  • Creating database part2
  • Creating database part3
  • Creating project structure
  • Connecting database to project
  • Dress template login
  • Login operation
  • Sql operation login

53. Add update and listing operation

  • First log operation
  • Add admin layout
  • Add meta part 1
  • Add meta part 2
  • Define message form
  • Meta list page
  • Update meta
  • Add social media part 1
  • Add social media part 2
  • Social media
  • Update social media
  • Add user
  • User list page
  • Update user
  • Add ads
  • Ads list page
  • Update
  • Update favicon and logo
  • Add address
  • Address list page
  • Update address
  • Add video
  • Video list page
  • Update video
  • Add category
  • Category list page
  • Update category
  • Add post part1
  • Add post part 2
  • Post list page
  • Update post
  • Quiz 7
  • Quiz 8

54. Add user

  • Add modal and delete record script
  • Delete meta
  • Delete address
  • Delete video
  • Delete ads
  • Delete social media
  • Delete image in update post page
  • Delete post with using trigger
  • Delete category
  • Delete user

55. Adjust admin layout

  • Adjust admin layout names for menu buttons

56. Adjust user menu settings

  • adjust user menu setting
  • User control operation

57. Adding training and videos

  • Adding trainings and videos for show in front page

58. Front pages of projects

  • Download vizew template
  • Adjust home template
  • Adjust menu home layout
  • Adjust social media in home layout
  • Adjust favicon and logo and tittle in home layout
  • Adjust meta in-home layout
  • Adjust address in home layout
  • Adjust hot news in home layout
  • Adjust main page part1
  • Adjust main page part 2
  • Adjust breaking training in main page
  • Adjust popular training in main page
  • Adjust most viewed training i main page
  • Adjust video main page
  • Adjust ads in main page
  • Routing operation part1
  • Routing operation part 2
  • Add post detail page
  • Add comments operation using toast
  • All comments list page in admin area
  • Category lies page list part 1
  • Category list page part2
  • Contact page
  • Unread message page in admin area
  • Search page
  • Increasing speed of project

59. Publish operation

  • Using github
  • Publish site on web

60. Android application

  • Making an android app for android studio

61. Change template

  • Download mag template
  • Add new layout
  • add index view
  • Add post view
  • Add category list post view
  • Add contact view
  • Add search view

62. Performance operations

  • Performance operation introduction
  • Database connection
  • Select command in linq
  • Cookie and session
  • Add session to project part 1
  • Add session to project part

63. Explanation videos

  • Break point using

64. Extras

  • Full stack web development with c3oop MS SQL Asp.net MVC