Voisap’s AWS Master’s instruction program will definitely help you understand numerous facets of AWS consisting of SysOps, AWS Developer principles, AWS Solutions Engineer, as well as AWS Cloud Transfer. Additionally, the course covers Linux OS as well as DevOps from square one to further enrich your understanding. In this particular expert’s course, our company will certainly cover 9 various programs and also 50 hands-on jobs and projects to ensure that you obtain likely experience to operate in these areas directly
The AWS Masters Program will certainly enable you to create, blueprint and also range AWS applications utilizing over 70 cloud processing services. The AWS training course is straightened with the most recent AWS exam including Amazon assigned absolute best strategies.
The requirement for AWS accredited professionals is enhancing annually. The AWS market is assumed to connect with $236B by 2020 at a CAGR of 22 per-cent with greater than 380,000 cloud computing jobs readily available around the globe (source: Without a doubt). A snapshot of work and related salaries is discussed below.
CA: 1-416-569-4606
WhatsApp – 1-416-569-4606
Email – contact@voisap.com
Introduction to cloud computing and its types, types of cloud models, various cloud vendors, AWS overview, features and importance of AWS, AWS services and security, Use cases, and career opportunities in cloud.
Cloud best practices, cloud security best practices, and best practices in Database Service, Compute Service, Network Service, Application Service, Storage Service, Content Delivery Service, Deploy & Management Service.
Understanding Amazon Machine Image (AMI), various network interfaces, IP classification, Instance and types of Instances, and creating, managing, and troubleshooting Instances
Hands-on Exercise: Creating an EC2 instance on AWS Management Console and connecting to the system
Introduction to Virtual Private Cloud (VPC) and basics of cloud networking, VPC components, custom route tables, VPC peering, public and private subnets, configuring subnets, fundamentals of Network Address Translation (NAT), route tables, NAT high-availability design, NAT server and NAT Gateway
Hands-on Exercise: Creating a Virtual Private Cloud Ecosystem
Overview of various storage services by AWS, storage limits, storage gateway and security, overview of Elastic Block Storage, Glacier overview, principles of Amazon S3, encryption and S3, S3 CORS, Snowball, and Storage troubleshooting
Hands-on Exercise: Uploading and downloading data from Amazon S3
Auto scaling, version updates using auto scaling, load balancing with AWS, Classic Load Balancer, Application Load Balancer, and identifying and distinguishing high availability on AWS
Hands-on Exercise: Scale out and scale in the number of servers with Auto Scaling
Introduction to IAM, groups, user administration and permission, security of AWS account, MFA, security and logging, and policies within the shared responsibility model
Hands-on Exercise: Creating IAM users, role, group, and policies in AWS Management Console
Procedure for Boto3 Python, writing code using AWS SDKs, AWS API Gateway, and AWS CLI, coding for serverless applications, access AWS resources, and creating sample program through Boto3 Python, Refactoring the current on-premise application code and move it to AWS, application optimization to get the best results from AWS features
Introduction to cloud monitoring, concepts of CloudWatch, logging basics, tracking API usage and user action with AWS CloudTrail, and troubleshooting
Hands-on Exercise: Allowing CloudTrail Log into S3 bucket and working with CloudWatch logs
Project 1 : Deploying a Multi-tier website using AWS EC2
Industry : Internet related
Problem Statement : How to scale a website fast using AWS without the upfront cost
Topics : In this AWS project you will launch an EC2 instance without the need to invest in hardware up front, so you can develop and deploy applications faster. You can use Amazon EC2 to launch as many or as few virtual servers as you need, configure security and networking, and manage storage. Amazon EC2 enables you to scale up or down to handle changes in requirements or spikes in popularity, reducing your need to forecast traffic.
Highlight :
Project 2 : Website Orchestration
Industry : Internet related
Problem Statement : How to orchestrate a website with lesser time and higher availability along with autoscaling.
Topics : In this AWS project you will deploy a high-availability PHP application with an external Amazon RDS database to Elastic Beanstalk. Running a DB instance external to Elastic Beanstalk decouples the database from the lifecycle of your environment. This lets you connect to the same database from multiple environments, swap one database for another, or perform a blue/green deployment without affecting your database.
Highlight :
Overview of AWS cloud services, discussing about various Amazon AMIs, AWS Global Infrastructure which explains AWS availability regions, and the practical demonstration of launching an AWS EC2 instance
Hands-on Exercise: Account creation on AWS Management Console
Understanding Amazon Machine Image (AMI), various network interfaces, IP classification, Instance and types of Instances, and creating, managing, and troubleshooting Instances
Hands-on Exercise: Creating an EC2 instance on AWS Management Console and connecting to the system
Introduction to Virtual Private Cloud (VPC) and basics of cloud networking, VPC components, custom route tables, VPC peering, public and private subnets, configuring subnets, fundamentals of Network Address Translation (NAT), route tables, NAT high-availability design, NAT server and NAT Gateway
Hands-on Exercise: Creating a Virtual Private Cloud Ecosystem
Overview of various storage services by AWS, storage limits, storage gateway and security, overview of Elastic Block Storage, Glacier overview, principles of Amazon S3, encryption and S3, S3 CORS, Snowball, and Storage troubleshooting
Hands-on Exercise: Uploading and downloading data from Amazon S3
Auto scaling, version updates using auto scaling, load balancing with AWS, Classic Load Balancer, Application Load Balancer, and identifying and distinguishing high availability on AWS
Hands-on Exercise: Scale out and scale in the number of servers with Auto Scaling
Introduction to IAM, groups, user administration and permission, security of AWS account, MFA, security and logging, and policies within the shared responsibility model
Hands-on Exercise: Creating IAM users, role, group, and policies in AWS Management Console
Introduction to cloud monitoring, concepts of CloudWatch, logging basics, tracking API usage and user action with AWS CloudTrail, and troubleshooting
Hands-on Exercise: Allowing CloudTrail Log into S3 bucket and working with CloudWatch logs
Configuration management tools, how to reduce cloud cost, creating expenditure alert, monitoring and tagging with CloudWatch, automation and optimization using CloudFormation, AWS UserData, AWS OpsWorks, and CloudFormation: template structure, maintaining templates, parameters, mapping, Init, WaitCondition, outputs, errors, and troubleshooting
Hands-on Exercise: Working on CloudFormation templates
1.1 What is Cloud Computing
1.2 Cloud Service & Deployment Models
1.3 How AWS is the leader in the cloud domain
1.4 Various cloud computing products offered by AWS
1.5 Introduction to AWS S3, EC2, VPC, EBS, ELB, AMI
1.6 AWS architecture and the AWS Management Console, virtualization in AWS (Xen hypervisor)
1.7 What is auto-scaling
1.8 AWS EC2 best practices and cost involved.
Hands-on Exercise – Setting up of AWS account, how to launch an EC2 instance, the process of hosting a website and launching a Linux Virtual Machine using an AWS EC2 instance.
2.1 Introduction to EC2
2.2 Regions & Availability Zones(AZs)
2.3 Pre-EC2, EC2 instance types
2.4 Comparing Public IP and Elastic IP
2.5 Demonstrating how to launch an AWS EC2 instance
2.6 Introduction to AMIs, Creating and Copying an AMI
2.7 Introduction to EBS
2.8 EBS volume types
2.9 EBS Snapshots
2.10 Introduction to EFS
2.11 Instance tenancy- Reserved and Spot instances
2.12 Pricing and Design Patterns.
Hands-on Exercise –
1. Launching an EC2 instance
2. Creating an AMI of the launched instance
3. Copying the AMI to another region
4. Creating an EBS volume
5. Attaching the EBS volume with an instance
6. Taking backup of an EBS volume
7. Creating an EFS volume and mounting the EFS volume to two instances.
3.1 Introduction to Elastic Load Balancer
3.2 Types of ELB – Classic, Network and Application
3.3 Load balancer architecture
3.4 Cross-zone load balancing
3.5 Introduction to Auto Scaling, vertical and horizontal scaling, the lifecycle of Auto Scaling
3.6 Components of Auto Scaling, scaling options and policy, instance termination
3.7 Using load balancer with Auto Scaling
3.8 Pre-Route 53 – how DNS works
3.9 Routing policy, Route 53 terminologies, Pricing.
Hands-on Exercise –
1. Creating a Classic ELB
2. Creating an Application ELB
3. Creating an auto-scaling group
4. Configuring an auto-scaling group
5. Integrating ELB with Auto Scaling
6. Redirect traffic from domain name to ELB using Route 53.
4.1 What is Amazon VPC,
4.2 VPC as a networking layer for EC2,
4.3 IP address and CIDR notations,
4.4 Components of VPC – network interfaces, route tables, internet gateway, NAT,
4.5 Security in VPC – security groups and NACL, types of VPC, what is a subnet, VPC peering with scenarios, VPC endpoints, VPC pricing and design patterns.
Hands-on Exercise –
1. Creating a VPC and subnets,
2. Creating a 3 Tier architecture with security groups,
3. NACL, Internet gateway and NAT gateway,
4. Creating a complete VPC architecture.
5.1 Introduction to AWS storage
5.2 Pre-S3 – online cloud storage
5.3 API, S3 consistency models
5.4 Storage hierarchy, buckets in S3
5.5 Objects in S3, metadata and storage classes, object versioning, object lifecycle management, cross-region replication, data encryption, connecting using VPC endpoint, S3 pricing.
Hands-on Exercise –
1. Creating an S3 bucket
2. Uploading objects to the S3 bucket
3. Enabling object versioning in the S3 bucket
4. Setting up lifecycle management for only a few objects
5. Setting up lifecycle management for all objects with the same tag
6. Static website hosting using S3.
6.1 What is a database, types of databases, databases on AWS
6.2 Introduction to Amazon RDS
6.3 Multi-AZ deployments, features of RDS
6.4 Read replicas in RDS, reserved DB instances
6.5 RDS pricing and design patterns
6.6 Introduction to Amazon Aurora, benefits of Aurora, Aurora pricing and design patterns
6.7 Introduction to DynamoDB, components of DynamoDB, DynamoDB pricing and design patterns
6.8 What is Amazon Redshift, advantages of Redshift
6.9 What is ElastiCache, why ElastiCache.
Hands-on Exercise –
1. Launching a MySQL RDS instance
2. Modifying an RDS instance
3. Connecting to the DB instance from your machine
4. Creating a multi-az deployment
5. Create an Aurora DB cluster
6. Creating an Aurora replica
7. Creating a DynamoDB table.
7.1 Introduction to CloudFormation
7.2 CloudFormation components
7.3 CloudFormation templates
7.4 The concept of Infrastructure-as-a-code
7.5 Functions and pseudo parameters
7.6 Introduction to Simple Notification Service, how does SNS work
7.7 Introduction to Simple Email Service, how does SES work
7.8 Introduction to Simple Queue Service, how does SQS work.
Hands-on Exercise –
1. Creating a CloudFormation stack
2. Launching a t2.micro
3. EC2 instance using CloudFormation
4. Using CloudFormation to automate an architectural deployment
5. Creating an SNS topic, creating a subscription within the topic
6. Setting up SES and sending a mail
7. Creating an SQS queue and sending a sample message.
8.1 Pre-IAM, why access management
8.2 Amazon Resource Name (ARN), IAM features
8.3 Multi-factor authentication (MFA) in IAM, JSON
8.4 IAM policies, IAM permissions, IAM roles, identity federation, pricing
8.5 Introduction to CloudWatch, metrics and namespaces, CloudWatch architecture, dashboards in CW, CloudWatch alarms, CloudWatch logs, pricing and design patterns
8.6 Introduction to CloudTrail, tracking API usage.
Hands-on Exercise –
1. Creating IAM users and a group
2. creating an IAM policy and attach it to the group
3. creating an IAM role
4. Setup MFA for a user
5. Creating a CloudWatch dashboard and add metrics
6. Create a CloudWatch alarm which triggers according to CPU Utilization of an EC2 instance
7. Creating a billing alarm
8. Creating a log group
9. Creating a trail.
9.1 What is AWS Lambda
9.2 How Lambda is different from EC2
9.3 Benefits and limitations of Lambda
9.4 How does Lambda work
9.5 Use cases of Lambda, Lambda concepts
9.6 Integration S3 with Lambda
9.7 What is Elastic Beanstalk, how does Beanstalk work, Beanstalk concepts, Beanstalk pricing
9.8 What is configuration management
9.9 What is AWS OpsWorks, AWS OpsWorks benefits
9.10 CloudFormation vs OpsWorks, services in OpsWorks, AWS OpsWorks Stacks, OpsWorks pricing.
Hands-on Exercise –
1. Creating a Lambda function
2. Setting up Lambda triggers and destinations
3. Creating an Elastic Beanstalk application
4. Uploading a new version of the application to Beanstalk
5. Creating a stack in OpsWorks
6. Launching the instance using OpsWorks and automatically installing the application.
10.1 What is FSx
10.2 Types of FSx,FSx for Windows server
10.3 How does FSx for Windows File Server work, FSx for Lustre
10.4 Use cases of FSx
10.5 Automatic failover process
10.6 Supported clients and access methods
10.7 What is a Global Accelerator, How Global Accelerator works, Listeners and Endpoints
10.8 What are AWS Organizations, Features of AWS Organizations, Managing multiple accounts
10.9 What are ENIs, ENAs and EFAs, Working with network interfaces
10.10 Enhanced Networking with ENA, EFA with MPI, Monitoring an EFA
Hands-on Exercise:
1. Creating a shared FSx file system between two windows instances
2. Accessing one instance with multiple Elastic IPS using ENI
3. Using Global Accelerator to map instances from 2 regions into one domain name
4. Enabling Enhanced Networking on an Ubuntu instance
11.1 Important guidelines for creating a well-architected AWS framework that is resilient and performant
11.2 Designing of fault-tolerant and high-availability architecture
11.3 Resilient storage
11.4 Decoupling mechanism
11.5 Multi-tier architecture solution
11.6 Disaster recovery solution
11.7 Scalable and elastic solutions.
12.1 What is DevOps,
12.2 Introduction to AWS DevOps,
12.3 AWS Developer tools – CodeCommit, CodeBuild, CodeDeploy and CodePipeline, integrating GitHub with CodePipeline,
12.4 Creating a DevOps lifecycle using AWS DevOps tools.
13.1 What is Cloud migration
13.2 Why migration is important
13.3 Migration process in AWS, the 6 R’s migration strategy
13.4 Virtual machine migration, migrating a local vm onto the AWS cloud
13.5 Migrating databases using Database Migration Service (DMS)
13.6 Migrating a local database to RDS
13.7 Migrating an on-premises database server to RDS using DMS, other migration services.
14.1 Guidance for clearing the exam, most probable interview questions and other helpful tips for clearing the exam and interview.
Deploying a Multi-Tier Website on AWS
Using various AWS services such as EC2, ELB, Auto Scaling, VPC, etc. to create a highly available and reliable architecture to host a PHP website. Furthermore, use SNS for sending mails of all your websites operations on AWS and deploy the application in a private subnet & use ELB to expose it. Prevent the website from crashing by dynamically scaling your servers.
Deploying a Website for High Availability and High Resilience
An architecture which should be designed to be highly available. Based on the applications workload, the architecture should automatically scale its servers up and down. To balance the load across all these servers, using a ELB is must and also the architecture should be decoupled to connect an RDS database with an Elastic Beanstalk environment.
Sending Notifications to patients using push notifications
Design an architecture to send notifications to patients based on their doctors’ feedback. Using SNS for sending messages will increase the reliability and resilience. Integrate EC2 with the SNS topic for message storing and by using Public and Private subnets we will have to secure the EC2 instances.
Application to sort objects in an S3 bucket using Beanstalk and Lambda
Uploading an application which could upload objects to an S3 bucket to Elastic Beanstalk. Set up your Lambda functions trigger as Object creation in the S3 bucket to which the Beanstalk application uploads the objects to. Add your Lambda code which will segregate the uploaded objects into separate buckets according to the extension (e.g., .png, .pdf, etc).
Case Study 1 - Using Different Operations on EC2 and EWS
The case study is to replicate or copy EC2 instances to varied regions depending upon the High Availability. Furthermore, the main strategy is to extend the size of EBS volumes without losing the data. The major highlights of this case study are to scale and mount the EBS volumes to different EC2 instances one at a time.
Case Study 2 - Autoscaling Compute Capacity in AWS
The major aim of this case study is to Autoscale (scaling up and down automatically) and Load Balance among multiple EC2 instances within AWS based on varied/defined metrics for Autoscaling instances. Also, the case study deals with and routing custom domains to AWS resources.
Case Study 3 - Creating custom VPCs in AWS
In this case study, the candidate will create a custom VPC in AWS with the help of multiple subnets having both private as well as public access. The route tables are also configured to subnets using the Internet Gateway and NAT Gateway.
Case Study 4 - Using AWS S3 for Lifecycle Access Management
The case study deals with moving artifacts from on-premise to S3 in the most cost-efficient manner. Furthermore, it deals with the creation of Lifecycle rules for events in S3 objects, hosting a static website, and experimenting with the usage of route 53.
Case Study 5 - Highly available Relational Database in AWS
This case study is all about creating a highly available and scalable AWS Database Service in AWS using RDS. The process involves creating Database Architecture, collecting data for real-time analysis, and relocating the latency issues.
Case Study 6 - CloudFormation for Infrastructure-as-Code
The case study involves provisioning and deploying AWS Resources using AWS CloudFormation. Within the process, the candidate has to define rules for deletion using IaC and also minimize the deployment time.
Case Study 7 - Administering user access using AWS IAM
In this case study, the candidate will create users in IAM for defining granular access that differs with each user. Alongside he/she will also define custom policies that add users to groups.
Case Study 8 - Application Services in AWS and Configuration Management
The main aim of this case study is to use application services in AWS Lambda for deploying code and also conduct configuration management using OpsWork. Alongside, WebApp is also deployed to Elastic Beanstalk.
Overview of AWS Services, AWS Security Services, AWS Compute and Storage, Cloud Watch, Auto Scaling, Load Balancing, AWS S3 Demo, AWS EC2 Instance, and AWS IaaC
Learning the Cloud Adoption Framework for AWS, knowing the 6R Migration Outline, and understanding the Well Architecture Framework
Introduction to Database services and Database Migration, understanding the challenges involved in Database Migration, learning the tasks of AWS pre-migration and post-migration phase
Hands-on Exercise: Demonstration of a source Database migration which belongs to a non-AWS environment
Learning AWS services like Application discovery and Server Migration, Server Migration with and without Agent, migrating the on-premise Microsoft Hyper VM, and migrating the on-premise VMware VM
Hands-on Exercise: Demonstration and learning of migrating on-premise VMware VM to AWS
Introduction to Docker, learn how docker is used for monolithic applications, introduction to Elastic Container Service (ECS), understand how ECS and docker work together, orchestrate docker containers
Hands-on Exercise: Demonstration and learning of migrating a monolithic application
1.1 EC2 Walkthrough
1.2 Installation of DevOps Tools on cloud
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
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
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
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
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
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
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
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
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
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
12.1 What is Infrastructure as a code
12.2 Iac vs Configuration Management
12.3 Introduction to Terraform
12.4 Installing Terraform on AWS
12.5 Basic Operations in terraform
12.6 Terraform Code Basics
12.7 Deploying and end-to-end architecture on AWS using Terraform
Hands-on Exercise –
1. Installing Terraform
2. Initializing AWS Terraform Provider
3. Creating an EC2 instance using Terraform
4. Updating changes to EC2 using Terraform
5. Destroying EC2 using Terraform
6. Deploying EC2 inside a custom VPC using Terraform
Creating CI/CD Pipeline to build and test a Website
Creating a CI/CD Pipeline to integrate devops tools like git, docker, Jenkins, puppet and selenium. In this project, we will be containerizing a website which will be pushed to git, and then will be deployed automatically on the testing server, and if everything goes well, will be pushed to production servers.
Deploying an app on Kubernetes using CI/CD Pipelines
In this project, you will be creating a CI/CD pipeline which is integrated with Kubernetes. This project will make use of tools like Git, Docker, Jenkins, selenium and Kubernetes. First we will containerize the code pushed in git, save the docker image and then push the image to Dockerhub. Finally it will be deployed on Kubernetes.
Merging Git Branches
In this project, we will understand the importance of merging branches in git. We will be using a production use case where merging is required, based on the use case we will have to decide whether we will be using git merge or rebase. Since this is a production problem, we will also have to make use of Git Workflows.
Implementing Git Workflow
Analyzing and using a specific Git Workflow scenario. In this case study, you will work with industry-standard architectures, merging branches, and simulating a working architecture in Git. You will have to be familiar with topics such as Git branches, Git workflows, merging, and rebasing to work on this case study.
Creating Custom Containers in Docker
Creating a custom container from the base Ubuntu container. In this case study, you will be required to create a Dockerfile, push the container to Dockerhub, and create custom Docker images. Through this case study, you will cover the working knowledge and implementation of Dockerfile and Dockerhub in DevOps.Using Blind Mounts, Docker Compose, and Docker Swarm
Using Blind Mounts, Docker Compose, and Docker Swarm
In this case study, you will be deploying an application using Docker compose, Bind Mounts, and Docker Swarm. You will create and use Blind Mounts in Docker, deploy multiple docker applications with Docker Compose, and create a Docker Swarm cluster and deploy applications over it. You will also use Docker storage and Docker Networks. Using Puppet for Configuration Management
Using Puppet for Configuration Management
In this case study, you will be learning how to work with Docker, puppet manifests, conditional statements, modules, and classes to create Modular scripts and also to manage a large fleet of servers with Puppet.
Using Selenium to Create Automated Test Cases
In this case study, you will be required to create automated test cases using Selenium. You will also have to create runnable jar files and run headless tests in Chrome using Non-GUI Linux. Through this case study, you will have a thorough understanding of how Selenium, runnable jar files, ChromeDriver, and headless tests work.
1.1 What is Cloud Computing
1.2 How AWS is the leader in the cloud domain
1.3 Various cloud computing products offered by AWS
1.4 Introduction to AWS S3, EC2, VPC, EBS, ELB, AMI
1.5 Getting a detailed understanding of the AWS architecture and the AWS Management Console
1.6 Introduction to AWS EC2
1.7 Comparing Public IP and Elastic IP
1.8 Demonstrating how to launch an AWS EC2 instance
1.9 What is auto scaling
1.10 AWS EC2 best practices and cost involved
1.11 Understanding various concepts of backup services in AWS
Hands-on Exercise –
2.1 Elastic Block Storage (EBS) for block level persistent storage volumes with S3 buckets
2.2 Understanding Amazon RDS and Amazon Aurora which are relational databases
2.3 Amazon DynamoDB which is a NoSQL database
2.4 Understanding Amazon Redshift which is a data warehousing product
2.5 Amazon ElasticCache which is an in-memory data store
2.6 Deploying AWS database migration service
Hands-on Exercise –
3.1 Introduction to AWS storage
3.2 AWS S3 (Simple Storage Service)
3.3 Creating an AWS S3 bucket
3.4 AWS Storage Gateway
3.5 Understanding the Command Line Interface (CLI)
3.6 Hosting a static website using Amazon S3
3.7 Amazon Glacier storage for long-term data backup and archiving
3.8 Amazon Snowball for data import/export
Hands-on Exercise –
4.1 Understanding Fault Tolerance in AWS
4.2 In-depth study of Elastic Load Balancing
4.3 The types of Load Balancers viz. Classic and Application
4.4 AWS Auto Scaling mechanism
4.5 Understanding AWS Management Console
4.6 How to access the Elastic Load Balancing
4.7 Studying AWS SDK, AWS CLI and Https Query API
Hands-on Exercise –
5.1 What is Amazon VPC
5.2 VPC as a networking layer for EC2
5.3 Getting started with VPC
5.4 Examples
5.5 VPC and Subnets
5.6 Default and non-default VPCs
5.7 Components of VPC networking
5.8 IP addressing
5.9 Security
5.10 VPN connections
5.11 Accessing the internet
5.12 Using AWS PrivateLink to access the services
5.13 VPC supported platforms
Hands-on Exercise –
6.1 Introduction to various AWS application services
6.2 Elastic Beanstalk
6.3 Simple Email Services (SES)
6.4 Simple Notification Service (SNS)
6.5 AWS Lambda
6.6 Elastic OpsWorks and CLI
Hands-on Exercise –
7.1 Authentication (who can use) and Authorization (level of access)
7.2 IAM Policies – JSON structure, users, groups and their Roles
7.3 IAM HTTPS API
7.4 Logging IAM events with AWS CloudTrail
7.5 Monitoring and managing AWS resources using CloudWatch
7.6 Deploying configuration alerts and notifications with CloudWatch
7.7 Billing for CloudWatch
Hands-on Exercise –
8.1 Configuration management and automation of server configuration using OpsWorks
8.2 Determining how servers are configured, managed and deployed across EC2 instances
8.3 Creating a virtual machine using Amazon Machine Image (AMI)
8.4 Introduction to the Domain Name Registration service AWS Route 53
8.5 How to route internet traffic to resources
8.6 Checking health of resources automatically
8.7 Provisioning of infrastructure resources using AWS CloudFormation
Hands-on Exercise –
9.1 Important guidelines for creating a well architected AWS framework that is resilient and performant
9.2 Designing of fault-tolerant and high-availability architecture, resilient storage, decoupling mechanism, multi-tier architecture solution, disaster recovery solution, scalable and elastic solutions
10.1 Guidance for clearing the exam
10.2 Most probable interview questions and other helpful tips for clearing the exam and interview
11.1 Migrating to the AWS cloud
11.2 Business drivers for migration
11.3 Various stages of cloud adoption
11.4 The actual migration process
11.5 Migration tools and services in AWS
11.6 Migrating customers to AWS cloud
11.7 Track the progress of application migration
11.8 Types of migration including data migration, application migration and databases migration
12.1 AWS cloud security essentials
12.2 Penetration testing
12.3 Security compliance
12.4 Infrastructure security
12.5 Mitigating DDOS
12.6 Identity and Access Control (IAM)
12.7 Logging and monitoring
12.8 Automatic audits and compliance
12.9 Limitations and challenges of native AWS security
13.1 Installation of Devops Tools on AWS
14.1 What is Software Development
14.2 Software Development Life Cycle
14.3 Traditional Models for SDLC
14.4 Why Devops?
14.5 What is Devops?
14.6 Devops Lifecycle
14.7 Devops Tools
15.1 What is Version Control
15.2 Types of Version Control System
15.3 Introduction to SVN
15.4 Introduction to Git
15.5 Git Lifecycle
15.6 Common Git Commands
15.7 Working with Branches in Git
15.8 Merging Branches
15.9 Resolving Merge Conflicts
15.10 Git Workflow
Hands-on Exercise –
16.1 Introduction to Docker
16.2 Understanding Docker Lifecycle
16.3 Components of Docker Ecosystem
16.4 Common Docker Operations
16.5 Creating a DockerHub Account
16.6 Committing changes in a Container
16.7 Pushing a Container Image to DockerHub
16.8 Creating Custom Docker Images using Dockerfile
Hands-on Exercise –
17.1 What are Docker Volumes
17.2 Deploying a Multi-Tier Application using Docker Network
17.3 Using Docker Compose to deploy containers
17.4 What is Container Orchestration
17.5 Container Orchestration Tools
17.6 Introduction to Docker Swarm
17.7 Deploying a 2-Node Cluster using Docker Swarm
Hands-on Exercise –
18.1 Need of Configuration Management
18.2 Configuration Management Tools
18.3 What is Puppet
18.4 Puppet Architecture
18.5 Setting up Master Slave using Puppet
18.6 Puppet Manifests
18.7 Puppet Modules
18.8 Applying configuration using Puppet
18.9 Puppet File Server
Hands-on Exercise –
19.1 What is Ansible?
19.2 Ansible vs Puppet
19.3 Ansible Architecture
19.4 Setting up Master Slave using Ansible
19.5 Ansible Playbook
19.6 Ansible Roles
19.7 Applying configuration using Ansible
Hands-on Exercise –
20.1 What is Continuous Testing?
20.2 What is Maven?
20.3 Running Test Cases on Chromium Web Driver
20.4 What is Headless Mode?
Hands-on Exercise –
21.1 Introduction to Continuous Integration
21.2 Jenkins Master Slave Architecture
21.3 Understanding CI/CD Pipelines
21.4 Creating an end to end automated CI/CD Pipeline
Hands-on Exercise –
22.1 Introduction to Kubernetes
22.2 Docker Swarm vs Kubernetes
22.3 Kubernetes Architecture
22.4 Deploying Kubernetes using Kubeadms
22.5 Alternate ways of deploying Kubernetes
22.6 YAML Files
22.7 Creating a Deployment in Kubernetes using YAML
22.8 Services in Kubernetes
22.9 Ingress in Kubernetes
Case Study –
Hands-on Exercise –
23.1 What is Continuous Monitoring
23.2 Introduction to Nagios
23.3 Nagios Architecture
23.4 Monitoring Services in Nagios
23.5 What are NRPE Plugins
23.6 Monitoring System Info using NRPE plugins
Hands-on Exercise –
24.1 How to deploy DevOps principles and methodology on the AWS platform
24.2 DevOps lifecycle and the important stages in the DevOps methodology
24.3 What is AWS CodeBuild
24.4 AWS CodeCommit
24.5 AWS CodePipeline
24.6 AWS CodeDeploy
25.1 Installing Terraform – Windows Users
25.2 Installing Terraform – Linux Users
25.3 Choosing Right IDE for Terraform IAC development
25.4 Creating first EC2 instance with Terraform
25.5 Terraform Code – First EC2 Instance
25.6 Understanding Resources & Providers
25.7 Destroying Infrastructure with Terraform
25.8 Destroying Specific Resource
25.9 Understanding Terraform State files
25.10 Understanding Desired & Current States
25.11 Challenges with the current state on computed values
25.12 Terraform Commands – State Files
25.13 Terraform Provider Versioning
25.14 Types of Terraform Providers
25.15 Understanding Attributes and Output Values in Terraform
25.16 Attribute Resource (Document)
25.17 Referencing Cross-Account Resource Attributes
25.18 Terraform Variables
25.19 Data Types for Variables
25.20 Fetching Data from Maps and List in Variable
25.21 Terraform Format
25.22 Validating Terraform Configuration Files
Hands-on Exercise –
26.1 What is Infrastructure as a code
26.2 Iac vs Configuration Management
26.3 Introduction to Terraform
26.4 Installing Terraform on AWS
26.5 Basic Operations in terraform
26.6 Terraform Code Basics
26.7 Deploying and end-to-end architecture on AWS using Terraform
Hands- on Exercise –
Project 1
Creating CI/CD Pipeline to build and test a Website
Creating a CI/CD Pipeline to integrate devops tools like git, docker, Jenkins, puppet and selenium. In this project, we will be containerizing a website which will be pushed to git, and then will be deployed automatically on the testing server, and if everything goes well, will be pushed to production servers.
Project 2
Creating Architecture for an Application.
Creating a complete architecture for a python application and launching it over the internet. For creating the infrastructure for application we have used services like VPC, EC2, Load Balancing, RDS, S3, SNS,IAM,Route53. In this project, we will be hosting the application in a secured architecture so that the code present in the github will be hosted over AWS. Once the user enters data then the data will be stored in Databases and once the objects are pushed to S3 then automatically it will trigger a notification over mail.
Project 3
Implementing Devops Life Cycle Using AWS.
Create a complete lifecycle of Devops over AWS, Using the services provided by AWS Devops. We will use the below tools/services. Git. Code Commit, Code Deploy, Code Pipeline. Once the code is built then it will be sent to the QA stage, Once it is passed then the code will be pushed to the Elastic Beanstalk.
Deploying a website for High Availability and High Resilience
In this project, we will design an architecture which can automatically scale up and down based on traffic and is decoupled for components like Database, webapp etc.
Sending Notifications to patients using push notifications.
In this project, we will design an architecture on AWS, which can send notifications to customers once the patient feedback is pushed in the system. We will be using services like SNS, AWS Lambda, EC2 and more.
Deploying an app on Kubernetes using CI/CD Pipelines
In this project, you will be creating a CI/CD pipeline which is integrated with Kubernetes. This project will make use of tools like Git, Docker, Jenkins, selenium and Kubernetes. First we will containerize the code pushed in git, save the docker image and then push the image to Dockerhub. Finally it will be deployed on Kubernetes
Merging Git Branches
In this project, we will understand the importance of merging branches in git. We will be using a production use case where merging is required, based on the use case we will have to decide whether we will be using git merge or rebase. Since this is a production problem, we will also have to make use of Git Workflows.
Deploying a Multi-Tier Website Using AWS EC2
For this project, you will have to scale a website fast using AWS without the upfront cost of hardware. You will learn to launch an EC2 instance, enable auto-scaling of EC2, configure security and networking, manage storage, create an RDS instance, and allow traffic from EC2 to RDS instance.
Website Orchestration
You will orchestrate a website with lesser time and higher availability along with autoscaling. In this AWS project, you will deploy a high-availability PHP application with an external Amazon RDS database to Elastic Beanstalk, launch a DB instance in Amazon RDS, create an Elastic Beanstalk Environment and configure security groups and scaling.
Containerizing Various Frameworks and NGINX Application using Docker
This project is about integrating the software projects deployed in diverse environments such as NGINX, Node.Js, MongoDB, and ASP.NET using Docker. The highlights of this project are setting up Node.js on Docker container, puling NGINX image from Docker hub, and deploying Windows Powershell and Hyper-V.
Case Study 1
Using Different Operations on EC2 and EWS
The case study is to replicate or copy EC2 instances to varied regions depending upon the High Availability. Furthermore, the main strategy is to extend the size of EBS volumes without losing the data. The major highlights of this case study are to scale and mount the EBS volumes to different EC2 instances one at a time.
Case Study 2
Autoscaling Compute Capacity in AWS
The major aim of this case study is to Autoscale (scaling up and down automatically) and Load Balance among multiple EC2 instances within AWS based on varied/defined metrics for Autoscaling instances. Also, the case study deals with and routing custom domains to AWS resources.
Case Study 3
Creating custom VPCs in AWS
In this case study, the candidate will create a custom VPC in AWS with the help of multiple subnets having both private as well as public access. The route tables are also configured to subnets using the Internet Gateway and NAT Gateway.
Case Study 4
Using AWS S3 for Lifecycle Access Management
The case study deals with moving artifacts from on-premise to S3 in the most cost-efficient manner. Furthermore, it deals with the creation of Lifecycle rules for events in S3 objects, hosting a static website, and experimenting with the usage of route 53.
Case Study 5
Highly available Relational Database in AWS
This case study is all about creating a highly available and scalable AWS Database Service in AWS using RDS. The process involves creating Database Architecture, collecting data for real-time analysis, and relocating the latency issues.
Case Study 6
CloudFormation for Infrastructure-as-Code
The case study involves provisioning and deploying AWS Resources using AWS CloudFormation. Within the process, the candidate has to define rules for deletion using IaC and also minimize the deployment time.
Case Study 7
Administering user access using AWS IAM
In this case study, the candidate will create users in IAM for defining granular access that differs with each user. Alongside he/she will also define custom policies that add users to groups.
Case Study 8
Application Services in AWS and Configuration Management
The main aim of this case study is to use application services in AWS Lambda for deploying code and also conduct configuration management using OpsWork. Alongside, WebApp is also deployed to Elastic Beanstalk.
DevOps Case Study 1
Implementing Git Workflow
Analyzing and using a specific Git Workflow scenario. In this case study, you will work with industry-standard architectures, merging branches, and simulating a working architecture in Git. You will have to be familiar with topics such as Git branches, Git workflows, merging, and rebasing to work on this case study.
Resolving Merge Conflicts
Understanding how to resolve merge conflicts in various scenarios. The case study is about understanding the difference between merging and rebasing. Through this case study, you will have an in-depth and up-close working knowledge of DevOps topics such as Git branches, merging, and rebasing.
Creating Custom Containers in Docker
Creating a custom container from the base Ubuntu container. In this case study, you will be required to create a Dockerfile, push the container to Dockerhub, and create custom Docker images. Through this case study, you will cover the working knowledge and implementation of Dockerfile and Dockerhub in DevOps.
Using Bind mounts, Docker Compose, and Docker Swarm
In this case study, you will be deploying an application using Docker compose, Bind Mounts, and Docker Swarm. You will create and use Bind mounts in Docker, deploy multiple docker applications with Docker Compose, and create a Docker Swarm cluster and deploy applications over it. You will also use Docker storage and Docker Networks.
Using Puppet for Configuration Management
In this case study, you will be learning how to work with Docker, puppet manifests, conditional statements, modules, and classes to create Modular scripts and also to manage a large fleet of servers with Puppet.
Using Selenium to Create Automated Test Cases
In this case study, you will be required to create automated test cases using Selenium. You will also have to create runnable jar files and run headless tests in Chrome using Non-GUI Linux. Through this case study, you will have a thorough understanding of how Selenium, runnable jar files, ChromeDriver, and headless tests work.
Project 1: Firewall Implementation
Domain: Security
Problem Statement: As a Cloud Engineer of a company, implement firewalls of Azure and secure the data of your organization
Topics: Cloud models, usage metrics, and Azure firewalls
Highlights:
● Adapting cloud models
● Understanding the usage of metrics
● Implementing Azure firewalls
Project 2: Updating Cloud Services
Domain: Cloud
Problem Statement: Update the cloud services to store the data of your company
Topics: Availability zones, Azure TCO, and multi-factor authentication
Highlights:
● Using availability zones
● Implementing Azure TCO
● Performing multi-factor authentication
Introduction to Linux, Basics of Shell, Basics of Kernel, CentOS 8 installation and VBox additions, Basic Linux Commands, ECHO and EXPR command, Set and unset a variable, Header of a shell script (#!).
Hands-on Exercise – Executing basic Linux commands, Installing CentOS 8 on VirtualBox and adding guest additions to the installed OS.
Text editors and file creation; Users, Groups and Processes; Root and Linux file hierarchy, Understanding file hierarchy, Understanding file permissions, chmod and chown commands, the LS command, Metacharacters, Editing a file using VIM, Displaying contents of a file, Copy, Move and Remove files.
Hands-on Exercise – Using VIM, Creating users and groups, Creating files and directories, Assigning file permissions and ownership using chmod and chown, Editing files in VIM.
Everything is a file in UNIX/Linux (files, directories, executables, processes), Process control commands (ps and kill), other process control tools (top, nice, renice).
Hands-on Exercise – Executing ps and kill commands on running services, Monitoring the OS using top.
What is shell scripting, Types of shell, Creating and writing a shell script, Changing the permission of the shell script, Executing the script, Environment variables, Defining a local and a global variable, User input in a shell script.
Hands-on Exercise – Creating a shell script, Writing and executing the shell script, creating a local and a global variable, taking input from the user in a shell script.
What are Conditional statements, Using IF, IF-ELSE, Nested IF statements, What are Looping statements, Using WHILE, UNTIL and FOR statements, Using the case…esac statement, What is a Function, Creating a function in Linux, Calling functions.
Hands-on Exercise – Executing IF, IF-ELSE, Nested IF statements, Executing WHILE, UNTIL and FOR statements, Executing the case…..esac statement, creating a function in multiple ways, calling a function in a file, calling a function from another file.
Using GREP command, Using SED command, Using AWK command, Mounting a file to the virtual box, Creating a shared folder (mounting a folder), Using SORT command and Using pipes to combine multiple Commands.
Hands-on Exercise – Executing commands using GREP, Executing commands using SED, Executing commands using AWK, Mounting a folder in the Windows OS to the Linux OS, Installing VirtualBox guest additions on CentOS 8, Extracting zipped files.
What are Daemons, Introduction to Task scheduling in Linux, Scheduling a job in Linux, What is Cron and Crontab, How to use cron, Using the AT command.
Hands-on Exercise – Starting, Stopping and Restarting Daemon processes, Scheduling jobs using cron and crontab, Scheduling a one time task using AT, Managing scheduled tasks using ATQ and ATRM.
Why monitoring, Introduction to process monitoring, Top vs HTop, What does PGREP do, Introduction to file and folder monitoring, Monitoring tool inotifywait, inotifywait options for folder monitoring, Events of a folder in inotify, the FREE command.
Hands-on Exercise – Using Top to moniter the OS, Installing Htop, Using Htop to monitor the OS, Filtering and sorting using Htop, Installing inotify tools, monitoring a folder using inotifywait, monitoring a folder only for certaing events, using the FREE command.
Installing and configuring MySQL, Securing MySQL, Running Queries from terminal, Running Queries from a shell script.
Hands-on Exercise – Downloading and installing MySQL, Connecting to MySQL from terminal, Querying directly from the terminal, Pushing the query result inside a file, CRUD operations from a shell script.
What is networking in Linux, Why do we need networking, Using networking commands – IFCONFIG, PING, Wget and cURL, SSH, SCP and FTP, Learning Firewall tools – iptables and firewalld, DNS and Resolving IP address, /etc/hosts and /etc/hostname, nslookup and dig.
Hands-on Exercise – Executing all the networking commands, Using iptables and firewalld, Adding and removing ports, Resolving IP address in /etc/hosts, looking into a websites IP and nameservers using nslookup and dig.
Project: Installing WordPress on Centos7
Industry: Internet related
Problem Statement: How to install LAMP stack on Centos7 and creating a database for WordPress
Topics: In this project you will be working on creating your account on WordPress (with Database), then flush it using Flush Privileges and Install a PHP Module. We can get that package directly from CentOS’s default repositories using yumand also we will install and update the WordPress for the latest Template & Formats.
Highlight
1.1 Various types of databases
1.2 Introduction to Structured Query Language
1.3 Distinction between client server and file server databases
1.4 Understanding SQL Server Management Studio
1.5 SQL Table basics
1.6 Data types and functions
1.7 Transaction-SQL
1.8 Authentication for Windows
1.9 Data control language
1.10 The identification of the keywords in T-SQL, such as Drop Table
2.1 Data Anomalies
2.2 Update Anomalies
2.3 Insertion Anomalies
2.4 Deletion Anomalies
2.5 Types of Dependencies
2.6 Functional Dependency
2.7 Fully functional dependency
2.8 Partial functional dependency
2.9 Transitive functional dependency
2.10 Multi-valued functional dependency
2.11 Decomposition of tables
2.12 Lossy decomposition
2.13 Lossless decomposition
2.14 What is Normalization?
2.15 First Normal Form
2.16 Second Normal Form
2.17 Third Normal Form
2.18 Boyce-Codd Normal Form(BCNF)
2.19 Fourth Normal Form
2.20 Entity-Relationship Model
2.21 Entity and Entity Set
2.22 Attributes and types of Attributes
2.23 Entity Sets
2.24 Relationship Sets
2.25 Degree of Relationship
2.26 Mapping Cardinalities, One-to-One, One-to-Many, Many-to-one, Many-to-many
2.27 Symbols used in E-R Notation
3.1 Introduction to relational databases
3.2 Fundamental concepts of relational rows, tables, and columns
3.3 Several operators (such as logical and relational), constraints, domains, indexes, stored procedures, primary and foreign keys
3.4 Understanding group functions
3.5 The unique key
4.1 Advanced concepts of SQL tables
4.2 SQL functions
4.3 Operators & queries
4.4 Table creation
4.5 Data retrieval from tables
4.6 Combining rows from tables using inner, outer, cross, and self joins
4.7 Deploying operators such as ‘intersect,’ ‘except,’ ‘union,’
4.8 Temporary table creation
4.9 Set operator rules
4.10 Table variables
5.1 Understanding SQL functions – what do they do?
5.2 Scalar functions
5.3 Aggregate functions
5.4 Functions that can be used on different datasets, such as numbers, characters, strings, and dates
5.5 Inline SQL functions
5.6 General functions
5.7 Duplicate functions
6.1 Understanding SQL subqueries, their rules
6.2 Statements and operators with which subqueries can be used
6.3 Using the set clause to modify subqueries
6.4 Understanding different types of subqueries, such as where, select, insert, update, delete, etc.
6.5 Methods to create and view subqueries
7.1 Learning SQL views
7.2 Methods of creating, using, altering, renaming, dropping, and modifying views
7.3 Understanding stored procedures and their key benefits
7.4 Working with stored procedures
7.5 Studying user-defined functions
7.6 Error handling
8.1 User-defined functions
8.2 Types of UDFs, such as scalar
8.3 Inline table value
8.4 Multi-statement table
8.5 Stored procedures and when to deploy them
8.6 What is rank function?
8.7 Triggers, and when to execute triggers?
9.1 SQL Server Management Studio
9.2 Using pivot in MS Excel and MS SQL Server
9.3 Differentiating between Char, Varchar, and NVarchar
9.4 XL path, indexes and their creation
9.5 Records grouping, advantages, searching, sorting, modifying data
9.6 Clustered indexes creation
9.7 Use of indexes to cover queries
9.8 Common table expressions
9.9 Index guidelines
10.1 Creating Transact-SQL queries
10.2 Querying multiple tables using joins
10.3 Implementing functions and aggregating data
10.4 Modifying data
10.5 Determining the results of DDL statements on supplied tables and data
10.6 Constructing DML statements using the output statement
11.1 Querying data using subqueries and APPLY
11.2 Querying data using table expressions
11.3 Grouping and pivoting data using queries
11.4 Querying temporal data and non-relational data
11.5 Constructing recursive table expressions to meet business requirements
11.6 Using windowing functions to group
11.7 Rank the results of a query
12.1 Creating database programmability objects by using T-SQL
12.2 Implementing error handling and transactions
12.3 Implementing transaction control in conjunction with error handling in stored procedures
12.4 Implementing data types and NULL
13.1 Designing and implementing relational database schema
13.2 Designing and implementing indexes
13.3 Learning to compare between indexed and included columns
13.4 Implementing clustered index
13.5 Designing and deploying views
13.6 Column store views
14.1 Explaining foreign key constraints
14.2 Using T-SQL statements
14.3 Usage of Data Manipulation Language (DML)
14.4 Designing the components of stored procedures
14.5 Implementing input and output parameters
14.6 Applying error handling
14.7 Executing control logic in stored procedures
14.8 Designing trigger logic, DDL triggers, etc.
15.1 Applying transactions
15.2 Using the transaction behavior to identify DML statements
15.3 Learning about implicit and explicit transactions
15.4 Isolation levels management
15.5 Understanding concurrency and locking behavior
15.6 Using memory-optimized tables
16.1 Accuracy of statistics
16.2 Formulating statistics maintenance tasks
16.3 Dynamic management objects management
16.4 Identifying missing indexes
16.5 Examining and troubleshooting query plans
16.6 Consolidating the overlapping indexes
16.7 The performance management of database instances
16.8 SQL server performance monitoring
17.1 Correlated Subquery, Grouping Sets, Rollup, Cube
Hands-on Exercise
18.1 Performance Tuning and Optimizing SQL Databases
18.2 Querying Data with Transact-SQL
Writing Complex Subqueries
In this project, you will be working with SQL subqueries and utilizing them in various scenarios. You will learn to use IN or NOT IN, ANY or ALL, EXISTS or NOT EXISTS, and other major queries. You will be required to access and manipulate datasets, operate and control statements in SQL, execute queries in SQL against databases.
Querying a Large Relational Database
This project is about how to get details about customers by querying the database. You will be working with Table basics and data types, various SQL operators, and SQL functions. The project will require you to download a database and restore it on the server, query the database for customer details and sales information.
Relational Database Design
In this project, you will learn to convert a relational design that has enlisted within its various users, user roles, user accounts, and their statuses into a table in SQL Server. You will have to define relations/attributes, primary keys, and create respective foreign keys with at least two rows in each of the tables.
As part of our eLearning program, you will be practically involved in various projects and assignments, which include Realtime Project Scenarios as well. This gives you realtime practical industry exposure.
VoiSAP’s certificate will be issued once you successfully complete the training which includes practicals, assignments and quiz.
VoiSAP’s certification training is recognized by more than 500 top MNCs, including CGI, Accenture, Walmart, Amazon, IMAX, Sony, RBC, HSBC, Standard Chartered Bank, IBM, Infosys, Lafarge, TCS, and many more.