Project 1 : Tuning of the database
Industry : General
Problem Statement : how to optimize the Oracle database and perform database tuning on it.
Topics – This project is involved with working on the Oracle Database for deploying the database performance tuning which includes optimizing and homogenizing the database performance. It is associated with query tuning but also includes DBMS selection, and configuration of the database environment. There are multiple tasks that you will perform giving you a hands-on experience –
- Space usage monitoring
- SQL scripts monitoring
- Database & SQL tuning
- Table & Index Statistics
- Chained Rows & Locks
Project 2 – Building an airline ticketing website
Industry : Ecommerce
Problem Statement : How to build a website for online flight ticket booking powered by Oracle database.
Description : This project will extensively use the Oracle database administration tools and technologies for building the database system for such a website. You will access the data using the Java Database Connectivity (JDBC). You will learn about the security & monitoring features of Oracle database. You will aggregate data from multiple airline sites for the best prices, take request for flight booking from users using multiple browsers and devices & provide output as per the user query.
- Oracle storage structure & architecture
- Oracle Server processes & user processes
- Initializing database instance & handling user requests.
Project 3 – HR management powered by Oracle database
Industry : Human Resources
Problem Statement : A large multinational company wants to have a human resource database to simplify the process of employee management.
Description : This Oracle database administration project will help you manage an HR database of a large multinational powered by Oracle database system. You will ensure that every manager has data pertaining to his team readily accessible for proper management. The HR database will be connected to the finance, operations, and training departments’ database for streamlining the employee management process.
- Table creation & Oracle storage structure
- Database security & regulatory compliance
- Creating Oracle database schema objects.