Courses
Browse

Full Stack Web Developer - MEAN Stack

Master Program

Our MEAN Stack training will allow you to learn how to create full-stack web applications using the front end and back-end JavaScript technologies, which form the core of MEAN - MongoDB, ExpressJS, Angular, and Node.js. As part of this MEAN Stack Certification course, you will cover each module in detail and gain hands-on experience by executing real-world projects. At the end of the training, you will be awarded Intellipaat's MEAN Stack Course Completion Certificate, which you can showcase to your potential employers to get lucrative jobs. Therefore, sign up for this course to learn to build applications from scratch and embark on one of the most profitable career paths.

In Collaboration with IBM Microsoft
  • 6+

    Courses

  • 13+

    Projects

  • 140

    Hours

  • Online Classroom Training

    • HTML and jQuery
    • Node.js
    • Angular
    • MongoDB
    • DevOps
    • SQL

Key Features

140 Hrs Instructor Led Training
134 Hrs Self-paced Videos
248 Hrs Project work & Exercises
Certification and Job Assistance
Flexible Schedule
Lifetime Free Upgrade
24 x 7 Lifetime Support & Access

Course Fees

Online Classroom preferred

  • Everything in self-paced, plus
  • 140 Hrs of instructor-led training
  • 1:1 doubt resolution sessions
  • Attend as many batches for Lifetime
  • Flexible Schedule
  • 06 Jun
  • SAT - SUN
  • 08:00 PM TO 11:00 PM IST (GMT +5:30)
  • 13 Jun
  • SAT - SUN
  • 08:00 PM TO 11:00 PM IST (GMT +5:30)
  • 20 Jun
  • SAT - SUN
  • 08:00 PM TO 11:00 PM IST (GMT +5:30)
  • 27 Jun
  • SAT - SUN
  • 08:00 PM TO 11:00 PM IST (GMT +5:30)
$700 10% OFF Expires in
$0

Corporate Training

  • Customized Learning
  • Enterprise grade learning management system (LMS)
  • 24x7 support
  • Strong Reporting

About MEAN Stack Master's Course

Intellipaat’s MEAN Stack master’s course is designed and curated by industry experts who have over 12 years of substantive experience in working as full-stack developers. Thus, by enrolling in this training program, you can lay a solid foundation on all the core components of MEAN, plus gain proficiency in HTML, CSS, DevOps, and more. In addition, you will work on several MEAN Stack projects that will help you evaluate your skills and knowledge to solve real-world business problems.

List of Courses Included:

Online Instructor-led Courses:

  • HTML and jQuery Training
  • Node.js
  • Angular
  • MongoDB
  • DevOps
  • SQL
  • MEAN stack (MongoDB, ExpressJS, Angular, and Node.js)
  • DevOps
  • HTML & CSS
  • Integration of Angular applications with Node.js
  • CURD (Create, Read, Update, and Delete)
  • JSON web-token authentication, and more

Intellipaat’s MEAN Stack developer certification course is meant for:

  • Undergraduates and Freshers looking to make their career in MEAN Stack
  • Web developers
  • Web designers
  • Freelancers who want to build and test their own apps by leveraging MEAN stack
  • Project managers, etc.

At Intellipaat, we do not enforce any pre-requisites for learners who want to upskill their MEAN stack knowledge. Everybody is welcome to enroll in this course.

View More

Talk to us

Full Stack Reviews

John Chioles

Ritesh Bhagwat

Mr Yoga

Dileep & Ajay

Sagar

Ashok Guntupalli

Kokila

Senior Web Developer at Netcommlabs

This course is very nice and interesting as I go through it. Before taking it, I was nervous because I didn't have enough knowledge, but now I can say that I know more than a beginner.... Wonderful job! Thanks intellipaat for building my career.

Aalap Raj

Hadoop Developer at Cognizant

Excellent videos and interactive mode of online teaching. Instructors are well informed and clear while communicating.

Full Stack Course Content

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 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

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.

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

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 - Software Version Control

3.1 What is Version Control
3.2 Types of Version Control System
3.3 Introduction to SVN
3.4 Introduction to Git
3.5 Git Lifecycle
3.6 Common Git Commands
3.7 Working with Branches in Git
3.8 Merging Branches
3.9 Resolving Merge Conflicts
3.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 04 - Continuous Deployment: Containerization with Docker

4.1 Introduction to Docker
4.2 Understanding Docker Lifecycle
4.3 Components of Docker Ecosystem
4.4 Common Docker Operations
4.5 Creating a DockerHub Account
4.6 Committing changes in a Container
4.7 Pushing a Container Image to DockerHub
4.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 05 - Containerization with Docker: Ecosystem and Networking

5.1 What are Docker Volumes
5.2 Deploying a Multi-Tier Application using Docker Network
5.3 Using Docker Compose to deploy containers
5.4 What is Container Orchestration
5.5 Container Orchestration Tools
5.6 Introduction to Docker Swarm
5.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 06 - Configuration Management using Puppet

6.1 Need of Configuration Management
6.2 Configuration Management Tools
6.3 What is Puppet
6.4 Puppet Architecture
6.5 Setting up Master Slave using Puppet
6.6 Puppet Manifests
6.7 Puppet Modules
6.8 Applying configuration using Puppet
6.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 07 - Configuration Management using Ansible

7.1 What is Ansible?
7.2 Ansible vs Puppet
7.3 Ansible Architecture
7.4 Setting up Master Slave using Ansible
7.5 Ansible Playbook
7.6 Ansible Roles
7.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 08 - Continuous Testing using Selenium

8.1 What is Continuous Testing?
8.2 Introduction to Selenium
8.3 What is Maven?
8.4 Using Maven with Selenium>
8.5 Creating Test Cases with Selenium
8.6 Running Test Cases on Chromium Web Driver
8.7 What is Headless Mode?

