|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/postgresql-pgadmin-for-beginners/
课程评论：没有评论
课程名称：Postgresql PgAdmin 初学者课程 课程概览：PostgreSQL（简称Postgres）是一个免费的开源关系数据库管理系统，强调可扩展性和SQL兼容性。它最初命名为POSTGRES，标志着其作为加州大学伯克利分校开发的Ingres数据库的后继者而诞生。PostgreSQL是一个高级、企业级的开源关系数据库系统，支持SQL（关系查询）和JSON（非关系查询）。该数据库经过超过20年的开源社区开发，具有高度的稳定性，广泛用于许多Web应用、移动应用和分析应用程序。 pgAdmin是最流行、功能最丰富的PostgreSQL开源管理和开发平台，适用于Linux、Unix、macOS和Windows。该工具可以管理PostgreSQL数据库和EDB高级服务器（10及以上版本）。PostgreSQL作为一个数据库引擎，实施SQL标准，通常在网络tcp端口上以服务器形式运行。pgAdmin则作为客户端，用户可以通过它在单个或多个PostgreSQL引擎实例上操作模式和数据。pgAdmin工具允许用户连接并与PostgreSQL服务器及其数据库进行交互。 本课程旨在为初学者提供PostgreSQL和pgAdmin的基本知识与实践技能，帮助学员掌握数据库的管理与开发。
PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley.PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying.PostgreSQL is a highly stable database backed by more than 20 years of development by the open-source community.PostgreSQL is used as a primary database for many web applications as well as mobile and analytics applications.pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world. pgAdmin may be used on Linux, Unix, macOS and Windows to manage PostgreSQL and EDB Advanced Server 10 and above.The PostgreSQL is a database engine implementing SQL standards. It usually listen as a server on a network tcp port to provide its abilities. The pgAdmin is a sort of client. You are able to manipulate schema and data on an instance or multiple instances of PostgreSQL engines.Pgadmin tool can be used to connect to and interact with PostgreSQL Server and databases.
