Seminar microsoft net specialist

Free Seminar on Feb 10, 2020 at 07:30 PM This extensive project driven course covers n-tier web application development using Microsoft .NET Framework / .NET Core, Visual Studio 2019 and SQL Server 2017. It includes object oriented programming using C#, web development using HTML5, CSS3 and Bootstrap 4; Interactive and rich UI development using JavaScript, jQuery and jQuery UI; Server side programming using ASP .NET Core MVC, Web API and C#; Database programming using ADO .NET Entity Framework, LINQ and SQL Server 2017. Brief Contents Overview of Microsoft .NET Platform & .NET Core Fundamentals of VB .NET / C# Language Object Oriented Class Libraries Development Generics , Exceptions, Events and Delegates Lambda expression, Collections & LINQ Developing Web Applications using Visual Studio 2019 Create web pages and HTML Forms using HTML5 & CSS3 Styling Text, Block Elements etc. using CSS3 Selectors Enhancing Graphical Effects by Using CSS3 Essentials of JavaScript, jQuery, & JSON Programming the HTML DOM with JavaScript & jQuery Validating User Input using HTML5 Attributes, JavaScript & jQuery Responsive Web Development using Twitter Bootstrap 4 Creating rich user interface using jQuery UI Using AJAX for Efficient ASP .NET Web UI Overview of ASP .NET Core MVC, Razor pages & Web API Essentials of ASP .NET Core MVC Application Creating & using ASP .NET Core MVC Models Developing Web Application using ASP .NET Core Razor pages Creating & using Layout Views, Partial Views & HTML Helpers Essentials of Database Programming in .NET Database Programming using Entity Framework Core Testing and Debugging ASP .NET Core MVC Web Application Applying Styles to ASP .NET Core MVC Web Applications Building Responsive Pages in ASP .NET Core MVC Applications State Management in ASP .NET Core MVC Developing & Consuming Web API using ASP .NET Core MVC Layered Architecture & N-Tier Web Application Development Creating Reports in ASP .NET Core MVC Application Configuration & Deployment of ASP .NET Core MVC Applications Training Methodology Lectures & Demos by industry experts Project Driven Hands-On approach Focus on latest tools, technologies & industry practices Projects, assignments & quizzes for student’s evaluation Audience Programmers, Software Developer, Web Developers Software Analysts , Software Designers and Software Architects Students of software engineering, computer science & IT Any other person willing to learn software development using .NET Course Project Participants of the course will develop a commercial level web application using C#, Entity Framework Core and ASP .NET Core MVC. The project should be implemented using best practices of the object oriented software application development.

Free Seminar on Mar 30, 2020 at 07:30 PM Microsoft SQL Server 2016 provides a robust architecture for enterprise level data management, developer’s productivity and business intelligence. This hands-on course is designed to provide necessary knowledge and hands-on experience for installation and configuration and administration of SQL Server 2016; designing and implementing SQL Server databases, querying and manipulating data from SQL Server and implementing a Data Warehouse with SQL Server 2016. Brief Contents Introduction to SQL Server, Its Installation & Configuration Introduction to Database Designing & Entity Relationship Diagram (ERD) Database Design Theory Concepts & Rules for Normalization Working with Tables, Schemas, Columns & Built-In Data Types Working with Primary Keys, Foreign Keys & Identity Column Working with SQL Server Management Studio Ensuring Data Integrity through Constraints Introduction to T-SQL & Writing Basic Select Statements Eliminating Duplicates with DISTINCT & Using Column and Table Aliases Writing Queries that Filter Data using a WHERE Clause Writing Queries that Sort Data Using an ORDER BY Clause Writing Queries that Filter Data Using the TOP Option Write Queries that filter data using the OFFSET-FETCH Querying Multiple Tables & Understanding Joins Inner Joins, Self Joins, Outer Joins & Cross Joins Indexing & Designing Optimized Indexing Strategies Using Conversion Functions, Logical Functions & Function to work with NULL Writing Queries using GROUP BY Clause & Aggregate Functions Writing Queries that Filter Groups with the HAVING Clause Using Self-Contained Subqueries, Scalar Subqueries & Multi-Result Subqueries Writing Queries That Use Correlated Subqueries and EXISTS Clause Writing Queries with UNION, EXCEPT, INTERSECT & APPLY Designing & Implementing Views & Performance Consideration for Views Inserting, Updating & Deleting Data using Data Manipulation Language (DML) Designing and Implementing Stored Procedures Creating & using user defined Table-Valued Functions (TVFs) Creating & using user defined Common Table Expressions (CTEs) Programming with T-SQL: T-SQL Programming Elements Programming with T-SQL: Controlling Program Flow Programming with T-SQL: Implementing T-SQL error handling Programming with T-SQL: Implementing structured exception handling Programming with T-SQL: Controlling database transactions Responding to Data Manipulation via Triggers Storing and Querying XML & Spatial Data in SQL Server Storing and Querying BLOBs and Text Documents in SQL Server Performance Optimization, Monitoring & Concurrency in SQL Server Training Methodology Audience Course Project Participants of the course will complete hands-on labs and project assignments with help of their trainers. Certificate EVS Certified SQL Server Developer MCP: Querying Data with Transact-SQL MCP: Developing SQL Database Duration & Frequency 2 Month (8 weeks; with 3 training sessions of 1.5 hours a week) Views: 2

