SQL in a Nutshell (In a Nutshell

For programmers, analysts, and database administrators, SQL in a Nutshellis the essential reference for the SQL language used in today's most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You'll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts — all packed into a succinct, comprehensive, and easy-to-use format. This book provides:

Read more

Background on the Relational Database Model, including current and previous SQL standards Fundamental concepts necessary for understanding relational databases and SQL commands An alphabetical command reference to SQL statements, according to the SQL2003 ANSI standard The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server An alphabetical reference of the ANSI SQL2003 functions, as well as the vendor implementations Platform-specific functions unique to each implementation Beginning where vendor documentation ends, SQL in a Nutshelldistills the experiences of professional database administrators and developers who have used SQL variants to support complex enterprise applications. Whether SQL is new to you, or you've been using SQL since its earliest days, you'll get lots of new tips and techniques in this book.

Audience
adult
Length
long · 591 pages

Click a tag to see books like this one that share it. Point at it (on a phone, tap it) for less of it instead.

Read it? Sign in to help tag it.

Liked SQL in a Nutshell (In a Nutshell? Here’s where I’d start.

These suit anyone who liked SQL in a Nutshell (In a Nutshell. Sign in and mark a few books for picks shaped around your own taste.

  1. Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design Shares computers, programming, it
  2. SQL Cookbook Shares programming, database, sql
  3. SQL and Relational Theory: How to Write Accurate SQL Code Shares database, sql, it
  4. Learning SQL Shares programming, sql, databases

“People who read SQL in a Nutshell (In a Nutshell tend to reach for these next.”

  1. Perl in a Nutshell
  2. Java in a Nutshell
  3. Mastering the Requirements Process
  4. Linux in a Nutshell

“If you want more of the same (science about technology), start with these.”

  1. Minds, Machines and Multiverse: The Quest for the Quantum Computer
  2. CCNA: Cisco Certified Network Associate Study Guide [Exam 640-801]
  3. Responsive Web Design with HTML5 and CSS3
  4. A Guide to LATEX: Document Preparation for Beginners and Advanced Users

“If it was the programming that hooked you, try one of these.”

  1. SQL Antipatterns
  2. Sams Teach Yourself SQL™ in 10 Minutes
  3. High Performance MySQL: Optimization, Backups, Replication, Load Balancing & More
  4. PostgreSQL: Up and Running

“These start from a similar idea, even if they go somewhere else with it.”

  1. Database in Depth: Relational Theory for Practitioners
  2. The Language of SQL
  3. SQL Visual QuickStart Guide
  4. PHP and MySQL For Dummies