Seminar microsoft

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 Feb 07, 2020 at 07:30 PM This extensive project-based course is designed to cover Full-Stack web development from scratch. It includes HTML5, CSS3 & BootStrap 4 for creating responsive and elegant webpages; JavaScript & jQuery for rich and more interactive UI development for web applications; PHP & Laravel Framework for back-end web development. Database programming for web using Eloquent ORM & MySql. Developing REST Services/API using PHP & Laravel Framework; and Consuming REST Services using AJAX & JSON. The course also covers essentials of Angular for modern single page web application development. Brief Contents Introduction Web Development, HTML, HTML5 & IDEs Basics of HTML & CSS and HTML Headings, Paragraphs & Images HTML Text Formatting, Links, Entities and Inline vs Block Level Elements HTML Lists: Unordered List, Ordered List and Description List iframe to Display Web-Pages from other Websites on your Website Detailed Overview of HTML5 and HTML5 Semantic Elements Using Audios and Videos on Websites using HTML5 Elements Creating Forms to Collect Data from Users using HTML5 & CSS3 Creating and Using CSS Styles: Inline CSS, Internal CSS & External CSS; Using CSS3 Styles with div, p, span etc. for Creating Beautiful Web Pages CSS3 Box-Model: Padding, Margin, Outline, Border, Background CSS3 Floating, Positioning, Overflow, Image-Opacity and Image-Sprites CSS3 Media Queries in Detail & Creating fully Responsive Web Pages Introduction to BootStrap 4 and BootStrap 4 Grid System in Detail BootStrap 4 Typography, Tables, Images, Thumbnails and Buttons BootStrap 4 for Creating Elegant Forms for Collecting User Data BootStrap 4 Jumbotron, Tooltips, Popovers, Alerts, Spinners & Badges BootStrap 4: Navs, Navbars, Menus, Tabs, Dropdown and Collapse BootStrap 4 Pagination, Modals, Cards, Image Carousel and Scrollspy JavaScript Statements, Expressions, Conditions and Loops JavaScript Objects, Functions, Arrays and Events Working with Numbers, Strings, and Dates in JavaScript Testing and Debug a JavaScript Applications Create object-oriented JavaScript applications Using Regular Expressions, Handling Exceptions and Validating Data Events, Images, and Timers, Closures, Callbacks and Recursion JavaScript Object Notation (JSON) in JavaScript Applications Selecting and Manipulating DOM Elements with jQuery Using jQuery for Event Handling, Basic Animations and Effects jQuery AJAX Calls ( load(), get(), post(), ajax(), getJSON(), getScript() ) Handling Responses of AJAX Call in Plain Text, HTML and JSON format Xammp & Netbeans Installation (PHP7 & MySql) Introduction to PHP, Basic PHP syntax & Conditional Statements PHP Programming: Loops (for, While , Do-while & Foreach) PHP Programming: Arrays , Super Global Arrays & Functions PHP Programming: Built in function’s PHP Programming: Intro to OOP, Data members & Data function PHP Programming: Access modifiers & Encapsulation PHP Programming: Magic Methods, Setter, Getter & Constructors PHP Programming: Inheritances, Polymorphism, Abstraction PHP Programming: Interfaces, Final Class, Static Function Introduction of Git Version-Control System & Git Installation Flow chart of Repositories, Branches & Git Commands Installing SourceTree GUI for Git & Composer Package Manager for PHP Download Latest Laravel Framework via Composer Intro of Laravel Directory Structure, Laravel Routing Laravel Framework: Create Controller via PHP Artisan Laravel Framework: Intro to Blade Template Engine Laravel Framework: Integrating Front-End theme to Laravel Laravel Framework: Build a Template Configuration based Laravel Framework: Create a components blade file and load in main controller file Laravel Framework: Load Layout in controller Laravel Framework: Create a global css and js file and load in main controller Laravel Framework: Download Laravel html collection package (form and html). Laravel Framework: Create a registration form & Intro of CSRF Token Laravel Framework: Create Forms & Handling Client side validation Laravel Famrwork: Uploading / Downloading Images using Laravel Introduction to Lumen Laravel Micro Framework for REST Services Create & Managing Databases for Web using MySQL Intro of Eloquent Laravel ORM Framework & Installation Database Programming using Eloquent & MySql Migration, Schema Builder, Seeders & Factories Eloquent REST APIs / REST Services: API routes, Controllers & Models Essentials of cURL for Consuming REST APIs / REST Services Consuming REST Services / REST API using AJAX and JSON Essentials of Angular for Creating Modern Web Applications Testing, Debugging & Publishing Website to a Commercial Server Training Methodology Lectures & Demos by industry experts Project Driven Hands-On approach Focus on latest tools, technologies & industry practices Projects, assignments & quizzes for participant’s evaluation Audience Students & Graduates of any discipline looking for future in IT Web Designers interested in learning Web Development Minimum requirement of formal education is intermediate Course Project Student of this course should be comfortable in using computers and internet. Prior knowledge of web development is helpful but not required for this course. Certificate On successful completion of the course participants will be awarded a participation certificate from EVS Professional Training Institute In addition to this, participants may acquire Microsoft certification for Programming in HTML5 with JavaScript & CSS3 ( Exam: 70-480: Programming in HTML5 with JavaScript & CSS3) Duration & Frequency Total Duration of the course is 6 months (24 Weeks, with 3 classes of 1.5 hours in a week).

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