Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Apply Your SQL Server DBA Skills to Oracle Database AdministrationUse your SQL Server experience to set up and maintain a high-performance Oracle Database environment. Written by a DBA with expertise in both platforms, Oracle Database Administration for Microsoft SQL Server DBAs illustrates each technique with clear explanations, examples, and comparison tables. Get full details on Oracle Database intervals, creation assistants, management techniques, and query tools. High availability, disaster recovery, and security procedures are also extensively covered in this comprehensive Oracle Press guide. Install and configure Oracle Database on Windows or Linux systems Administer and monitor databases from Oracle Enterprise Manager Implement robust security using roles, permissions, and privileges Back up and restore databases with Oracle Recovery Manager Use the Oracle cost-based optimizer to tune performance Write, debug, and execute PL/SQL queries using Oracle SQL Developer Maximize availability with Oracle Real Application Clusters Build standby and failover servers using Oracle Data Guard

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Maximize the powerful features of the latest release of today's most popular desktop database program How to Do Everything with Microsoft Office Access 2007 shows you how to create and customize an efficient, multi-user database, retrieve, interpret, and share your data, secure your information, and much more. Designed to help you get things done quickly and easily, this user-friendly guide is your all-access pass to Access 2007. Navigate the new user interface with ease Design a well-organized database using pre-designed templates Enter and edit data and ensure data validity Sort, filter, and print records Extract specific information using queries Master form and report design basics Add charts and graphs to forms and reports easily Optimize database performance and speed Exchange database objects and text files between Access databases

Getting started with MongoDB is easy, but once you begin building applications with it, you'll face some complex issues. What are the tradeoffs between normalized and denormalized data? How do you handle replica set failure and failover? This collection of MongoDB tips, tricks, and hacks helps you resolve issues with everything from application design and implementation to data safety and monitoring.

You get specific guidance in five topic areas directly from engineers at 10gen, the company that develops and supports this open source database: Application Design Tips: What to keep in mind when designing your schema Implementation Tips: Programming applications against MongoDB Optimization Tips: Speeding up your applications Data Safety Tips: Using replication and journaling to keep data safe--without sacrificing too much performance Administration Tips: How to configure MongoDB and keep it running smoothly

This volume is for those interested in methods and tools for improving the development of educational hypermedia on a large scale. Interactive multimedia or hypermedia is one of the technologies which is most influencing the educating and training of people. This book shows how coordination and reuse pertain to the development of courseware, which provides new opportunities and challenges to researchers, practitioners, and designers from disciplines such as computer science, education, library science, communication and psychology.

Have you ever been faced with a new type of query to write, or been asked to create an unfamiliar database object? In such situations, you have probably wanted a good, solid example upon which to build, and instead have been forced into the drudgery of parsing railroad-style syntax diagrams in Oracle's manual set. This book frees you from that drudgery by providing tested and working examples of SQL used to solve common problems faced by developers and database administrators on a daily basis. When you're under pressure to get results fast, Oracle SQL Recipes is there at your side.Example-based, providing quality solutions to everyday problems Respects your time by putting solutions first and keeping discussions short Solves the most commonly encountered SQL problems What you'll learn Recognize common query patterns and apply their corresponding solutions. Solve common reporting problems such as sorting rows into buckets. Troubleshoot SQL performance problems. Create and manage database objects such as tables, indexes, and views. Work with XML and tree-structured data. Take advantage of analytic functions, regular expressions, hierarchical query support, and other powerful aspects of Oracle SQL. Who this book is for

Oracle SQL Recipes is written for developers and database administrators who write SQL to run against an Oracle database. It is further written for those whose time is precious, and who just wish for a good example to help them get on with their work. If you want to spend your time writing SQL rather than reading about it, then this is the right book for you. Table of Contents The Basics Summarizing and Aggregating Data Querying from Multiple Tables Creating and Deriving Data Common Query Patterns Working with Date and Time Values Strings Working with Numbers Managing Transactions Data Dictionary Common Reporting Problems Cleansing Data Tree-Structured Data Working with XML Data Partitioning LOBs Database Administration Object Management SQLMonitoring and Tuning Database Troubleshooting

