PostgreSQL: Up and Running: A Practical Introduction to the Advanced Open Source Database

PostgreSQL: Up and Running: A Practical Introduction to the Advanced Open Source Database


Thinking of migrating to PostgreSQL? This transparent, fast paced advent is helping you recognize and use this open resource database approach. not just will you know about the firm type positive factors in models 9.2, 9.3, and 9.4, you are going to additionally realize that PostgeSQL is greater than a database system--it's additionally a magnificent software platform.
With examples all through, this e-book exhibits you the way to accomplish initiatives which are tough or most unlikely in different databases. This moment version covers LATERAL queries, augmented JSON help, materialized perspectives, and different key themes. in case you are a present PostgreSQL consumer, you will decide up gem stones you have got neglected before.
  • Learn easy management initiatives similar to position administration, database construction, backup, and restore
  • Apply the psql command-line software and the pgAdmin graphical management tool
  • Explore PostgreSQL tables, constraints, and indexes
  • Learn strong SQL constructs no longer as a rule present in different databases
  • Use a number of various languages to write down database functions
  • Tune your queries to run as quick as your will allow
  • Query exterior and variegated information resources with overseas info wrappers
  • Learn the way to use integrated replication gains to copy data

Show sample text content

Download sample