Сильва, Рик. Основы Postgres: разработка баз данных с использованием PostgreSQL

Essential Postgres: Database Development using PostgreSQL

Opis:

If you want to learn the basics of Postgres development, Essential Postgres is for you. This book gets right to the point, and gives you exposure to the most used – and useful – parts of database development using Postgres version 15. Writing SQL statements, creating tables, functions, triggers, views, as well as data integrity are explained. Tips and insights that the author has picked up over his years of working with Postgres are included.

PostgreSQL, also known as Postgres, is a popular free and open source relational database management system. Postgres is a great technology to learn. It is a powerful, secure, and fast relational database system that is growing in popularity. It is a mature, stable database that has been around for over 30 years. Postgres runs on a wide variety of operating systems, including Linux, Windows, macOS, and it even runs in the cloud. Postgres helps you to maintain the integrity of your data. It has a robust set of features, and is even extensible if you ever need to do something unconventional that it doesn’t already do.

■ Learn to write SQL queries ■ Learn to create, drop, and change database tables ■ Explore Postgres data types for text, integers, dates, and booleans ■ Join database tables using inner joins, outer joins, cross joins, and self-joins ■ Explore ways to compare values in your SQL queries ■ Find out how to order your query results and to group like data ■ Call Postgres built-in functions and write your own ■ Create views, materialized views, sequences, procedures, and triggers

The book includes a set of online scripts that contain the SQL commands shown in the book. The paperback version has been updated with an index for easy reference.

Okładka: Paperback

Liczba stron:210

Autor:Silva, Rick

Język: English: Published; English: Original Language; English

Data wydania: 2020-10-03

Waga: 0.67 gram

Wysokość: 0.7 cm

Szerokość: 6.1 cm

Długość: 8.7 cm

UWAGA: Kupując produkt na tej aukcji zgadzasz się na wydłużony termin realizacji wysyłki (10-14 dni roboczych). Podany towar pochodzi z zagranicznego magazynu, stąd wydłużony czas realizacji który podany jest obok.