This volume contains the proceedings of the International Middleware Con- rence, held in Leuven, Belgium during December 1-4, 2008. This year marked the ninth rendition of this annual conference in its current format initially - opted in 1998, aspiring to serve as the premier venue focusing exclusively on important middleware results. A lot has happened over the intervening 10-year span. Middleware has become pervasive in an increasinglyinterconnected world, with its concepts now securely embedded in the notional architectures driving forward the information age. The conference continues to be a focal point for important new initiatives and results for new generations of middleware. With each succeeding year, it has become an even more competitive publishing venue, further extending its selectivity this year as well. Of the 117 submissions, - ly 21 were able to receive acceptance invitations, for an acceptance rate of less than18%. Competitiveindeed. Additionally, thesesubmissionscontinuetocome from all over the globe, spanning authors from 23 countries. A truly world-wide endeavor. But other things have also changed as we turn the corner on the ?rst decade of this conference. In many ways, middleware has achieved signi?cant success where it really counts: in terms of technical innovations, advanced capabilities, successful ideas, and ?elded systems which permeate society, industry, gov- nment, and academia. With this success comes maturity

SQL Server 2005, Microsoft's next-generation data management and analysis solution, represents a huge leap forward. It comes with a myriad of changes that deliver increased security, scalability, and power--making it the complete data package. Used properly, SQL Server 2005 can help organizations of all sizes meet their data challenges head on. Programming SQL Server 2005 from O'Reilly provides a practical look at this updated version of Microsoft's premier database product. It guides you through all the new features, explaining how they work and how to use them. The first half of the book examines the changes and new features of the SQL Server Engine itself. The second addresses the enhanced features and tools of the platform, including the new services blended into this popular version. Each chapter contains numerous code samples-written in C# and compiled using the Visual Studio 2005 development environment-that show you exactly how to program SQL Server 2005. Programming SQL Server 2005 can help you: * Build, deploy, and manage enterprise applications that are more secure, scalable, and reliable * Maximize IT productivity by reducing the complexity of building, deploying, and managing database applications * Share data across multiple platforms, applications, and devices to make it easier to connect internal and external systems Because the goal of Programming SQL Server 2005 is to introduce all facets of Programming SQL Server 2005, it's beneficial to programmers of all levels. The book can be used as a primer by developers with little experience with SQL Server, as a ramp up to the new programming models for SQL Server 2005 for more experienced programmers, or as background and primer to specific concepts. Any IT professional who wants to learn about SQL Server 2005's comprehensive feature set, interoperability with existing systems, and automation of routine tasks will find the answers in this authoritative guide.

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.

Book + Content Update Program SQL Server 2016 High Availability Unleashed provides start-to-finish coverage of SQL Server's powerful high availability (HA) solutions for your traditional on-premise databases, cloud-based databases (Azure or AWS), hybrid databases (on-premise coupled with the cloud), and your emerging Big Data solutions. This complete guide introduces an easy-to-follow, formal HA methodology that has been refined over the past several years and helps you identity the right HA solution for your needs. There is also additional coverage of both disaster recovery and business continuity architectures and considerations. You are provided with step-by-step guides, examples, and sample code to help you set up, manage, and administer these highly available solutions. All examples are based on existing production deployments at major Fortune 500 companies around the globe. This book is for all intermediate-to-advanced SQL Server and Big Data professionals, but is also organized so that the first few chapters are great foundation reading for CIOs, CTOs, and even some tech-savvy CFOs. Learn a formal, high availability methodology for understanding and selecting the right HA solution for your needs Deep dive into Microsoft Cluster Services Use selective data replication topologies Explore thorough details on AlwaysOn and availability groups Learn about HA options with log shipping and database mirroring/ snapshots Get details on Microsoft Azure for Big Data and Azure SQL Explore business continuity and disaster recovery Learn about on-premise, cloud, and hybrid deployments Provide all types of database needs, including online transaction processing, data warehouse and business intelligence, and Big Data Explore the future of HA and disaster recovery In addition, this book is part of InformIT's exciting Content Update Program, which provides content updates for major technology improvements! As significant updates are made to SQL Server, sections of this book will be updated or new sections will be added to match the updates to the technologies. As updates become available, they will be delivered to you via a free Web Edition of this book, which can be accessed with any Internet connection. To learn more, visit informit.com/cup. How to access the Web Edition: Follow the instructions inside to learn how to register your book to access the FREE Web Edition.

As part of the Microsoft Office suite, Access has become the industry's leading desktop database management program for organizing, accessing, and sharing information. But taking advantage of this product to build increasingly complex Access applications requires something more than your typical how-to book. What it calls for is "Access Hacks" from O'Reilly.

This valuable guide provides direct, hands-on solutions that can help relieve the frustrations felt by users struggling to master the program's various complexities. For experienced users, "Access Hacks" offers a unique collection of proven techniques and tools that enable them to take their database skills and productivity to the next level. For Access beginners, it helps them acquire a firm grasp of the program's most productive features.

