|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-data-analysis-using-postgresql-for-beginners/
课程评论：没有评论
课程名称：初学者的PostgreSQL数据分析SQL课程 课程概述：SQL（结构化查询语言）是一种用于管理关系数据库中数据的编程语言，自1970年代以来一直存在，是当今访问数据库数据的最常用方法。SQL拥有多种功能，可以让用户读取、操作和更改数据。虽然SQL通常被软件开发工程师使用，但数据分析师也非常青睐它。SQL被视为访问和操作数据库的标准语言。 SQL能做什么？ - 执行针对数据库的查询 - 获取和分析存储在数据库中的数据 - 从数据库中检索数据 - 向数据库插入记录 - 更新数据库中的记录 - 从数据库中删除记录 - 创建新数据库 - 在数据库中创建新表 - 创建存储过程 - 在数据库中创建视图 - 设置表、过程和视图的权限 PostgreSQL是一个高级的、企业级的开源关系数据库，支持SQL（关系）和JSON（非关系）查询。作为一种拥有超过20年社区开发支持的稳定数据库管理系统，PostgreSQL因其高弹性、完整性和准确性而备受信赖。许多网络、移动、地理空间和分析应用程序使用PostgreSQL作为主要的数据存储或数据仓库。
SQL (Structured Query Language) is a programming language designed for managing data in a relational database. It's been around since the 1970s and is the most common method of accessing data in databases today. SQL has a variety of functions that allow its users to read, manipulate, and change data. Though SQL is commonly used by engineers in software development, it's also popular with data analysts. SQL is a standard language for accessing and manipulating databases.What Can SQL do?SQL can execute queries against a databaseSQL can fetch and analyse data stored inside a databaseSQL can retrieve data from a databaseSQL can insert records in a databaseSQL can update records in a databaseSQL can delete records from a databaseSQL can create new databasesSQL can create new tables in a databaseSQL can create stored procedures in a databaseSQL can create views in a databaseSQL can set permissions on tables, procedures, and viewsPostgreSQL is an advanced, enterprise class open source relational database that supports both SQL (relational) and JSON (non-relational) querying. It is a highly stable database management system, backed by more than 20 years of community development which has contributed to its high levels of resilience, integrity, and correctness. PostgreSQL is used as the primary data store or data warehouse for many web, mobile, geospatial, and analytics applications.
