SQL Pocket Guide

  • Auteur: Jonathan Gennick
  • ISBN: 1449396666
  • Date de sortie: 2010-11-10
  • Collection: "O'Reilly Media, Inc."
  • Total Download: 7751
  • Total Read: 8270

Télécharger Lire


If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2. SQL Pocket Guide describes how these database systems implement SQL syntax for querying, managing transactions, and making changes to data. It also shows how the systems use SQL functions, regular expression syntax, and type conversion functions and formats. All example SQL statements in this book execute against a set of tables, with data that you can quickly download. The third edition covers important database changes, including: Oracle's support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operators Functions new to Oracle, such as LISTAGG, NTH_VALUE, and more PostgreSQL’s support of recursive WITH and some window functions DB2 syntax and datatypes, some compatible with Oracle MySQL features such as the TIMESTAMP type and the TO_SECONDS function

SQL Cookbook

  • Auteur: Anthony Molinaro
  • ISBN: 0596009763
  • Date de sortie: 2005-12-16
  • Collection: "O'Reilly Media, Inc."
  • Total Download: 5270
  • Total Read: 1769

Télécharger Lire


A guide to SQL covers such topics as retrieving records, metadata queries, working with strings, data arithmetic, date manipulation, reporting and warehousing, and hierarchical queries.

SQL in a Nutshell

  • Auteur: Kevin Kline
  • ISBN: 0596554257
  • Date de sortie: 2008-11-21
  • Collection: "O'Reilly Media, Inc."
  • Total Download: 5019
  • Total Read: 1063

Télécharger Lire


For programmers, analysts, and database administrators, SQL in a Nutshell is 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: 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 Nutshell distills 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.

Beginning SQL

  • Auteur: Paul Wilton
  • ISBN: 0764577328
  • Date de sortie: 2005-03-04
  • Collection: John Wiley & Sons
  • Total Download: 2030
  • Total Read: 4818

Télécharger Lire


Describes the basics of SQL, database design, and how to create a database using the SQL language.

T SQL Querying

  • Auteur: Itzik Ben-Gan
  • ISBN: 0133986624
  • Date de sortie: 2015-02-17
  • Collection: Microsoft Press
  • Total Download: 9030
  • Total Read: 9748

Télécharger Lire


T-SQL insiders help you tackle your toughest queries and query-tuning problems Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Emphasizing a correct understanding of the language and its foundations, the authors present unique solutions they have spent years developing and refining. All code and techniques are fully updated to reflect new T-SQL enhancements in Microsoft SQL Server 2014 and SQL Server 2012. Write faster, more efficient T-SQL code: Move from procedural programming to the language of sets and logic Master an efficient top-down tuning methodology Assess algorithmic complexity to predict performance Compare data aggregation techniques, including new grouping sets Efficiently perform data-analysis calculations Make the most of T-SQL’s optimized bulk import tools Avoid date/time pitfalls that lead to buggy, poorly performing code Create optimized BI statistical queries without additional software Use programmable objects to accelerate queries Unlock major performance improvements with In-Memory OLTP Master useful and elegant approaches to manipulating graphs About This Book For experienced T-SQL practitioners Includes coverage updated from Inside Microsoft SQL Server 2008 T-SQL Querying and Inside Microsoft SQL Server 2008 T-SQL Programming Valuable to developers, DBAs, BI professionals, and data scientists Covers many MCSE 70-464 and MCSA/MCSE 70-461 exam topics

SQL

  • Auteur: Robert Sheldon
  • ISBN: 9780072228854
  • Date de sortie: 2003
  • Collection: McGraw Hill Professional
  • Total Download: 6090
  • Total Read: 3728

Télécharger Lire


Explains how to program with SQL, covering topics including database objects, queries, modifications, embedded statements, and troubleshooting.

Clarion Databases SQL

  • Auteur: David Gerhard Harms
  • ISBN: 9780968955338
  • Date de sortie: 2004
  • Collection: CoveComm Inc.
  • Total Download: 6339
  • Total Read: 9734

Télécharger Lire


DMCA - Contact