|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-beginners-with-postgresql/
课程评论：没有评论
课程名称：初学者的SQL与PostgreSQL 课程概述：PostgreSQL是一种开源数据库管理系统，适用于企业级数据库应用。它支持SQL和JSON，用于关系型和非关系型查询，具备可扩展性和SQL合规性。同时，PostgreSQL提供了先进的数据类型和性能优化功能，能够存储和扩展复杂的数据库工作负载。SQL（结构化查询语言）的魅力在于，只要是使用关系型数据库存储数据的公司，任何员工都能运用它来处理数据。例如，如果你在一家软件公司工作，想要提取客户的使用数据，可以通过SQL实现。如果你正在为一家电子商务公司开发网站，该公司有顾客购买数据，你可以利用SQL来查看哪些顾客购买了哪些产品。这只是众多应用中的一些示例。全球大量的原始数据——从电子病历到客户交易历史——都存储在称为关系数据库的有组织表格中。要有效地处理数据，你必须掌握如何使用SQL从这些数据库中提取和操纵数据。
PostgreSQL is an open-source database management system for enterprise-class database applications. It supports both SQL and JSON for relational and non-relational queries for extensibility and SQL compliance. It also offers advanced data types and performance optimization features to store and scale complicated database workloads. It is also known as Postgres.SQL (often pronounced like "sequel") stands for Structured Query Language, and it's used when companies have a ton of data that they want to manipulate. The beauty of SQL is that anyone working at a company that stores data in a relational database can use it. (And chances are, yours does.)For example, if you work for a software company and want to pull usage data on your customers, you can do that with SQL. If you're helping develop a website for an ecommerce company that has data about customer purchases, you can use SQL to find out which customers are purchasing which products. Of course, these are just a few of many possible applications.Much of the world's raw data-from electronic medical records to customer transaction histories-lives in organized collections of tables called relational databases. To be effective in working with data , you must know how to wrangle and extract data from these databases using a language called SQL.
