|
所在平台: Coursera专项课程 |
课程主页: https://www.coursera.org/specializations/postgresql-for-everybody
课程评论：没有评论
课程名称： PostgreSQL for Everybody 课程概述： 在本课程中，你将学习如何使用psql和SQL命令在PostgreSQL数据库中实施CRUD（创建、读取、更新和删除）操作。你将识别并利用数据库中的主键、逻辑键和外键的功能。此外，你还将构建并区分PostgreSQL中的一对多和多对多关系，并回顾对SQL标准建设有贡献的重要人物、组织和创新。 所获得的技能： - Json - 数据库管理系统（DBMS） - 自然语言处理 - SQL 关于本专业： 本课程系列共包括四门课程，旨在教会你如何使用PostgreSQL数据库，并探索从数据库设计到数据库架构和部署的各个主题。你还将比较SQL和NoSQL的数据库设计方法。本课程的技能将对从事数据挖掘或应用开发的学习者非常有用。 实践学习项目： 本课程系列利用自定义自动评分环境，提供真实的评分和实践作业，包括创建和操纵表，设计数据模型，构建高级查询，处理文本的技术，包括正则表达式等。 证书： 完成课程后可获得可分享证书。课程为100%在线，学习者可以按自己的时间安排学习，并设置灵活的截止日期。 课程难度： 本课程为中级水平，要求完成“Python for Everybody”专业的前两门课程或具备相当于基本Python理解的能力。预计完成时间约为4个月，建议每周学习4小时。 可用语言： 本课程以英语授课，提供英语字幕。 课程链接： - 数据库设计与PostgreSQL基础SQL - 进阶PostgreSQL - PostgreSQL中的JSON与自然语言处理 - 数据库架构、可扩展性及Elasticsearch与NoSQL 欢迎立即注册参与学习！
Course Link: https://www.coursera.org/learn/database-design-postgresql
Name:Database Design and Basic SQL in PostgreSQL
Description:Offered by University of Michigan. In this course you will learn more about the historical design of databases and the use of SQL in the ... Enroll for free.
Course Link: https://www.coursera.org/learn/intermediate-postgresql
Name:Intermediate PostgreSQL
Description:Offered by University of Michigan. This course covers a wide range of SQL techniques, beyond basic CRUD (Create, Read, Update, and Delete) ... Enroll for free.
Course Link: https://www.coursera.org/learn/json-natural-language-processing-postgresql
Name:JSON and Natural Language Processing in PostgreSQL
Description:Offered by University of Michigan. Within this course, you’ll learn about how PostgreSQL creates and uses inverted indexes for JSON and ... Enroll for free.
Course Link: https://www.coursera.org/learn/database-architecture-scale-nosql-elasticsearch-postgresql
Name:Database Architecture, Scale, and NoSQL with Elasticsearch
Description:Offered by University of Michigan. In this final course, you will explore database architecture, PostgreSQL, and various scalable deployment ... Enroll for free.
What you will learn
Utilize psql and SQL commands to implement CRUD (Create, Read, Update, and Delete) operations for tables in a PostgreSQL database.
Identify and utilize the functions of primary, logical, and foreign keys within a database.
Build and differentiate between one-to-many and many-to-many relationships within PostgreSQL.
Recall key people, organizations, and innovations that were instrumental to building the SQL standard
Skills you will gain
Json
Database (DBMS)
Natural Language Processing
SQL
About this Specialization
14,063
recent views
Across these four courses, you’ll learn how to use the PostgreSQL database and explore topics ranging from database design to database architecture and deployment. You’ll also compare and contrast SQL and NoSQL approaches to database design. The skills in this course will be useful to learners doing data mining or application development.
Applied Learning Project
This course series utilizes a custom autograding environment for an authentic set of graded and practice assignments, including: creating and manipulating tables, designing data models, constructing advanced queries, techniques for working with text in databases, including regular expressions, and more.
Shareable Certificate
Shareable Certificate
Earn a Certificate upon completion
100% online courses
100% online courses
Start instantly and learn at your own schedule.
Flexible Schedule
Flexible Schedule
Set and maintain flexible deadlines.
Intermediate Level
Intermediate Level
Completion of the first two courses in the
Python for Everybody specialization
or an equivalent basic understanding of Python
Hours to complete
Approximately 4 months to complete
Suggested pace of 4 hours/week
Available languages
English
Subtitles: English
Shareable Certificate
Shareable Certificate
Earn a Certificate upon completion
100% online courses
100% online courses
Start instantly and learn at your own schedule.
Flexible Schedule
Flexible Schedule
Set and maintain flexible deadlines.
Intermediate Level
Intermediate Level
Completion of the first two courses in the
Python for Everybody specialization
or an equivalent basic understanding of Python
Hours to complete
Approximately 4 months to complete
Suggested pace of 4 hours/week
Available languages
English
Subtitles: English