Free Seminar on Mar 30, 2020 at 07:30 PM Microsoft SQL Server 2016 provides a robust architecture for enterprise level data management, developer’s productivity and business intelligence. This hands-on course is designed to provide necessary knowledge and hands-on experience for installation and configuration and administration of SQL Server 2016; designing and implementing SQL Server databases, querying and manipulating data from SQL Server and implementing a Data Warehouse with SQL Server 2016. Brief Contents Introduction to SQL Server, Its Installation & Configuration Introduction to Database Designing & Entity Relationship Diagram (ERD) Database Design Theory Concepts & Rules for Normalization Working with Tables, Schemas, Columns & Built-In Data Types Working with Primary Keys, Foreign Keys & Identity Column Working with SQL Server Management Studio Ensuring Data Integrity through Constraints Introduction to T-SQL & Writing Basic Select Statements Eliminating Duplicates with DISTINCT & Using Column and Table Aliases Writing Queries that Filter Data using a WHERE Clause Writing Queries that Sort Data Using an ORDER BY Clause Writing Queries that Filter Data Using the TOP Option Write Queries that filter data using the OFFSET-FETCH Querying Multiple Tables & Understanding Joins Inner Joins, Self Joins, Outer Joins & Cross Joins Indexing & Designing Optimized Indexing Strategies Using Conversion Functions, Logical Functions & Function to work with NULL Writing Queries using GROUP BY Clause & Aggregate Functions Writing Queries that Filter Groups with the HAVING Clause Using Self-Contained Subqueries, Scalar Subqueries & Multi-Result Subqueries Writing Queries That Use Correlated Subqueries and EXISTS Clause Writing Queries with UNION, EXCEPT, INTERSECT & APPLY Designing & Implementing Views & Performance Consideration for Views Inserting, Updating & Deleting Data using Data Manipulation Language (DML) Designing and Implementing Stored Procedures Creating & using user defined Table-Valued Functions (TVFs) Creating & using user defined Common Table Expressions (CTEs) Programming with T-SQL: T-SQL Programming Elements Programming with T-SQL: Controlling Program Flow Programming with T-SQL: Implementing T-SQL error handling Programming with T-SQL: Implementing structured exception handling Programming with T-SQL: Controlling database transactions Responding to Data Manipulation via Triggers Storing and Querying XML & Spatial Data in SQL Server Storing and Querying BLOBs and Text Documents in SQL Server Performance Optimization, Monitoring & Concurrency in SQL Server Training Methodology Audience Course Project Participants of the course will complete hands-on labs and project assignments with help of their trainers. Certificate EVS Certified SQL Server Developer MCP: Querying Data with Transact-SQL MCP: Developing SQL Database Duration & Frequency 2 Month (8 weeks; with 3 training sessions of 1.5 hours a week) Date Mar 30th