Your email was sent successfully. Check your inbox.

An error occurred while sending the email. Please try again.

Proceed reservation?

Export
  • 1
    Online Resource
    Online Resource
    SQL pocket guide (2010)
    Sebastopol, CA : O'Reilly
    Details
    Language: English
    Pages: 1 online resource (vii, 196 p.) , ill.
    Edition: 3rd ed.
    Parallel Title: Erscheint auch als
    Keywords: SQL (Computer program language) ; Relational databases ; Database management ; Electronic books ; lcgft ; Electronic books ; local
    Abstract: 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
    Note: Includes index. - Description based on print version record
    URL: https://learning.oreilly.com/library/view/-/9781449397586/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 2
    Online Resource
    Online Resource
    Transact-SQL cookbook (2002)
    Sebastopol, CA ; : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xviii, 282 p. , ill. ; , 24 cm
    Edition: 1st ed.
    DDC: 005.756
    Keywords: Relational databases ; SQL (Computer program language) ; Electronic books ; local
    Abstract: This unique cookbook contains a wealth of solutions to problems that SQL programmers face all the time. The recipes inside range from how to perform simple tasks, like importing external data, to ways of handling issues that are more complicated, like set algebra. Authors Ales Spetic and Jonathan Gennick, two authorities with extensive database and SQL programming experience, include a discussion with each recipe to explain the logic and concepts underlying the solution.SQL (Structured Query Language) is the closest thing to a standard query language that currently exists, and Transact-SQL -- a full-featured programming language that dramatically extends the power of SQL -- is the procedural language of choice for both Microsoft SQL Server and Sybase SQL Server systems. The Transact-SQL Cookbook is designed so you can use the recipes directly, as a source of ideas, or as a way to learn a little more about SQL and what you can do with it. Topics covered include: Audit logging. In addition to recipes for implementing an audit log, this chapter also includes recipes for: improving performance where large log tables are involved; supporting multiple-languages; and simulating server push. Hierarchies. Recipes show you how to manipulate hierarchical data using Transact-SQL. Importing data. This chapter introduces concepts like normalization and recipes useful for working with imported data tables. Sets. Recipes demonstrate different operations, such as how to find common elements, summarize the data in a set, and find the element in a set that represents an extreme. Statistics. This chapter?s recipes show you how to effectively use SQL for common statistical operations from means and standard deviations to weighted moving averages. Temporal data. Recipes demonstrate how to construct queries against time-based data. Data Structures. This chapter shows how to manipulate data structures like stacks, queues, matrices, and arrays. With an abundance of recipes to help you get your job done more efficiently, the Transact-SQL Cookbook is sure to become an essential part of your library.
    Note: "Help for database programmers"--Cover. - Includes index
    URL: https://learning.oreilly.com/library/view/-/1565927567/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 3
    Online Resource
    Online Resource
    Oracle SQL*Plus : pocket reference (2002)
    Sebastopol, CA : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: vi, 113 p. ; , 18 cm
    Edition: 2nd ed.
    Keywords: Oracle (Computer file) ; Database management ; Query languages (Computer science) ; Relational databases ; SQL*PLUS (Computer program language) ; Electronic books ; local
    Abstract: SQL*Plus is available at every Oracle site--from the largest data warehouse to the smallest single-user system--and it's a critical tool for virtually every Oracle user. Despite its wide use, few developers and DBAs know how powerful a tool SQL*Plus can be. This pocket reference provides quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus syntax, including the syntax for the Oracle9i release. This book boils down the most vital information from Gennick's best-selling book, "Oracle SQL8Plus: The Definitive Guide", into an accessible summary and works as a vital companion to the larger book. It concisely describes interacting with SQL*Plus, selecting data, formatting reports with SQL*Plus, and tuning SQL queries. It also contains quick references to the SQL*Plus commands and format elements. The new 2nd edition of our Oracle SQL*Plus Pocket Reference includes many new features for Oracle9i (e.g., COALESCE function, searched CASE expressions, new table join syntax, partition operations, MERGE statement, and syntax changes in existing SQL*Plus statements such as ACCEPT, DESRIBE, HELP, and SET) It also adds sections on basic SQL (a much-requested feature): INSERT, DELETE, UPDATE, SELECT, and transaction management. The pocket reference size is especially appropriate for this particular subject, since Oracle SQL*Plus is used on every possible platform, it's particularly convenient to be able to carry a small book around from office computer to home computer to laptop.
    Note: "A guide to SQL*Plus syntax"--Cover. - "Covers Oracle9i"--Cover. - Includes index
    URL: https://learning.oreilly.com/library/view/-/0596004419/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 4
    Online Resource
    Online Resource
    Oracle SQL*Plus : pocket reference (2000)
    Sebastopol, CA : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: iv, 90 p. ; , 18 cm
    Edition: 1st ed.
    Keywords: Oracle (Computer file) ; Query languages (Computer science) ; Relational databases ; SQL*Plus (Computer program language) ; Electronic books ; local
    Abstract: This pocket reference provides quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus syntax, including the syntax for new Oracle8 i release 8.1.6 features. SQL*Plus is available at every Oracle site--from the largest data warehouse to the smallest single-user system--and it's a critical tool for virtually every Oracle user. Despite its wide use, few developers and DBAs know how powerful a tool SQL*Plus can be. This book boils down the most vital information from Gennick's best-selling book, Oracle SQL*Plus: The Definitive Guide , into an accessible summary. It concisely describes interacting with SQL*Plus, selecting data, formatting reports with SQL*Plus, and tuning SQL queries. It also contains quick references to the SQL*Plus commands and format elements. This book is an indispensable companion to O'Reilly bestselling book, Oracle SQL*Plus: The Definitive Guide , but it does not replace it; the larger book is truly the definitive guide, suitable for readers at all levels of expertise. The definitive guide describes the many tasks that SQL*Plus can perform, and provides a tutorial on many SQL*Plus topics. But this quick reference is an excellent, portable resource for readers who want a pocket-sized summary of SQL*Plus capabilities and a reminder of how to issue specific commands and formatting options for SQL*Plus. Table of Contents: Interacting with SQL*Plus Selecting Data Formatting Reports Tuning SQL SQL*Plus Format Elements SQL*Plus Command Reference
    Note: "Covers Oracle8i"--cover. - "Guide to SQL*Plus syntax"--cover
    URL: https://learning.oreilly.com/library/view/-/1565929411/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 5
    Online Resource
    Online Resource
    SQL pocket guide (2006)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780596526887 , 0596526881
    Language: English
    Edition: 2nd. ed.
    Keywords: SQL (Computer program language) ; Relational databases ; Database management ; Electronic books ; local
    Abstract: 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 or two. Now available in an updated second edition, our very popular SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including: Oracle Database 10g, Release 2 (includingthe free Oracle Database 10g Express Edition (XE)) Microsoft SQL Server 2005 MySQL 5 IBM DB2 8.2 PostreSQL 8.1 database
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780596526887/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 6
    Online Resource
    Online Resource
    Oracle SQL*Loader : the definitive guide (2001)
    Beijing ; : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xvii, 251 p. , ill. ; , 24 cm
    Keywords: Oracle (Computer file) ; Relational databases ; SQL (Computer program language) ; Electronic books ; local
    Abstract: SQL Loader is a ubiquitous tool in the Oracle world. It has been shipped with Oracle since at least Version 6 and continues to be supported and enhanced with each new version of Oracle, including Oracle8 and Oracle8 i. The job of SQL Loader is to load data from flat files into an Oracle database. It's optimized for loading large volumes of data, and is flexible enough to handle virtually any input format.Almost every Oracle user has to use SQL Loader at one time or another, and DBAs are frequently called upon to load data for the users in their organization. Despite SQL Loader's wide availability and usage, few DBAs and developers know how to get the most out of it. Oracle SQL Loader: The Definitive Guide has everything you need to know to put SQLLoader to its best use: an introduction to SQL Loader, a reference to all of its syntax options, and most importantly, step-by-step instructions for all the SQL Loader tasks you'd want to perform--and maybe some you didn't realize you COULD perform.You'll learn how to construct the necessary control files and load from different types of files containing different types of data (e.g., fixed-width data, delimited data, and data of various datatypes). You'll also learn how to validate data, load it selectively, transform it as it is loaded, and recover after failure. This book explains how to optimize SQL Loader performance by adjusting the transaction size and using the new direct path option. It also covers the newest SQL Loader features--the loading of large object (LOB) columns and the new object types (nested tables, varying arrays, and object tables). Oracle SQL Loader: The Definitive Guide is an indispensable resource for anyone who is new to SQLLoader; a task-oriented learning tool for those who are already using it; and a quick reference for every user. If you want to take best advantage of an essential Oracle tool, you need this book.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/1565929489/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 7
    Online Resource
    Online Resource
    Oracle SQL*Plus : pocket reference (2009)
    Sebastopol, CA : O'Reilly
    Details
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: Oracle (Computer file) ; Relational databases ; SQL*PLUS (Computer program language) ; Query languages (Computer science) ; Electronic books ; Electronic books ; local
    Abstract: The Oracle SQL Plus Pocket Reference is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQLPlus. As Oracle's long-standing interactive query tool, SQL Plus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQL Plus is still often not completely understood or fully utilized.Database administrators and developers alike will therefore find the Oracle SQL Plus Pocket Reference to be extremely beneficial. In addition to summarizing all of the SQLPlus syntax and format options, including new Oracle Database 10 g features, this handy, on-the-job guide specifically shows readers how to: Differentiate between SQL and SQL Plus Interact with SQLPlus from both the command line and the web browser Select, insert, update, and delete data Format both text and HTML reports with SQL Plus Specify SQLPlus commands and format elements Tune SQL queries The new third edition of this book has been updated for Oracle Database 10 g to include information on both SQL Plus and SQL. New SQL information includes the SELECT statement's new MODEL clause, flashback queries, partition outer joins, and DBMS_XPLAN.With its quick-reference format and compact size, the Oracle SQL Plus Pocket Reference follows in the long line of successful "pocket references" offered by O'Reilly. It also serves as the ideal companion to O'Reilly's larger, more comprehensive book on SQL Plus, the bestselling Oracle SQL Plus: The Definitive Guide.Author Jonathan Gennick is an editor for O'Reilly specializing in database and programming titles, having amassed some 17 years of programming and database management experience.
    Note: Includes index. - Description based on online resource; title from title page (Safari, viewed April 6, 2015)
    URL: https://learning.oreilly.com/library/view/-/9781491926680/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 8
    Online Resource
    Online Resource
    SQL : kurz & gut (2007)
    Köln : O'Reilly Verlag | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9783897215221 , 3897215225
    Language: German
    Pages: 208 p , 18 cm
    Edition: 2. Aufl.
    Series Statement: O'Reillys Taschenbibliothek
    Keywords: SQL (Computer program language) ; Relational databases ; Database management ; Electronic books ; local
    Abstract: Die stark erweiterte und aktualisierte Neuauflage des Bestsellers bietet gewohnt knapp und präzise die wichtigsten Informationen zu SQL und deckt neben Oracle Database 10 g Release 2, IBM DB2 8.2, Microsoft SQL Server 2005 und MySQL 5.0 nun auch PostgreSQL 8.1 ab. Bei aller Aktualität erhalten geblieben ist das bewährte Konzept des Titels: Anhand konkreter Beispiele werden die SQL-Anweisungen und -Optionen vorgestellt, die in der Praxis am häufigsten benötigt werden. Kompakt, übersichtlich und auf den Punkt gebracht: SQL - kurz & gut ist auch in der zweiten Auflage ein aktuelles, nützliches Nachschlagewerk.
    Note: Title from resource description page (viewed April 22, 2009). - "Übersetzung und deutsche Bearbeitung: Lars Schulten, Köln" --P. 2. - Includes index. - Text in German translated from English
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
Close ⊗
This website uses cookies and the analysis tool Matomo. More information can be found here...