Database Using PostgrSQL

IQAC & Department of Science(B.Sc.(Information Technology)) organised certificate course on 1-8-2023  “Database Using PostgrSQL” by resource person Sandeep Vishwakarma from Sandeep’s Institute of Career Guidance and Technology from for a duration of 30 hours in offline mode for the students of B.Sc.(IT&CS).

Objective: The training session aims to equip participants with essential skills in designing, querying, and managing databases using PostgreSQL. Through interactive lectures, hands-on exercises, and real-world examples, students will gain a deep understanding of database concepts and practical experience with PostgreSQL, a leading open-source relational database management system.

Topics Covered: 

  1. Introduction to Databases 
  2. Overview of PostgreSQL 
  3. Data Types and Operators 
  4. Database Design and Normalization 
  5. SQL Basics: Queries and Data Manipulation 
  6. Advanced SQL Queries 
  7. Database Administration 
  8. Backup and Restore Operations 

Outcomes

  • Enhanced Skills: Participants gained practical skills in database design, querying, and administration using PostgreSQL.
  • Improved Understanding: The interactive approach facilitated a deeper understanding of database concepts and their practical applications.
  • Confidence Building: Hands-on exercises and real-world examples boosted students’ confidence in working with databases.
  •  Career Readiness: The training equipped students with valuable skills sought after in the industry, enhancing their career prospects in IT and related fields.
  • Students were awarded certificates after completion of the course.
  • Convener
Scroll to Top