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.
- 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.
- 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.
- 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.
- Inserting data in table and joining tables
- Querying the data for various conditions
- Prepping the data for analysis.