T�tulo: Learning PostgreSQL 10: A beginner's guide to building high-performance PostgreSQL database solutions, 2nd Edition
Editor: Packt Publishing
Fecha de publicaci�n: 2017
Idioma: Ingl�s
ISBN 10: 1788392019
ISBN 13: 9781788392013
Encuadernaci�n: Encuadernaci�n de tapa blanda
Edici�n: 2� Edici�n
Estado: New

Acerca de

Sinopsis

Leverage the power of PostgreSQL 10 to build powerful database and data warehousing applications.

Key Features:

Be introduced to the concept of relational databases and PostgreSQL, one of the fastest growing open source databases in the world
Learn client-side and server-side programming in PostgreSQL, and how to administer PostgreSQL databases
Discover tips on implementing efficient database solutions with PostgreSQL 10

Book Description:

PostgreSQL is one of the most popular open source databases in the world, supporting the most advanced features included in SQL standards. This book will familiarize you with the latest features released in PostgreSQL 10.

We'll start with a thorough introduction to PostgreSQL and the new features introduced in PostgreSQL 10. We'll cover the Data Definition Language (DDL) with an emphasis on PostgreSQL, and the common DDL commands supported by ANSI SQL. You'll learn to create tables, define integrity constraints, build indexes, and set up views and other schema objects. Moving on, we'll cover the concepts of Data Manipulation Language (DML) and PostgreSQL server-side programming capabilities using PL/pgSQL. We'll also explore the NoSQL capabilities of PostgreSQL and connect to your PostgreSQL database to manipulate data objects.

By the end of this book, you'll have a thorough understanding of the basics of PostgreSQL 10 and will have the necessary skills to build efficient database solutions.

What You Will Learn:

Understand the fundamentals of relational databases, relational algebra, and data modeling
Install a PostgreSQL cluster, create a database, and implement your data model
Create tables and views, define indexes, and implement triggers, stored procedures, and other schema objects
Use the Structured Query Language (SQL) to manipulate data in the database
Implement business logic on the server side with triggers and stored procedures using PL/pgSQL
Make use of advanced data types supported by PostgreSQL 10: arrays, hstore, JSONB, and others
Develop OLAP database solutions using the most recent features of PostgreSQL 10
Connect your Python applications to a PostgreSQL database and work with data efficiently
Test your database code, find bottlenecks, improve performance, and enhance the reliability of database applications

Who this book is for:

If you're interested in learning more about PostgreSQL, one of the most popular relational databases in the world, then this book is for you. Those looking to build solid database or data warehousing applications with PostgreSQL 10 will also find this book a useful resource. No prior knowledge of database programming or administration is required to get started with this book.

Acerca del autor

Salahaldin Juba has over than a decade of experience in the industry and academia, with a focus on database development for large-scale and enterprise applications. He holds a master's degree of science in environmental management with a distinction, and a bachelor's degree of engineering in computer systems. He is also a Microsoft Certified Solution Developer (MCSD).He has worked mainly with SQL server, PostgreSQL, and Greenplum databases. As a software engineer, he works mainly with defining ETL processes with external parties, promoting SQL best practices, designing OLTP and OLAP applications, and providing training and consultation services.

"Sobre este t�tulo" puede pertenecer a otra edici�n de este libro.

Descripci�n de la librer�a

Hello! Ria Christie Collections is an online venture that was initially set up in 2012 to sell books. We do not have a physical high street store. We are professional online booksellers. We only sell brand new books in perfect condition that we source from various suppliers and the publishers. Primarily, our aim is to provide an excellent service to all our customers. We always work as a team to achieve this. Our other objectives are to: 1. Ensure that all our products reach their destination quickly in a safe and secure manner 2. Answer to all our customer queries within 24 hours 3. Ensure that our customers are happy with their purchases 4. Provide all the items at a competitive price 5. Always listen to our customers Ria Christie Collections is not a registered company. It is a Sole Trader venture. Other key information is shown below: Contact Person Name: Rakesh Luchmun (Mr) Storefront Name: Ria Christie Collections Place of Establishment Address: Suite B; ARUN House; ARUN Building Arundel Road Uxbridge UB8 2RR United Kingdom E-Mail Address: riachristie@hotmail.co.uk VAT Number: GB 160 5650 25 We always work hard and aim to comply with all of Abebooks Policies. If you have any issues, please do not hesitate to write to us whether before or after a purchase. We promise to reply to you promptly and, in any case, within 24 hours. Thank you kindly! Yours sincerely Mr Rakesh Luchmun (Founder) and the Ria Christie Collections Team

Ver la p�gina web de la librer�a

Informaci�n empresarial del vendedor

Ryefield Investments Limited
175 Pield Heath Road, Uxbridge, UB8 3NL, United Kingdom

Condiciones de venta y env�o

Condiciones de venta

All Returns and Refund are as per Abebooks policies.

Condiciones de env�o

Orders usually ship within 2 business days. If your book order is heavy or oversized, we may contact you to let you know extra shipping is required. Thank you!