Full Stack Web Developer - MEAN Stack

Introduction to SQL

Various types of databases, introduction to Structured Query Language, distinction between client server and file server databases, understanding SQL Server Management Studio, SQL Table basics, data types and functions, Transaction-SQL, authentication for Windows, data control language, and the identification of the keywords in T-SQL, such as Drop Table.

Database Normalization and Entity Relationship Model

Data Anomalies, Update Anomalies, Insertion Anomalies, Deletion Anomalies, Types of Dependencies, Functional Dependency, Fully functional dependency, Partial functional dependency, Transitive functional dependency, Multi-valued functional dependency, Decomposition of tables, Lossy decomposition, Lossless decomposition, What is Normalization?, First Normal Form, Second Normal Form, Third Normal Form, Boyce-Codd Normal Form(BCNF), Fourth Normal Form, Entity-Relationship Model, Entity and Entity Set, Attributes and types of Attributes, Entity Sets, Relationship Sets, Degree of Relationship, Mapping Cardinalities, One-to-One, One-to-Many, Many-to-one, Many-to-many, Symbols used in E-R Notation.

SQL Operators

Introduction to relational databases, fundamental concepts of relational rows, tables, and columns; several operators (such as logical and relational), constraints, domains, indexes, stored procedures, primary and foreign keys, understanding group functions, the unique key, etc.

Working with SQL: Join, Tables, and Variables

Advanced concepts of SQL tables, SQL functions, operators & queries, table creation, data retrieval from tables, combining rows from tables using inner, outer, cross, and self joins, deploying operators such as ‘intersect,’ ‘except,’ ‘union,’ temporary table creation, set operator rules, table variables, etc.

Deep Dive into SQL Functions

Understanding SQL functions – what do they do?, scalar functions, aggregate functions, functions that can be used on different datasets, such as numbers, characters, strings, and dates, inline SQL functions, general functions, and duplicate functions.

Working with Subqueries

Understanding SQL subqueries, their rules; statements and operators with which subqueries can be used, using the set clause to modify subqueries, understanding different types of subqueries, such as where, select, insert, update, delete, etc., and methods to create and view subqueries.

SQL Views, Functions, and Stored Procedures

Learning SQL views, methods of creating, using, altering, renaming, dropping, and modifying views; understanding stored procedures and their key benefits, working with stored procedures, studying user-defined functions, and error handling.

Deep Dive into User-defined Functions

User-defined functions; types of UDFs, such as scalar, inline table value, multi-statement table, stored procedures and when to deploy them, what is rank function?, triggers, and when to execute triggers?

SQL Optimization and Performance

SQL Server Management Studio, using pivot in MS Excel and MS SQL Server, differentiating between Char, Varchar, and NVarchar, XL path, indexes and their creation, records grouping, advantages, searching, sorting, modifying data; clustered indexes creation, use of indexes to cover queries, common table expressions, and index guidelines.

Managing Data with Transact-SQL

Creating Transact-SQL queries, querying multiple tables using joins, implementing functions and aggregating data, modifying data, determining the results of DDL statements on supplied tables and data, and constructing DML statements using the output statement.

Querying Data with Advanced Transact-SQL Components

Querying data using subqueries and APPLY, querying data using table expressions, grouping and pivoting data using queries, querying temporal data and non-relational data, constructing recursive table expressions to meet business requirements, and using windowing functions to group and rank the results of a query.

Programming Databases Using Transact-SQL

Creating database programmability objects by using T-SQL, implementing error handling and transactions, implementing transaction control in conjunction with error handling in stored procedures, and implementing data types and NULL.

Designing and Implementing Database Objects

Designing and implementing relational database schema; designing and implementing indexes, learning to compare between indexed and included columns, implementing clustered index, and designing and deploying views and column store views.

Implementing Programmability Objects

Explaining foreign key constraints, using T-SQL statements, usage of Data Manipulation Language (DML), designing the components of stored procedures, implementing input and output parameters, applying error handling, executing control logic in stored procedures, and designing trigger logic, DDL triggers, etc.

Managing Database Concurrency

Applying transactions, using the transaction behavior to identify DML statements, learning about implicit and explicit transactions, isolation levels management, understanding concurrency and locking behavior, and using memory-optimized tables.

Optimizing Database Objects

