|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/postgresql-for-beginners-learn-postgresql-from-scratch/
课程评论：没有评论
课程名称：PostgreSQL 入门 课程概述： 该课程介绍了 PostgreSQL，这是一个强大且开源的对象关系数据库系统，利用并扩展 SQL 语言，结合多种功能，安全地存储和扩展最复杂的数据工作负载。PostgreSQL 追溯至1986年，起源于加州大学伯克利分校的 POSTGRES 项目，已有超过30年的核心平台开发历史。 为什么选择 PostgreSQL？ PostgreSQL 拥有众多功能，旨在帮助开发人员构建应用程序，帮助管理员保护数据完整性并创建容错环境，也帮助用户管理各种规模的数据集。除了免费和开源外，PostgreSQL 具有高度的可扩展性，用户可以定义自有数据类型、构建自定义函数，甚至在不重新编译数据库的情况下使用不同编程语言编写代码。 为什么选择这门课程？ 在本课程中，您将学习广泛的 SQL 技术，超越基础的 CRUD（创建、读取、更新和删除）操作。您将学习聚合、事务、读取和解析 CSV 文件以及如何将数据插入数据库的具体细节。此外，课程还将介绍数据库的历史设计以及 SQL 在 PostgreSQL 环境中的使用。通过 SQL 技巧和通用命令（如 INSERT INTO、WHERE、ORDER BY、ON DELETE CASCADE 等），您将能够在 PostgreSQL 中创建表、定义列类型和数据模式。课程还会教授数据建模，以及如何在 PostgreSQL 中表示一对多和多对多关系。 课程中包含一些有趣的测验，基于 PostgreSQL 概念，涉及创建表、插入数据、设计数据模型、创建关系结构以及在表中插入和查询关系数据。 希望您享受此课程！
What is PostgreSQL ?PostgreSQL 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.Why to use PostgreSQL ?PostgreSQL comes with many features aimed to help developers build applications, administrators to protect data integrity and build fault-tolerant environments, and help you manage your data no matter how big or small the dataset. In addition to being free and open source, PostgreSQL is highly extensible. For example, you can define your own data types, build out custom functions, even write code from different programming languages without recompiling your database!Why to choose this Course ?In this course you will learn wide range of SQL techniques, beyond basic CRUD (Create, Read, Update, and Delete) operations in PostgreSQL. You will learn the specifics of aggregation, transactions, reading and parsing CSV files and inserting data into a database. Also you will learn more about the historical design of databases and the use of SQL in the PostgreSQL environment. Using SQL techniques and common commands (INSERT INTO, WHERE, ORDER BY, ON DELETE CASCADE, etc.) will enable you to create tables, column types and define the schema of your data in PostgreSQL. You will learn about data modeling and how to represent one-to-many and many-to-many relationships in PostgreSQL. Course contains some interesting quizzes on basis of PostgreSQL concepts like creating tables, inserting data, designing data models, creating relational structures and inserting and querying relational data in tables.Enjoy the course!
