Today, software engineers need to know not only how to program effectively but also how to …. Skip to main content. Start your free trial. Obe , Leo S. Buy on Amazon. Learn basic administration tasks such as role management, database creation, backup, and restore Apply the psql command-line utility and the pgAdmin graphical administration tool Explore PostgreSQL tables, constraints, and indexes Learn powerful SQL constructs not generally found in other databases Use several different languages to write database functions Tune your queries to run as fast as your hardware will allow Query external and variegated data sources with foreign data wrappers Learn how to use built-in replication to replicate data.
There's also live online events, interactive content, certification prep materials, and more. What we hope to accomplish in this book is to give you a firm grounding in the concepts and features that make PostgreSQL so impressive. Along the way, we should convince you that PostgreSQL does indeed stand up to its claim to fame. Because the database is advanced, no book short of the pages of documentation can bring out all its glory. So in our shorter pager, we hope to get you, as the subtitle proclaims, Up and Running.
Each topic is presented with some context so you understand when to use it and what it offers. We assume you have prior experience with some other database so that we can jump right to the key points of PostgreSQL. We generously litter the pages of this book with links to references so you can dig deeper into topics of interest. These links lead to sections in the manual, to helpful articles, to blog posts of PostgreSQL vanguards.
We also link to our own site at Postgres OnLine Journal , where we have collected many pieces that we have written on PostgreSQL and its interoperability with other applications. This book focuses on PostgreSQL versions 9. Perhaps more importantly, we highlight feats you can achieve with PostgreSQL that are difficult or impossible to do in other databases. SQL is much like chess—a few hours to learn, a lifetime to master. You have wisely chosen PostgreSQL. Thinking of migrating to PostgreSQL?
This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9. No prior knowledge of database programming or administration is required to get started.
This site comply with DMCA digital copyright. We do not store files not owned by us, or without the permission of the owner. We also do not have links that lead to sites DMCA copyright infringement.
0コメント