舉報 
會員
Learning PostgreSQL
最新章節：
Index
Create,developandmanagerelationaldatabasesinrealworldapplicationsusingPostgreSQLAboutThisBook?LearnaboutthePostgreSQLdevelopmentlifecycleincludingitstestingandrefactoring?BuildproductivedatabasesolutionsandusetheminJavaapplications?AcomprehensiveguidetolearnaboutSQL,PostgreSQLprocedurallanguageandPL/pgSQLWhoThisBookIsForIfyouareastudent,databasedeveloperoranadministrator,interestedindevelopingandmaintainingaPostgreSQLdatabase,thenthisbookisforyou.Noknowledgeofdatabaseprogrammingoradministrationisnecessary.WhatYouWillLearn?Learnconceptsofdatamodellingandrelationalgebra?InstallandsetupPostgreSQLdatabaseserverandclientsoftware?ImplementdatastructuresinPostgreSQL?ManipulatedatainthedatabaseusingSQL?Implementdataprocessinglogicinthedatabasewithstoredfunctions,triggersandviews?Testdatabasesolutionsandassesstheperformance?IntegratedatabasewithJavaapplications?DetailedknowledgeofthemainPostgreSQLbuildingobjects,mostusedextensions?Practicedatabasedevelopmentlifecycleincludinganalysis,modelling,(documentation),testing,bugfixesandrefactoringInDetailPostgreSQLisoneofthemostpowerfulandeasytousedatabasemanagementsystems.Ithasstrongsupportfromthecommunityandisbeingactivelydevelopedwithanewreleaseeveryyear.PostgreSQLsupportsthemostadvancedfeaturesincludedinSQLstandards.AlsoitprovidesNoSQLcapabilities,andveryrichdatatypesandextensions.AllthatmakesPostgreSQLaveryattractivesolutioninvariouskindsofsoftwaresystems.ThebookstartswiththeintroductionofrelationaldatabaseswithPostegreSQL.Itthenmovesontocoveringdatadefinitionlanguage(DDL)withemphasisonPostgreSQLandcommonDDLcommandssupportedbyANSISQL.Youwillthenlearnthedatamanipulationlanguage(DML),andadvancedtopicslikelockingandmultiversionconcurrencycontrol(MVCC).Thiswillgiveyouaveryrobustbackgroundtotuneandtroubleshootyourapplication.Thebookthencoverstheimplementationofdatamodelsinthedatabasesuchascreatingtables,settingupintegrityconstraints,buildingindexes,definingviewsandotherschemaobjects.Next,itwillgiveyouanoverviewabouttheNoSQLcapabilitiesofPostgreSQLalongwithHstore,XML,Jsonandarrays.Finallybytheendofthebook,you'lllearntousetheJDBCdriverandmanipulatedataobjectsintheHibernateframework.StyleandapproachAneasy-to-followguidetolearnprogrammingbuildapplicationswithPostgreSQL,andmanageaPostgreSQLdatabaseinstance.
目錄(104章)
倒序
- coverpage
- Learning PostgreSQL
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Support files eBooks discount offers and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Chapter 1. Relational Databases
- Database management systems
- Relational algebra
- Data modeling
- Summary
- Chapter 2. PostgreSQL in Action
- An overview of PostgreSQL
- PostgreSQL capabilities
- Installing PostgreSQL
- Summary
- Chapter 3. PostgreSQL Basic Building Blocks
- Database coding
- PostgreSQL objects hierarchy
- PostgreSQL high-level object interaction
- PostgreSQL database components
- Summary
- Chapter 4. PostgreSQL Advanced Building Blocks
- Views
- Indexes
- Functions
- PostgreSQL user-defined data types
- Triggers and rule systems
- Summary
- Chapter 5. SQL Language
- SQL fundamentals
- Querying the data with the SELECT statement
- Changing the data in the database
- Summary
- Chapter 6. Advanced Query Writing
- Common table expressions
- Window functions
- Advanced SQL
- Transaction isolation and multiversion concurrency control
- Summary
- Chapter 7. Server-Side Programming with PL/pgSQL
- Introduction
- PostgreSQL function parameters
- The PostgreSQL PL/pgSQL control statements
- Exception handling
- Dynamic SQL
- Summary
- Chapter 8. PostgreSQL Security
- Authentication in PostgreSQL
- PostgreSQL default access privileges
- PostgreSQL security levels
- Encrypting data
- Summary
- Chapter 9. The PostgreSQL System Catalog and System Administration Functions
- The system catalog
- Getting the database cluster and client tools version
- Terminating and canceling user sessions
- Setting and getting database cluster settings
- Getting the database and database object size
- Cleaning up the database
- Cleaning up data in the database
- Managing database locks
- Adding missing indexes on foreign keys and altering the default statistic
- Getting the views dependency tree
- Summary
- Chapter 10. Optimizing Database Performance
- PostgreSQL configuration tuning
- Tuning PostgreSQL queries
- Cross column correlation
- Table partitioning
- Summary
- Chapter 11. Beyond Conventional Data types
- PostgreSQL arrays
- Hash store
- The PostgreSQL JSON data type
- A PostgreSQL full text search
- Summary
- Chapter 12. Testing
- Unit testing
- Schema difference
- The interfaces test
- PostgreSQL benchmarks
- Summary
- Chapter 13. PostgreSQL JDBC
- Introduction to JDBC
- Connecting to a PostgreSQL database
- Issuing a query and processing the results
- Function handling
- Design considerations
- Summary
- Chapter 14. PostgreSQL and Hibernate
- Introduction to ORM and Hibernate
- Installation and configuration
- Working with entities
- Summary
- Index 更新時間：2021-04-02 20:32:33
推薦閱讀
- 極簡算法史：從數學到機器的故事
- Mastering Visual Studio 2017
- C++程序設計（第3版）
- Building Modern Web Applications Using Angular
- Functional Programming in JavaScript
- BeagleBone Black Cookbook
- RabbitMQ Essentials
- Unity 2017 Mobile Game Development
- Apache Solr PHP Integration
- Mastering JavaScript
- SAP Web Dynpro for ABAP開發技術詳解：基礎應用
- Python程序設計現代方法
- 深度剖析ApacheDubbo核心技術內幕
- ReactJS Blueprints
- App Inventor開發實戰
- Visual C++.NET 2010開發實踐：基于C++/CLI
- 零基礎Python學習筆記
- C/C++程序設計（第3版）
- VMware vRealize Operations Essentials
- Numerical Computing with Python
- Windows PowerShell for .NET Developers（Second Edition）
- Android Studio 2 Essentials（Second Edition）
- Getting Started with Julia
- Hands-On Design Patterns with React Native
- Kali Linux：An Ethical Hacker's Cookbook
- 小創客趣玩micro：bit開發板編程
- C++ 黑客編程揭秘與防范（第3版）
- UiPath RPA開發：入門、實戰與進階
- Building Minecraft Server Modifications（Second Edition）
- MariaDB Essentials
