Oblasti, naše knjige

Web design

Java, JavaScript, JScript, Perl

C++ Visual C++ C#

Apple - MAC OS X

Visual Basic .NET, VBA, V. Studio

Android

PHP I MYSQL

FULL STACK DEVELOPMENT

Python programiranje

WordPress

AutoCad, ArchiCAD, SolidWorks, Catia, Pro/Engineer

Mašinsko učenje

Access

Animacija

Audio, Multimedia, Video

Baze podataka

Cloud

CSS

Delphi

Digitalna fotografija

Django

E-komerc

ECDL

GOOGLE

Grafika, Dizajn, Štampa

Hardver

Internet

Joomla

jQuery

Mreže

MS Office

Obrada teksta

OFFICE 2013

Programiranje

Raspberry PI

Rečnici

Robotika

Ruby i Ruby on Rails

Sertifikati

SQL Server

Statistika

Tabele

Telekomunikacije

Unix, Linux

Windows

Windows 7

Windows 8

Zaštita i sigurnost

 

Oblasti, drugi izdavači

Alternativna učenja

Antropologija

Arheologija

Arhitektura

Astrologija

Astronomija

Audio kursevi + knjige

Autobiografija

Automobili

Bajke

Biografija

Biološke nauke

Botanika

Dečije knjige

Dizajn

Domaće pripovetke

Domaći roman

Drama

E-knjiga

Ekologija

Ekonomija

Elektrotehnika

Enciklopedija

Esejistika

Etika

Fantastika

Film

Filologija

Filozofija

Fizika

Fotografija

Geografija

Geologija

Građevinarstvo

Hemija

Hidrotehnika

Hobi

Horor

Humor

Intervju

Istorija

Istorija i teorija književnosti

Istorija umetnosti

Istorijski roman

Knjiga posle posla - Beletristika i ostala izdanja

Knjižare i naše knjige

Književna kritika

Kuvari, hrana i piće

Leksikografija

Lingvistika

Ljubavni roman

logo

Magija

Marketing

Mašinstvo

Matematika

Medicina

Memoari

Menadžment

Modeliranje podataka

Monografija

Muzika

Nagrađivanje knjige

Naučna fantastika

OpenOffice.org

Operativni sistemi

Oracle

Organizacione nauke

Pedagogija

Pisci u medijima

Ples

Poezija

Politika

Poljoprivreda

Popularna medicina

Popularna nauka

Popularna psihologija

Posao

Pozorište

Pravo

Pravoslavlje

Primenjene nauke

Pripovetke

Prirodne nauke

Priručnik

Psihologija

Publicistika

Putopis

Religija

Roman

Satira

Saveti

Slikarstvo

Socijalna mreža - Facebook

Sociologija

Sport

Sport i hobi

Strip

Tableti

Tehnologija

Triler

Turizam

Twitter

Udžbenici

Umetnost

Urbanizam

UX DIZAJN

Zoologija

 

Baze podataka

 

Learning PostgreSQL 11 - Third Edition

 

Learning PostgreSQL 11 - Third Edition

Autor: Andrey Volkov, Salahadin Juba
Broj strana: 556
ISBN broj: 9781789535464
Izdavač: PACKT PUBLISHING
Godina izdanja: 2019.

Pregleda (30 dana / ukupno): 113 / 113

Predlog za prevod

  • Twitter
  • Facebook
  • Google plus
  • Linkedin
  • Pinterest
  • Email

 

 

  • Understand the basics of relational databases, relational algebra, and data modeling
  • Install a PostgreSQL server, create a database, and implement your data model
  • Create tables and views, define indexes and stored procedures, and implement triggers
  • Make use of advanced data types such as Arrays, hstore, and JSONB
  • Connect your Python applications to PostgreSQL and work with data efficiently
  • Identify bottlenecks to enhance reliability and performance of database applications

