Custom cover image
Custom cover image

Learning PostgreSQL

By: Resource type: Ressourcentyp: Buch (Online)Book (Online)Language: English Series: Community experience distilledPublisher: Birmingham : Packt Publishing, 2015Description: Online-Ressource (464)ISBN:
  • 9781783989195
Subject(s): Additional physical formats: 178398919X. | 1783989181 | 9781783989195. | Erscheint auch als: Learning PostgreSQL Druck-Ausgabe | Erscheint auch als: Learning PostgreSQL. Birmingham : Packt Publishing, Open Source, community experience distilled, 2015. xvii, 433 SeitenDDC classification:
  • 005.7585
  • 005.75/65
LOC classification:
  • T55.4-60.8
  • QA76.9.D3
Online resources: Summary: Cover -- Copyright -- Credits -- About the Authors -- About the Reviewers -- www.PacktPub.com -- Table of Contents -- Preface -- Chapter 1: Relational Databases -- Database management systems -- A brief history -- Database categories -- The NoSQL databases -- The CAP theorem -- NoSQL motivation -- Key value database -- Columnar databases -- Document databases -- Graph databases -- Relational and object relational databases -- ACID properties -- SQL Language -- Basic concepts -- Relation -- Tuple -- Attribute -- Constraint -- Relational algebra -- SELECT and PROJECT operations -- The RENAME operation -- The Set theory operations -- The CROSS JOIN (Cartesian product) operation -- Data modeling -- Data model perspectives -- The entity-relation model -- Sample application -- Entities, attributes, and keys -- Mapping ER to Relations -- UML class diagrams -- Summary -- Chapter 2: PostgreSQL in Action -- An overview of PostgreSQL -- PostgreSQL history -- The advantages of PostgreSQL -- Business advantages of PostgreSQL -- PostgreSQL user advantages -- PostgreSQL applications -- Success stories -- Forks -- PostgreSQL architecture -- PostgreSQL abstract architecture -- The PostgreSQL community -- PostgreSQL capabilities -- Replication -- Security -- Extension -- NoSQL capabilities -- Foreign data wrapper -- Performance -- Very rich SQL constructs -- Installing PostgreSQL -- Installing PostgreSQL on Ubuntu -- Client installation -- Server installation -- Basic server configuration -- Installing PostgreSQL on Windows -- The PostgreSQL clients -- The psql client -- PostgreSQL utility tools -- Backup and replication -- Utilities -- PgAdmin III -- Summary -- Chapter 3: PostgreSQL Basic Building Blocks -- Database coding -- Database naming conventions -- PostgreSQL identifiers -- Documentation -- Version control system -- PostgreSQL objects hierarchy.PPN: PPN: 845254731Package identifier: Produktsigel: ZDB-38-EBR | ZDB-30-PAD | ZDB-30-PQE | ZDB-26-MYL
No physical items for this record

Online-Ausg.