|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/postgresql-dba-routine-maintenance-tasks-and-data-dictionary/
课程评论：没有评论
课程名称：《PostgreSQL DBA日常维护任务与数据字典》 课程概述：此课程为PostgreSQL数据库管理员提供了一种中立的培训与认证方式，适合从初学者到专家级别的数据库专业人士。PostgreSQL是一种强大的开源对象关系型数据库系统，结合多种功能以安全存储和扩展复杂的数据工作负载。自1986年加州大学伯克利分校的Postgres项目以来，PostgreSQL已有超过30年的核心平台开发历史。 本课程由CertFirst提供，该机构是全球领先的开源和安全认证培训提供商，并于2005年首次推出结构化的PostgreSQL培训与认证项目。CertFirst提供的Postgresqlcert课程旨在为客户提供客观中立的培训及认证，培养学员对市场上各种可用选项的理解，而不仅仅是集中在某一供应商的产品和服务上。 学习前提条件：学员需要具备基本的SQL和Linux操作系统知识，并需能访问互联网以下载PostgreSQL服务器。虽然对SQL语言的基本理解强烈推荐，但并非强制要求。 目标受众：本课程适合现有的Oracle、MySQL或Microsoft DBA，以及希望获得PostgreSQL DBA认证的新候选人。认证考试费用为195美元（不包括在内）。 课程内容涵盖PostgreSQL数据库管理的多个领域，每个视频专注于特定主题，使学员能够在实际操作环境中掌握与应用所学知识。学员将学习数据库健康监控、定期备份与恢复、通过索引和清理优化数据库性能以及优化存储空间利用等日常维护任务。此外，课程还深入探讨了PostgreSQL中的数据字典，它是一个集中存储元数据的存储库，包含关于数据库对象、模式、权限及其他相关详细信息的全面信息。这使得管理员能够有效管理和分析数据库结构与内容。通过掌握这些关键技能，参与者不仅能够确保PostgreSQL数据库的高效性和安全性，还能为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 "PostgreSQL DBA Routine Maintenance Tasks and Data Dictionary" topic within the PostgreSQLCert program provides an in-depth exploration of crucial routine maintenance activities essential for maintaining the peak performance, dependability, and security of PostgreSQL databases. This encompasses a spectrum of tasks, including monitoring database health, conducting regular backups and restores, fine-tuning database performance through indexing and vacuuming, and optimizing database storage space utilization. Moreover, the topic delves into the concept of a data dictionary in PostgreSQL, acting as a centralized repository of metadata containing comprehensive information about database objects, schemas, privileges, and other pertinent details. This empowers administrators to efficiently manage and analyze database structures and contents. By mastering these essential skills, participants not only ensure the efficiency and security of PostgreSQL databases but also bolster their readiness for the PostgreSQL DBA certification program.
