Course Details

• Basic knowledge of RDBMS

• Familiarity with SQL fundamentals

• Open to all

• Undergraduate / Postgraduate in Computer Science, Data Science, or related disciplines(completed / pursuing) and even working professionals in similar domains

This course is designed to:

• Provide a foundational and practical understanding of Postgres database and its implementation across multiple domains

• Understand the architecture and benefits of postgres database Enable students to do hands-on code building, performance-tuning

The key modules of the course consist of:

• Creating the postgres database, schema and objects for a database.

• Intro to Encryption

• Introduction to Performance-Tuning

The milestones are:

• Build a database application end to end

• Play with encryption of data, retrieval techniques etc etc

• Finetune a small model for small task

• Know how to connect the backend and develop procedures, functions and triggers

• Performance tuning - optimize the queries which is taking more time to execute

• Create materialized views and refresh the views in an acceptable frequency

• Create views by storing the queries for which is run a frequent manner

• Create role based access and grant the privileges, revoke the privileges and create read only user for reporting purposes.

• Create procedures to manipulate the data of that module and store the data in a temporary table

• Create backups and restore the whole database or a particular table from the backup or from the db script through copy command.

• Weightage for assignments = 20%

• Weightage for Quiz = 20%

• Weightage for live session attendance = 10%

• Weightage for project = 50%

• 75% - 100% - Gold Badge

• 50% - 74% - Silver Badge

• Below 50% - No Badge Earned

At the end of this course, students should be able to:

• Evaluate, optimize, and deploy generative models for production use cases

• Build and fine-tune the database codes for various applications