|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/postgresql-course/
课程评论：没有评论
课程名称：完整的PostgreSQL课程！从基础到高级 v2025！ 概述： PostgreSQL是一款开源的数据库管理系统，自1996年推出以来，由“PostgreSQL全球开发组”维护。由于其完全开放和免费的特性，PostgreSQL广泛应用于全球各地的企业。对于想要投资构建小型到大型系统的用户，建议使用PostgreSQL数据库。它具有多个主要特性，包括： - 外键支持 - 更复杂的查询功能 - 稳健且高质量的软件，具有可维护和良好注释的代码 - 多版本并发管理 - 事务完整性 - 出色的性能、安全性和高可用性 - 高可接近性 - 混合对象-关系模型支持 - 视图与触发器 - 文本索引 - 支持pgSQL、Python、Java、Perl、C等不同语言的存储过程的结构化编程语言 - PostGIS数据存储系统，用于地理信息系统 用户还可以根据需要扩展PostgreSQL，获取新的工具，如过程语言、数据类型、函数、操作符、聚合函数、索引方法等等。由于其较少的限制性许可，这款数据库管理系统可以被任何公司用于任何目的（商业、学术、个人），而无需支付任何类型的许可证费用或其他报酬。 许多人感到惊讶的是，PostgreSQL的功能集与Oracle数据库或SQL Server的相似程度，远超与MySQL或MariaDB的比较。MySQL/MariaDB与PostgreSQL之间唯一的联系在于这两个项目都是开源的，此外，两者的功能特点和使用哲学几乎完全不同。从早期作为研究数据库实施新特性着手，到近年来对大量代码进行重写和改进，为数据库管理员提供稳定的服务器软件和商业用途的高可用性。 欢迎您加入这门课程，深入探索PostgreSQL的强大功能与应用潜力！
Launched in 1996, PostgreSQL is an open-source DBMS maintained by the "PostgreSQL Global Development Group".As it is open-source and completely free, PostgreSQL is widely used in companies around the world.It is recommended that anyone who wants to invest in creating small to large systems use and apply the PostgreSQL database.Some of the main features are:Foreign keys;More complex searches;Robust and high-quality software with maintainable and well-commented codeMultiversion concurrency management;Transactional integrity;Performance, security and high availabilityHigh accessibility;Support for the hybrid object-relational model.Views;Triggers;Text indexing;Structured programming language in different languages for stored procedures, such as pgSQL, Python, Java, Perl, C, etc.; PostGIS data storage system, for Geographic Information System.And it can be expanded by any user, gaining new tools such as: procedural languages, data types; functions; operators; aggregation functions; index methods, among others.Because of its less restrictive license, this DBMS can be used, modified and distributed by any company and for any purpose (commercial, academic, personal) without having to pay any type of license or any other remuneration.What surprises many people is that the PostgreSQL feature set is more comparable to that of Oracle Database or SQL Server than to MySQL or MariaDB itself.The only connection between MySQL/MariaDB and PostgreSQL is that these two projects are open source;In addition, the characteristics and philosophies of use are almost completely different.In the early days, when PostgreSQL was still a research database, the focus was exclusively on new features.But over the past few years, huge amounts of code have been rewritten and improved, and extensions have been provided to database administrators, more stable server software, and high availability for commercial use.
