Kevin E. Kline's Books

SQL in a Nutshell

A Desktop Quick Reference

By: Kevin E. Kline,Daniel Kline,Brand Hunt

Write a review Read reviews Take a Quiz Solve Book Puzzle

SQL in a Nutshell

A Desktop Quick Reference

By: Kevin E. Kline,Daniel Kline,Brand Hunt

SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference to the language. While it's a standardized language, actual implementations of SQL are anything but standard. Vendor variation abounds, and that's where this book comes into play. SQL in a Nutshell, Second Edition, is a practical and useful command reference for SQL2003, the latest release of the SQL language. The book presents each of the SQL2003 statements and describes their usage and syntax, not only from the point of view of the standard itself, but also as implemented by each of the five major database platforms : DB2, Oracle, MySQL, PostgreSQL, and SQL Server. Each statement reference includes the command syntax by vendor, a description, and informative examples that illustrate important concepts and uses. And SQL is not just about statements. Also important are datatypes and the vast library of built-in SQL functions that is so necessary in getting real work done. This book documents those datatypes and functions, both as described in the standard and as implemented by the various vendors. This edition also includes detailed information about the newer window function syntax that is supported in DB2 and Oracle. SQL in a Nutsbell, Second Edition, is not only a convenient reference guide for experienced SQL programmers, analysts, and database administrators. It's also a great resource for consultants and others who need to be familiar with the various SQL dialects across many platforms.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

710

Publisher

"O'Reilly Media, Inc."

Published Date

ISBN 10

0596004818

ISBN 13

9780596004811

Oracle's Cooperative Development Environment

A Reference and User's Guide

By: Kevin E. Kline

Write a review Read reviews Take a Quiz Solve Book Puzzle

Oracle's Cooperative Development Environment

A Reference and User's Guide

By: Kevin E. Kline

A comprehensive examination of all the programming tools in Oracle's new Cooperative Development Environment (CDE), this text explores the capabilities of the CDE and details the creation of powerful GUI-based, client server and centralized information systems. Readers will acquire the skills necessary to quickly and easily complete the most complex information management projects.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

388

Publisher

Elsevier

Published Date

ISBN 10

0750695005

ISBN 13

9780750695008

SQL in a Nutshell

By: Kevin Kline,Regina O. Obe,Leo S. Hsu

Write a review Read reviews Take a Quiz Solve Book Puzzle

SQL in a Nutshell

By: Kevin Kline,Regina O. Obe,Leo S. Hsu

For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL language used in today's most popular database products. This new fourth edition clearly documents SQL commands according to the latest ANSI/ISO standard and details how those commands are implemented in Microsoft SQL Server 2019 and Oracle 19c, as well as in the MySQL 8, MariaDB 10.5, and PostgreSQL 14 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. Sections include: 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 SQL:2016 ANSI standard The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server An alphabetical reference of the ANSI SQL:2016 functions and constructs as well as the vendor implementations Platform-specific functions unique to each implementation

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

929

Publisher

"O'Reilly Media, Inc."

Published Date

ISBN 10

1492088811

ISBN 13

9781492088813

Book's by Kevin E. Kline

SQL in a Nutshell

SQL in a Nutshell

Oracle's Cooperative Development Environment

Oracle's Cooperative Development Environment

SQL in a Nutshell

SQL in a Nutshell

Username

Password

Username

Password

Password again

Birthday

Email