PostgreSQL is one of the most popular open source database management systems in the world, and it supports advanced features included in SQL standards. This book will familiarize you with the latest features in PostgreSQL 11, and get you up and running with building efficient PostgreSQL database solutions from scratch. Learning PostgreSQL, 11 begins by covering the concepts of relational databases and their core principles. You’ll explore the Data Definition Language (DDL) and commonly used DDL commands supported by ANSI SQL. You’ll also learn how to create tables, define integrity constraints, build indexes, and set up views and other schema objects. As you advance, you’ll come to understand Data Manipulation Language (DML) and server-side programming capabilities using PL/pgSQL, giving you a robust background to develop, tune, test, and troubleshoot your database application. The book will guide you in exploring NoSQL capabilities and connecting to your database to manipulate data objects. You’ll get to grips with using data warehousing in analytical solutions and reports, and scaling the database for high availability and performance. By the end of this book, you’ll have gained a thorough understanding of PostgreSQL 11 and developed the necessary skills to build efficient database solutions.

  • Monitor, secure, and fine-tune your PostgreSQL 11 database
  • Learn client-side and server-side programming using SQL and PL/pgSQL
  • Discover tips on implementing efficient database solutions

Table of contents

1 Relational Databases
Database management systems
Relational and object-relational databases
Relational algebra
Data modeling
Summary
Questions

2 PostgreSQL in Action
An overview of PostgreSQL
PostgreSQL capabilities
Installing PostgreSQL
Summary
Questions 

3 PostgreSQL Basic Building Blocks
Database coding
PostgreSQL object hierarchy
PostgreSQL database components
PostgreSQL native data types
The car web portal database
Summary
Questions

4 PostgreSQL Advanced Building Blocks
Views
Indexes
Functions
User-defined data types
Trigger and rule systems
Summary
Questions

5 SQL Language
SQL fundamentals
Querying data with SELECT statements
Changing the data in a database
Summary
Questions

6 Advanced Query Writing
Common table expressions
Window functions
Advanced SQL techniques
Summary
Questions

7 Server-Side Programming with PL/pgSQL
The SQL language and PL/pgSQL – a comparison
Functions and procedures – a comparison
PostgreSQL function parameters
The PostgreSQL PL/pgSQL control statements
Function predefined variables
Exception handling
Dynamic SQL
Summary
Questions

8 OLAP and Data Warehousing
OLTP and OLAP
Online analytical processing
Partitioning
Parallel query
Index-only scans
Summary
Questions

9 Beyond Conventional Data Types
Arrays
The hash store data structure
The JSON data structure
A PostgreSQL full-text search
Summary
Questions

10 Transactions and Concurrency Control
Transactions
Explicit locking
Transaction in functions and procedures
Summary
Questions

11 PostgreSQL Security
Authentication in PostgreSQL
Authentication best practices
PostgreSQL default access privileges
Role system and proxy authentication
PostgreSQL security levels
Encrypting data
Summary
Questions

12 The PostgreSQL Catalog
The system catalog
System catalog for administrators
Cleaning up the database
Tuning for performance 
Selective dump
Summary 
Questions 

13 Optimizing Database Performance
PostgreSQL configuration tuning
Tuning performance for write
Tuning performance for read 
Detecting problems in query plans
Common mistakes in writing queries
Table partitioning
Query rewriting
Summary
Questions

14 Testing
Technical requirements
Unit testing
Database-abstraction interfaces
Summary
Questions

15 Using PostgreSQL in Python Applications
Technical requirements
Python DB-API 2.0
Low-level database access with Psycopg 2
Alternative drivers for PostgreSQL
Object-relational mapping with SQLAlchemy
Summary
Questions

16 Scalability
Technical requirements
The problem of scalability and the CAP theorem
Data replication in PostgreSQL
Building a scalable PostgreSQL solution
Summary
Questions
Further reading

17 What's Next?
Fundamentals
Working with PostgreSQL software
Working with data in PostgreSQL databases
Summary

 

Budite prvi koji će ostaviti komentar.

Ostavite komentar Ostavite komentar

 

Preporučujemo

 

Oracle and PL/SQL Recipes A Problem-Solution Approach

1. Oracle and PL/SQL Recipes A Problem-Solution Approach

Oracle PL/SQL Recipes provides task-oriented solutions to common PL/SQL programming problems. This is your go to book for straightforward advice on PL/SQL programming.

Predlog za prevod

Više o knjizi Više o knjizi

 

Everyday Data Structures

2. Everyday Data Structures

A practical guide to learning data structures simply and easily

Predlog za prevod

Više o knjizi Više o knjizi

 

Learning PostgreSQL

3. Learning PostgreSQL

If you are a student, database developer or an administrator, interested in developing and maintaining a PostgreSQL database, then this book is for you. No knowledge of database programming or administration is necessary. Readers should, however, know SQL.

Predlog za prevod

Više o knjizi Više o knjizi