DevOps Engineer Certification in Mumbai, India

Project 1 Scenario:

• Set up a MySQL database in a Docker container
• Design a database table structure for the data
• Write an SQL script to create the table and enter some sample data
• Create the table in the database
• Create a Java entity object and map it to the database table
• Create a DAO and its implementation
• Create a Junit test case and write integration tests

The deliverables are:

• SQL script
• Entity object code
• Hibernate configuration file
• DAO and implementation code
• Junit test case

 
Project 2 Scenario:

A library has a large CD collection which it needs to catalog. It needs to store information in a database and have a web front end. You will need to design, implement and deploy part of the system. The objective of this project is to produce a web application which implements the catalog. The information required for each CD is:

• Title
• Artist(s)
• Year of release
• Number of tracks
• Total playing time

Each CD will also have a list of tracks containing the following information:

• Title
• Author(s)
• Playing time

Goals of the project:

The starting point for this project is the code and instructions for exercise 8.7. Take a copy of the DevOps project from lesson 8 and rename the files from Monitoring to Library. You are only required to produce the web front end. The data manager can generate a hard-coded list of CDs rather than extract them from the database.

The deliverables are:

• The data manager Java file
• The library controller Java file
• The JSP which displays the CD list
•  A screenshot of the web page showing the list of CDs

Project 3 Scenario:

There is a requirement to be able to convert an integer into words. For example, 57 needs to be converted into “fifty-seven”.The objective of this project is to develop a method which can convert the numbers 1 through 999 to words. If you have time to extend the range up to 2 billion. The method needs to be developed using Test Driven Development (TDD). A standalone application is also required which reads a number from the keyboard and prints out its value in words or “Invalid number”. The program should exit when the user enters 0.
 
The application needs to be packaged as an executable jar file using Ant.

 Goals of the project:

• Clone the repository and install Ant.
• Git clone https://github.com/simplilearn-devops/devops-project-3
• Curl -O http://apache.mindstudios.com//ant/binaries/apache-ant-1.10.0-bin.zip
• Unzip apache-ant-1.10.0-bin.zip
• Ins apache-ant-1.10.0 ant
• Start the VNC server
• On your local machine connect to the VNC server on port 5901
• Open the Numbers project in Eclipse
• Add the jar files in lib to the classpath
• Develop the numbers to words application using TDD
• Implement the main application to read numbers from the keyboard and print out the values
• On the server navigate to the Numbers project
• Run ant to build the project. The build will fail if the unit tests fail.
• ~/ant/bin/ant dist
• The results of the unit tests are in the report directory which got created
• Run the application and try it out
•  java –j Numbers.jar

The deliverables are:

• The unit test java file
• The number of words Java file
• The main application Java file
• The test results file from the report directory
•  A screenshot of the application output after running it with a representative set of numbers

Project 4 Scenario:

You were asked to put some downloadable materials to Amazon S3 so that your company’s customers all around the world can access them. 
A month later, during a massive marketing campaign, the marketing team realized that using S3 is expensive and asked you to find and use a more cost-effective way to distribute the files. 

Goals of the Project:

• Create an S3 bucket
• Set its access permissions to allow all anonymous users to download the files from it
• Upload sample files to an S3 bucket 
• Create a CloudFront distribution using an S3 bucket as its origin
• Verify that the files are accessible

Project 5 Scenario:

The Oscrop Corporation’s public-facing web app currently runs on an IIS web server at the company’s chosen ISP. Oscrop wants to migrate this web app to Azure. You must test the web app’s functionality by setting up a test Oscrop web app. An internal team will provide you with a test web app to deploy. You must ensure that they can continue to stage changes to the test web app before deploying those changes to the public-facing site. 

The operations team at Oscrop currently uses a Microsoft SQL Server database to store back-end data for the web app on the company’s servers. You want to investigate the option of using Azure SQL Database to host this database.

The operations team is interested in monitoring the performance of this database in Azure. 

Goals of the Project:

• Create a new web app
• Deploy a web app
• Manage web apps
• Create an Azure SQL Database
• Configure server firewall rules
• Use SQL Server Management Studio
• View database metrics