Database structure design?  It’s here.  Query tuning and optimization? You’ll master it.  Complex queries? Yes indeed!
数据库结构设计？它就在这里。查询调优和优化？你会掌握它。复杂的查询？是的，确实如此！

This is the only course online that will teach you how to design a database, store complex data, optimize your queries, everything that is needed for operating a production, scalable database!
这是唯一一门在线课程，可以教您如何设计数据库、存储复杂数据、优化查询，以及操作生产、可扩展数据库所需的一切！

Every app in the world, whether it is a mobile app built with Flutter, a web app constructed with React, or a plain HTML page, needs to store information in a database.  Although there are many different databases you can use, PostgreSQL has been a number-one pick for decades, offering scalable performance, rock-solid uptime, and flexible design systems.  This course will teach you everything you need to know about PostgreSQL to use it on your next big project!
世界上的每一个应用程序，无论是使用 Flutter 构建的移动应用程序、使用 React 构建的 Web 应用程序，还是纯 HTML 页面，都需要将信息存储在数据库中。尽管您可以使用许多不同的数据库，但 PostgreSQL 几十年来一直是首选，它提供可扩展的性能、坚如磐石的正常运行时间和灵活的设计系统。本课程将教您有关PostgreSQL的所有知识，以便在您的下一个大项目中使用它！

Don’t know anything about databases at all? No problem. We begin with an overview of SQL, the language used to interact with PostgreSQL. Through an incredible number of exercises, you’ll get practical, hands on experience working with realistic datasets.  You will understand how to store, fetch, and update information with a series of powerful commands. 
对数据库一无所知？没关系。我们首先概述SQL，这是用于与PostgreSQL交互的语言。通过大量的练习，你将获得使用真实数据集的实用实践经验。您将了解如何使用一系列强大的命令来存储、获取和更新信息。

After gaining experience with elementary operations, you will move on to understanding database design patterns, offering multiple ways to structure your database for efficient data modeling. You’ll see many different scenarios with different types of data, and understand the pros and cons to several approaches.
在获得基本操作经验后，您将继续了解数据库设计模式，提供多种方法来构建数据库以实现高效的数据建模。你将看到具有不同类型数据的许多不同的方案，并了解几种方法的优缺点。

This course is packed with practice exercises and quizzes. You’ll get immediate practice on all of the different topics and features that you learn!  In addition, you’ll understand exactly where to use each of these features in real and practical projects.
本课程包含练习和测验。您将立即获得所学所有不同主题和功能的练习！此外，您将确切地了解在实际和实际项目中在哪里使用这些功能。

Besides getting practical hands-on experience, you’ll also get a behind-the-scenes look at how PostgreSQL works internally. We’ll dive into raw data files, investigating how PostgreSQL stores information on your hard drive bit by bit.  This knowledge is invaluable when it comes time to start tuning your queries for performance.  By having a natural instinct of how PostgreSQL works, you can plan on being able to get every last bit of performance out of your database.
除了获得实际的实践经验外，您还将了解 PostgreSQL 内部工作原理的幕后花絮。我们将深入研究原始数据文件，研究 PostgreSQL 如何一点一点地将信息存储在您的硬盘上。在开始调整查询的性能时，这些知识非常宝贵。通过对 PostgreSQL 工作原理的自然直觉，您可以计划能够从数据库中获得最后一点性能。

Here is a partial list of some of the topics that are covered in this course:
以下是本课程涵盖的一些主题的部分列表：

• Apply powerful SQL commands to store, update, and retrieve information
  应用强大的 SQL 命令来存储、更新和检索信息

• Build relationships between records using foreign keys between tables
  使用表之间的外键在记录之间建立关系

• Understand PostgreSQL’s numerous data types, and when to use each
  了解 PostgreSQL 的多种数据类型，以及何时使用每种数据类型

• Assemble reports of business data by using aggregation pipelines
  使用聚合管道组合业务数据报表

• Work with millions of records to simulate real production queries
  处理数百万条记录以模拟实际生产查询

• Exercise your query logic skills through the use of sets and sorting operators
  通过使用集合和排序运算符来锻炼查询逻辑技能

• Compose queries out of smaller reusable units using subqueries
  使用子查询从较小的可重用单元中编写查询

• Use different design patterns to efficiently model your data
  使用不同的设计模式对数据进行高效建模

• See how to divide database objects into different schemas to maintain them more easily
  了解如何将数据库对象划分为不同的架构，以便更轻松地维护它们

• Validate your data using simple ‘check’ rules
  使用简单的“检查”规则验证数据

• Construct perfect designs for common features such as ‘like’, ‘follow’, and ‘tag’ systems
  为“喜欢”、“关注”和“标签”系统等常见功能构建完美的设计

• Speed up your queries with indexes – you’ll see exactly how they work behind the scenes!
  使用索引加快查询速度 – 您将确切地看到它们在幕后的工作方式！

• Dive into some of the most complex queries around with recursive common table expressions
  深入了解一些使用递归公用表表达式的最复杂的查询

• Deal with concurrency issues easily by applying transactions
  通过应用事务轻松处理并发问题

I made this course to be the perfect resource for engineers just getting started with their first database.  Master the database itself, and see how to apply it with real designs.  Sign up today and master PostgreSQL!
我使这门课程成为刚开始使用第一个数据库的工程师的完美资源。掌握数据库本身，并了解如何将其应用于实际设计。立即注册并掌握 PostgreSQL！