|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/postgres-administration-for-database-administrator/
课程评论：没有评论
课程名称：PostgreSQL数据库管理基础培训 课程概述：本课程旨在为初学者和有其他数据库管理系统（如Microsoft SQL Server、MySQL或Oracle）经验的数据库管理员提供实用的培训。整个课程中涵盖的练习和示例将提供实践操作经验，使学员掌握相关技术。 课程目标：本课程旨在让学员掌握PostgreSQL数据库的安装、管理、维护、备份、恢复和调优等知识。 适用人群：本课程适合需要了解PostgreSQL 10至16版特性和功能的专业数据库管理员以及使用PostgreSQL 9的用户。 学习技能：学员将学习并掌握以下技能： - 安装PostgreSQL - 创建数据库 - 管理角色和权限 - 检查统计信息和系统表 - 管理表空间 - 执行定期维护（如VACUUM和自动真空） - 备份和恢复数据库 - 配置以提高性能的设置 PostgreSQL是目前最先进的开源平台之一，许多大型组织（如Cisco和Apple）在其基于web和移动应用程序开发中使用该工具。PostgreSQL由致力于保持平台时效性的开源社区管理，开发者社区的另一个关注点是安全性，他们不断推进PostgreSQL的更新以应对当今的安全威胁。
PostgreSQL Administration Course OverviewThis course is targeted at beginners and DBAs with experience using another DBMS such as Microsoft SQL Server, MySQL, or Oracle. Exercises and examples are used throughout the course to give practical, hands-on experience with the techniques covered.Course ObjectivesThis course aims to provide the delegate with the knowledge to be able to install, administer, maintain, backup, recover, and tune a PostgreSQL database.Who will the Course Benefit?This PostgreSQL Administration course is designed for professional database administrators who need to gain an understanding of the features and functionality that can be used to manage PostgreSQL 10, 11, 12, 13, 14, 15 an 16 databases. This course is also suitable for users of PostgreSQL 9 databases.Skills GainedThe delegate will learn and acquire skills as follows:Install PostgreSQLCreate a databaseManage roles and privilegesExamine statistics and system tablesManage tablespacesCarry out periodic maintenance with VACUUM autovacuumBackup and restore databasesConfigure settings for increased performancePostgreSQL is one of the most advanced open-source platforms available today. Multiple large-scale organizations such as Cisco and Apple use the tool for their web-based and mobile-based application development. It is managed by an open-source community that is dedicated to improving the platform to keep it relevant to today's time. Another focus for the community of developers is security; they keep evolving PostgreSQL and updating their security measures to keep up with the threats of today.