Accuracy of statistics, formulating statistics maintenance tasks, dynamic management objects management, identifying missing indexes, examining and troubleshooting query plans, consolidating the overlapping indexes, the performance management of database instances, and SQL server performance monitoring.

Advanced Topics

Corelated Subquery, Grouping Sets, Rollup, Cube

Hands-on Exercise

Implementing Corelated Subqueries, Using EXISTS with a Correlated subquery, Using Union Query, Using Grouping Set Query, Using Rollup, Using CUBE to generate four grouping sets, Perform a partial CUBE.

Microsoft Courses: Study Material

• Performance Tuning and Optimizing SQL Databases
• Querying Data with Transact-SQL

What are the projects I will be working on during this Microsoft SQL certification training?

Project 1: Writing Complex Subqueries

Industry: General

Problem Statement: How to create subqueries using SQL?

Topics: This project will give you hands-on experience in working with SQL subqueries and utilizing them in various scenarios. Some of the subqueries that you will be working with and gaining hands-on experience in are: IN or NOT IN, ANY or ALL, EXISTS or NOT EXISTS, and other major queries.

Highlights:

• Accessing and manipulating databases
• Operators and control statements in SQL
• Executing queries in SQL against databases

Project 2: Querying a Large Relational Database

Industry: General

Problem Statement: How to get details about customers by querying the database?

Topics: In this project, you will work on downloading a database and restoring it on the server. You will then query the database to get customer details like name, phone number, email ID, sales made in a particular month, increase in month-on-month sales, and even the total sales made to a particular customer.

Highlights:

• Table basics and data types
• Various SQL operators
• Various SQL functions

Project 3: Relational Database Design

Industry: General

Problem Statement: How to convert a relational design into a table in SQL Server?

Topics: In this project, you will work on converting a relational design that has enlisted within it various users, user roles, user accounts, and their statuses. You will create a table in SQL Server and insert data into it. With at least two rows in each of the tables, you will ensure that you have created respective foreign keys.

Highlights:

• Defining relations/attributes
• Defining the primary keys
• Creating foreign keys

Module 01 - Infrastructure Setup

1.1 EC2 Walkthrough

1.2 Installation of DevOps Tools on cloud

• • Git
  • Docker
  • Selenium
  • Maven
  • Jenkins
  • Puppet
  • Ansible
  • Kubernetes
  • Nagios

Module 02 - Introduction to DevOps

2.1 What is Software Development
2.2 Software Development Life Cycle
2.3 Traditional Models for SDLC
2.4 Why DevOps?
2.5 What is DevOps?
2.6 DevOps Lifecycle
2.7 DevOps Tools

Module 03 - Continuous Testing

3.1 What is Continuous Testing?
3.2 What is Maven?
3.3 Running Test Cases on Chromium Web Driver
3.4 What is Headless Mode?

Hands-on Exercise – 

1. Using Maven to import dependencies in Eclipse
2. Implementing a headless test using Chrome WebDriver

Module 04 - Continuous Integration using Jenkins

4.1 Introduction to Continuous Integration
4.2 Jenkins Master Slave Architecture
4.3 Understanding CI/CD Pipelines
4.4 Creating an end to end automated CI/CD Pipeline

Hands-on Exercise –

1. Creating a Jenkins Master Slave on AWS
2. Installing Plug-ins in Jenkins
3. Creating Jenkins Builds
4. Creating Scheduled Builds
5. Triggering Jobs using Git Web Hooks
6. Using the Pipeline Plugin In Jenkins

Module 05 - Software Version Control

5.1 What is Version Control
5.2 Types of Version Control System
5.3 Introduction to SVN
5.4 Introduction to Git
5.5 Git Lifecycle
5.6 Common Git Commands
5.7 Working with Branches in Git
5.8 Merging Branches
5.9 Resolving Merge Conflicts
5.10 Git Workflow

Hands-on Exercise – 

1. Git Life cycle Commands
2. Pushing Code to Github
3. Stashing Code in git
4. Creating, Deleting Git Branches
5. Reverting a Push to GitHub
6. Merging branches using git merge
7. Merging branches using git rebase.
8. Resolving merge conflicts using git merge tool

Module 06 - Continuous Deployment: Containerization with Docker

