Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
SQL Pocket Guide (Pocket Guides)

Buy
SQL Pocket Guide (Pocket Guides), 9781449394097 (1449394094), O'Reilly, 2010

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
(HTML tags aren't allowed.)

Applying Use Case Driven Object Modeling with UML: An Annotated e-Commerce Example
Applying Use Case Driven Object Modeling with UML: An Annotated e-Commerce Example

Applying Use Case Driven Object Modeling with UML: An Annotated e-Commerce Example is a practical, hands-on guide to putting use case methods to work in real-world situations. This workbook is a companion to Use Case Driven Object Modeling with UML. It bridges the gap between the theory presented in the main book...

Systems Analysis and Design for Advanced Modeling Methods: Best Practices (Advances in Database Research)
Systems Analysis and Design for Advanced Modeling Methods: Best Practices (Advances in Database Research)
Systems analysis and design (SAND) is an evolving field that still represents the point where business and technology intersects. As discussed in (Bajaj, Batra, Hevner, Parsons, & Siau, 2005), SAND represents the core of management information systems (MIS) curricula but is underrepresented in the area of MIS research. The...
Multiple Sclerosis
Multiple Sclerosis

Education about multiple sclerosis has traditionally been medically oriented and related to disease and dysfunction. In contrast, this brand-new second edition of the Guide continues to focus on staying well in the presence of MS, a disease that - while incurable - can be managed. The book covers a broad spectrum of topics related to MS and...


Real Leaders Don't Boss: Inspire, Motivate, and Earn Respect from Employees and Watch Your Organization Soar
Real Leaders Don't Boss: Inspire, Motivate, and Earn Respect from Employees and Watch Your Organization Soar

"...throw away the heavy textbooks and get set for some real-world wisdom from someone who has been there and done it..."
--Mike McCurry, White House Press Secretary for President Clinton, Principal, Public Strategies Washington, Inc.

"Ritch has deep leadership knowledge and experience, and this book
...

Strategies for Managing Is/It Personnel
Strategies for Managing Is/It Personnel

As IT staff shortages are being experienced worldwide, with a huge gap between the number of positions available for IS/IT workers and the number of available qualified workers to fill them. The major factors that have contributed to the IS/IT crisis include lack of understanding of the career orientations of IS personnel; high IS staff...

Java Database Programming Bible
Java Database Programming Bible
Java Database Bible is a comprehensive approach to learning how to develop and implement a professional level Java 2 database program using the Java database connection API (JDBC 3.0).

Includes an introduction to relational databases and designing database applications; covers interacting with a relational database using a Java
...
©2019 LearnIT (support@pdfchm.net) - Privacy Policy