Interview Questions
PostgreSQL is an advanced, enterprise class open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying.
What you’ll learn
- PostgreSQL DBA concepts.
- Real time questions included with answers.
- Clear explanation of concepts.
- Easily you will clear PostgreSQL DBA interviews.
Course Content
- Introduction –> 1 lecture • 3min.
- PostgreSQL terminology –> 1 lecture • 5min.
- Architecture –> 1 lecture • 8min.
- Database Cluster –> 1 lecture • 9min.
- Configuration Files –> 1 lecture • 10min.
- Schemas & Users & MVCC –> 1 lecture • 6min.
- Tablespaces in PostgreSQL –> 1 lecture • 3min.
- Backup & Restore –> 4 lectures • 24min.
- Vacuum Operations –> 1 lecture • 6min.
- Upgrade –> 0 lectures • 0min.
- Replication –> 2 lectures • 9min.
- Performance –> 1 lecture • 9min.
- Miscellaneous –> 1 lecture • 1min.
- Views in PostgreSQL –> 1 lecture • 1min.
- Section 15 : Interview questions with answers –> 1 lecture • 1min.
Requirements
- Must and should have working experience in PostgreSQL Administration.
PostgreSQL is an advanced, enterprise class open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying.
The course provides the candidate with an extensive knowledge of PostgreSQL Database Administration with real life scenarios .
Topics discussed are:
- PostgreSQL Database Naming Conventions
- PostgreSQL Database Data Directory
- PostgreSQL Database default Bin Directory
- PostgreSQL Database default configuration files location
- PostgreSQL Database Maintenance
- PostgreSQL Database Architecture
- PostgreSQL Database Backup & Recovery
- PostgreSQL Database Performance
- PostgreSQL Database Cluster
- PostgreSQL Database Replication
- PostgreSQL Database Upgrade
- PostgreSQL Database/Tables Vacuum operations
- PostgreSQL Database Views
- PostgreSQL Database Tablespace management
- PostgreSQL Database Users
- PostgreSQL Database Schemas
- PostgreSQL Database Configuration Files
Minimum hardware required to install and run PostgreSQL are:
============================================
a 1 GHz processor.
2 GB of RAM.
512 MB of HDD.
Software Requirements
root or super user access is required on Linux Systems
Views in postgreSQL
==============
pg_aggregate aggregate functions
pg_am index access methods
pg_amop access method operators
pg_amproc access method support procedures
pg_attrdef column default values
pg_attribute table columns (“attributes”)
pg_authid authorization identifiers (roles)
pg_auth_members authorization identifier membership relationships
pg_cast casts (data type conversions)
pg_class tables, indexes, sequences, views (“relations”)
pg_constraint check constraints, unique constraints, primary key constraints, foreign key constraints
pg_collation collations (locale information)
pg_conversion encoding conversion information
pg_database databases within this database cluster
pg_db_role_setting per-role and per-database settings
pg_default_acl default privileges for object types
pg_depend dependencies between database objects
pg_description descriptions or comments on database objects
pg_enum enum label and value definitions
pg_extension installed extensions
pg_foreign_data_wrapper foreign-data wrapper definitions
pg_foreign_server foreign server definitions
pg_foreign_table additional foreign table information
pg_index additional index information
pg_inherits table inheritance hierarchy
pg_language languages for writing functions
pg_largeobject data pages for large objects
pg_largeobject_metadata metadata for large objects
pg_namespace schemas
pg_opclass access method operator classes
pg_operator operators
pg_opfamily access method operator families
pg_pltemplate template data for procedural languages
pg_proc functions and procedures
pg_rewrite query rewrite rules
pg_seclabel security labels on database objects
pg_shdepend dependencies on shared objects
pg_shdescription comments on shared objects
pg_statistic planner statistics
pg_tablespace tablespaces within this database cluster
pg_trigger triggers
pg_ts_config text search configurations
pg_ts_config_map text search configurations’ token mappings
pg_ts_dict text search dictionaries
pg_ts_parser text search parsers
pg_ts_template text search templates
pg_type data types
pg_user_mapping mappings of users to foreign servers