6.1 Introduction to Docker
6.2 Understanding Docker Lifecycle
6.3 Components of Docker Ecosystem
6.4 Common Docker Operations
6.5 Creating a DockerHub Account
6.6 Committing changes in a Container
6.7 Pushing a Container Image to DockerHub
6.8 Creating Custom Docker Images using Dockerfile

Hands-on Exercise – 

1. Common Docker Operations
2. Creating a DockerHub Account
3. Committing Changes to a Container
4. Pushing container to DockerHub
5. Creating Local Image Repository
6. Building an Image using Dockerfile

Module 07 - Containerization with Docker: Ecosystem and Networking

7.1 What are Docker Volumes
7.2 Deploying a Multi-Tier Application using Docker Network
7.3 Using Docker Compose to deploy containers
7.4 What is Container Orchestration
7.5 Container Orchestration Tools
7.6 Introduction to Docker Swarm
7.7 Deploying a 2-Node Cluster using Docker Swarm

Hands-on Exercise – 

1. Creating Docker Volumes
2. Using Docker Compose to deploy multiple containers
3. Deploying a Multi Node Cluster using Docker Swarm
4. Deploying a multi-service app on Docker Swarm

Module 08 - Configuration Management using Puppet

8.1 Need of Configuration Management
8.2 Configuration Management Tools
8.3 What is Puppet
8.4 Puppet Architecture
8.5 Setting up Master Slave using Puppet
8.6 Puppet Manifests
8.7 Puppet Modules
8.8 Applying configuration using Puppet
8.9 Puppet File Server

Hands-on Exercise – 

1. Setting up Master Slave on AWS
2. Testing Connection of nodes with Puppet
3. Creating a Manifest
4. Deploying Manifest on Node
5. Creating a Module
6. Deploying sample software on nodes using Puppet Modules and Manifests
7. Implementing a File Server Module on Puppet

Module 09 - Configuration Management using Ansible

9.1 What is Ansible?
9.2 Ansible vs Puppet
9.3 Ansible Architecture
9.4 Setting up Master Slave using Ansible
9.5 Ansible Playbook
9.6 Ansible Roles
9.7 Applying configuration using Ansible

Hands-on Exercise – 

1. Installing Ansible on AWS
2. Creating a Playbook using YAML
3. Creating an Ansible Role
4. Using Roles in Playbook

Module 10 - Continuous Orchestration using Kubernetes

10.1 Introduction to Kubernetes
10.2 Docker Swarm vs Kubernetes
10.3 Kubernetes Architecture
10.4 Deploying Kubernetes using Kubeadms
10.5 Alternate ways of deploying Kubernetes
10.6 YAML Files
10.7 Creating a Deployment in Kubernetes using YAML
10.8 Services in Kubernetes
10.9 Ingress in Kubernetes
10.10 Case Study – Kubernetes Architecture

Hands-on Exercise – 

1. Setting up Kubernetes using kubeadm
2. Installing Kubernetes using kops and GCK
3. Creating a Deployment
4. Creating Services
5. Creating an Ingress
6. Demonstrating the use of Ingress, services and deployments together

Module 11 - Continuous Monitoring using Nagios

11.1 What is Continuous Monitoring
11.2 Introduction to Nagios
11.3 Nagios Architecture
11.4 Monitoring Services in Nagios
11.5 What are NRPE Plugins
11.6 Monitoring System Info using NRPE plugins

Hands-on Exercise – 

1. Installing Nagios
2. Monitoring of different servers using Nagios

Module 12 - Terraform Modules & Workspaces

12.1 Creating first EC2 instance with Terraform
12.2 Understanding Resources & Providers
12.3 Destroying Infrastructure with Terraform
12.4 Destroying Specific Resource
12.5 Understanding Terraform State files
12.6 Understanding Desired & Current States
12.7 Challenges with the current state on computed values
12.8 Terraform Commands – State Files
12.9 Terraform Provider Versioning
12.10 Types of Terraform Providers
12.11 Understanding Attributes and Output Values in Terraform
12.12 Attribute Resource (Document)
12.13 Fetching Data from Maps and List in Variable
12.14 Terraform Format
12.15 Validating Terraform Configuration Files
12.16 Integrating with GIT for team management
12.17 Terraform Provider UseCase – Resources in Multiple Regions

