.NET Full-Stack Web Developer

• Front end, back end, database and API concepts
• Client-server architecture
• HTTP and HTTPS fundamentals
• Installing Visual Studio 2022
• Installing .NET SDK and SQL Server
• Creating console applications
• C# program structure
• Variables and data types
• Type conversion
• Operators and expressions
• Conditional statements
• Loops
• Debugging fundamentals

• Fields, properties and methods
• Constructors
• Method overloading
• Inheritance
• Method overriding
• Encapsulation
• Abstraction
• Polymorphism
• Abstract classes
• Interfaces
• Access modifiers
• Static and sealed classes
• Namespaces

• Arrays and strings
• Collections
• Generic collections
• List, Dictionary and HashSet
• Exception handling
• File handling
• Date and time
• Delegates
• Events
• Lambda expressions
• LINQ
• Nullable types
• Asynchronous programming
• async and await
• Dependency injection concepts

• HTML document structure
• Links, images, tables and lists
• HTML forms
• Semantic HTML
• CSS selectors
• Box model
• Flexbox and CSS Grid
• Responsive web design
• Bootstrap grid system
• Navbar, cards, tables, forms and modals
• JavaScript variables and data types
• Functions, arrays and objects
• DOM manipulation
• Event handling
• Client-side form validation
• JSON and Fetch API

• Relational database concepts
• Installing SQL Server and SSMS
• Creating databases and tables
• SQL Server data types
• Primary and foreign keys
• SQL commands: INSERT, SELECT, UPDATE and DELETE
• Filtering and sorting
• Aggregate functions
• Grouping
• Joins and subqueries
• Views
• Stored procedures
• Functions and triggers
• Database normalization
• Indexes
• Transactions

• Introduction to ADO.NET
• Connected and disconnected architecture
• SQL connection
• SQL command
• Data reader
• Data adapter
• DataSet and DataTable
• Parameterized queries
• Calling stored procedures
• Transaction handling
• Repository pattern introduction
• Preventing SQL injection
• Database configuration

• Introduction to .NET and ASP.NET Core
• ASP.NET Core project structure
• MVC architecture
• Models, views and controllers
• Routing
• Razor syntax
• Layout pages
• Partial views
• ViewBag, ViewData and TempData
• Strongly typed views
• Tag Helpers
• Model binding
• Form handling
• Server-side validation
• Static files
• Configuration files
• Middleware fundamentals

• Introduction to ORM
• Entity Framework Core architecture
• Code First approach
• Database First approach
• DbContext
• Entity models
• Migrations
• Data annotations
• Fluent API
• CRUD operations
• LINQ to Entities
• One-to-one relationships
• One-to-many relationships
• Many-to-many relationships
• Eager, lazy and explicit loading
• Repository pattern
• Searching, sorting and pagination
• Unit of Work concept

• REST architecture
• API endpoint design
• HTTP methods
• HTTP status codes
• Creating Web API controllers
• Attribute routing
• Route parameters
• Query parameters
• Request body
• JSON serialization
• IActionResult
• ActionResult<T>
• DTOs
• AutoMapper
• API validation
• Global exception handling
• Testing APIs using Postman

• Layered and clean architecture fundamentals
• Service and repository layers
• Dependency injection
• Async database operations
• API pagination
• Searching, filtering and sorting
• API relationships
• File and image upload APIs
• API versioning
• CORS configuration
• Logging with ILogger
• Rate limiting
• Response caching
• Swagger/OpenAPI documentation
• Health checks
• Unit testing with xUnit
• Mocking with Moq

• Authentication and authorization
• ASP.NET Core Identity
• User registration and login
• Password hashing
• Roles and claims
• Policy-based authorization
• JWT structure
• JWT token generation
• Token validation
• Securing API endpoints
• Refresh token concepts
• Role-based API permissions
• Email confirmation
• Password reset
• Protecting sensitive configuration
• Common web security practices

• Introduction to React
• Installing Node.js and npm
• Creating a React application
• React project structure
• Components and JSX
• Props
• State
• Event handling
• Conditional rendering
• Lists and keys
• Forms
• Hooks
• useState
• useEffect
• React Router
• Reusable components
• Bootstrap integration

• Fetch API and Axios
• Connecting React with Web API
• Displaying API data
• Adding, editing and deleting records
• Client-side form validation
• Handling server validation errors
• Search and pagination
• Loading indicators
• Reusable API service classes
• Environment variables
• CORS troubleshooting
• Responsive tables and forms

• React registration and login pages
• Connecting React with Identity API
• Sending JWT tokens
• Axios interceptors
• Protected routes
• Admin and user dashboards
• Role-based navigation
• Token expiration
• Logout process
• Handling unauthorized and forbidden responses
• Refresh token workflow
• Secure token-storage considerations

• Git and GitHub
• Creating repositories
• Commit, push and pull
• Branches and merging
• Resolving merge conflicts
• Team development workflow
• Unit and integration testing
• API testing with Postman
• React production build
• Publishing ASP.NET Core applications
• IIS deployment
• SQL Server production configuration
• Deployment on Azure App Service
• Environment variables
• Domain and SSL concepts
• Application logging
• Database backup
• Production security checklist

Students will create a complete application containing:

• Responsive React front end
• ASP.NET Core Web API
• SQL Server database
• Entity Framework Core
• Registration and login
• JWT authentication
• Admin and user roles
• CRUD operations
• Database relationships
• Search, filtering and pagination
• Image or document upload
• Dashboard and reports
• API and form validation
• Swagger documentation
• Unit and API testing
• GitHub repository
• IIS or Azure deployment