Название: PostgreSQL for beginners
Автор: Michael Fallon
Издательство: Amazon.com Services LLC
Год: 2020
Страниц: 419
Язык: английский
Формат: pdf, mobi, epub
Размер: 10.1 MB

Currently, the term "database" is known to many people, even those far from professional development of computer programs. Databases have become very widespread technology, which required, in turn, more the number of specialists able to design and maintain them. In the course of evolution theory and practice of databases, the de facto standard has become the relational model data, and within the framework of this model, a specialized language was formed gramming, which allows you to perform all the necessary operations with data Structured Query Language (SQL). Thus, an important component of qualification The database specialist's knowledge is SQL. This tutorial covers the basics of the SQL language — this is a basic course. Moreover, the language is considered in relation to a specific control system of the data mining Database Management System (DBMS) - PostgreSQL.

The implementation of the SQL language in each DBMS corresponds conforms to the standard to one degree or another, but apart from standardized functions and capabilities, each DBMS also offers its own additional language extensions ka. PostgreSQL provides very good support for the SQL language standard and also provides interesting and practically useful additional features.

One of the main advantages of PostgreSQL is extensibility. This means onexample that a user (of course, a specialist in the field of databasesny) can develop their own data types. These data types will be shared get along with all the properties of built-in data types and can be put to work without stopping the server. In addition, PostgreSQL is free open source product that is available on a large number of boards forms. The tutorial covers not only all the basic commands of the SQL language, but also other issues like indexes and transactions.