Cargando…
PostgreSQL developer's guide : design, develop, and implement streamlined databases with postgreSQL /
Annotation
| Clasificación: | Libro Electrónico |
|---|---|
| Autores principales: | , , |
| Otros Autores: | , , , |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, England ; Mumbai [India] :
Packt Publishing,
2015.
|
| Colección: | Community experience distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | EBSCO_ocn905919345 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cn||||||||| | ||
| 008 | 150316t20152015enka o 001 0 eng d | ||
| 040 | |a E7B |b eng |e rda |e pn |c E7B |d N$T |d YDXCP |d OCLCF |d REB |d OCLCQ |d CNNOR |d VT2 |d D6H |d OCLCQ |d STF |d OCLCQ |d OCLCO |d G3B |d RDF |d OCLCO |d OCLCQ |d QGK |d OCLCO | ||
| 019 | |a 905735809 |a 961642497 |a 1259151727 | ||
| 020 | |a 9781783989034 |q (electronic bk.) | ||
| 020 | |a 1783989033 |q (electronic bk.) | ||
| 020 | |z 9781783989027 | ||
| 029 | 1 | |a AU@ |b 000054939313 | |
| 029 | 1 | |a CHNEW |b 000707468 | |
| 029 | 1 | |a DEBBG |b BV042622426 | |
| 035 | |a (OCoLC)905919345 |z (OCoLC)905735809 |z (OCoLC)961642497 |z (OCoLC)1259151727 | ||
| 050 | 4 | |a QA76.73.S67 |b .A364 2015eb | |
| 072 | 7 | |a COM |x 051170 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.756 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Ahmed, Ibrar, |e author. | |
| 245 | 1 | 0 | |a PostgreSQL developer's guide : |b design, develop, and implement streamlined databases with postgreSQL / |c Ibrar Ahmed, Asif Fayyaz, Amjad Shahzad ; commissioning editor Julian Ursell ; copy editors Shivangi Chaturvedi, Deepa Nambiar, Adithi Shetty. |
| 264 | 1 | |a Birmingham, England ; |a Mumbai [India] : |b Packt Publishing, |c 2015. | |
| 264 | 4 | |c ©2015 | |
| 300 | |a 1 online resource (270 pages) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a text file | ||
| 490 | 1 | |a Community Experience Distilled | |
| 500 | |a Includes index. | ||
| 588 | 0 | |a Online resource; title from PDF title page (ebrary, viewed March 14, 2015). | |
| 520 | 8 | |a Annotation |b If you are a database developer who wants to learn how to design and implement databases for application development using PostgreSQL, this is the book for you. Existing knowledge of basic database concepts and some programming experience is required. | |
| 505 | 0 | |a Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Getting Started with PostgreSQL; Writing queries using psql; Creating, altering, and truncating a table; Creating tables; Altering tables; Truncating tables; Inserting, updating, and deleting data from tables; Inserting data; Updating data; Deleting data; PostgreSQL's supported data types; PostgreSQL's operators and usage; Logical operators; Comparison operators; Mathematical operators; Constraints in PostgreSQL; Unique constraints; Not-null constraints | |
| 505 | 8 | |a Exclusion constraintsPrimary key constraints; Foreign key constraints; Check constraints; Privileges in PostgreSQL; Summary; Chapter 2: The Procedural Language; Why should you use PL/pgSQL?; Installing PL/pgSQL; Understanding the structure of PL/pgSQL; Using comments in PL/pgSQL; Declaring variables in PL/pgSQL; Declaring function parameters; Declaring the %TYPE attribute; Declaring the row-type and record type variables; Statements and expressions; Using statements; The assignment statement; Function call/return from a function; The RETURN expression; Exception handling statements | |
| 505 | 8 | |a Compound statementsExpressions; Control structures; Conditional statements; IF-THEN; IF-THEN-ELSE; IF-THEN-ELSIF; Simple CASE; Searched CASE; Loops; The simple loop; The WHILE loop; The FOR loop; Exception handling; Native support for other procedural languages; PL/Python; Installing PL/Python; Writing functions in PL/Python; Handling arguments with PL/Python; Accessing the database with PL/Python; PL/Perl; Installing PL/Perl; Writing functions in PL/Perl; Handling arguments with PL/Perl; Accessing the database with PL/Perl; PL/Tcl; Installing PL/Tcl; Writing functions in PL/Tcl | |
| 505 | 8 | |a Handling arguments with PL/TclAccessing the database with PL/Tcl; Summary; Chapter 3: Working with Indexes; What is an index?; How to create an index; How to drop an index; Types of indexes; The single-column index; The multicolumn index; The partial index; The unique index; Explicitly creating an index using the CREATE INDEX command; The expression index; The implicit index; The concurrent index; Index types; The B-tree index; The hash index; The GiST index; The GIN index; Index bloating; Dump and restore; VACUUM; CLUSTER; Reindexing; Points to ponder; Summary | |
| 505 | 8 | |a Chapter 4: Triggers, Rules, and ViewsUnderstanding triggers; Tricky triggers; Creating triggers and trigger functions with PL/pgSQL; Creating triggers on views; Creating triggers in PL/Perl; Creating triggers in PL/Tcl; Creating triggers in PL/Python; PostgreSQL rules; Rules versus triggers -- creating updateable views with rules; Understanding views; Materialized views; Creating materialized views; Summary; Chapter 5: Window Functions; Understanding window functions; The cume_dist() function; The row_number() function; The rank() function; The dense_rank() function | |
| 546 | |a English. | ||
| 590 | |a eBooks on EBSCOhost |b EBSCO eBook Subscription Academic Collection - Worldwide | ||
| 630 | 0 | 0 | |a PostgreSQL. |
| 630 | 0 | 7 | |a PostgreSQL |2 fast |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 7 | |a COMPUTERS |x Programming Languages |x SQL. |2 bisacsh | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 700 | 1 | |a Fayyaz, Asif, |e author. | |
| 700 | 1 | |a Shahzād, Amjad, |e author. | |
| 700 | 1 | |a Ursell, Julian, |e editor. | |
| 700 | 1 | |a Chaturvedi, Shivangi, |e editor. | |
| 700 | 1 | |a Nambiar, Deepa, |e editor. | |
| 700 | 1 | |a Shetty, Adithi, |e editor. | |
| 776 | 0 | 8 | |i Print version: |a Ahmed, Ibrar. |t PostgreSQL developer's guide : design, develop, and implement streamlined databases with postgreSQL. |d Birmingham, England ; Mumbai, [India] : Packt Publishing, ©2015 |h vii, 248 pages |k Community experience distilled. |z 9781783989027 |
| 830 | 0 | |a Community experience distilled. | |
| 856 | 4 | 0 | |u https://ebsco.uam.elogim.com/login.aspx?direct=true&scope=site&db=nlebk&AN=960445 |z Texto completo |
| 938 | |a ebrary |b EBRY |n ebr11026017 | ||
| 938 | |a EBSCOhost |b EBSC |n 960445 | ||
| 938 | |a YBP Library Services |b YANK |n 12323701 | ||
| 994 | |a 92 |b IZTAP | ||