PostgreSQL Database Administration (DBA) for Beginners

Learn Practical Database Administration

Created by: Bluelime Learning Solutions
Making Learning Simple

What Will I Learn?

• Install PostgreSQL Server
• Load sample database
• Create a database
• Create a table
• Insert data into tables
• Update existing records inside a table
• Delete Records in a table
• Remove duplicate records
• Query data from a table
• Create a subquery
• Get data from multiple tables
• Create and manage roles
• Create a view
• Create tablespace
• Backup and restore database
• Filter and sort data
• Use various operators
• Use aggregate and analytic functions
• Create triggers

Requirements

• Internet access is required to download PostgreSQL Server
• Basic understanding of database concept would help
• Basic understanding of SQL would help

Target audience

• Beginner Database Administrators -DBA's
• Beginner Data Scientist
• Beginner Data Analyst