|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/postgresql-dba-table-partitioning-and-pg_upgrade/
课程评论：没有评论
课程名称：PostgreSQL DBA表分区与PG_UPGRADE 课程概述：这是一个面向PostgreSQL数据库管理员（DBA）的培训及认证课程，适合从初学者到专家级别的数据库专业人士。PostgreSQL作为一个强大的开源对象关系数据库系统，自1986年始于加利福尼亚大学伯克利分校的Postgres项目，已有超过30年的核心平台开发历史。课程由CertFirst提供，这是全球领先的开源与安全认证培训机构，致力于提供无偏见的培训和认证，帮助学员了解市场上所有可用的选项。 **先决条件**： - 基础SQL与Linux操作系统知识 - 需要网络访问以下载PostgreSQL服务器 - 推荐具有SQL语言的基本理解，但非必需 **目标受众**： - 现有的Oracle、MySQL或Microsoft DBA - 有兴趣获得PostgreSQL DBA认证的新候选人 **认证考试费用**：$195（不包括在内） 课程内容详细探讨了PostgreSQL DBA表分区和PG_UPGRADE两个关键方面。首先，课程介绍了表分区这种有效的技术，通过将表分割成更小、更易管理的部分，来增强数据库性能和简化大型数据集的管理。此部分包括了不同的分区策略、实施方法以及优化性能和简化数据管理的推荐实践。 其次，课程深入讲解了PG_UPGRADE工具，该工具旨在帮助数据库集群无缝升级到新版本，同时确保数据完整性并最小化停机时间。内容涵盖了从初步规划和准备步骤到执行升级及后续验证和测试的详细指导。 本模块不仅提供了丰富的理论知识，还为学员提供了实践环境，旨在帮助参与者在PostgreSQL DBA认证的道路上获得成功。
Only Vendor Neutral Training & Certification course for PostgreSQL DBACOURSE FOR BEGINNERS TO EXPERT LEVEL DATABASE PROFESSIONALSPostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The origins of PostgreSQL date back to 1986 as part of the Postgres project at the University of California at Berkeley and has more than 30 years of active development on the core platform.PostgreSQLCert is a dedicated PostgreSQL Training, Certification & Services division of CertFirst (A leading Global Open Source and Security certification Training Provider). CertFirst became the first company in 2005 to launch a structured PostgreSQL Training & Certification program and has successfully provided hands-on Instructor-led training to hundreds of clients world-wide.Postgresqlcert offers vendor Neutral certification programs so the client can get to learn about all available options in the market NOT just focused on one vendor who is just trying to promote their own products and services. Postgresqlcert goal is provide the best possible non-bias training & certification possible to all its clients.Pre-Requisite:Basic SQL & Linux OSInternet access is required to download PostgreSQL ServerBasic understanding of SQL language is highly recommended but not requiredTarget Audience:Existing Oracle, MySQL or Microsoft DBA's or new candidates interested in getting certified as a PostgreSQL DBA.Certification Exam Fee: $195 (not Included)This extensive PostgreSQL DBA training & certification program is divided in to several domains. Each video covers a specific specialized topic which will enable candidate to master each domain by learning and then applying this knowledge in the hands-on environment. Local or cloud installation will be required in order to perform all labs.The PostgreSQLCert module focusing on "PostgreSQL DBA table partitioning and PG_UPGRADE" provides comprehensive coverage of two critical aspects of PostgreSQL database administration. Firstly, it explores table partitioning, an effective technique utilized to enhance database performance and streamline the management of large datasets by partitioning tables into smaller, more manageable segments based on defined criteria such as ranges or hash values. The module extensively discusses various partitioning strategies, implementation approaches, and recommended practices aimed at optimizing performance and simplifying data administration.Secondly, the module delves into PG_UPGRADE, a utility within PostgreSQL designed to facilitate the seamless upgrade of database clusters to newer versions while ensuring data integrity and minimizing downtime. It encompasses detailed guidance on the entire upgrade process, from initial planning and preparatory steps to executing the upgrade and conducting post-upgrade verification and testing. Additionally, this module serves as valuable preparation for the PostgreSQL DBA certification program, equipping participants with the necessary knowledge and skills to excel in their certification journey.
