|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/intermediate-postgresql
课程评论：没有评论
课程名称：中级PostgreSQL 课程概述：该课程涵盖了广泛的SQL技术，超越了基本的CRUD（创建、读取、更新和删除）操作。您将学习聚合、事务处理、读取和解析CSV文件以及将数据插入数据库的具体方法。同时，还将了解PostgreSQL如何处理和索引文本数据。学生将完成一些作业，涉及更改表架构、创建存储过程、构建高级查询，探讨排序和分组查询数据的技巧，以及使用正则表达式处理数据库中的文本数据。 课程大纲： - 第一周：SQL技术 - 描述：这一周您将介绍课程内容，并学习在PostgreSQL数据库中编辑列和表的SQL命令，包括创建存储过程和使用SELECT DISTINCT命令。 - 第二周：使用SQL技术 - 描述：这一周，我们将专注于从CSV文件生成正确规范化的表，并利用ALTER TABLE命令调整表的架构。 - 第三周：PostgreSQL中的文本 - 描述：这一周将重点讨论PostgreSQL中的文本，包括使用字符集、识别哈希算法及属性，以及索引选择与技巧。 - 第四周：正则表达式 - 描述：在最后一周，我们将专注于正则表达式：其功能以及如何构建正则表达式以选择与特定模式匹配的表行。
Name:SQL Techniques
Description:In this first week, you'll be introduced to the course and look at SQL commands for editing columns and tables in a PostgreSQL Database. You'll learn to create stored procedures and also utilize the SELECT DISTINCT command.
Name:Using SQL Techniques
Description:This week, we'll focus on producing properly normalized tables from CSV files and utilizing the ALTER TABLE command to adjust the schema of tables.
Name:Text in PostgreSQL
Description:This week will focus on text in PostgreSQL, including utilizing character sets, identifying hashtag algorithms and attributes, as well as index choices and techniques.
Name:Regular Expressions
Description:In our final week, we will focus on regular expressions: their functions, and how to construct them to select rows from a table that match a pattern.
This course covers a 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. You’ll also take a look at how PostgreSQL handles and indexes text data. Specifically, students will do assignments that alter table schemas, create stored procedures, construct advanced queries, explore sorting and grouping query data, and techniques for working with text in databases including regular expressions.