Hands-on Exercise – 

1. Creating Infrastructure with Terraform Cloud
2. Implementing remote-exec provisioners
3. Implementing local-exec provisioners
4. Handling Access & Secret Keys the Right Way in Providers
5. Handling Multiple AWS Profiles with Terraform Providers

What projects I will be working on this DevOps certification training?

In this DevOps project you will be introduced to the DevOps pipeline demo in various industry domains like media, finance, medical projects and more. You will get hands-on experience in Docker containerization by deploying Jenkins, working with integration tests in DevOps, Project Reports and finance app configuration.

Project 01 – Creating CI/CD Pipeline to build and test a Website

Problem Statement : How to create a CI/CD Pipeline for building and testing a website

Topics : Git, Docker, Jenkins, Puppet, Selenium

Highlights:

• Setting Puppet and Jenkins in Master Slave Architecture
• Integrating Git and Jenkins for automated pipelines
• Using Puppet for Configuration Management
• Containerizing a Website

Project 02 – Deploying an app on Kubernetes using CI/CD Pipelines

Topics : Git, Docker, Jenkins, Selenium, Kubernetes

Highlights:

• Connecting Jenkins, Git and Kubernetes
• Containerizing code using Dockerfile
• Deploying Dockerfile to container, and then to Dockerhub
• Deploying from Dockerhub to Kubernetes using Jenkins

Case Study 01 – Implementing Git Workflow

Problem Statement: To analyze and use a specific Git Workflow scenario

Topics: Git branches, Git workflows, merging, rebasing

Highlights:

• Using Industry standard architectures for implementing Git
• Merging braches
• Simulating a working architecture in git

Case Study 02 –Resolving Merge Conflicts

Problem Statement: Understanding how to resolve merge conflicts in different scenarios

Topics: Git branches, merging, rebasing

Highlights:

• Understanding the difference between merging and rebasing
• Resolving Merge conflicts based on different scenarios

Case Study 03 – Creating custom containers in Docker

Problem Statement: Creating a custom container from base Ubuntu container

Topics: Dockerfile, Dockerhub

Highlights:

• Creating a Dockerfile
• Pushing container to Dockerhub
• Creating custom Docker images

Case Study 04 – Using Bind Mounts, Docker Compose and Docker Swarm

Problem Statement: Deploy an application using Docker compose, Bind Mounts and Docker Swarm

Topics: Docker Swarm, Docker storage, Docker Compose, Docker Networks

Highlights:

• Creating and using Bind Mounts in Docker
• Deploying Multiple Docker applications using Docker compose
• Creating a Docker swarm cluster and Deploying applications over it

Case Study 05 – Using Puppet for Configuration Management

Problem Statement: Managing large fleet of servers using Puppet

Topics: Docker, puppet manifests, conditional statements, modules, classes

Highlights:

• Creating Modular scripts in Puppet
• Working with Puppet Manifests
• Managing large number of servers using Puppet

Case Study 06 – Using Selenium to create automated test cases

Problem Statement: Creating Automated Test cases in Selenium

Topics: Selenium, Runnable Jar files, chromedriver, headless tests

Highlights:

• Creating Automated Test Cases
• Creating Runnable Jar files
• Running headless tests in chrome using Non-GUI Linux

Introduction to Node.js

• What is Node.js?
• Why Node.js?
• Node Modules
• Node Built-in packages.
• Creating your own package.
• Import your own Package.
• NPM (Node Package Manager)
• Local and Global Packages

Hands-on:

• Install Node.js
• Run a simple Node.js Script
• Create a Node Module and use it in your code
• Search the NPM Repository to find a package and install it in your project

Asynchronous Programming

• What is Asynchronous Programming in JavaScript?
• JavaScript EventLoop
• Callbacks
• Callback Hell
• Promises
• Promise Chaining
• Async Await

Hands-on:

• Demonstrate the use of callbacks, promises, and async-await

FileSystem

• Synchronous vs Asynchronous IO
• File Constants (__dirname and __filename)
• Synchronous File Operations
• Asynchronous File Operations
• FileSystem Watcher

Hands-on:

• Write Node.js code to asynchronously perform file operations
• Write Node.js code to log to the console if a file changes in a directory

Streams and Events

