Project 1 : Performing DML operations on database

Industry : General

Problem Statement : How to manipulate data with DML

Topics : In this project you will learn about the Data Manipulation Language (DML), understand all about the DML triggers which are a special type of stored procedures that are automatically executed when DML operation is performed. You will learn about the various DML operations like INSERT, UPDATE, or DELETE which when fired on a Table or View can activate a DML Trigger. This project involves working with database and application Triggers, deploying the Triggers for various business applications and testing of the DML Triggers.

Highlights :

Manipulating data with DML

Working with DML Triggers

Various DML operations.

Project 2 : Streamlining banking data with PL/SQL

Industry : Banking and finance

Problem Statement : Get information on customer accounts spread across geographies and the history of transactions done.

Description : In this project you will create a model to capture details of bank, its different branches and store customer information based on geography. With this model you should be able to identify a customer having multiple accounts in different geographies as well as what transactions have been done in the past at all the branches.

Highlights :

Create a model and validate it for all use cases

Create the tables with required Constraints

Insert the appropriate Data

Apply Joins & get the required results.

Project 3 : Creating Detailed Patient Report

Industry : Healthcare

Problem Statement : How to analyze the condition of various patients based on disparate data sets

Description : In this PL SQL project you will be working on creating tables and columns based on various entities and insert the sample data. Write SQL queries to extract the data that can be used for analysis purpose. Based on that you shall create a detailed report about the patient, medications taken, any adverse conditions and so on.

Highlights :

PL/SQL for coding program blocks

Write procedures for IF ELSE conditions

Deploy PL/SQL functions & Packages.

Project 4 : Working on university data set

Industry : Education

Problem Statement : How to improve the teaching process of a university

Description : In this PL SQL project you have the Student and Staff data in tables. You will create the Course table and insert data into it. Then you will join the three tables and analyze the data. This includes coming up with all the courses with corresponding students and the teachers associated. Then finally you will create a detailed report on the teaching structure and ways to improve it.

Highlights :