|Categories||Free Downloadable S Q L eBooks!|
In Postgres Succinctly, author Peter Shaw guides you from installing Postgres, to creating your first database, to using Postgres in a .NET application with ADO .NET and Entity Framework.
Learn SQL The Hard Way - An Introduction To SQL
This book will teach you the 80% of SQL you probably need to use it effectively, and will mix in concepts in data modeling at the same time. If you've been fumbling around building web, desktop, or mobile applications because you don't know SQL, then this book is for you. It is written for people with no prior database, programming, or SQL knowledge, but knowing at least one programming language will help.
Complete Showplan Operators
Writing good TSQL code is not an easy task. Then you submit the code to the query optimizer and strange things happen. The one good view you have into what the optimizer decided to do is provided by the execution plans. Understanding execution plans is a lot of work. Trust me on that. What you need to really understand your queries is as much knowledge as you can get. That's where this excellent collection of articles on some of the more common execution plan operators comes in.
Oracle PL/SQL Programming, 5th Edition
This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this fifth edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 11g Release 2, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website.
PostgreSQL 9.0 Reference Manual - Volume 3: Server Administration Guide
This manual is part of the official reference documentation for PostgreSQL 9.0. This volume is the system administration guide, and covers the installation, configuration and maintenance of PostgreSQL database servers.
PostgreSQL 9.0 Reference Manual - Volume 1A: The SQL Language
This manual is part of the official reference documentation for PostgreSQL 9.0. It describes the SQL language specification as implemented by PostgreSQL, including syntax, data types, functions and operators, indexes and transactions.
PostgreSQL 9.0 Reference Manual - Volume 2: Programming Guide
This manual is part of the official reference documentation for PostgreSQL 9.0. It documents the client and server interfaces to PostgreSQL: the C/C++ interface libpq, the embedded SQL/C compiler ECPG and the server-side languages PL/pgSQL, PL/Tcl, PL/Perl and PL/Python. Each chapter includes reference documentation and examples. In particular, the use of triggers, rules and views is described in detail. The PL/pgSQL chapter also includes a guide to porting Oracle PL/SQL functions to PostgreSQL.
The Best of SQLServerCentral.com, Vol.7
SQLServerCentral.com brings you a variety of articles on all aspects of SQL Server from administration to XML and everything in between. Our articles are written by real DBAs and developers, based on the articles and scripts they use in their daily work. And this book is a collection of the best articles we've seen from the past year from over 50 authors.
The articles are written by real DBAs and developers, based on the articles and scripts they use in their daily work. This book is a collection of the best articles from the past year from over 50 authors.