|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/postgresql-for-beginners-learn-the-fundamentals-of-sql/
课程评论：没有评论
## Coursera 课程总结：SQL & PostgreSQL 入门：掌握 SQL 基础 本课程是为希望在 2021 年最热门的技术行业中获得一项备受追捧的技能的学习者而设计的。SQL（结构化查询语言）是一种用于从数据库存储、管理、操作和提取数据的计算机语言。学习 SQL 是 2021 年的重要技能之一，能够显著提升职业前景。 **课程内容涵盖：** * **SQL 基础语句：** SELECT, SELECT DISTINCT, LIMIT 等。 * **基础聚合函数：** SUM, AVG, COUNT, MAX, MIN。 * **基础数学、字符串和时间函数及运算符。** * **数据类型、主键与外键、约束。** * **创建、插入和修改表（增删改查）的操作。** * **数据分析：** GROUP BY 语句和 HAVING 子句。 * **多表连接：** UNION, LEFT JOIN, RIGHT JOIN, INNER JOIN, OUTER JOIN。 * **复杂查询编写。** * **高级概念：** CASE, COALESCE, VIEWS 等。 * **CREATE FUNCTION 命令。** * **窗口函数。** * **CSV 文件导入/导出（PostgreSQL 操作）。** 本课程不仅涵盖理论知识，还通过在 pgAdmin 中编写查询进行实践操作，并配有作业，以帮助学习者深入理解和应用所学概念。完成本课程后，学习者将掌握应对真实世界场景所需的全部 SQL 知识。
Learn one of the most in-demand skills in tech industry in 2021!SQL, also known as Structured Query Language is a computer language that is designed to store, manage, manipulate, and extract data from a database. Learning SQL is actually one of the top skills in 2021, and can significantly improve your career prospects.This course is designed in such a way that it will taught effectively, and the concepts you learn here can easily be applied to real-world scenarios. In this course, you will learn the following:The Fundamental Statements of SQL like SELECT, SELECT DISTINCT, LIMIT, and much more.Basic Aggregate functions like SUM, AVG, COUNT, MAX, and MIN.Basic mathematical, string, and time functions and operators.Data types, Primary & Foreign Keys, Constraints.Creating your own tables, inserting values in them, and also modifying the rows and columns of the tables.GROUP BY statement, and HAVING clause for data analysisJOINING multiple tables with the help of UNION, LEFT JOIN, RIGHT JOIN, INNER JOIN, OUTER JOIN.Writing complex queries. Advanced concepts like CASE,COALESCE, VIEWS etc.CREATE FUNCTION command.Window Functions.Import/Export csv files to/from PostgreSQL server. We will not only cover the concepts, but also perform practical examples by writing queries on pgAdmin. This will help you a lot in understanding the topics that we will discuss throughout this course. I will also give you assignments throughout this course, which will help you cover all the concepts that we will discuss.By the end of this course, you would have acquired all the knowledge necessary for real-world scenarios. I wish you all the best for this course, and Good Luck.
