Follow the instructions given in this article https://www.digitalocean.com/community/tutorials/how-to-install-postgresql-on-ubuntu-20-04-quickstart

Complete SQLBolt 3 times.

Complete PostgreSQL Exercises 3 times. (Recursive Queries are optional)

Solve the IPL data problem, but this time with SQL, using PostgreSQL database.

Write a SQL script that creates a new user, and database. Make the user the owner of the db.

Write another SQL script that cleans up the user, and database created in the previous step.

Write a SQL script that loads CSV data into a table.

In a SQL file write queries that will solve the problems of the IPL data set, but this time with SQL. You can copy paste the queries in a .sql file and submit.

Note: the result in this case is not a graph but SQL Result Set.

As with previous projects ...

1. Create a repository - data-project-database.
2. All the code for this assignment should be in that repo.
3. Supporting files like .gitignore, README.md should also be included.
4. The README should have all the info for your mentor to run the scripts.

Write a technical paper in detail in markdown format

Some concepts to understand for databases:

• ACID
• CAP Theorem
• Joins
• Aggregations, Filters in queries
• Normalization
• Indexes
• Transactions
• Locking mechanism
• Database Isolation Levels
• Triggers