A smart collection of insider tips and tricks, "Access Hacks" covers all of the program's finer points. Among the multitude of topics addressed, it shows users how to:

work with Access in multi-user environments

utilize SQL queries

work with external data and programs

integrate Access with third-party products

Just imagine: a learning process without the angst. Well, "Access Hacks" delivers it with ease, thanks to these down-and-dirty techniques not collected together anywhere else.

Part of O'Reilly's best-selling Hacks series, "Access Hacks" is based on author Ken Bluttman's two decades of real-world experience in database programming and business application building. It's because of his vast experiences that the book is able to offer such a deep understanding of the program's expanding possibilities.

Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQL*Plus. This bestselling book--now updated for Oracle 10g--is the only in-depth guide to this interactive query tool for writing SQL scripts. It's an essential resource for any Oracle user.

The new second edition of "Oracle SQL*Plus: The Definitive Guide" clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQL*Plus--and maybe some you didn't realize you could perform.

With "Oracle SQL*Plus: The Definitive Guide," you'll expertly:

write and execute script files

generate ad hoc reports

extract data from the database

query the data dictionary tables

customize an SQL*Plus environment

and much more

It also includes a handy quick reference to all of its syntax options and an often-requested chapter on SQL itself, along with a clear, concise, and complete introduction.

This book is truly the definitive guide to SQL*Plus. It's an indispensable resource for those who are new to SQL*Plus, a task-oriented learning tool for those who are already using it, and an immediately useful quick reference for every user. If you want to leverage the full power and flexibility of this popular Oracle tool, you'll need this book.

Oracle Regular Expressions Pocket Reference is part tutorial and part quick-reference. It's suitable for those who have never used regular expressions before, as well as those who have experience with Perl and other languages supporting regular expressions. The book describes Oracle Database 10G's support for regular expressions, including globalization support and differences between Perl's syntax and the POSIX syntax supported by Oracle 10G. It also provides a comprehensive reference, including examples, to all supported regular expression operators, functions, and error messages.

The first edition of this book has been praised as "the best reference book available on the subject." This new edition, Programming ColdFusion MX, 2nd Edition, goes even further, documenting new techniques for using ColdFusion MX 6.1 to develop and serve dynamic web page content. This exhaustive guide covers everything from the basics to advanced topics, with numerous examples that you can use for your own applications.

The JDBC Pocket Reference offers quick look-ups for all methods of the standard JDBC classes. These include concise reviews of the procedures for common JDBC tasks such as connecting to a database, executing stored procedures, executing DDL and the like. You'll find documentation of the connect string formats for the most common databases, including Oracle, SQL-Server, and PostgreSQL. You'll even find information on working with large objects, and on using SQL99 user defined datatypes to work with object-relational data. Searching for this sort of material through large tutorials is frustrating and a waste of time, but this pocket-sized book is easy to take anywhere and makes finding the information you need a snap.

One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. Mark provides a number of handy SQL tuning tips, discusses the use of the DBMS_STATS package to manage database statistics, and shows you how to use outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify.

The "Oracle SQL*Plus Pocket Reference" is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQL*Plus. 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 SQL*Plus 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 SQL*Plus 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 SQL*Plus 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.

This is the first book to tie together the commercial world of Oracle and the free-wheeling world of open source software. It describes nearly 100 open source tools, from the widely applied (like Linux, Perl, and Apache) to the Oracle-specific (like Orasoft, Orac, OracleTool, and OraSnap). You'll learn where to find them, what their advantages are, and how to create and release new open source Oracle tools yourself.

If you are an Oracle DBA moving to Unix from another environment such as Windows NT or IBM Mainframe, you know that the commands you need to learn are far different from those covered in most beginning Unix books. In this handy pocket-sized book, Don Burleson introduces those Unix commands that you as an Oracle DBA most need to know.

A companion to Feuerstein's other bestselling Oracle PL/SQL books, this workbook presents a carefully constructed set of problems and solutions that will test your language skills and help you become a better developer. Three levels of exercises--beginner, intermediate, and expert--cover the full set of language features. These include variables, loops, exception handling, data structures, object technology, cursors, built-in functions and packages, PL/SQL tuning, and the new Oracle8i features (including Java and the Web).

Designed for both new programmers and those experienced in other languages, this book presents the core features of Oracle's PL/SQL language in an easy-to-read format. Learning Oracle PL/SQL will bring programmers up to speed on the most important aspects of PL/SQL, including web and Internet programming. Updated through Oracle9i, includes sample programs downloadable from examples.oreilly.com/learnoracle.

