Synopsis
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
"synopsis" may belong to another edition of this title.
About the Authors
Kevin Kline is a noted database expert and software industry veteran. A Microsoft SQL Server MVP since 2004, Kevin is a founder and former president of the Professional Association for SQL Server (PASS.org) and the author of many popular IT books. Kevin is also a top-rated speaker at industry trade shows worldwide.
Regina Obe is co-principal of Paragon Corporation (paragoncorporation.com), a database consulting company based in Boston. She has close to 30 years of professional experience in various programming languages and database systems, with special focus on PostgreSQL and PostGIS spatial database extension for PostgreSQL. She is a member of the PostGIS steering committee and development team. She is a coauthor of several database books with her husband, Leo Hsu.
Leo Hsu is co-principal of Paragon Corporation, a database consulting company based in Boston. He has over 25 years of professional experience developing and thinking about databases for organizations large and small. He also holds a lectureship at Tufts University, teaching SQL to graduate level students. He has coauthored several database books with his wife Regina Obe.
"About this title" may belong to another edition of this title.
Search results for SQL in a Nutshell: A Desktop Quick Reference
Stock Image
SQL in a Nutshell: A Desktop Quick Reference
Published by
O'Reilly Media (edition 4), 2022
ISBN 10: 1492088862
ISBN 13: 9781492088868
Used
Paperback
Seller: BooksRun, Philadelphia, PA, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. 4. It's a well-cared-for item that has seen limited use. The item may show minor signs of wear. All the text is legible, with all pages included. It may have slight markings and/or highlighting. Seller Inventory # 1492088862-8-1
Stock Image
SQL in a Nutshell: A Desktop Quick Reference
Published by
O'Reilly Media (edition 4), 2022
ISBN 10: 1492088862
ISBN 13: 9781492088868
Used
Paperback
Seller: BooksRun, Philadelphia, PA, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: As New. 4. It's a preowned item in almost perfect condition. It has no visible cosmetic imperfections. May come without any shrink wrap; pages are clean and not marred by notes or folds of any kind. Seller Inventory # 1492088862-10-1
Stock Image
SQL in a Nutshell: A Desktop Quick Reference
Seller: World of Books (was SecondSale), Montgomery, IL, U.S.A.
Seller rating 5 out of 5 stars
Condition: Good. Good condition ex-library book with usual library markings and stickers. Seller Inventory # 00094841375
Seller Image
SQL in a Nutshell : A Desktop Quick Reference
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # 43155201-n
Stock Image
SQL in a Nutshell A Desktop Quick Reference
Seller: Lakeside Books, Benton Harbor, MI, U.S.A.
Seller rating 5 out of 5 stars
Condition: New. Brand New! Not Overstocks or Low Quality Book Club Editions! Direct From the Publisher! We're not a giant, faceless warehouse organization! We're a small town bookstore that loves books and loves it's customers! Buy from Lakeside Books! Seller Inventory # OTF-S-9781492088868
Seller Image
SQL in a Nutshell: A Desktop Quick Reference (Paperback or Softback)
Published by
O'Reilly Media 7/19/2022, 2022
ISBN 10: 1492088862
ISBN 13: 9781492088868
New
Paperback or Softback
Seller: BargainBookStores, Grand Rapids, MI, U.S.A.
Seller rating 5 out of 5 stars
Paperback or Softback. Condition: New. SQL in a Nutshell: A Desktop Quick Reference. Book. Seller Inventory # BBS-9781492088868
Stock Image
SQL in a Nutshell: A Desktop Quick Reference
Seller: Lucky's Textbooks, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # ABLIING23Mar2716030177823
Seller Image
SQL in a Nutshell : A Desktop Quick Reference
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: As New. Unread book in perfect condition. Seller Inventory # 43155201
Stock Image
SQL in a Nutshell: A Desktop Quick Reference
Seller: California Books, Miami, FL, U.S.A.
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # I-9781492088868
Seller Image
SQL in a Nutshell
Seller: Rarewaves USA, OSWEGO, IL, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: New. 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. Seller Inventory # LU-9781492088868