|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-sql-using-postgresql-server-beginner-to-expert/
课程评论：没有评论
课程名称：使用PostgreSQL服务器学习SQL - 从初学者到专家 课程概述： SQL（结构化查询语言）是一种国际公认的用于与多种数据库系统进行通信和操作的语言。数据无处不在，并且以快速的速度增长。我们日常互动的大多数软件应用程序都涉及存储的数据，从与银行的互动到社交媒体应用程序如Facebook和Instagram。由于数据的相关性和依赖性，具备SQL技能的专业人士在帮助与各种数据库交互以支持商业智能和其他依赖数据的领域中非常抢手。本课程将从绝对初学者教授到专家，使学员能够自信地构建简单到复杂的查询，以与数据库进行交互。我们将使用PostgreSQL服务器作为数据库的托管平台，PostgreSQL是一种全球许多公司使用的关系数据库管理系统（RDBMS）。 学习内容包括： - 如何通过联接从多个数据库表中提取数据 - 如何使用SQL向数据库插入新数据 - 如何更新数据库中的现有数据 - 如何从数据库中删除数据 - 如何过滤数据 - 如何对数据进行排序 - 如何创建和查询视图 - 如何构建存储过程 - 如何使用聚合函数总结返回的数据 - 如何对数据进行分组 - 创建视图 - 创建触发器 - 创建子查询 - 使用分析函数进行数据分析 SQL还可以用于数据分析，将数据库中已经存在的数据转换为有价值的信息，帮助公司和组织做出关键的商业和管理决策。在数据被收集的各处，所有交易、每次网页访问、每次支付——这些以及更多的内容都在关系数据库中填充了原始数据，这些数据可以分析以提供有用的信息。因此，能够利用数据进行报告和分析的人才需求不断上升，协助企业和组织做出重要和关键的决策。
SQL -Structured Query Language is an internationally recognised language used to communicate and manipulate various database systems.Data is everywhere and growing at a rapid rate. Most Software application we interact with daily deals with stored data. From our interaction with our banks to social media applications like Facebook and Instagram..Due to the relevance and dependency on data , professionals that are skilled in SQL are always in high demand to help interact with various databases to help business intelligence and other sectors that relies on data.This course will teach you from absolute beginner to expert so you can be confident with enough skills to build simple to complex queries to communicate and interact with databases.We will be using PostgreSQL Server to host our database.PostgreSQL Server is a relational database management system -RDBMS used by lots of companies all over the world What You Will Learn include:How to extract data from multiple Database Tables using JoinsHow to insert new data into database with SQLHow to update existing data inside a databaseHow to delete data from a databaseHow to filter dataHow to sort dataHow to create and query viewsHow to build a stored procedureHow to use Aggregate functions to summarize returned dataHow to group dataCreating viewsCreating TriggersCreating sub-queriesData Analysis with Analytic functionsSQL can be used for Data Analysis to transform data already present in the database to valuable useful information that help companies and organisations make key business and management decisions.Everywhere data is being collected, every transaction, every web page visit,every payment-all these and much, much more are filling relational databases with raw data that can be analysed to provide useful information.There is a demand for people who can use data to perform reporting and analysis thus helping businesses and organizations make important and critical decisions.
