reklama - zainteresowany?

SQL in a Nutshell. 3rd Edition - Helion

SQL in a Nutshell. 3rd Edition
ebook
Autor: Kevin Kline, Daniel Kline, Brand Hunt
ISBN: 978-05-965-5425-5
stron: 594, Format: ebook
Data wydania: 2008-11-21
Księgarnia: Helion

Cena książki: 126,65 zł (poprzednio: 147,27 zł)
Oszczędzasz: 14% (-20,62 zł)

Dodaj do koszyka SQL in a Nutshell. 3rd Edition

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.

Dodaj do koszyka SQL in a Nutshell. 3rd Edition

 

Osoby które kupowały "SQL in a Nutshell. 3rd Edition", wybierały także:

  • Windows Media Center. Domowe centrum rozrywki
  • Ruby on Rails. Ćwiczenia
  • DevOps w praktyce. Kurs video. Jenkins, Ansible, Terraform i Docker
  • Przywództwo w Å›wiecie VUCA. Jak być skutecznym liderem w niepewnym Å›rodowisku
  • Scrum. O zwinnym zarzÄ…dzaniu projektami. Wydanie II rozszerzone

Dodaj do koszyka SQL in a Nutshell. 3rd Edition

Spis treści

SQL in a Nutshell. A Desktop Quick Reference Guide. 3rd Edition eBook -- spis treści

  • SQL in a Nutshell
  • SPECIAL OFFER: Upgrade this ebook with OReilly
  • Preface
    • Why This Book?
    • Who Should Read This Book?
    • How This Book Is Organized
    • How to Use This Book
    • Resources
    • Changes in the Third Edition
    • Conventions Used in This Book
    • Using Code Examples
    • How to Contact Us
    • Safari Books Online
    • Acknowledgments
      • Kevin E. Klines Acknowledgments
      • Daniel Kline's Acknowledgments
      • Brand Hunt's Acknowledgments
  • 1. SQL History and Implementations
    • The Relational Model and ANSI SQL
      • Codd's Rules for Relational Database Systems
        • Data structures (rules 1, 2, and 8)
        • NULLs (rule 3)
        • Metadata (rules 4 and 10)
        • The language (rules 5 and 11)
        • Views (rule 6)
        • Set operations (rules 7 and 12)
      • Codd's Rules in Action: Simple SELECT Examples
    • History of the SQL Standard
      • What's New in SQL2006
      • What's New in SQL2003 (SQL3)
      • Levels of Conformance
      • Supplemental Features Packages in the SQL3 Standard
      • SQL3 Statement Classes
    • SQL Dialects
  • 2. Foundational Concepts
    • Database Platforms Described in This Book
      • Categories of Syntax
        • Identifiers
        • Naming conventions
        • Identifier rules
      • Literals
      • Operators
        • Arithmetic operators
        • Assignment operators
        • Bitwise operators
        • Comparison operators
        • Logical operators
        • Unary operators
        • Operator precedence
        • System delimiters and operators
      • Keywords and Reserved Words
    • SQL2003 and Platform-Specific Datatypes
      • MySQL Datatypes
      • Oracle Datatypes
      • PostgreSQL Datatypes
      • SQL Server Datatypes
    • Constraints
      • Scope
      • Syntax
      • PRIMARY KEY Constraints
      • FOREIGN KEY Constraints
      • UNIQUE Constraints
      • CHECK Constraints
  • 3. SQL Statement Command Reference
    • How to Use This Chapter
    • SQL Platform Support
    • SQL Command Reference
      • ALL/ANY/SOME Operators
      • BETWEEN Operator
      • CALL Statement
      • CLOSE CURSOR Statement
      • COMMIT Statement
      • CONNECT Statement
      • CREATE/ALTER DATABASE Statement
      • CREATE/ALTER FUNCTION/PROCEDURE Statements
      • CREATE/ALTER INDEX Statement
      • CREATE/ALTER METHOD Statement
      • CREATE ROLE Statement
      • CREATE SCHEMA Statement
      • CREATE/ALTER TABLE Statement
      • CREATE/ALTER TRIGGER Statement
      • CREATE/ALTER TYPE Statement
      • CREATE/ALTER VIEW Statement
      • DECLARE CURSOR Command
      • DELETE Statement
      • DISCONNECT Statement
      • DROP Statements
      • EXCEPT Set Operator
      • EXISTS Operator
      • FETCH Statement
      • GRANT Statement
      • IN Operator
      • INSERT Statement
      • INTERSECT Set Operator
      • IS Operator
      • JOIN Subclause
      • LIKE Operator
      • MERGE Statement
      • OPEN Statement
      • ORDER BY Clause
      • RELEASE SAVEPOINT Statement
      • RETURN Statement
      • REVOKE Statement
      • ROLLBACK Statement
      • SAVEPOINT Statement
      • SELECT Statement
      • SET Statement
      • SET CONNECTION Statement
      • SET CONSTRAINT Statement
      • SET PATH Statement
      • SET ROLE Statement
      • SET SCHEMA Statement
      • SET SESSION AUTHORIZATION Statement
      • SET TIME ZONE Statement
      • SET TRANSACTION Statement
      • START TRANSACTION Statement
      • SUBQUERY Substatement
      • TRUNCATE TABLE Statement
      • UNION Set Operator
      • UPDATE Statement
      • WHERE Clause
  • 4. SQL Functions
    • Types of Functions
      • Deterministic and Nondeterministic Functions
      • Aggregate and Scalar Functions
      • Window Functions
    • ANSI SQL Aggregate Functions
      • AVG and SUM
      • CORR
      • COUNT
      • COVAR_POP
      • COVAR_SAMP
      • CUME_DIST
      • DENSE_RANK
      • MIN and MAX
      • PERCENT_RANK
      • PERCENTILE_CONT
      • PERCENTILE_DISC
      • RANK
      • The REGR Family of Functions
      • STDDEV_POP
      • STDDEV_SAMP
      • VAR_POP
      • VAR_SAMP
    • ANSI SQL Window Functions
      • ANSI SQL2003's Window Syntax
      • Oracle's Window Syntax
      • SQL Server's Window Syntax
      • Partitioning
      • Ordering
      • Grouping or Windowing
      • List of Window Functions
        • CUME_DIST
        • DENSE_RANK
        • PERCENT_RANK
        • RANK
        • ROW_NUMBER
    • ANSI SQL Scalar Functions
      • Built-in Scalar Functions
      • CASE and CAST Functions
        • CASE
        • CAST
      • Numeric Scalar Functions
        • ABS
        • BIT_LENGTH, CHAR_LENGTH, and OCTET_LENGTH
        • CEIL
        • EXP
        • EXTRACT
        • FLOOR
        • LN
        • MOD
        • POSITION
        • POWER
        • SQRT
        • WIDTH_BUCKET
      • String Functions and Operators
        • Concatenation Operator
        • CONVERT and TRANSLATE
        • LOWER and UPPER
        • OVERLAY
        • SUBSTRING
        • TRIM
    • Platform-Specific Extensions
      • MySQL-Supported Functions
      • Oracle-Supported Functions
      • PostgreSQL-Supported Functions
      • SQL Server-Supported Functions
  • A. Shared and Platform-Specific Keywords
  • Index
  • About the Author
  • Colophon
  • SPECIAL OFFER: Upgrade this ebook with OReilly
  • Copyright

Dodaj do koszyka SQL in a Nutshell. 3rd Edition

Code, Publish & WebDesing by CATALIST.com.pl



(c) 2005-2024 CATALIST agencja interaktywna, znaki firmowe należą do wydawnictwa Helion S.A.