• What are Streams in Node.js
• Reading and Writing Streams
• Understanding and using EventEmitter class
• Emitting Events
• Responding to events

Hands-on:

• Read data from a file using Input Stream and display on screen.

HTTP

• What is HTTP
• How Does HTTP Work?
• Standard HTTP response codes
• Node HTTP Module
• Processing Form Data
• Processing Query Strings from URL
• Sending Back response

Hands-on:

• Create a simple HTTP Server using Node

ExpressJS

• What is ExpressJS?
• Installing ExpressJS
• Creating a simple HTTPServer using ExpressJS
• Routing in Express
• Templating in Express
• Templating using JADE
• Middlewares

Hands-on:

• Create a simple ExpressJS Application with routes and templates

ExpressJS and MongoDB

• What is MongoDB
• MongoDB Advantages
• Documents
• Collections
• Mongoose ODM
• Creating Schemas and Models using mongoose
• CRUD Operations in MongoDB using Mongoose and Express

Hands-on:

• Create a simple TodoList Application using ExpressJS and Mongoose

Testing

• What is Unit Testing?
• Why Unit Testing?
• Unit Testing Frameworks
• What are Mocks and Stubs?
• Writing and Running tests in Express

Hands-on:

• Write and run some unit tests to test a module

REST API using Express and Mongoose

• What is a REST API
• Why REST API?
• Data Exchange Formats
• JSON vs. XML
• Monolith Architecture
• Microservice Architecture

Hands-on:

• Build a small application using the REST API

Module 01 - ES6 Primer

1.1 JavaScript history
1.2 ES6 and Babel
1.3 Arrow functions and template literals
1.4 Rest and spread operators
1.5 Classes and inheritance
1.6 Static methods and properties
1.7 Iterators and iterables
1.8 Generators

Module 02 - Introduction to React

2.1 Why React?
2.2 Version history of React
2.3 React 15 vs React 16
2.4 Using create-react-app
2.5 Debugging first react app

Module 03 - Templating Using JSX

3.1 Working with React.createElement
3.2 Logical operators and expressions
3.3 Specifying attributes and children

Module 04 - Components of React

4.1 Component architecture and its significance
4.2 Types of components

Module 05 - Working with Props and State

5.1 State and its significance
5.2 Set and read states
5.3 Passing data to a component through props
5.4 Validation of props with propTypes
5.5 Using default props to supply default values to props
5.6 Rendering lists
5.7 Using the React key prop
5.8 Using the map function for iteration on arrays to generate elements

Module 06 - Event Handling in React

6.1 React event system and the synthetic event
6.2 Passing arguments to event handlers
6.3 Component lifecycle
6.4 Significance of lifecycle methods and real-time use cases

Module 07 - Working with Forms

7.1 Controlled and uncontrolled components
7.2 Significance of the default Value prop
7.3 Using the React ref prop to access the DOM element

Module 08 - Routing with React Router

8.1 Setting up the router
8.2 Understanding routing with the help of single-page applications
8.3 Working with HashRouter and BrowserRouter components
8.4 Configuration of the router, using the route component
8.5 Using switch component for defining routing rules
8.6 Using route params for making routes dynamic
8.7 Working with nested routes
8.8 Navigation to pages, using NavLink and Link components
8.9 Using the redirect component to redirect the route
8.10 Using the prompt component to get user consent for navigation
8.11 Making use of the pathless route for handling failed matches

Module 09 - Just Redux and Immutable.js

9.1 What is redux?
9.2 Why redux?
9.3 Principles of redux
9.4 Installation and setup process of redux
9.5 Creation of reducer, actions, and store
9.6 What is Immutable.js?
9.7 Collections in Immutable
9.8 Lists, sets, and maps

Module 10 - React Redux

10.1 What is React Redux and why is it used?
10.2 Installation and setting up of React Redux
10.3 Container components vs presentational components
10.4 Understanding the high-order component
10.5 Understanding mapDispatchtToProps and mapStateToProps usage

Module 11 - Redux Middleware

11.1 Why redux middleware?
11.2 Choices available in redux middleware
11.3 Redux saga
11.4 Setting up and installing redux
11.5 Working with saga helpers
11.6 Promises vs sagas

Module 12 - Unit Testing

12.1 Significance of unit testing
12.2 Understanding unit testing tools and jargons
12.3 Unit testing react components, using enzyme and jest

