Your email was sent successfully. Check your inbox.

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

Proceed reservation?

Export
Filter
  • Sebastopol, Calif. : O'Reilly  (21)
  • Cmabridge, MA : O'Reilly
  • Database management  (21)
  • Oracle (Computer file)
Datasource
Material
Language
Years
Author, Corporation
Publisher
Keywords
  • 1
    Online Resource
    Online Resource
    MongoDB and Python (2011)
    Sebastopol, Calif. : O'Reilly
    Details
    Language: English
    Pages: 1 online resource (vii, 53 p.) , ill.
    Keywords: MongoDB ; Database management ; Python (Computer program language) ; Open source software ; Electronic books ; Electronic books ; local
    Abstract: Learn how to leverage MongoDB with your Python applications, using the hands-on recipes in this book. You get complete code samples for tasks such as making fast geo queries for location-based apps, efficiently indexing your user documents for social-graph lookups, and many other scenarios. This guide explains the basics of the document-oriented database and shows you how to set up a Python environment with it. Learn how to read and write to MongoDB, apply idiomatic MongoDB and Python patterns, and use the database with several popular Python web frameworks. You'll discover how to model your data, write effective queries, and avoid concurrency problems such as race conditions and deadlocks. The recipes will help you: Read, write, count, and sort documents in a MongoDB collection Learn how to use the rich MongoDB query language Maintain data integrity in replicated/distributed MongoDB environments Use embedding to efficiently model your data without joins Code defensively to avoid keyerrors and other bugs Apply atomic operations to update game scores, billing systems, and more with the fast accounting pattern Use MongoDB with the Pylons 1.x, Django, and Pyramid web frameworks
    Note: "Patterns and processes for the popular document-oriented database"--Cover
    URL: https://learning.oreilly.com/library/view/-/9781449312817/?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
    Using SQLite (2010)
    Sebastopol, Calif. : O'Reilly
    Details
    ISBN: 9781449394592 , 1449394590
    Language: English
    Pages: 1 online resource (xx, 503 p.) , ill.
    Edition: 1st ed.
    Parallel Title: Erscheint auch als
    Keywords: SQL (Computer program language) ; Relational databases ; Database management ; Application software ; Electronic books ; lcgft ; Electronic books ; local
    Abstract: Application developers, take note: databases aren't just for the IS group any more. You can build database-backed applications for the desktop, Web, embedded systems, or operating systems without linking to heavy-duty client-server databases such as Oracle and MySQL. This book shows you how to use SQLite, a small and lightweight relational database engine that you can build directly into your application. With SQLite, you'll discover how to develop a database-backed application that remains manageable in size and complexity. This book guides you every step of the way. You'll get a crash course in data modeling, become familiar with SQLite's dialect of the SQL database language, and much more. Learn how to maintain localized storage in a single file that requires no configuration Build your own SQLite library or use a precompiled distribution in your application Get a primer on SQL, and learn how to use several language functions and extensions Work with SQLite using a scripting language or a C-based language such as C# or Objective-C Understand the basics of database design, and learn how to transfer what you already know to SQLite Take advantage of virtual tables and modules "Complex SQL concepts explained clearly." --D. Richard Hipp, creator of SQLite
    Note: "Previous programming experience is recommended"--P. [4] of cover. - Includes index. - Description based on print version record
    URL: https://learning.oreilly.com/library/view/-/9781449394592/?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
    SQL injection defenses (2007)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780596529642 , 0596529643
    Language: English
    Keywords: SQL server ; Database management ; Data transmission systems ; Client/server computing ; Electronic books ; local
    Abstract: This Short Cut introduces you to how SQL injection vulnerabilities work, what makes applications vulnerable, and how to protect them. It helps you find your vulnerabilities with analysis and testing tools and describes simple approaches for fixing them in the most popular web-programming languages. This Short Cut also helps you protect your live applications by describing how to monitor for and block attacks before your data is stolen. Hacking is an increasingly criminal enterprise, and web applications are an attractive path to identity theft. If the applications you build, manage, or guard are a path to sensitive data, you must protect your applications and their users from this growing threat.
    URL: https://learning.oreilly.com/library/view/-/9780596529642/?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
    Filemaker Pro 9 : the missing manual (2007)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780596514136 , 0596514131
    Language: English
    Pages: xx, 778 p , ill. , 24 cm
    Edition: 1st ed.
    Keywords: FileMaker pro ; Database management ; Electronic books ; local
    Abstract: FileMaker Pro 9: The Missing Manual is the clear, thorough and accessible guide to the latest version of this popular desktop database program. FileMaker Pro lets you do almost anything with the information you give it. You can print corporate reports, plan your retirement, or run a small country -- if you know what you're doing. This book helps non-technical folks like you get in, get your database built, and get the results you need. Pronto. The new edition gives novices and experienced users the scoop on versions 8.5 and 9. It offers complete coverage of timesaving new features such as the Quick Start screen that lets you open or a create a database in a snap, the handy "save to" buttons for making Excel documents or PDFs, the multiple level Undo and Redo commands let you step backwards through your typing tasks, and much more. With FileMaker Pro 9: The Missing Manual , you can: Get your first database running in minutes and perform basic tasks right away. Catalog people, processes and things with streamlined data entry and sorting tools. Learn to use layout tools to organize the appearance of your database. Use your data to generate reports, correspondence and other documents with ease. Create, connect, and manage multiple tables and set up complex relationships that show you just the data you need. Crunch numbers, search text, or pin down dates and times with dozens of built-in formulas. Automate repetitive tasks with FileMaker Pro 9's easy-to-learn scripting language. Protect your database with passwords and set up privileges to determine what others can do once they gain entry. Outfit your database for the Web and import and export data to other formats. Each chapter in the book contains "living examples" -- downloadable tutorials that help you learn how to build a database by actually doing it. You also get plenty of sound, objective advice that lets you know which features are really useful, and which ones you'll barely touch. To make the most of FileMaker Pro 9, you need the book that should have been in the box.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780596514136/?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
    Understanding Oracle Clinical (2007)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780596550059 , 0596550057
    Language: English
    Keywords: Oracle (Computer file) ; Database management ; Relational databases ; Electronic books ; local
    Abstract: This Short Cut is written to assist you, an Oracle Clinical Developer, with many of the tasks and decisions you may encounter on an occasional basis. These tasks involve study setup and maintenance, account maintenance, handling discrepancies, preparing data sets for analysis, batch-loading data, altering system-level settings and defining standard processes. A working knowledge of screen setup and procedure coding is assumed. Remote Data Capture (RDC), which moves data entry from the CRO or pharmaceutical company to the sites, is fast becoming the preferred way to gather and clean data for clinical trails. Thus, RDC, in either Classic or PDF form is frequently discussed here; however, occasionally traditional OC data entry methods will be noted. Ideally, you will have a general programming background as well as a strong knowledge of clinical trials and PL/SQL.
    URL: https://learning.oreilly.com/library/view/-/9780596550059/?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
    SQL server integration services (2007)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780596513757 , 0596513755
    Language: English
    Keywords: SQL server ; Database management ; Data warehousing ; Electronic books ; local
    Abstract: SQL Server 2005 Integration Services (SSIS) lets you build high-performance data integration solutions. SSIS solutions wrap sophisticated workflows around tasks that extract, transform, and load (ETL) data from and to a wide variety of data sources. This Short Cut begins with an overview of key SSIS concepts, capabilities, standard workflow and ETL elements, the development environment, execution, deployment, and migration from Data Transformation Services (DTS). Next, you'll see how to apply the concepts you've learned through hands-on examples of common integration scenarios. Once you've finished this Short Cut, you'll have the background and understanding you need to start building your own SSIS integration solutions.
    URL: https://learning.oreilly.com/library/view/-/9780596513757/?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
    MySQL pocket reference (2007)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 9780596514266 , 0596514263
    Language: English
    Edition: 2nd ed.
    Keywords: MySQL (Electronic resource) ; Database management ; Relational databases ; Electronic books ; local
    Abstract: To help you be more efficient in your work, this handy pocket reference gives you instant reminders on how to use important MySQL functions, especially in conjunction with key parts of the LAMP open source infrastructure. This powerful database system is so rich in features that no administrator or programmer can stay familiar with all of them. MySQL Pocket Reference is an ideal on-the-job companion, well organized to help you find and adapt the statements you need -- quickly. Updated for the latest versions of this popular database, this edition covers many complex features that have been added to MySQL 5.0 and 5.1, including a section dedicated to stored procedures and triggers. After a brief introduction on installation and initial setup, the book explains: How to configure MySQL, such as setting the root password MySQL data types, including numerics, strings, dates, and complex types SQL syntax, commands, data types, operators, and functions Arithmetic, comparison and logical operators Aggregate and general functions Stored procedures and triggers, including procedure definition, procedure calls, procedure management, cursors, and triggers You don't have time to stop and thumb through an exhaustive reference when you're hard at work. This portable and affordable guide is small enough to fit into your pocket, and gives you a convenient reference that you can consult anywhere. When you reach a sticking point and need to get to a solution quickly, the MySQL Pocket Reference is the book you want to have.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780596514266/?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
    Backup & recovery (2006)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596102461 , 9780596102463
    Language: English
    Keywords: Electronic data processing ; Backup processing alternatives ; Data recovery (Computer science) ; Database management ; Electronic books ; local
    Abstract: Packed with practical, freely available backup and recoverysolutions for Unix, Linux, Windows, and Mac OS X systems -- as wellas various databases -- this new guide is a complete overhaul of Unix Backup & Recovery by the same author, now revisedand expanded with over 75% new material. Backup & Recovery starts with a complete overview ofbackup philosophy and design, including the basic backup utilitiesof tar, dump, cpio, ntbackup, ditto, and rsync. It then explainsseveral open source backup products that automate backups usingthose utilities, including AMANDA, Bacula, BackupPC, rdiff-backup,and rsnapshot. Backup & Recovery then explains how toperform bare metal recovery of AIX, HP-UX, Linux, Mac OS, Solaris,VMWare, & Windows systems using freely-available utilities. Thebook also provides overviews of the current state of the commercialbackup software and hardware market, including overviews of CDP,Data De-duplication, D2D2T, and VTL technology. Finally, it covershow to automate the backups of DB2, Exchange, MySQL, Oracle,PostgreSQL, SQL-Server, and Sybase databases - without purchasing acommercial backup product to do so. For environments of all sizes and budgets, this unique bookshows you how to ensure data protection without resorting toexpensive commercial solutions. You will soon learn to: Automate the backup of popular databases without a commercialutility Perform bare metal recovery of any popular open systemsplatform, including your PC or laptop Utilize valuable but often unknown open source backupproducts Understand the state of commercial backup software, includingexplanations of CDP and data de-duplication software Access the current state of backup hardware, including VirtualTape Libraries (VTLs)
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0596102461/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 9
    Online Resource
    Online Resource
    Essential Microsoft Operations Manager (2006)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596009534
    Language: English
    Pages: 380 p
    Keywords: Client/server computing ; Database management ; Computer networks ; Electronic books ; local
    Abstract: For system administrators, ensuring that all Windows servers are performing optimally is a tall order. The larger the enterprise, the greater the chance for irritating, time-consuming configuration problems. Sometimes, you can determine the root cause of the problem yourself-but that's only if you're lucky. With Microsoft Operations Manager (MOM), the diagnosis is done for you. MOM monitors server operations and automatically notifies you of problems by sending an immediate alert to your console, email address, or pager. To help you better understand how MOM works, O'Reilly presents Essential Microsoft Operations Manager . The goal of this comprehensive tutorial is to give first-time MOM administrators a solid foundation for planning, implementing, and administering MOM 2005. Author Chris Fox, a renowned MOM expert, offers the type of practical, real-world advice that you need to improve the performance of your IT infrastructure. After taking you through the entire process of setting up MOM on the network, the book moves on to more advanced administration issues. It carefully instructs you how to program and automate MOM and the agents that reside on the servers themselves. You'll also learn how to manage the scripts that determine which server agents are relevant to report. By capturing system data, intelligently analyzing it, and then notifying you with a suggested course of action, MOM makes extinguishing fires a breeze. And now, thanks to Essential Microsoft Operations Manager , learning how to use MOM is a breeze, too.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0596009534/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 10
    Online Resource
    Online Resource
    MySQL cookbook (2006)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 059652708X , 9780596527082
    Language: English
    Edition: 2nd ed.
    Keywords: MySQL (Electronic resource) ; SQL (Computer program language) ; Database management ; Relational databases ; Electronic books ; local
    Abstract: Along with MySQL's popularity has come a flood of questions about solving specific problems, and that's where this Cookbook is essential. Designed as a handy resource when you need quick solutions or techniques, the book offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don't have the time (or expertise) to solve MySQL problems from scratch. The new edition covers MySQL 5.0 and its powerful new features, as well as the older but still widespread MySQL 4.1. One major emphasis of this book is how to use SQL to formulate queries for particular kinds of questions, using the mysql client program included in MySQL distributions. The other major emphasis is how to write programs that interact with the MySQL server through an API. You'll find plenty of examples using several language APIs in multiple scenarios and situations, including the use of Ruby to retrieve and format data. There are also many new examples for using Perl, PHP, Python, and Java as well. Other recipes in the book teach you to: Access data from multiple tables at the same time Use SQL to select, sort, and summarize rows Find matches or mismatches between rows in two tables Determine intervals between dates or times, including age calculations Store images into MySQL and retrieve them for display in web pages Get LOAD DATA to read your data files properly or find which values in the file are invalid Use strict mode to prevent entry of bad data into your database Copy a table or a database to another server Generate sequence numbers to use as unique row identifiers Create database events that execute according to a schedule And a lot more MySQL Cookbook doesn't attempt to develop full-fledged, complex applications. Instead, it's intended to assist you in developing applications yourself by helping you get past problems that have you stumped.
    Note: "Includes Ruby examples.". - Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/059652708X/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 11
    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.
  • 12
    Online Resource
    Online Resource
    Essential CVS (2006)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596527039 , 9780596527037
    Language: English
    Edition: 2nd ed.
    Keywords: CVS ; Database management ; Computer software ; Development ; Electronic books ; local
    Abstract: This easy-to-follow reference shows a variety of professionals how to use the Concurrent Versions System (CVS), the open source tool that lets you manage versions of anything stored in files. Ideal for software developers tracking different versions of the same code, this new edition has been expanded to explain common usages of CVS for system administrators, project managers, software architects, user-interface (UI) specialists, graphic designers and others. Current for version 1.12, Essential CVS , 2nd Edition offers an overview of CVS, explains the core concepts, and describes the commands that most people use on a day-to-day basis. For those who need to get up to speed rapidly, the book's Quickstart Guide shows you how to build and use a basic CVS repository with the default settings and a minimum of extras. You'll also find: A full command reference that details all aspects of customizing CVS for automation, logging, branching, merging documents, and creating alerts Examples and descriptions of the most commonly used options for each command Why and when to tag or branch your project, tagging before releases, and using branching to create a bugfix version of a project Details on the systems used in CVS to permit multiple developers to work on the same project without loss of data An entire section devoted to document version management and project management includes ways to import and export projects, work with remote repositories, and shows how to fix things that can go wrong when using CVS. You'll find more screenshots in this edition as well as examples of using graphical CVS clients to run CVS commands. Essential CVS also includes a FAQ that answers common queries in the CVS mailing list to get you up and running with this system quickly and painlessly.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0596527039/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 13
    Online Resource
    Online Resource
    Learning SQL on SQL Server 2005 (2006)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596102151
    Language: English
    Pages: 342 p
    Keywords: SQL server ; SQL (Computer program language) ; Database design ; Database management ; Electronic books ; local
    Abstract: Anyone who interacts with today's modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information. In recent years, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly. If you're new to databases, or need a SQL refresher, Learning SQL on SQL Server 2005 is an ideal step-by-step introduction to this database query tool, with everything you need for programming SQL using Microsoft's SQL Server 2005-one of the most powerful and popular database engines used today. Plenty of books explain database theory. This guide lets you apply the theory as you learn SQL. You don't need prior database knowledge, or even prior computer knowledge. Based on a popular university-level course designed by authors Sikha Saha Bagui and Richard Walsh Earp, Learning SQL on SQL Server 2005 starts with very simple SQL concepts, and slowly builds into more complex query development. Every topic, concept, and idea comes with examples of code and output, along with exercises to help you gain proficiency in SQL and SQL Server 2005. With this book, you'll learn: Beginning SQL commands, such as how and where to type an SQL query, and how to create, populate, alter and delete tables How to customize SQL Server 2005's settings and about SQL Server 2005's functions About joins, a common database mechanism for combining tables Query development, the use of views and other derived structures, and simple set operations Subqueries, aggregate functions and correlated subqueries, as well as indexes and constraints that can be added to tables in SQL Server 2005 Whether you're an undergraduate computer science or MIS student, a self-learner who has access to the new Microsoft database, or work for your company's IT department, Learning SQL on SQL Server 2005 will get you up to speed on SQL in no time.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0596102151/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 14
    Online Resource
    Online Resource
    Learning MySQL (2006)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596008643 , 9780596008642
    Language: English
    Keywords: MySQL (Electronic resource) ; PHP (Computer program language) ; SQL (Computer program language) ; Database management ; Web databases ; Electronic books ; local
    Abstract: Whether you're running a business, keeping track of members andmeetings for a club, or just trying to organize a large and diversecollection of information, you'll find the MySQL database engineuseful for answering questions such as: Which are my top ten fastest-selling products? How frequently does this person come to our facility? What was the highest, lowest, and average score of the team last season? MySQL, the most popular open-source database, offers the power ofa relational database in a package that's easy to set up andadminister, and Learning MySQL provides all the tools you need toget started. This densely packed tutorial includes detailedinstructions to help you set up and design an effective database,create powerful queries using SQL, configure MySQL for improvedsecurity, and squeeze information out of your data. After covering the basics, the book travels far into MySQL'ssubtleties, including complex queries and joins, how to interact withthe database over the Web using PHP or Perl, and importanthouse-keeping such as backups and security. Topic include: Installation on Linux, Windows, and Mac OS X Basic and advanced querying using SQL User management and security Backups and recovery Tuning for improved efficiency Developing command-line and web database applications using thePHP and Perl programming languages The authors, Saied Tahaghoghi and Hugh E. Williams, have careers inacademia and business, and share a keen interest in research intosearch technologies. Whether you've never touched a database or have already completedsome MySQL projects, you'll find insights in Learning MySQL that will last a career.
    Note: Includes index
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 15
    Online Resource
    Online Resource
    MySQL stored procedure programming (2006)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596100892
    Language: English
    Pages: 636 p , ill.
    Keywords: SQL (Computer program language) ; Database management ; Electronic books ; local
    Abstract: The implementation of stored procedures in MySQL 5.0 a hugemilestone -- one that is expected to lead to widespread enterprise adoption ofthe already extremely popular MySQL database. If you are serious aboutbuilding the web-based database applications of the future, you need toget up to speed quickly on how stored procedures work -- and how tobuild them the right way. This book, destined to be the bible of storedprocedure development, is a resource that no real MySQL programmer canafford to do without. In the decade since MySQL burst on the scene, it has become thedominant open source database, with capabilities and performancerivaling those of commercial RDBMS offerings like Oracle and SQLServer. Along with Linux and PHP, MySQL is at the heart of millions ofapplications. And now, with support for stored procedures, functions,and triggers in MySQL 5.0, MySQL offers the programming power neededfor true enterprise use. MySQL's new procedural language has a straightforward syntax, making iteasy to write simple programs. But it's not so easy to write secure,easily maintained, high-performance, and bug-free programs. Few in theMySQL world have substantial experience yet with stored procedures, butGuy Harrison and Steven Feuerstein have decades of combined expertise. In MySQL Stored Procedure Programming , they putthat hard-won experience to good use. Packed with code examples and coveringeverything from language basics to application building to advancedtuning and best practices, this highly readable book is the one-stopguide to MySQL development. It consists of four major sections: MySQL stored programming fundamentals -- tutorial, basicstatements, SQL in stored programs, and error handling Building MySQL stored programs -- transaction handling,built-in functions, stored functions, and triggers MySQL stored programs in applications -- using storedprograms with PHP, Java, Perl, Python, and .NET (C# and VB.NET) Optimizing MySQL stored programs -- security, basic andadvanced SQL tuning, optimizing stored program code, and programmingbest practices A companion web site contains many thousands of lines of code, that youcan put to use immediately. Guy Harrison is Chief Architect of Database Solutions at Quest Softwareand a frequent speaker and writer on MySQL topics. Steven Feuerstein isthe author of Oracle PL/SQL Programming , the classic reference for Oracle stored programming for more than ten years. Both have decades of experience as database develo...
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0596100892/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 16
    Online Resource
    Online Resource
    Oracle PL/SQL programming (2005)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596009771
    Language: English
    Pages: 1198 p
    Edition: 4th ed.
    Keywords: Oracle (Computer file) ; SQL/ORACLE (Computer program language) ; Database management ; Electronic books ; local
    Abstract: For the past ten years, O'Reilly's Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to database administrators--make the most of PL/SQL. The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10 g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers. The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization. Co-authored by the world's foremost PL/SQL authority, Steven Feuerstein, this classic reference provides language syntax, best practices, and extensive code, ranging from simple examples to complete applications--making it a must-have on your road to PL/SQL mastery. A companion web site contains many more examples and additional technical content for enhanced learning.
    Note: Includes index and errata
    URL: https://learning.oreilly.com/library/view/-/0596009771/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 17
    Online Resource
    Online Resource
    Integrating Excel and Access (2005)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596009739
    Language: English
    Pages: 232 p , ill.
    Keywords: Microsoft Excel (Computer file) ; Microsoft Access ; Database management ; Electronic books ; local
    Abstract: In a corporate setting, the Microsoft Office Suite is an invaluable set of applications. One of Offices' biggest advantages is that its applications can work together to share information, produce reports, and so on. The problem is, there isn't much documentation on their cross-usage. Until now. Introducing Integrating Excel and Access , the unique reference that shows you how to combine the strengths of Microsoft Excel with those of Microsoft Access. In particular, the book explains how the powerful analysis tools of Excel can work in concert with the structured storage and more powerful querying of Access. The results that these two applications can produce together are virtually impossible to achieve with one program separately. But the book isn't just limited to Excel and Access. There's also a chapter on SQL Server, as well as one dedicated to integrating with other Microsoft Office applications. In no time, you'll discover how to: Utilize the built in features of Access and Excel to access data Use VBA within Access or Excel to access data Build connection strings using ADO and DAO Automate Excel reports including formatting, functions, and page setup Write complex functions and queries with VBA Write simple and advanced queries with the Access GUI Produce pivot tables and charts with your data With Integrating Excel and Access , you can crunch and visualize data like never before. It's the ideal guide for anyone who uses Microsoft Office to handle data.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0596009739/?ar
    URL: Inhaltstext
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 18
    Online Resource
    Online Resource
    SQL cookbook (2005)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596009763
    Language: English
    Pages: 628 p
    Keywords: SQL (Computer program language) ; Database management ; Electronic books ; local
    Abstract: You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level. Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT columns FROM table WHERE conditions. But there is so much more you can do with the language. In the SQL Cookbook , experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about: Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing out Powerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES function Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set Bucketization , and why you should never use that term in Brooklyn. How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques The technique of walking a string , which allows you to use SQL to parse through the characters, words, or delimited elements of a string Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.
    Note: Includes index
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 19
    Online Resource
    Online Resource
    Oracle PL/SQL for DBAs (2005)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596005873
    Language: English
    Pages: 454 p
    Keywords: Oracle (Computer file) ; PL/SQL (Computer program language) ; Relational databases ; Electronic books ; local
    Abstract: PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performance and as the lines between developers and DBAs blur. Until now, there has not been a book focused squarely on the language topics of special concern to DBAs Oracle PL/SQL for DBAs fills the gap. Covering the latest Oracle version, Oracle Database 10g Release 2 and packed with code and usage examples, it contains: A quick tour of the PL/SQL language, providing enough basic information about language fundamentals to get DBAs up and running Extensive coverage of security topics for DBAs: Encryption (including both traditional methods and Oracle's new Transparent Data Encryption, TDE); Row-Level Security(RLS), Fine-Grained Auditing (FGA); and random value generation Methods for DBAs to improve query and database performance with cursors and table functions Coverage of Oracle scheduling, which allows jobs such as database monitoring andstatistics gathering to be scheduled for regular execution Using Oracle's built-in packages (DBMS_CRYPTO, DBMS_RLS, DBMS_FGA, DBMS_RANDOM,DBMS_SCHEDULING) as a base, the book describes ways of building on top of these packages to suit particular organizational needs. Authors are Arup Nanda, Oracle Magazine 2003 DBA of the Year, and Steven Feuerstein, the world's foremost PL/SQL expert and coauthor of the classic reference, Oracle PL/SQL Programming . DBAs who have not yet discovered how helpful PL/SQL can be will find this book a superb introduction to the language and its special database administration features. Even if you have used PL/SQL for years, you'll find the detailed coverage in this book to be an invaluable resource.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0596005873/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 20
    Online Resource
    Online Resource
    Access for starters : the missing manual (2005)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    Details
    ISBN: 0596006659
    Language: English
    Pages: 396 p
    Keywords: Microsoft Access ; Database management ; Electronic books ; local
    Abstract: Maybe you got Access as part of Microsoft Office and wonder what it can do for you and your household; maybe you're a small business manager and don't have a techie on staff to train the office in Microsoft Access. Regardless, you want to quickly get your feet wet--but not get in over your head--and Access 2003 for Starters: The Missing Manual is the book to make it happen. Far more than a skimpy introduction but much less daunting than a weighty tech book, Access 2003 for Starters: The Missing Manual demystifies databases and explains how to design and create them with ease. It delivers everything you need--and nothing you don't--to use Access right away. It's your expert guide to the Access features that are most vital and most useful, and it's your trusted advisor on the more in-depth features that are best saved for developers and programmers. Access is sophisticated and powerful enough for professional developers but easy and practical enough for everyday users like you. This Missing Manual explains all the major features of Access2003, including designing and creating databases, organizing and filtering information, and generating effective forms and reports. Bestselling authors, database designers, and programmers Scott Palmer, Ph.D., and Kate Chase are your guides for putting the world's most popular desktop data management program to work. Their clear explanations, step-by-step instructions, plenty of illustrations, and timesaving advice help you get up to speed quickly and painlessly. Whether you're just starting out or you know you've been avoiding aspects of the program and missing out on much of what it can do, this friendly, witty book will gently immerse you in Microsoft Access. Keep it handy, as you'll undoubtedly refer to it again and again.
    Note: Includes index and errata
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 21
    Online Resource
    Online Resource
    Essential CVS (2003)
    Sebastopol, Calif. : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xiv, 320 p. , ill. ; , 24 cm
    DDC: 005.1
    Keywords: CVS ; Computer software ; Development ; Database management ; Electronic books ; local
    Abstract: CVS, the Concurrent Versions System, is the popular source-code management tool that frees developers from the chaos that too often ensues when multiple users work on the same file. An open source technology that is available on most computer platforms, including Windows® and Mac OS® X, CVS is widely used to manage program code, web site content, and to track changes made to system configuration files. Multiple users can check out files from a directory tree, make changes, and then commit those changes back into the directory. If two developers modify the same file, CVS enables both sets of changes to be merged together into one final file. Although CVS is a lifesaver in many development scenarios, it suffers from poor documentation. But with Essential CVS , developers can have it all: the order that CVS brings and the comprehensive documentation developers need. Essential CVS is a complete and easy-to-follow reference that helps programmers and system administrators apply order to the task of managing large quantities of documents. The book covers basic concepts and usage of CVS, and features a comprehensive reference for CVS commands--including a handy Command Reference Card for quick, on-the-job checks. The book also includes advanced information on all aspects of CVS that involve automation, logging, branching and merging, and "watches." Readers will find in-depth coverage of the following: Installing CVS and building your first repository Basic use of CVS, including importing projects, checking out projects, committing changes, and updating projects Tagging, branching and merging Working with multiple users Clients, operating systems, and IDEs Repository management and managing remote repositories Project administration, including bug tracking systems, enforcing log messages, history and annotation, and more. Troubleshooting Version control is essential to maintaining order in any project, large or small. Any CVS user, from beginners to team leaders and system administrators, will find this practical guide to CVS indispensable in getting the most from this valuable tool.
    URL: https://learning.oreilly.com/library/view/-/0596004591/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 22
    Online Resource
    Online Resource
    Programming the Perl DBI (2000)
    Cmabridge, MA : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: p. cm
    DDC: 005.74
    Keywords: Database management ; Perl (Computer program language) ; Electronic books ; local
    Abstract: One of the greatest strengths of the Perl programming language is its ability to manipulate large amounts of data. Database programming is therefore a natural fit for Perl, not only for business applications but also for CGI-based web and intranet applications.The primary interface for database programming in Perl is DBI. DBI is a database-independent package that provides a consistent set of routines regardless of what database product you use--Oracle, Sybase, Ingres, Informix, you name it. The design of DBI is to separate the actual database drivers (DBDs) from the programmer's API, so any DBI program can work with any database, or even with multiple databases by different vendors simultaneously. Programming the Perl DBI is coauthored by Alligator Descartes, one of the most active members of the DBI community, and by Tim Bunce, the inventor of DBI. For the uninitiated, the book explains the architecture of DBI and shows you how to write DBI-based programs. For the experienced DBI dabbler, this book reveals DBI's nuances and the peculiarities of each individual DBD.The book includes: An introduction to DBI and its design How to construct queries and bind parameters Working with database, driver, and statement handles Debugging techniques Coverage of each existing DBD A complete reference to DBI This is the definitive book for database programming in Perl.
    URL: https://learning.oreilly.com/library/view/-/1565926994/?ar
    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...