|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/intro-to-postgresql-databases-with-pgadmin/
课程评论：没有评论
Coursera 推出《PostgreSQL 数据库入门：PgAdmin 实战指南》，由拥有近 20 年经验的 John Elder 授课。本课程专为初学者设计，无需任何先修知识。 **课程亮点：** * **安装与基础：** 学习安装 PostgreSQL 和 PgAdmin 4，了解数据库概念。 * **PgAdmin 界面：** 熟悉 PgAdmin 4 的各项功能。 * **数据操作：** 掌握创建表、添加、查询（SELECT、WHERE、Wildcards、AND/OR/NOT）、排序（ORDER BY）、插入（INSERT INTO）、更新（UPDATE）、删除（DELETE）以及限制（LIMIT）数据。 * **高级功能：** 深入学习外键（Foreign Keys）、内连接（Inner Join）、连接条件（Join Where Hack）、删除表（Delete Table）、表的导入导出（Import and Export Tables）以及数据库的备份与恢复（Backup and Restore Database）。 * **为什么选择 PostgreSQL：** 了解 PostgreSQL 在数据分析、Web 开发等领域的广泛应用及其易用性。 John Elder 拥有丰富的授课经验，并且提供 100% 退款保证。无论您是想进入数据领域，还是为 Web 开发打基础，本课程都将是您学习 PostgreSQL 的绝佳起点。
In this course I'll teach you how to setup and use PostgreSQL databases with the PgAdmin 4 interface! There's a reason why Postgres is so popular, find out why in this course! You have many databases to choose from, and even many free databases to choose from. But Postgresql is constantly ranked a top database for everything from data analytics to basic web development - and everything in between. Postgres is pretty easy to use! You'll be amazed at how quick and easy it is to dive in and get started!In this course, you learn to:Install pgAdmin and PostgreSQLWhat Is A DatabasepgAdmin OverviewCreate Table ColumnsAdd Data To A TablePostgreSQL Select StatementsPostgreSQL Where ClausePostgreSQL WildcardsPostgreSQL AND OR NOTPostgreSQL Order ByPostgreSQL Insert IntoPostgreSQL UpdatePostgreSQL DeletePostgreSQL LimitpgAdmin Menu WalkthruPostgreSQL Foreign KeysPostgreSQL Inner JoinPostgreSQL Join Where HackPostgreSQL Delete TablePostgreSQL Import and Export TablesPostgreSQL Backup and Restore DatabaseAnd More!This course is perfect for anyone just starting out, you don't need any special skills or prior knowledge to take this course.And as always, we offer a 100% money back guarantee if you aren't completely happy with the course. No questions asked!My name is John Elder and I have nearly 40 courses here at udemy, with close to 45,000 students and over 105,000 enrollments. I've been writing code and developing neat things online for over 20 years and I'd love to teach you what I know!What are you waiting for, let's learn some PostgreSQL database wizardry!-John ElderCEO Codemy. com