Module 13 - New Features of React 16

13.1 Handling exceptions in components
13.2 Error boundaries

Module 14 - Webpack Primer and Isomorphic React

14.1 Webpack and its use
14.2 Setting up and installing Webpack
14.3 Working with the configuration file of Webpack
14.4 Working with loaders
14.5 Quick word on lazy loading, code splitting, and tree shaking
14.6 Setting up a hot module replacement
14.7 Server-side rendering (SSR)
14.8 Working with renderToStaticMarkup and renderToString methods

What are the projects I will be working on in this React training course?

Project 1: Developing an iOS Calculator

Domain: iOS Application

Problem Statement: Build and implement an iOS calculator using React

Topics: Nested routes, Webpack, and expressions

Highlights:

• Implementing nested routes
• Using Webpack
• Understanding expressions and operators

Project 2: Building an Offline Image Compressor

Domain: Image Compressor

Problem Statement: Develop an offline image compressor with browser-image-compression and React

Topics: Redux, iterators, and rendering lists

Highlights:

• Installing Redux
• Utilizing iterators
• Creating rendering lists

Introduction to NoSQL and MongoDB

RDBMS, types of relational databases, challenges of RDBMS, NoSQL database, its significance, how NoSQL suits Big Data needs, introduction to MongoDB and its advantages, MongoDB installation, JSON features, data types and examples

MongoDB Installation

Installing MongoDB, basic MongoDB commands and operations, MongoChef (MongoGUI) installation and MongoDB data types

Hands-on Exercise: Install MongoDB and install MongoChef (MongoGUI)

Importance of NoSQL

The need for NoSQL, types of NoSQL databases, OLTP, OLAP, limitations of RDBMS, ACID properties, CAP Theorem, Base property, learning about JSON/BSON, database collection and documentation, MongoDB uses, MongoDB write concern—acknowledged, replica acknowledged, unacknowledged, journaled—and Fsync

Hands-on Exercise: Write a JSON document

CRUD Operations

Understanding CRUD and its functionality, CRUD concepts, MongoDB query and syntax and read and write queries and query optimization

Hands-on Exercise:Use insert query to create a data entry, use find query to read data, use update and replace queries to update and use delete query operations on a DB file

Data Modeling and Schema Design

Concepts of data modelling, difference between MongoDB and RDBMS modelling, model tree structure, operational strategies, monitoring and backup

Hands-on Exercise: Write a data model tree structure for a family hierarchy

Data Management and Administration

In this module, you will learn MongoDB® Administration activities such as health check, backup, recovery, database sharding and profiling, data import/export, performance tuning, etc.

Hands-on Exercise: Use shard key and hashed shard keys, perform backup and recovery of a dummy dataset, import data from a CSV file and export data to a CSV file

Data Indexing and Aggregation

Concepts of data aggregation and types and data indexing concepts, properties and variations

Hands-on Exercise: Do aggregation using pipeline, sort, skip and limit and create index on data using single key and using multi-key

MongoDB Security

Understanding database security risks, MongoDB security concept and security approach and MongoDB integration with Java and Robomongo

Hands-on Exercise: MongoDB integration with Java and Robomongo

Working with Unstructured Data

Implementing techniques to work with variety of unstructured data like images, videos, log data and others and understanding GridFS MongoDB file system for storing data

Hands-on Exercise: Work with variety of unstructured data like images, videos, log data and others

What projects I will be working on this MongoDB training?

Project: Working with the MongoDB Java Driver

Industry: General

Problem Statement: How to create table for video insertion using Java

Topics: In this project, you will work with MongoDB Java Driver and become proficient in creating a table for inserting video using Java programming. You will work with collections and documents and understand the read and write basics of MongoDB database and the Java virtual machine libraries.

Highlights:

• Setting up MongoDB JDBC Driver
• Connecting to the database
• Java virtual machine libraries

HTML Course Content

Understanding HTML

Introduction to the Internet, and Web Technologies, learning about Server, Server types, HTTP Protocol, programming and methods, introduction to HTML programming, creation of HTML tags, marketing element with tags, adding attributes to an element, HTML5 Document Declaration and Document Structure, the strengths of HTML5 – extensive multimedia support, Canvas element, drag and drop features, geolocation, web storage, web workers and web sockets.