Hands-on Exercise – 

1. Using Maven to import dependencies in Eclipse
2. Create Sample Test Case for a website using Selenium
3. Implementing a headless test in selenium using Chrome WebDriver

Module 09 - Continuous Integration using Jenkins

9.1 Introduction to Continuous Integration
9.2 Jenkins Master Slave Architecture
9.3 Understanding CI/CD Pipelines
9.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 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

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 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
View More

Free Career Counselling

Certification

Intellipaat MEAN Stack Certification training is a comprehensive online classroom program designed to clear multiple certifications, including:

  • JavaScript
  • HTML
  • CSS
  • Node.js
  • Angular
  • MongoDB
  • DevOps

The entire content of the training tallies with the corresponding certification exam. At the end of the training, quizzes will be conducted that perfectly reflects the nature of the questions asked in each certification exam and help you achieve higher scores. The Intellipaat course completion certificate will be awarded after the project has been completed (after expert review) and upon scoring a minimum of 60% in the test. You would be glad to know that Intellipaat’s certification is recognized across the globe by leading multinational companies, including IBM, Amazon, Ericsson, Sony, Mu Sigma, Cisco, Cognizant, Saint-Gobain, Standard Chartered Bank, TCS, Hexaware, Genpact, and more.

Our Alumni works at top 3000+ companies

client-desktop client-mobile

Course Advisor

Suresh Paritala

Suresh Paritala

Solutions Architect at Microsoft, USA

A Senior Software Architect at NextGen Healthcare who has previously worked with IBM Corporation, Suresh Paritala has worked on Big Data, Data Science, Advanced Analytics, Internet of Things and Azure, along with AI domains like Machine Learning and Deep Learning. He has successfully implemented high-impact.

David Callaghan

David Callaghan

Big Data Solutions Architect, USA

An experienced Blockchain Professional who has been bringing integrated Blockchain, particularly Hyperledger and Ethereum, and Big Data solutions to the cloud, David Callaghan has previously worked on Hadoop, AWS Cloud, Big Data and Pentaho projects that have had major impact on revenues of marquee brands around the world.

Samanth Reddy

Samanth Reddy

Data Team Lead at Sony, USA

A renowned Data Scientist who has worked with Google and is currently working at ASCAP, Samanth Reddy has a proven ability to develop Data Science strategies that have a high impact on the revenues of various organizations. He comes with strong Data Science expertise and has created decisive Data Science strategies for Fortune 500 corporations.

Frequently Asked Questions on MEAN Stack

What is Intellipaat’s MEAN Stack master's course and how it is different from individual courses?

Intellipaat MEAN Stack certification training covers topics such as JavaScript, HTML, CSS, Node.js, Angular, MongoDB, DevOps, etc., to help you become a full-stack developer. However, Intellipaat’s individual courses focus on one or two technologies only. Therefore, if you need to master MEAN Stack, then this is the best option for you.

At Intellipaat you can enroll either for the instructor-led online training or self-paced training. Apart from this Intellipaat also offers corporate training for organizations to upskill their workforce. All trainers at Intellipaat have 12+ years of relevant industry experience and they have been actively working as consultants in the same domain making them subject matter experts. Go through the sample videos to check the quality of the trainers.
Intellipaat is offering the 24/7 query resolution and you can raise a ticket with the dedicated support team anytime. You can avail the email support for all your queries. In the event of your query not getting resolved through email we can also arrange one-to-one sessions with the trainers. You would be glad to know that you can contact Intellipaat support even after completion of the training. We also do not put a limit on the number of tickets you can raise when it comes to query resolution and doubt clearance.
Intellipaat offers the self-paced training to those who want to learn at their own pace. This training also affords you the benefit of query resolution through email, one-on-one sessions with trainers, round the clock support and access to the learning modules or LMS for lifetime. Also you get the latest version of the course material at no added cost. The Intellipaat self-paced training is 75% lesser priced compared to the online instructor-led training. If you face any problems while learning we can always arrange a virtual live class with the trainers as well.
Intellipaat is offering you the most updated, relevant and high value real-world projects as part of the training program. This way you can implement the learning that you have acquired in a real-world industry setup. All training comes with multiple projects that thoroughly test your skills, learning and practical knowledge thus making you completely industry-ready. You will work on highly exciting projects in the domains of high technology, ecommerce, marketing, sales, networking, banking, insurance, etc. Upon successful completion of the projects your skills will be considered equal to six months of rigorous industry experience.
Intellipaat actively provides placement assistance to all learners who have successfully completed the training. For this we are exclusively tied-up with over 80 top MNCs from around the world. This way you can be placed in outstanding organizations like Sony, Ericsson, TCS, Mu Sigma, Standard Chartered, Cognizant, Cisco, among other equally great enterprises. We also help you with the job interview and résumé preparation part as well.
You can definitely make the switch from self-paced to online instructor-led training by simply paying the extra amount and joining the next batch of the training which shall be notified to you specifically.
Once you complete the Intellipaat training program along with all the real-world projects, quizzes and assignments and upon scoring at least 60% marks in the qualifying exam; you will be awarded the Intellipaat verified certification. This certificate is very well recognized in Intellipaat affiliate organizations which include over 80 top MNCs from around the world which are also part of the Fortune 500 list of companies.
Apparently, No. Our Job Assistance program is aimed at helping you land in your dream job. It offers a potential opportunity for you to explore various competitive openings in the corporate world and assists you in finding a well-paid job, matching your profile. The final decision on your hiring will always be based on your performance in the interview and the requirements of the recruiter.
View More

Talk to us

Select Currency