Overview

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 ConventionsPostgreSQL Database Data DirectoryPostgreSQL Database default Bin DirectoryPostgreSQL Database default configuration files locationPostgreSQL Database MaintenancePostgreSQL Database ArchitecturePostgreSQL Database Backup & RecoveryPostgreSQL Database PerformancePostgreSQL Database ClusterPostgreSQL Database ReplicationPostgreSQL Database UpgradePostgreSQL Database/Tables Vacuum operationsPostgreSQL Database ViewsPostgreSQL Database Tablespace managementPostgreSQL Database UsersPostgreSQL Database SchemasPostgreSQL Database Configuration FilesMinimum hardware required to install and run PostgreSQL are:============================================a 1 GHz processor.2 GB of RAM.512 MB of HDD.Software Requirementsroot or super user access is required on Linux SystemsViews in postgreSQL==============pg_aggregate aggregate functionspg_am index access methodspg_amop access method operatorspg_amproc access method support procedurespg_attrdef column default valuespg_attribute table columns ("attributes")pg_authid authorization identifiers (roles)pg_auth_members authorization identifier membership relationshipspg_cast casts (data type conversions)pg_class tables, indexes, sequences, views ("relations")pg_constraint check constraints, unique constraints, primary key constraints, foreign key constraintspg_collation collations (locale information)pg_conversion encoding conversion informationpg_database databases within this database clusterpg_db_role_setting per-role and per-database settingspg_default_acl default privileges for object typespg_depend dependencies between database objectspg_description descriptions or comments on database objectspg_enum enum label and value definitionspg_extension installed extensionspg_foreign_data_wrapper foreign-data wrapper definitionspg_foreign_server foreign server definitionspg_foreign_table additional foreign table informationpg_index additional index informationpg_inherits table inheritance hierarchypg_language languages for writing functionspg_largeobject data pages for large objectspg_largeobject_metadata metadata for large objectspg_namespace schemaspg_opclass access method operator classespg_operator operatorspg_opfamily access method operator familiespg_pltemplate template data for procedural languagespg_proc functions and procedurespg_rewrite query rewrite rulespg_seclabel security labels on database objectspg_shdepend dependencies on shared objectspg_shdescription comments on shared objectspg_statistic planner statisticspg_tablespace tablespaces within this database clusterpg_trigger triggerspg_ts_config text search configurationspg_ts_config_map text search configurations' token mappingspg_ts_dict text search dictionariespg_ts_parser text search parserspg_ts_template text search templatespg_type data typespg_user_mapping mappings of users to foreign servers

Skills

Reviews