Microsoft .NET Core with ReactJS Outline
| Trainer Name | |
|---|---|
| Authur Name | |
| Course Title | Microsoft .NET Core with ReactJS |
| Objectives and Expectations | Employable skills and hands-on practice in Microsoft .NET Core with ReactJS This is a special course designed to address unemployment in the youth. The course aims to achieve the above objective through hands on practical training delivery by a team of dedicated professionals having rich market/work experience. This course is therefore not just for developing a theoretical understanding/back ground of the trainees. Contrary to that, it is primarily aimed at equipping the trainees to perform commercially in a market space in independent capacity or as a member of a team. The course therefore is designed to impart not only technical skills but also soft skills (i.e. interpersonal/communication skills; personal grooming of the trainees etc.) as well as entrepreneurial skills (i.e. marketing skills; free lancing etc.). The course also seeks to inculcate work ethics to foster better citizenship in general and improve the image of Pakistani work force in particular. Main Expectations: In short, the course under reference should be delivered by professional instructors in such a robust hands-on manner that the trainees are comfortably able to employ their skills for earning money (through wage/self-employment) at its conclusion. This course thus clearly goes beyond the domain of the traditional training practices in vogue and underscores an expectation that a market-centric approach will be adopted as the main driving force while delivering it. The instructors should therefore be experienced enough to be able to identify the training needs for the possible market roles available out there. Moreover, they should also know the strengths and weaknesses of each trainee to prepare them for such market roles during/after the training. |
| Entry-level of trainees | For an advanced course of Microsoft .NET Core with ReactJS proposed entry level is minimum bachelors in relevant subject, so expectations from the trainees are: · Have knowledge of Programming Languages C# and VB.NET · Have Understanding of .NET Framework · Have concept of HTML, CSS, and JavaScript · Having a Basic Understanding of Web Development Concepts · Having SQL Server Database Knowledge · Familiarity with MVC Architecture · Having knowledge of Web APIs · Familiar with ReactJS |
| Learning Outcomes of the course | By the end of this course, students will be able to: · Design/Development of Web Applications, eCommerce Website and CMS · Understanding of modern tool usage for Web Development in Industry · Comprehensive knowledge of React JS, including its component- based architecture. · Ability to create and manage React components. · Proficiency in developing Single Page Applications using React for the frontend. · Integration of React with .NET Core APIs. · Consuming and handling data from APIs within a React application. |
| Course Execution Plan | The total duration of the course: 3 months (12 Weeks) Class hours: 4 hours per day Theory: 20% Practical: 80% Weekly hours: 20 hours per week Total contact hours: 260 hours |
| Companies offering jobs in the respective trade | · Senior Dotnet and Reactjs Developer – Calrom Islamabad: Software House develop innovative travel software solutions, designed from the ground up in partnership with some of the world’s leading airlines. · Dotnet Developer – SigmaTec Solutions Pvt. Limited Islamabad: Software House in Islamabad provide unique ability to combine vital product development expertise with deep technical competence and business comprehension. · React Developer – Rainsoft Financials Karachi: Rainsoft Financials (Pvt.) Ltd. is an IT and IT enabled off-shore BPO service provider for the US financial services industry. |
| Job Opportunities | · Web Applications Developer · Back – End Web Developer using ASP.NET Core · Full Stack Web Developer using ASP.NET Core · Front – End Developer |
| No of Students | 25 |
| Learning Place | Classroom / Lab |
| Instructional Resources | 1.HTML/CSS/JavaScript https://dotnettutorials.net/course/html-tutorials/ https://dotnettutorials.net/course/css-tutorials-for-beginners-and- professionals/ https://dotnettutorials.net/course/javascript-tutorial-for-beginners-and- professionals/ These links will provide step by step knowledge of HTML, CSS, and JavaScript for both beginners and experts to develop basic static Web Page. 2. SQL Server: https://dotnettutorials.net/course/sql-server/ This link provides a basic and expert tutorial about SQL Server for creating and managing database and perform different functions e.g. Clauses, Joins, Views and Store Procedures on data stored in database. 3. ASP.NET Core MVC: https://dotnettutorials.net/course/asp-dot-net-mvc-tutorials/ In this ASP.NET MVC Tutorial For Beginners and Professionals series, it covered all the features of ASP.NET MVC. You will learn from the basic to advanced level features of ASP.NET MVC like JavaScript, jQuery, Entity framework, and much more. |
MODULES
| Scheduled Weeks | Module Title | Days | Hours | Learning Units | Home Assignment |
|---|---|---|---|---|---|
| Week 1 | Introduction to Web Development and ASP.NET | Day 1 | Hour 1 | Course Introduction and Expectations | |
| Hour 2 | Intro to ASP.NET and React JS | ||||
| Hour 3 | Job Market Overview | ||||
| Hour 4 | Work Ethics in Institute | ||||
| Day 2 | Hour 1 | Introduction to HTML · Learn Basic Tags in HTML · Tables in HTML · Forms in HTML | |||
| Hour 2 | Introduction to CSS · Learn Basics of CSS · Call Multiple CSS Files in Single HTML Page | ||||
| Hour 3 | JavaScript Language Basics · Variables and Data Types · JavaScript Basic Operators · JavaScript Logical Operators | ||||
| Hour 4 | Lab: Create a Simple HTML Page with CSS and Basic JavaScript files | ||||
| Day 3 | Hour 1 | JavaScript Conditional Statements | |||
| Hour 2 | JavaScript Loops | ||||
| Hour 3 | JavaScript Functions | ||||
| Hour 4 | Lab: Amend the HTML page with Complex JavaScript File | ||||
| Day 4 | Hour 1 | Setup and Install Visual Studio .NET | |||
| Hour 2 | Getting Started with C# · Variables · Data Types · Control Statements | ||||
| Hour 3 | Getting Started with C# · Loops · Functions · Abstract Classes · Data Structures and Collections | ||||
| Hour 4 | Revise Object Oriented Programming Concepts | ||||
| Day 5 | Hour 1 | Revise Object Oriented Programming Concepts | |||
| Hour 2 | Revise .NET Framework and LINQ | ||||
| Hour 3 | Lab: Create a Basic C# Web Application | ||||
| Hour 4 | Short Question/Answer Session | ||||
| Week 2 | Working with SQL Server | Day 1 | Hour 1 | SQL Server Basics · Creating, Altering and Deleting Database and Tables | |
| Hour 2 | SQL Server Basics · Datatypes · Constraints | ||||
| Hour 3 | SQL Server Basics · Datatypes · Constraints | ||||
| Hour 4 | Lab: Let the students Practice SQL Server with their Questions | ||||
| Day 2 | Hour 1 | SQL Server Basics · Primary, Foreign and Composite Key | |||
| Hour 2 | SQL Server Basics · Primary, Foreign and Composite Key · Select Statement | ||||
| Hour 3 | SQL Server – Clauses · Where Clause · Order Clause · Top n Clause · Group By Clause | ||||
| Hour 4 | SQL Server – Clauses · Having Clause · Difference Between Where and Having Clause | ||||
| Day 3 | Hour 1 | SQL Server Operators · Assignment Operator · Arithmetic Operator · Comparison Operator · Logical Operator | |||
| Hour 2 | SQL Server Operators · IN BETWEEN and LIKE Operator · ALL Operator · ANY Operator · SOME Operator | ||||
| Hour 3 | SQL Server Operators · EXISTS Operator · UNION and UNION . ALL Operators | ||||
| Hour 4 | SQL Server Operators · EXCEPT Operator · INTERSECT Operator · Differences Between UNION EXCEPT and INTERSECT Operators | ||||
| Day 4 | Hour 1 | SQL Server – JOINS · Joins in SQL Server · Inner Join | |||
| Hour 2 | SQL Server – JOINS · Left Outer Join · Right Outer Join | ||||
| Hour 3 | SQL Server – JOINS · Full Outer Join · Self Join · Cross Join | ||||
| Hour 4 | Question / Answer Session Lab Session | ||||
| Day 5 | Hour 1 | SQL Server – Indexes · Indexes in SQL Server · Clustered Index | |||
| Hour 2 | SQL Server – Indexes · Non-Clustered Index · How Index impacts DML Operation | ||||
| Hour 3 | SQL Server – Indexes · Unique Index · Index in GROUP BY Clause | ||||
| Hour 4 | Advantages and Disadvantages of Indexes Lab: Let the students practice and ask questions | ||||
| Week 3 | Working with SQL Server Database | Day 1 | Hour 1 | SQL Server – Built-in Functions | |
| Hour 2 | SQL Server – Built-in Functions | ||||
| Hour 3 | Stored Procedures | ||||
| Hour 4 | Stored Procedures | ||||
| Day 2 | Hour 1 | Exception Handling and Transaction Management · Transaction Management · Types of Transactions · Nested Transactions | |||
| Hour 2 | Exception Handling and Transaction Management · ACID Properties · Exception Handling | ||||
| Hour 3 | Exception Handling and Transaction Management · RaiseError and @@ERROR Function | ||||
| Hour 4 | Exception Handling and Transaction Management · How to Raise Errors Explicitly | ||||
| Day 3 | Hour 1 | SQL Server Views and Triggers · Views in SQL Server · Advantages and Disadvantages of Views | |||
| Hour 2 | SQL Server Views and Triggers · Complex Views · Views with Check Option, Check Encryption and Schema Binding · Indexed View | ||||
| Hour 3 | SQL Server Views and Triggers · Triggers in SQL · DML Trigger Real- Time Examples | ||||
| Hour 4 | SQL Server Views and Triggers · Short Question/Answer Session | ||||
| Day 4 | Hour 1 | Concurrent Transactions and Deadlock in SQL Server | |||
| Hour 2 | Concurrent Transactions and Deadlock in SQL Server | ||||
| Hour 3 | Question / Answer Session Lab Session | ||||
| Hour 4 | Question / Answer Session Lab Session Helpers | ||||
| Day 5 | Hour 1 | Summarize SQL Server | |||
| Hour 2 | Summarize SQL Server | ||||
| Hour 3 | Question / Answer Session | ||||
| Hour 4 | Quiz on SQL Server | ||||
| Week 4 | ASP.NET MVC Core – Introduction | Day 1 | Hour 1 | ASP.NET MVC – Basics · Introduction to ASP.NET MVC Framework · ASP.NET MVC File and Folder Structure | |
| Hour 2 | ASP.NET MVC – Basics · Controller | ||||
| Hour 3 | ASP.NET MVC – Basics · View | ||||
| Hour 4 | ASP.NET MVC – Basics · Model · Question / Answer Session | ||||
| Day 2 | Hour 1 | ASP.NET MVC – Basics · ViewData · ViewBag | |||
| Hour 2 | ASP.NET MVC – Basics · Strongly Typed Views · ViewModel | ||||
| Hour 3 | ASP.NET MVC – Basics · TempData | ||||
| Hour 4 | Question / Answer Session | ||||
| Day 3 | Hour 1 | ASP.NET MVC – Routing · Routing in ASP.NET MVC | |||
| Hour 2 | ASP.NET MVC – Routing · Creating Custom Routes | ||||
| Hour 3 | ASP.NET MVC – Routing · Route Constraints | ||||
| Hour 4 | ASP.NET MVC – Routing · Attribute Routing | ||||
| Day 4 | Hour 1 | ASP.NET MVC – Routing · Attribute Routing with Optional Parameter | |||
| Hour 2 | ASP.NET MVC – Routing · Route Prefix in ASP.NET MVC Attribute Routing | ||||
| Hour 3 | ASP.NET MVC – Routing · Route Constraints | ||||
| Hour 4 | ASP.NET MVC – Routing · Default Route and Route Name | ||||
| Day 5 | Hour 1 | ASP.NET MVC – SQL Server · Entity Framework in ASP.NET MVC | |||
| Hour 2 | ASP.NET MVC – SQL Server · Entity Framework in ASP.NET MVC | ||||
| Hour 3 | ASP.NET MVC – SQL Server · Entity Framework in ASP.NET MVC | ||||
| Hour 4 | ASP.NET MVC – SQL Server · Entity Framework in ASP.NET MVC | ||||
| Week 5 | ASP.NET MVC Core – Continue | Day 1 | Hour 1 | ASP.NET MVC – SQL Server · ActionLink HTML | |
| Hour 2 | ASP.NET MVC – SQL Server · Working with Multiple Tables in ASP.NET MVC using Entity Framework | ||||
| Hour 3 | ASP.NET MVC – SQL Server · Working with Multiple Tables in ASP.NET MVC using Entity Framework | ||||
| Hour 4 | ASP.NET MVC – SQL Server · Working with Multiple Tables in ASP.NET MVC using Entity Framework | ||||
| Day 2 | Hour 1 | ASP.NET MVC – SQL Server · Business Objects as Model | |||
| Hour 2 | ASP.NET MVC – SQL Server · FormCollection | ||||
| Hour 3 | ASP.NET MVC – SQL Server · FormCollection | ||||
| Hour 4 | Short Questions / Answer Session | ||||
| Day 3 | Hour 1 | ASP.NET MVC – SQL Server · Model Binding | |||
| Hour 2 | ASP.NET MVC – SQL Server · UpdateModel and TryUpdateModel | ||||
| Hour 3 | ASP.NET MVC – SQL Server · Editing a Model | ||||
| Hour 4 | Short Questions / Answer Session | ||||
| Day 4 | Hour 1 | ASP.NET MVC – SQL Server · Unintended Updates | |||
| Hour 2 | ASP.NET MVC – SQL Server · Bind Attribute | ||||
| Hour 3 | ASP.NET MVC – SQL Server · Model Binding Using Interface | ||||
| Hour 4 | ASP.NET MVC – SQL Server · Deleting Database Records in ASP.NET MVC | ||||
| Day 5 | Hour 1 | ASP.NET MVC – SQL Server · CRUD Operations using Entity Framework | |||
| Hour 2 | ASP.NET MVC – SQL Server · CRUD Operations using Entity Framework | ||||
| Hour 3 | ASP.NET MVC – SQL Server · Customizing Auto Generated Index and Create Views · Customizing Auto Generated Edit View | ||||
| Hour 4 | QUIZ | ||||
| Week 6 | ASP.NET MVC Core – Continue | Day 1 | Hour 1 | ASP.NET MVC – HTML Helpers · HTML Helpers · TextBox · DropDownList | |
| Hour 2 | ASP.NET MVC – HTML Helpers · RadioButton · CheckBox · ListBox | ||||
| Hour 3 | ASP.NET MVC – HTML Helpers · Editor · Password Field and Hidden Field · Templated Helpers | ||||
| Hour 4 | ASP.NET MVC – HTML Helpers · Customizing Templated Helpers · Custom HTML Helpers | ||||
| Day 2 | Hour 1 | ASP.NET MVC – Attributes · Attributes in ASP.NET | |||
| Hour 2 | ASP.NET MVC – Attributes · Attributes in ASP.NET | ||||
| Hour 3 | ASP.NET MVC – Attributes · Action Selectors | ||||
| Hour 4 | ASP.NET MVC – Attributes · Action Verb Selector · Non-Action Selector | ||||
| Day 3 | Hour 1 | ASP.NET MVC – Data Annotations · Data Annotations · Required and StringLength Attribute | |||
| Hour 2 | ASP.NET MVC – Data Annotations · Regular Expression Attribute · Range Attribute | ||||
| Hour 3 | ASP.NET MVC – Data Annotations · Custom Validation Attribute · DataType and Compare Attributes | ||||
| Hour 4 | ASP.NET MVC – Data Annotations · Validation Message and Validation Summary · Remote Validations · Remote Validation in ASP.NET MVC when JavaScript is Disabled | ||||
| Day 4 | Hour 1 | ASP.NET MVC – Action Results · Action Results in ASP.NET MVC · View Result and Partial View Result in MVC | |||
| Hour 2 | ASP.NET MVC – Action Results · JSON Result · JavaScript Result | ||||
| Hour 3 | ASP.NET MVC – Action Results · File Result · Content Result · Empty Result | ||||
| Hour 4 | ASP.NET MVC – Action Results · Redirect, RedirectToRoute and RedirectToAction · Status Results | ||||
| Day 5 | Hour 1 | Multi-Agent RL | |||
| Hour 2 | Cooperative and competitive scenarios | ||||
| Hour 3 | Multi-Agent Deep RL | ||||
| Hour 4 | Applications of RL in robotics | ||||
| Week 7 | ASP.NET MVC Core – Continue | Day 1 | Hour 1 | ASP.NET MVC – Views · Partial Views · Different Ways to Render Partial View · Razer View Syntax | |
| Hour 2 | ASP.NET MVC – Filters · Exception Filter · Custom Exception Filter · Error Pages Based on Status Code | ||||
| Hour 3 | ASP.NET MVC – Filters · ChildActionOnly Attribute · OutputCache Attribute · Custom OutputCache Attribute | ||||
| Hour 4 | ASP.NET MVC – Filters · ValidateInput Attribute · RequireHttps Attribute · Custom Action Filters · Filter Overrides · Authorization Filter · Custom Authorization · Custom Authentication Filter | ||||
| Day 2 | Hour 1 | ASP.NET MVC – Security · Authentication and Authorization · Forms Authentication | |||
| Hour 2 | ASP.NET MVC – Security · Role-Based Authentication · Role-Based Menus | ||||
| Hour 3 | ASP.NET Identity · Introduction to ASP.NET Identity · ASP.NET Identity Architecture | ||||
| Hour 4 | ASP.NET Identity · Getting Started with ASP.NET Identity · Setting up ASP.NET Identity with EF Code-First | ||||
| Day 3 | Hour 1 | ASP.NET Identity · Customizing ASP.NET Identity Tables · Create a User Account | |||
| Hour 2 | ASP.NET Identity · Update and Delete a User Account · Update User Password | ||||
| Hour 3 | ASP.NET Identity · Forget Password · Custom Password Policy | ||||
| Hour 4 | ASP.NET Identity · Username and Email Policy · Login a User in ASP.NET Identity | ||||
| Day 4 | Hour 1 | ASP.NET Identity · How to Implement Remember Me Feature | |||
| Hour 2 | ASP.NET Identity · How to Get the Current Logged in User Id · How to Logout a User | ||||
| Hour 3 | ASP.NET Identity · How to Lockout a User Account | ||||
| Hour 4 | ASP.NET Identity · Authorization in ASP.NET Identity · Roles Management | ||||
| Day 5 | Hour 1 | ASP.NET Identity · How to Add, Update, and Delete Roles | |||
| Hour 2 | ASP.NET Identity · How to Assign a User to a Role · How to Get a User Roles | ||||
| Hour 3 | ASP.NET Identity · Role-Based Authorization | ||||
| Hour 4 | QUIZ on ASP.NET MVC Core | ||||
| Week 8 | ASP.NET WEB API | Day 1 | Hour 1 | Introduction & Environment Setup · Introduction to ASP.NET Core Web API · Environment Setup for ASP.NET Core Web API | |
| Hour 2 | · Web API Project using .NET Core CLI · Test ASP.NET Core Web API using Postman | ||||
| Hour 3 | Creating ASP.NET Core Web API Project in Visual Studio 2022 | ||||
| Hour 4 | · Web API Files and Folders · Swagger API in ASP.NET Core Web API | ||||
| Day 2 | Hour 1 | Converting Console App to Web API App · Build ASP.NET Core Web API Project From Scratch | |||
| Hour 2 | Converting Console App to Web API App · Adding Web Host Builder | ||||
| Hour 3 | Converting Console App to Web API App · Configuring Startup Class in ASP.NET Core | ||||
| Hour 4 | Converting Console App to Web API App · Adding Controller in ASP.NET Core | ||||
| Day 3 | Hour 1 | ASP.NET Core Web API – Routing · Routing in ASP.NET Core Web API · Variables and Query Strings in Routing | |||
| Hour 2 | ASP.NET Core Web API – Routing · Multiple URLs for a Single Resource using Routing | ||||
| Hour 3 | ASP.NET Core Web API – Routing · Base Route | ||||
| Hour 4 | ASP.NET Core Web API –Routing · Route Constraints | ||||
| Day 4 | Hour 1 | ASP.NET WEB API – CRUD Operations · Configuring GET method | |||
| Hour 2 | ASP.NET WEB API – CRUD Operations · Configuring UPDATE method | ||||
| Hour 3 | ASP.NET WEB API – CRUD Operations · Configuring CREATE method | ||||
| Hour 4 | ASP.NET WEB API – CRUD Operations · Configuring DELETE method | ||||
| Day 5 | Hour 1 | ASP.NET WEB API – CRUD Operations · Configuring DELETE method | |||
| Hour 2 | Return Types and Status Codes · Controller Action Return Types | ||||
| Hour 3 | Return Types and Status Codes · 200 HTTP Status Code | ||||
| Hour 4 | Microservices using ASP.NET Core | ||||
| Week 9 | React JS | Day 1 | Hour 1 | ReactJS Introduction · What is ReactJS | |
| Hour 2 | ReactJS Introduction · Why ReactJS Instead of JavaScript | ||||
| Hour 3 | ReactJS Introduction · Single Page Applications with ReactJS | ||||
| Hour 4 | ReactJS Introduction · Single Page Applications with ReactJS | ||||
| Day 2 | Hour 1 | JavaScript Refresher · JavaScript let and const · JavaScript Arrow Functions | |||
| Hour 2 | JavaScript Refresher · Exports and Imports in JavaScript · Classes in JavaScript | ||||
| Hour 3 | JavaScript Refresher · Properties and Methods in JavaScript · Spread and Rest Operators in JavaScript | ||||
| Hour 4 | JavaScript Refresher · Destructuring in JavaScript · Reference and Primitive Types Refresher | ||||
| Day 3 | Hour 1 | React – Basic · React Basic Module Introduction · What are ReactJS | |||
| Hour 2 | React – Basic · Creating a new React Project · Understanding Standard React Project | ||||
| Hour 3 | React – Basic · Introduction to JSX · How React Works | ||||
| Hour 4 | React – Basic · Creating Custom Component · Writing More Complex JSX Code | ||||
| Day 4 | Hour 1 | React – Basic · Adding CSS Styling in React Project · Dynamic Data and Working with Expressions in JSX | |||
| Hour 2 | React – Basic · How to Make React Component Reusable | ||||
| Hour 3 | React – Basic · Adding JavaScript Logic to React Components | ||||
| Hour 4 | React – Basic · Splitting Components into Multiple Components | ||||
| Day 5 | Hour 1 | React – Basic · Composition in React · Summary of React Component | |||
| Hour 2 | React – Basic · Working of JSX · Organizing Component Files in React | ||||
| Hour 3 | React – Basic · Alternative Function Syntax in React | ||||
| Hour 4 | React – Basic QUIZ on React Basic | ||||
| Week 10 | Advanced Computer Vision | Day 1 | Hour 1 | React State and Events · React State and Event Module Introduction | |
| Hour 2 | React State and Events · Working with Event Handlers in React | ||||
| Hour 3 | React State and Events · How Component Functions are Executed · Working with State in React | ||||
| Hour 4 | React State and Events · Working with React useState Hook | ||||
| Day 2 | Hour 1 | React State and Events · Adding Form Inputs in React | |||
| Hour 2 | React State and Events · Listening to User Input in React | ||||
| Hour 3 | React State and Events · Working with Multiple | ||||
| Hour 4 | React State and Events Discussion | ||||
| Day 3 | Hour 1 | React State and Events . Updating State that Depends on Previous State | |||
| Hour 2 | React State and Events · Creating a Shared Handler Function | ||||
| Hour 3 | React State and Events · Handling Form Submission | ||||
| Hour 4 | React State and Events · How to Add Two- Way Binding | ||||
| Day 4 | Hour 1 | React State and Events · Child-to-Parent Component Communication | |||
| Hour 2 | React State and Events · Lifting State Up in React | ||||
| Hour 3 | React State and Events · Derived Computed State | ||||
| Hour 4 | React State and Events · Controlled vs Uncontrolled Components and Stateless vs Stateful Components | ||||
| Day 5 | Hour 1 | Rendering Lists and Conditional Content Module · Introduction · Rendering Lists of Data | |||
| Hour 2 | Rendering Lists and Conditional Content Module · Using Stateful Lists · Understanding Keys | ||||
| Hour 3 | Rendering Lists and Conditional Content Module · Outputting Conditional Content · Adding Conditional Return Statements | ||||
| Hour 4 | Complete topic revision | ||||
| Week 11 | Connecting Front-End with Back-End | Day 1 | Hour 1 | Freelancing Tools & Techniques | |
| Hour 2 | Adding Axios and designing the page | ||||
| Hour 3 | Cross-Origin Requests (CORS) | ||||
| Hour 4 | Discussion | ||||
| Day 2 | Hour 1 | Displaying Data from Back- End to Front-End | |||
| Hour 2 | Displaying Data from Back- End to Front-End | ||||
| Hour 3 | Displaying Data from Back- End to Front-End | ||||
| Hour 4 | Discussion | ||||
| Day 3 | Hour 1 | Updating Data from Front- End | |||
| Hour 2 | Updating Data from Front- End | ||||
| Hour 3 | Updating Data from Front- End | ||||
| Hour 4 | Discussion | ||||
| Day 4 | Hour 1 | Insert Data from Front-End | |||
| Hour 2 | Insert Data from Front-End | ||||
| Hour 3 | Insert Data from Front-End | ||||
| Hour 4 | Delete Data from Front- End | ||||
| Day 5 | Hour 1 | Adding SweetAlert for notification | |||
| Hour 2 | Adding SweetAlert for notification | ||||
| Hour 3 | Handling errors in the Front-End | ||||
| Hour 4 | Publishing the solution in IIS | ||||
| Week 12 | Freelancing Tools & Techniques | Day 1 | Hour 1 | Introduction to Freelancing and its Importance | |
| Hour 2 | Fiverr Account · Create Account · Profile Creation | ||||
| Hour 3 | Fiverr Account · Adding Skills Set in Fiverr | ||||
| Hour 4 | Discussion | ||||
| Day 2 | Hour 1 | Create Gigs on Fiverr · Identify the services you want to offer · Create gigs for each service | |||
| Hour 2 | Create Gigs on Fiverr · Optimizing the gig for search engine using relevant key-words | ||||
| Hour 3 | Create Gigs on Fiverr · Optimize the gig title using the manual method | ||||
| Hour 4 | Promote the Gigs on social media and other online platforms | ||||
| Day 3 | Hour 1 | Upwork Account Create an Upwork account and complete the profile, including the bio, skills, and experience | |||
| Hour 2 | Create project on Upwork | ||||
| Hour 3 | Create proposal to apply for jobs | ||||
| Hour 4 | Communication Skills Session | ||||
| Day 4 | Hour 1 | Final Project · Discussion and Helping Material | |||
| Hour 2 | Final Project · Discussion and Helping Material | ||||
| Hour 3 | Final Project · Discussion and Helping Material | ||||
| Hour 4 | Final Project · Discussion and Helping Material | ||||
| Day 5 | Hour 1 | Closing Statements and Best Wishes | |||
| Hour 2 | Final Exam Conduct the final paper | ||||
| Hour 3 | Final Exam Conduct the final paper | ||||
| Hour 4 | Final Exam Conduct the final paper |
Tasks for Certificate in Microsoft ASP.NET Core MVC and React JS
| Task No. | Task | Description | Week |
|---|---|---|---|
| 1 | Interactive Quiz Game | Develop an interactive quiz game with HTML for the structure, CSS for styling, and JavaScript for quiz logic and user interaction. Provide feedback on correct and incorrect answers. | Week 1 |
| 2 | Design a Library System Database | Design a Database for Library Management with at least 5 tables. Retrieve Information from multiple tables using WHERE Clause, JOINS and Built-in Functions. Also apply Indexing on appropriate columns and evaluate query performance | Week 2 |
| 3 | Database Optimization and Automation | Use the Library Management Database and do the following 1. Stored Procedures: To perform common CRUD operations on key tables in the database. 2. Views: Create views to simplify complex queries. 3. Triggers: Implement triggers to automate specific actions. 4. Optimization: Identify and optimize any existing stored procedures 5. Error Handling: Implement proper error handling mechanisms in your stored procedures and triggers. | Week 3 |
| 4 | Building a Simple Library Management System Application using ASP.NET Core MVC | Design a web application for Library Management System 1. Modeling the Book Table 2. Setting Up Entity Framework 3. Implementing CRUD Operations 4. Routing and Navigation 5. Displaying Books Information 6. Validation 7. Entity Framework Relationships 8. Security Considerations. | Week 4 |
| 5 | Working on Library Management System | Modify the Library Management System with HTML Helper and User SQL Server Database for CRUD Operations using Entity Framework | Week 5 |
| 6 | Update Library Management System for Client Side | Update your Library Management System with AJAX Technologies for View, Update, Delete Functions | Week 6 |
| 7 | Securing your Library Management Application | Apply ASP.NET Core MVC Security Functionalities on your Library Management System | Week 7 |
| 8 | Develop and Consume Web API | Develop ASP.NET Core Web API for Library Management System and Consume it for Web Application | Week 8 |
| 9 | Building a simple React Application | Build a React JS application includes Component Design, State Management, Routing and API Integration | Week 9 |
| 10 | Modifying React Application for front-end | Update your React JS Application that will have UI Implementation, State Management Implementation, Error Handling and Optimization | Week 10 |
| 11 | Complete Library Management System | Connect your Back-End SQL Server with Front-End Using ASP.NET MVC and React JS for Library Management System. Use ASP.NET Web APIs for CRUD Operations | Week 11 |
| 12 | Final Project | Develop Full Stack Web Application with ASP.NET Core MVC and Web API includes React JS | Week 12 |