Despite the wide availability and use of SQL*Loader, few Oracle DBAs and developers know how powerful it really is. This book describes all of SQL*Loader's functions, including how to construct the necessary control files, load different types of data, and get the best performance. It 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).

You don't have to be a techie to use FileMaker Pro 13, but you do need to know what you're doing. With clear, step-by-step instructions, this friendly guide shows you how to create a powerful database that lets you do almost anything with your data. Whether you're running a business, printing a catalog, or planning a wedding, you'll discover how to customize your database and put it to work on several devices.

The important stuff you need to know: Get started. Tour FileMaker Pro's features and create your first database in minutes.Explore the entire platform. Use FileMaker on a desktop, server, WebDirect, or FileMaker Go.Catalog your data. View, sort, and shape information in dozens of ways.Create professional documents. Publish reports, invoices, and other documents with ease.Harness processing power. Use calculations and scripts to crunch numbers, search text, and automate tasks.Add visual power and clarity. Create colorful charts to illustrate and summarize your data.Think like a developer. Dive into advanced topics like relational databases, scripting, and designing for multiple devices.

This bestselling book helps you use FileMaker Pro quickly and efficiently, whether you're experienced with the program or just beginning.

Prepare for Microsoft Exam 70-761-and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: * Filter, sort, join, aggregate, and modify data * Use subqueries, table expressions, grouping sets, and pivoting * Query temporal and non-relational data, and output XML or JSON * Create views, user-defined functions, and stored procedures * Implement error handling, transactions, data types, and nulls This Microsoft Exam Ref: * Organizes its coverage by exam objectives * Features strategic, what-if scenarios to challenge you * Assumes you have experience working with SQL Server as a database administrator, system engineer, or developer * Includes downloadable sample database and code for SQL Server 2016 SP1 (or later) and Azure SQL Database Querying Data with Transact-SQL About the Exam Exam 70-761 focuses on the skills and knowledge necessary to manage and query data and to program databases with Transact-SQL in SQL Server 2016. About Microsoft Certification Passing this exam earns you credit toward a Microsoft Certified Solutions Associate (MCSA) certification that demonstrates your mastery of essential skills for building and implementing on-premises and cloud-based databases across organizations. Exam 70-762 (Developing SQL Databases) is also required for MCSA: SQL 2016 Database Development certification. See full details at: microsoft.com/learning

The FileMaker Pro 10 desktop database lets you do almost anything with the information you give it - especially with this book as your guide. Clear, thorough, and accessible, "FileMaker Pro 10: The Missing Manual" helps you get in, build your database, and get the results you need, whether you're running a business, pursuing a hobby, or planning your retirement. It's the ideal guide for non-technical and experienced folks alike. Each chapter in this fully updated edition covers the latest time-saving features of FileMaker Pro 10, including saved finds and a redesigned toolbar that reveals information and features more clearly than ever. You'll learn how to import information from the new Bento consumer database (Mac only), write scripts to make your database even easier to use, and send email without leaving FileMaker. This book helps you: 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; use your data to generate reports, correspondence, and other documents with ease; create, connect, and manage multiple tables and set up complex relationships that display just the data you need; crunch numbers, search text, or pin down dates and times with dozens of built-in formulas; and, outfit your database for the Web, and import and export data to other formats. You'll also get objective advice on which features are really useful, and which aren't. To make the most of this database, you need "FileMaker Pro 10: The Missing Manual" - the book that should have been in the box.

The Oracle database is one of the most popular in the world, and for good reason. It's compatible, scalable, portable, and capable of performing incredibly fast. The advantages Oracle holds over its competition come with a price, however--it's a highly complex database that's becoming more complex with every release. And this level of detail, of course, can begin to weigh on database administrators (DBAs).

Fortunately, the "Oracle DBA Pocket Guide" from O'Reilly is on the case. This handy reference is designed to help administrators make more effective use of their time by presenting a compact summary of DBA tasks in an easy-to-use form. With this book by your side, you'll have instant access to the most important concepts, best practices, tips, and checklists. Key topics include architecture, installation, configuration, tuning, and backup/recovery. Everything that you absolutely must know to do your job well is right there at your fingertips.

Moreover, the "Oracle DBA Pocket Guide" covers Oracle Database 9i, as well as its latest release, Oracle Database 10g. The first database designed for enterprising grid computing, Oracle Database 10g significantly reduces the cost of managing the IT environment with a simplified install, reduced configuration and management requirements, and automatic performance diagnosis and SQL tuning.

The latest in O'Reilly's line of bestselling Oracle titles, this book is an invaluable companion for any database administrator--new or experienced--interested in reviewing core Oracle concepts at a glance.