Deep dive into HTML

Detailed understanding of HTML5, the various elements like Header, Footer, Navigation, Section, Address, Article and Menu Elements, HTML specifications, creation of menu with order and unordered list, command table, distinguishing between Section & Article Element, web form creation and DIV element.

Hands-on Exercise – Write an htmp page with Header, Footer, Navigation elements, Create menu with order and unordered list, Create a web form, Create a div and a span element.

Jquery Course Content

Introduction to JQuery

Introducing JQuery, the objective of JQuery, fast and concise JavaScript Library, learning to use the JQuery Library, JQuery strengths of animation, event handling, HTML document traversing and Ajax interactions, accessing Google Hosted CDN, understanding DOM Loaded and DOM Not Loaded, the difference between window.onload and document.ready, understanding the wrapping element, selecting elements and performing action, finding zero elements, chaining multiple methods, JQuery Version, JQuery Prototype, no-conflict mode.

Hands-on Exercise – Traverse HTML document using Ajax interactions and retrived the values of elements, Access Google Hosted CDN

Working with Selectors & CSS

Introduction to Cascading Style Sheets, and CSS Selectors, understanding the various functions like HTML, CSS, Val, AddClass, RemoveClass, toggleClass Function, hasClass Function, understanding attr Function, removeAttr Function, prop Function, removeProp Function, Attribute Equal Selector, Attribute Not Equal Selector, Attribute Start with Selector, Attribute Ends with Selector, understanding Class, Element, ID, Lang, Not, Root Selector, working with last-of-type selector, Only Child Selector, Parent, Empty, Form and Button Selector.

Hands-on Exercise – Perform css operations to change the properties and alignments of page elements and tags

Working with JQuery Core

Introduction to JQuery Core, understanding how JQuery Core is defined in the JQuery Script, understanding the various functions like isEmptyObject, isPlainObject, isNumeric, isWindow Function, isArray Function, isEmptyObject, isPlainObject, the merge and map function, summary.

Hands-on Exercise – Use functions isEmptyObject, isPlainObject, isNumeric, isWindow Function, isArray Function, isEmptyObject, isPlainObject, the merge and map function

Event Handling

The objectives of JQuery Event Model, Binding Event Handlers, the bind and unbind event attachment, JQuery New Event API, current Target and related Target Property, JQuery Event Classification, form, mouse, keyboard events, trigger functions, custom events, the trigger Handler Function, summary.

Hands-on Exercise – Bind Event Handlers, Bind and Unbind event, set current Target and related Target Property, Handle events of form field entry, mouse clicks, keyboard events, trigger functions, custom events, the trigger Handler Function

Working with DOM Elements

Understanding the of Document Object Model, DOM Manipulation and function classification, the various Functions like wrap, wrapAll, wrapInner, unwrap, working with append, prepend, DOM Insertion, insertAfter, replaceAll Functions, summary.

Hands-on Exercise – Manipulate DOM using jQuery methods like wrap, wrapAll, wrapInner, unwrap, working with append, prepend, DOM Insertion, insertAfter, replace All

Working with AJAX

Understanding Asynchronous JavaScript, comparing Synchronous and Asynchronous, the advantages and disadvantages of AJAX, the data types, Get vs Post,  jQuery $.ajax() : The heart, The jqXHR Object, Ajax core method : Settings, A Sample AJAX request, jQuery $.get() Method, jQuery $.post() Method, .load method, AJAX EVENTS, Helper Function.

Hands-on Exercise – Use heart plugin to show ratings of a webpage, Use  $.ajax() to define GET and POST request handlers, Use jqXHR Object, Send a AJAX request, Use jQuery $.get() Method, Use $.post() Method

What projects I will be working on this HTML and Jquery training?

Project – Login Page and Load the data

Industry : Internet

Problem Statement – How to create a typical login page

Topics : It creates a login page which contains two fields that is username and password. If user enters the correct value then it will show a successful message and redirect to another page which includes three options: Load Data, Reload Data, Load Content. This is a hands-on project that helps you understand how HTML and JQuery works.

Highlights:

• Detailed HTML like Header, Footer, Navigation
• Working with JQuery library
• DOM programming API

Introduction to Angular

