CG数据库 >> PostgreSQL: From Zero to Hero

PostgreSQL: From Zero to Hero的图片1

PostgreSQL: From Zero to Hero

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 3.5 Hours | Lec: 58 | 556 MB

Genre: eLearning | Language: English

Master one of the great open source databases.

Learning SQL was one of the most valuable skills I learned while building Match. We had one of the largest instances of Microsoft SQL Server in the 90s with millions of records to keep the site running. The better we got at SQL, the better we could make the site work for our users and answers sophisticated questions about our users.

I want to teach you how to use PostgreSQL. We will walk through

Basic selection statements

Joining multiple tables together

Grouping records to get aggregate data

Inserting, updating and deleting records

Creating tables and indexes

Constraining data input using field and table constraints

PostgreSQL: From Zero to Hero的图片2

PostgreSQL: From Zero to Hero的图片1
PostgreSQL: From Zero to Hero的图片2

发布日期: 2018-03-19