Interview Questions
What you'll learn
PostgreSQL DBA concepts
Real time questions included with answers
Clear explanation of concepts
Easily you will clear PostgreSQL DBA interviews
Requirements
Must and should have working experience in PostgreSQL Administration
Description
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
Who this course is for
DBA's
DB developers who are interested in PostgreSQL Administration and willing to do Administration activities

Homepage

https://www.udemy.com/course/postgresql-database-administration-interview-questions/