What is Angular, what are its features and advantages, understanding the Angular Technology Stack and Angular Library Components.

TypeScript

What is TypeScript, what is its need, how to install TypeScript, Nodemon for monitoring changes, interfaces in Class, String Templates, Maps, Sets and Object Destructuring, Var, Let, and Const keywords.

Features of Angular

The top features of Angular, CLI prompts, Angular Compiler, dependency and document updates, Angular elements and improved accessibility.

How to build with Angular Components

Building with Angular Components, building web components, custom elements, Angular CLI, ng-packagr, the lifecycle of Angular Components, creating a component and Deeper Nesting.

Responsive web designing

What is a responsive web design, building responsive web design with Angular, introduction to Bootstrap, creating responsive layouts with Bootstrap and code design for responsive websites.

Event binding

What is event binding, how to create event binding in Angular, building directives, template model, what is SystemJS and Webpack, responding to DOM events mostly created by users and getting inputs by binding to these inputs.

Dependency injection

Understanding Dependency Injection, the Dependency Injection API, Angular framework for Dependency Injection, coding pattern for dependencies, overview of service and how to create a service.

Directives in Angular

The function of a Directive in Angular, extending the power of HTML, giving it a new syntax, various types of Directives, how to create a custom Directive, different types of built-in Directives and custom structural Directives.

Pipes in Angular

What are Pipes in Angular and their features, transforming value in Angular template, various built-in Pipes in Angular, how to use it in any template and creating a custom Pipe in Angular.

Forms in Angular

What are Forms in Angular and what are their functions, advantages of Forms, template-driven Forms, reactive Forms, what is Angular Validation and Model driven approach.

Angular Routing

What is Angular Routing, its fundamentals, benefits and features, building a single page application and updating it dynamically with Angular Routing, what is Parameter Routing, Router Lifecycle Hooks and Child Routes.

Promises and Observables

What are Promises and Observables in Angular, comparing the two, handling HTTP requests with Promise, resolving multiple values with Observables, RxJS library for reactive programming with Observables, interacting with http get() in Angular and http Post.

Testing Angular applications

Introduction to testing Angular applications, setup and tools for testing, deploying Angular Test Bed for testing on Angular framework, testing services in Angular, E2E and DOM testing.

Linux Installation and Initialization (Automated)

Multiple Linux installations, automated installation using Kick start, deploying it using web server, installation media and Kick start configuration files.

Package management & Process monitoring

Linux Package which is Pre-built set of programs, installation of Packages, its libraries and the dependencies, understanding the low-level and high-levels tools needed, configuring Linux Yum Server, understanding the Yum repository Server-Client system.

Services, Utilities, Important Files and Directories

Deep dive into Linux Services, the important system files, utilities, directories.

Understanding SystemD

Learning about SystemD, the Linux-specific system and service manager, understanding what are the programs that run when Linux loads, familiarising with the systemctl commands.

Linux User Administration

Linux user management, groups, attributes and file permissions, granting permission based on tasks to be performed, various advanced user administration features, setting user and group disk space quotas, Linux file system quotas.

File System Management (Generic & LVM)

Managing the Linux File System, understanding the Logical Volume Management, allocating disks, stripping, mirroring, resizing, logical volumes, deploying LVM for setting hard disks for physical volumes.

Advanced File System Management (Software RAID)

Understanding the concept of RAID data storage virtualization, the RAID software management tool, learning about Linux Kernel with RAID Support, implementing the software RAID in Linux.

Server-Client Configurations (FTP / SFTP / HTTP)

Learning about the Server Configuration in Linux, the FTP/SFTP, the HTTP Server/Client Systems configuration.

Configuring Samba and SMTP

Understanding the Samba Open Source tool, the Simple Mail Transfer Protocol, configuring the Samba Server and SMTP with Linux.

Firewall & IP Tables

Understanding the basics of firewall in Linux, deploying the firewall and iptables in Linux which is a rule-based firewall system in Linux, testing the firewall rules.

Database Configuration (MySQL / Mariadb)

Understanding how to configure databases in Linux, working with MySQL database and MariaDB database for configuring it with Linux.

Using Control Panels to Manage Linux Servers (Webmin)

Learning about the various control panels in Linux, its various uses and applications in various services, deploying of these control panels to manage the Linux servers.