Querying Data with SQL from PostgreSQL | Path
Год выпуска: 2020
Производитель: Pluralsight
Сайт производителя://app.pluralsight.com/paths/skill/querying-data-with-sql-from-postgresql
Автор: Коллектив авторов
Продолжительность: ~20h
Тип раздаваемого материала: Видеоурок
Язык: Английский
Описание:
SQL (“sequel” or Structured Query Language) is a common language used to query and manage data in relational database and data stream management systems. This skill will teach you how to use SQL to query data from the PostgreSQL relational database.
What You Will Learn:
Querying data with the SELECT statement
Filtering data with the WHERE clause
Combining data with JOINs
Aggregating data
Inserting, updating, and deleting data
Prerequisites:
Relational database literacy
Related Topics:
[Pluralsight] MySQL | Path [2020, ENG]
[Pluralsight] Querying Data with SQL in MariaDB | Path [2022, ENG]
[Pluralsight] Querying and Modifying Data in MongoDB | Path [2020, ENG]
Содержание
Beginner
Learn to use the SELECT statement, along with JOINs and WHERE clasues, to create organized projections of data stored in PostgreSQL.
Querying Data from PostgreSQL (Jason Browning, 2019)
Combining and Filtering Data with PostgreSQL (Jason Browning, 2019)
Intermediate
Insert, update, and delete data from PostgreSQL.
PostgreSQL Data Manipulation Playbook (Ami Levin, 2019)
Advanced
Create PostgreSQL database objects, such as functions to capture reusable query logic.
Capturing Logic with Custom Functions in PostgreSQL (Gerald Britton, 2020)
PostgreSQL Functions Playbook (Gerald Britton, 2019)
Bonus
PostgreSQL is a powerful relational engine - but did you know you can make it just as flexible and exciting as MongoDB, CouchDB, or RethinkDB?
The PostgreSQL Document Database (Rob Conery, 2015)
Programming PostgreSQL (Rob Conery, 2015)
PostgreSQL Playbook for Developer DBAs (Rob Conery, 2016)
Файлы примеров: присутствуют
Субтитры: присутствуют
Формат видео: MP4
Видео: H.264/AVC, 1280x720, 16:9, 30fps, 295 kb/s
Аудио: AAC, 48.0 kHz, 96.0 kbit/s, 2 channels
Скриншоты
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
