|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/postgresql-database-administration-interview-questions/
课程评论：没有评论
课程名称：PostgreSQL数据库管理面试问题 课程概述：PostgreSQL是一款先进的企业级开源对象关系数据库管理系统（ORDBMS），支持SQL（关系型）和JSON（非关系型）查询。该课程为候选人提供了关于PostgreSQL数据库管理的深入知识，通过实际案例进行讲解。课程涉及的话题包括：PostgreSQL数据库命名规范、数据目录、默认Bin目录、默认配置文件位置、数据库维护、架构、备份与恢复、性能优化、集群管理、复制、升级、清理操作、视图、表空间管理、用户管理和模式管理等。 所需硬件：须具备至少1 GHz的处理器、2 GB内存和512 MB硬盘。 软件要求：在Linux系统上需具备root或超级用户访问权限。 PostgreSQL中的视图包括但不限于：聚合函数、索引访问方法、列默认值、表的属性、角色授权、数据库集群内的数据库、默认权限、跨数据库对象的依赖关系等。 本课程为希望在PostgreSQL数据库管理领域面试的候选人提供全面的知识和技能，以帮助他们在实际工作中应对各种挑战。
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
