Microsoft ASP.Net CORE MVC Developer Diploma

Course details

Querying Microsoft SQL Server 
Course Outline
 
Understanding Core Database Concepts.
Working with Database Design and Normalization.
Introduction to Microsoft SQL Server 2014
Creating Database Objects
Introduction to T-SQL Querying
Writing SELECT Queries.
Sorting and Filtering Data
Grouping and Aggregating Data
Querying Multiple Tables.
Working with Views.
Working with SQL Server 2014 Data Types, Operators and Variables
Executing INSERT, UPDATE, DELETE
Using Subqueries
Using Set Operators
Using Built-In Functions
Using User-Defined Functions
Executing Stored Procedures
Working with DML Triggers
Pivoting and Grouping Sets
 Course 20483C: Programming in C# 


Course Outline
 
Intro to Programming Concepts.
.Net framework Components (BCL, CLR, JIT-Compiler)
Intro to Visual studio
Working with Data type , Operators
Variables
Casting and Conversion (implicit ,Explicit)
Control Statements
Branching (if , switch)
Iterations (for , do while , while , foreach)
Arrays
Jumping (go to) and Interruptions (continue, break, return)
Errors and Exception Handling (try-catch-finally)
Enumerations
Functions and Methods
Working with Method parameters and Calling (value, reference, out)
OOP Concepts
Classes and Objects
Working with Class members (Fields, properties , Methods)
Structures
Overloading and Overriding
Inheritance
Working with Interfaces
Constructor and Destructor
Static
Abstraction, Encapsulation and Polymorphism
Generics (Methods, Classes, Interfaces)    
Collections (List, ArrayList, Dictionary)      
LINQ to Objects
LINQ to Entities
 
Course 20480 Programming in HTML5 with JavaScript and CSS3
 Course Outline

 
Module 1: Overview of HTML and CSS
Module 2: Creating and Styling HTML Pages
Module 3: Introduction to JavaScript
Module 4: Creating Forms to Collect and Validate User Input
Module 5: Communicating with a Remote Server
Module 6: Styling HTML5 by Using CSS3
Module 7: Creating Objects and Methods by Using JavaScript
Module 8: Creating Interactive Pages by Using HTML5 APIs
Module 9: Adding Offline Support to Web Applications
Module 10: Implementing an Adaptive User Interface
Module 11: Creating Advanced Graphics
Module 12: Animating the User Interface
 Quick Introduction to jQuery
 Quick Introduction to Bootstrap 
  
Course 20486D: Developing Core MVC Web Applications

Course Outline
 
Module 1: Exploring Core MVC
Module 2: Designing Core MVC Web Applications
Module 3: Configure Middlewares and Services in Core
Module 4: Developing Controllers
Module 5: Developing Views
Module 6: Developing Models
Module 7: Using Entity Framework Core in Core
Module 8: Using Layouts, CSS and JavaScript in Core MVC
Module 9: Client-Side Development
Module 10: Testing and Troubleshooting
Module 11: Managing Security
Module 12: Performance and Communication
Module 13: Implementing Web APIs
Module 14: Hosting and Deployment
 
Course 20487 Developing Microsoft Azure and Web Services

Course Outline
 
Module 1: Overview of service and cloud technologies
Module 2: Querying and Manipulating Data Using Entity Framework
Module 3: Creating and Consuming Core Web APIs
Module 4: Extending Core HTTP Services
Module 5: Hosting Services On-Premises and in Azure
Module 6: Deploying and Managing Services
Module 7: Implementing Data Storage in Azure
Module 8: Diagnostics and Monitoring
Module 9: Securing services on-premises and in Microsoft Azure
Module 10: Scaling Services
  Updated on 09 November, 2021