|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/postgresql-database-administration-dba-for-beginners/
课程评论：没有评论
课程名称：PostgreSQL数据库管理（DBA）入门 课程概述：PostgreSQL（常称为Postgres）是一种强大的开源对象关系数据库系统。数据库管理员（DBA）的主要职责是确保数据的可用性，防止数据丢失和损坏，并在需要时方便地访问数据。本课程涵盖了PostgreSQL数据库服务器管理中的一些重要活动，包括：数据库管理、备份和恢复、表空间管理、角色管理、用户管理以及通过适当的角色管理来保护数据库。 在本课程中，我们将介绍PostgreSQL的基础知识，涵盖从安装、基本查询编写到从表中检索数据的主题。我们还将探讨连接表以检索数据的逻辑。课程内容包括创建表、使用数据类型存储数据，以及处理表达式、运算符和字符串。具体主题包括：安装PostgreSQL、加载示例数据库、创建数据库和表、执行CRUD操作、连接表、使用聚合和分析函数、创建视图和触发器。 这是一个实用的动手课程，将为您提供与PostgreSQL相关的技能和信心。
PostgreSQL is commonly known as Postgres and it is also open source database. PostgreSQL is a powerful, open source object-relational database system.A database administrator's (DBA) primary job is to ensure that data is available, protected from loss and corruption, and easily accessible as needed.The PostgreSQL administration covers some of the most important PostgreSQL database server administration activities. Some of the Key Responsibilities of a Database Administrator includes:Database ManagementDatabase Backup and restoreTablespace managementRole ManagementManaging users Securing database via proper role managementA DBA ( Database administrator) has to perform several responsibilities to ensure the smooth running of the SQL sever database.In this course, we will go over the basics of the PostgreSQL. We will cover topics ranging from installations, to writing basic queries and retrieving data from tables. We will also explore the logic of joining tables to retrieve data and much more. The course also covers the basics of creating tables, storing data with data types, and working with expressions, operators, and strings. Topics also includes:Installing PostgreSQLLoading sample databaseCreating database and tablesPerforming CRUD operationsJoining TablesUsing aggregate and analytic functionsCreating views and triggersThis is a practical hands-on course that will equip you with the skills and confidence to work with PostgreSQL.
