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. Get a Solid Foundation in Oracle Database Technology Master Oracle Database 11g fundamentals quickly and easily. Using self-paced tutorials, this book covers core database essentials, the role of the administrator, high availability, and large database features. Oracle Database 11g: A Beginner's Guide walks you, step by step, through database setup, administration, programming, backup, and recovery. In-depth introductions to SQL and PL/SQL are included. Designed for easy learning, this exclusive Oracle Press guide offers: Core Concepts--Oracle Database 11g topics presented in logically organized chapters Critical Skills--Lists of specific skills covered in each chapter Projects--Practical exercises that show how to apply the critical skills learned in each chapter Progress Checks--Quick self-assessment sections to check your progress Notes--Extra information related to the topic being covered Mastery Checks--Chapter-ending quizzes to test your knowledge

Excel 2007 VBA Programming with XML and ASP offers a hands-on approach for those looking to extend and customize Excel functionality. From recording a simple macro and writing VBA code to working with XML documents and using ASP to access and display data, this book takes you on a programming journey that will change the way you work with Excel Learn how to: * Automate spreadsheet tasks with macros. * Write VBA code to program PivotTables, generate charts, build dialog boxes, and customize the Ribbon. * Handle errors and debug programs. * Create hyperlinks and publish HTML files. * Retrieve data from the web directly into Excel. * Develop and manipulate smart tags using XML.

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. Your One-Stop Guide to Enterprise Reporting with Crystal Reports 2008 Transform disconnected corporate data into compelling, interactive business intelligence using all of the powerful tools available in Crystal Reports 2008. Through detailed explanations, real-world examples, and expert advice, this comprehensive guide shows you how to create, maintain, and distribute dynamic, visually appealing enterprise database reports. Crystal Reports 2008: The Complete Reference explains how to select and gather pertinent business data, organize it into manageable groups, and assemble it into user-friendly business reports. You will learn how to improve report interactivity with sort controls and the parameter panel; solve complex reporting problems with cross-tabs and subreports; integrate Crystal Xcelsius dashboards; reduce development time; and publish your results to Web and Windows applications. Integrate pictures, multimedia files, graphs, and charts Allow user-controlled report sorting with new sort controls Develop sophisticated formulas and custom functions with the Formula Workshop Embed Flash files, including Xcelsius 2008 interactive dashboards Create complex cross-tab reports with new derived rows and columns Export reports into Word, Excel, Acrobat, and updated XML formats Enhance Web interactivity with the new parameter panel and optional parameter fields Work with SQL databases, OLAP cubes, and proprietary systems Centralize design elements and auto-update reports using the repository Schedule and distribute reports with the latest BusinessObjects Enterprise XI 3.0 Embed reports in Web and Windows applications using Visual Studio 2008

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. SQL Server 2005 is Microsoft's next-generation data management and analysis software designed to deliver increased scalability, availability, and security to enterprise data and analytical applications while making them easier to create, deploy, and manage. Filled with practical solutions and real-world examples, this resource includes full details on: Enterprise data management capabilities, including security and clustering Powerful developer tools -- T-SQL, .NET CLR, XML, ADO.NET 2.0 Business Intelligence features, such as Integration Services, data warehousing, and reports

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. Build and manage a scalable storage infrastructure with Oracle Automatic Storage Management Streamline data management and provisioning using Oracle Automatic Storage Management (Oracle ASM) and the detailed information contained in this exclusive Oracle Press resource. Written by a team of database experts, Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide explains how to build and maintain a dynamic, highly available Oracle database storage environment. Inside, you'll learn how to configure storage for Oracle ASM, build disk groups, use data striping and mirroring, and optimize performance. You'll also learn how to ensure consistency across server and storage platforms, maximize data redundancy, and administer Oracle ASM from the command line. Manage Oracle ASM Instances and configure Oracle RDBMS instances to leverage Oracle ASM Define, discover, and manage disk storage under Oracle ASM Create external, normal-redundancy, and high-redundancy disk groups Add and remove Oracle ASM storage without affecting RDMS instance availability Learn how Oracle ASM provides even I/O distribution Work with Oracle ASM directories, files, templates, and aliases Improve storage performance and integrity using the ASMLIB API Simplify system administration with the Oracle ASM command line interface Understand key internal Oracle ASM structures and algorithms

Targeting the data warehouse professional, this book provides tips on how to glean hidden trends and correlations from terabytes of Oracle data using proven tools such as SAS and ODM. Instructions for performing complex predictive analysis are also included.

SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, developer, and business intelligence (BI) developer. It is no longer unheard of to have 20-terabyte databases running on a SQL Server. SQL Server administration used to just be the job of a database administrator (DBA), but as SQL Server proliferates throughout smaller companies, many developers have begun to act as administrators as well. Additionally, some of the new features in SQL Server are more developer-centric, and poor configuration of these features can result in poor performance. SQL Server now enables you to manage the policies on hundreds of SQL Servers in your environment as if you were managing a single instance. We've provided a comprehensive, tutorial-based book to get you over the learning curve of how to configure and administer SQL Server 2008. Whether you're an administrator or developer using SQL Server, you can't avoid wearing a DBA hat at some point. Developers often have SQL Server on their own workstations and must provide guidance to the administrator about how they'd like the production configured. Oftentimes, they're responsible for creating the database tables and indexes. Administrators or DBAs support the production servers and often inherit the database from the developer. This book is intended for developers, DBAs, and casual users who hope to administer or may already be administering a SQL Server 2008 system and its business intelligence features, such as Integration Services. This book is a professional book, meaning the authors assume that you know the basics about how to query a SQL Server and have some rudimentary concepts of SQL Server already. For example, this book does not show you how to create a database or walk you through the installation of SQL Server using the wizard. Instead, the author of the installation chapter may provide insight into how to use some of the more advanced concepts of the installation. Although this book does not cover how to query a SQL Server database, it does cover how to tune the queries you've already written. The first ten chapters of the book are about administering the various areas of SQL Server, including the developer and business intelligence features. Chapter 1 briefly covers the architecture of SQL Server and the changing role of the DBA. Chapters 2 and 3 dive into best practices on installing and upgrading to SQL Server 2008. Managing your SQL Server database instance is talked about in Chapter 4. This chapter also describes some of the hidden tools you may not even know you have. Once you know how to manage your SQL Server, you can learn in Chapter 5 how to automate many of the redundant monitoring and maintenance tasks. This chapter also discusses best practices on configuring SQL Server Agent. Chapters 6 and 7 cover how to properly administer and automate many tasks inside of the Microsoft business intelligence products, such as Integration Services and Analysis Services. Developers will find that Chapter 8 is very useful, as it covers how to administer the development features, such as SQL CLR. Chapter 9 explains how to secure your SQL Server from many common threats and how to create logins and users. Chapter 10 covers how to create a SQL Server project and do proper change management in promoting your scripts through the various environments. It also covers the Policy-Based Management framework in SQL Server. Chapters 11 through 15 make up the performance tuning part of the book. Chapter 11 discusses how to choose the right hardware configuration for your SQL Server in order to achieve optimal performance. After the hardware and operating system is configured, Chapter 12 shows you how to optimize your SQL Server instance for the best performance. Chapter 13 describes how to monitor your SQL Server instance for problematic issues such as blocking and locking. Chapters 14 and 15 discuss how to optimize the T-SQL that accesses your tables and then how to index your tables appropriately. Chapters 16 through 20 consist of the high-availability chapters of the book. Chapter 16 covers how to use the various forms of replication, while database mirroring is covered in Chapter 17. Classic issues and best practices with backing up and recovering your database are discussed in Chapter 18. Chapter 19 dives deeply into the role of log shipping in your high-availability strategy, and Chapter 20 presents a step-by-step guide to clustering your SQL Server and Windows 2008 server. This edition of the book covers all the same great information we covered in the last book, and we've added loads of new content for SQL Server 2008, which adds numerous new features to improve the DBA's life. In short, the new version of SQL Server focuses on improving your efficiency, the scale of your server, and the performance of your environment, so you can do more in much less time, and with fewer resources and people. This means you can manage many servers at one time using Policy-Based Management, scale your I/O load using compression, and collect valuable information about your environment using data collectors, to name just a few key new features. To follow the examples in this book, you will need to have SQL Server 2008 installed. If you wish to learn how to administer the business intelligence features, you need to have Analysis Services and the Integration Services components installed. You need a machine that can support the minimum hardware requirements to run SQL Server 2008; and you also need the AdventureWorks2008 and AdventureWorksDW2008 databases installed. Instructions for accessing these databases can be found in the ReadMe file on this book's Web site. Some features in this book (especially in the high-availability part) require the Enterprise or Developer Edition of SQL Server. If you do not have this edition, you will still be able to follow through some of the examples in the chapter with Standard Edition.

Asynchronous JavaScript and XML (Ajax) is a web technique used to transfer data between a browser and server asynchronously without posting the web page to the server. "Asynchronously" implies that the processing of the web page continues while the Ajax request is sent to the server and a response is received from the server. The web page, or section(s) of the web page, is refreshed with the Ajax response without reposting the web page. Ajax has the following advantages over non-Ajax web applications.

- Reduced response time and reduced server load, as the complete web page is not reposted.

- Reduced bandwidth of web applications as only data is transferred and the HTML format is applied in the browser.

- Separation of data, format and style.

The book covers web search and RSS Feed with Ajax as well as form validation with Ajax frameworks for Java, JSP, JSF, and PHP. It discusses using Ajax in Oracle JDeveloper and is IDE based. JDeveloper has the following advantages over Eclipse IDE.

- JDeveloper 11g provides an integrated JavaScript Editor for Ajax/Web development.

- It also provides a PHP extension.

- JDeveloper has a built-in support for JSF and for JDBC.

This unique book focuses on removing the guesswork from creating dynamic web pages with Oracle content. Packed with working code examples, this book shows working examples of connecting to Oracle and delivering data into an HTML page. This indispensable reference shows working examples of complex Oracle queries in PHP, updating Oracle from PHP, and passing parameters to a PHP program.

This is a practical guide to working with the Oracle 10g v10.2 database from Visual Studio .NET 2005, using Oracle Data Provider for .NET and Oracle Developer Tools. ODP.NET optimizes Oracle database access from a .NET environment, allowing developers to leverage advanced Oracle database functionality, including Real Application Clusters, XML DB, and advanced security, using VB.NET, C#, or any .NET language. With many hands-on examples the book provides the in-depth information to use ODP.NET and Oracle Developer Tools from Visual Studio 2005. After introducing ODP.NET, it covers using SQL, PL/SQL, LOBs, and XML DB through ODP.NET; developing Web Applications, Web Services, and Mobile Applications; and finally Oracle Developer Tools for VS.NET. All the code examples use Visual Basic.NET 2005. This book is for professional .NET developers with a minimum knowledge of Oracle SQL and PL/SQL who need to work with and take full advantage of the Oracle Database 10g using Visual Studio 2005.

Beginners/Intermediate. The quickest and easiest way to learn Microsoft Access 2003. "Microsoft Access 2003 With Examples" is a step-by-step approach to building and maintaining your database. It is full of practical examples and tips. With screen-by-screen illustration you can learn fast. With examples and illustrations you can learn Microsoft Access 2003 and start building your own databases in no time. Master the essentials of designing and building a database. Create effective tables and queries. Create professional looking forms and reports. Import, export data from different sources and databases. Create web pages with your database. Secure your database from unauthorized users. Analyze your data.

Designed to exploit Oracle 10g's SQL, this book takes a comprehensive look at Oracle 10g's analytical functions, MODEL statements, and regular expressions. In addition, the book covers collection objects and object-oriented structures and introduces new Oracle 10g topics such as XML and statistical functions. The authors' logical and developmental approach to query building includes a review of older Oracle tools to help in the transition to newer material. This text will teach the reader how to format result sets with SQL*Plus reporting tools; use aggregate functions for partitioning, ordering, and reporting; perform calculations with the MODEL statement; search within strings using regular expressions; work with collection objects; handle XML within SQL.

Do you have tons and tons of data on your computer but you're not quite sure how to make heads or tails of them-or even organize them? Are you using Access as spreadsheet rather than what it was really meant for? If you have trouble finding meaning in your data, then Access 2007 Forms & Reports for Dummies let you discover the wonders of this highly useful program. This no-nonsense guide gets right down to business by showing you the easy way to use this powerful tool. It gets you started with selective, targeted queries; forms that improve efficiency; and reports that communicate-while sparing you of any fancy language. This hands-on guide features clear, concise instructions that show you how to: * Orient yourself with forms and reports * Create and modify queries * Build and edit forms * Design and update reports * Troubleshoot queries, forms, and reports * Make your forms useful * Add multiple tables to forms * Add finishing touches to reports Thanks to the included references, Web sites, and informative tips, putting your data to good use has never been easier. You'll even add some pizzazz to your reports with handy suggestions on ways to wow your viewers. With Access 2007 Forms & Reports for Dummies, you will be creating effective queries, forms, and reports in no time!

Gain the Competitive Edge with the Ultimate Resource on BusinessObjects XI Release 2.

. Publish actionable business reports across your enterprise using BusinessObjects XI and the detailed information contained in this one-stop resource. "BusinessObjects XI: The Complete Reference" explains, step-by-step, how to design and build powerful universes, integrate security, execute efficient queries, and distribute the results..

. You'll learn how to create an implementation strategy that fits your business goals, define and manage users, and integrate your reports into Web and Windows applications. All of the new and updated features of BusinessObjects XI Release 2 are covered in full detail, including the new architecture, Designer, security through the Central Management Console, InfoView, Web Intelligence, Desktop Intelligence, report scheduling, and auditing usage..

. Develop a visionary BusinessObjects XI deployment strategy. Migrate existing deployments to BusinessObjects XI Release 2. Use Designer to create robust universes aligned with the business goals that empower users to answer their own questions. Design and implement security policies that fit your company's needs. Monitor system usage and develop deployment practices for mission-critical BI. Translate complex business questions into simple, efficient Web Intelligence queries. Design reports that facilitate insight with richly formatted tables, charts, alerters, and report formulas. Reach more users with the power of interactive reports to dynamically sort, filter, rank, and drill through to detail at a simple mouse-click

This is a unique, one-volume guide to the administration and management of the Oracle database. Fully revised and updated from its best-selling 9i predecessor, this edition covers all new features, with fully field-tested examplesnot just "showcase" examples.

This book covers the new 10g management and performance tools and provides essential primers on Unix, Linux and Windows NT administration and on core SQL and PL/SQL programming techniques. And it provides everything the new and aspring Oracle DBA needs to build and admisiter complex Oracle 10g databases.

But there's a second stronger reason for writing this book which stands taller than the readers demand and that is SQL Server itself. Almost 90 per cent projects in software industry need databases or persistent data in some or other form. When it comes to .NET persisting data SQL Server is the most preferred database to do it. There are projects which use Oracle, DB2 and other database product, but SQL Server still has the major market chunk when language is .NET and especially operating system is windows. I treat this great relationship between .NET, SQL Server and Windows OS as a family relationship. In my previous book we had only one chapter which was dedicated to SQL Server which is complete injustice to this beautiful product. So why an interview question book on SQL Server? If you look at any .NET interview conducted in your premises both parties (Employer and Candidate) pay no attention to SQL Server even though when it is such an important part of development project. They will go talking about stars (OOP, AOP, Design patterns, MVC patterns, Microsoft Application blocks, Project Management etc etc). I am not saying these things are not important but if you see in development or maintenance majority time you will be either in your IDE or in SQL Server. Secondly many candidates go really as heroes when answering questions of OOP, AOP, Design patterns, architecture, remoting and others but when it comes to simple basic question on SQL Server like SQL, indexes (Forget DBA level questions) they are completely out of track. Third very important thing IT is changing people expect more out of less. That means they expect a programmer should be architect, coder, tester and yes and yes a DBA also. There where times and it will still exist for mission critical data that there will be separate positions for DBA's. But now many interviewers expect programmers to also do a job of DBA, Data warehousing etc. This is the major place where developers lack during facing these kinds of interview. So this book will make you walk through those surprising questions which can sprang from SQL Server aspect. I have tried to not go too deep as that will defeat the complete purpose of an "Interview Question" book. I think that an interview book should make you run through those surprising question and make you prepare in a small duration (probably with a night or so). I hope this book really point pitfalls which can come during SQL Server Interview's. I hope this book takes you to a better height and gives you extra confidence boost during Interviews. SQL Server is the database flagship of Microsoft. It's probably the only best database product when doing projects with windows and its rule the windows family like a king. "SQL Server 2005", its recent release is packed with probably the best features like .NET integration, Data warehousing and mining concept which makes it one of the best product for both DBA's and programmers. This book goes how to tackle interview questions related to this product and get you in to a decent position.

"This book should satisfy those who want a different perspective than the official Oracle documentation. It will cover all important aspects of a data warehouse while giving the necessary examples to make the reading a lively experience."
- Tim Donar, Author and Systems Architect
for Enterprise Data Warehouses
Tuning a data warehouse database focuses on large
transactions, mostly requiring what is known as throughput. Throughput is the passing of large amounts of information through a server, network
and Internet environment, backwards and forwards, constantly! The ultimate objective of a data warehouse is the production of meaningful and useful reporting, from historical and archived data. The trick is to make the reports print within an acceptable time frame.
A data model contains tables and relationships between tables. Tuning a data model involves Normalization and Denormalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model.
* Takes users beyond basics to critical issues in running most efficient data warehouse applications
* Illustrates how to keep data going in and out in the most productive way possible
* Focus is placed on Data Warehouse performance tuning

The new Oracle Application Server offers a wide range of functionality, including Java runtime and development tools, portal development tools, business intelligence, single sign-on identify management, and much more. It's so powerful and complex, in fact, that many people who use the product (or are considering using it) are familiar with only a portion of the entire range of its capabilities. The choices can be overwhelming. Few people grasp how the larger issues--such as the interplay between components or the various architectural choices in the product--play out in the Oracle Application Server.

This new guide provides the perfect introduction to the Oracle Application Server for users of any level. Regardless of which of the server's capabilities you use, you'll benefit from this tightly focused, all-in-one technical overview. It's written for anyone who is concerned with using and managing web servers, doing Java development and deployment, using Oracle's own tools--like Forms and Reports, using or developing for Oracle Portal, or those who use and administer business intelligence, mobile or integration software.

Divided into three concise sections, the book covers server basics, core components, and server functionality. The book leads with the history of Oracle Application Server, its architecture, management, standards, and third-party support for languages and tools such as Java, Perl, and HTTP. The next section covers Oracle's web server, containers for Java web caching, and the server's security features. And finally, the book discusses HTML development, Java development, and Oracle development. Although the book refers mainly to Oracle Application Server 10g, theauthors also describe features in earlier product releases where necessary, particularly Oracle9i Application Server.

More comprehensible than a large reference and more detailed than a primer, the book provides a foundation for understanding and using Oracle Application Server effectively and efficiently. Readers concentrate on the most important issues and components of the server, focusing primarily on principles rather than syntax. Designed to be the ideal first OracleAS book, "Oracle Application Server 10g Essentials" offers Oracle application developers and administrators everything they need to know about this powerful server.

The essential reference for PL/SQL has been revised and expanded, featuring all new examples throughout based on the new Oracle Database 10g sample schema plus a CD with all the book’s code as well as development environments. Written by a senior member of the technical staff on the Diagnostics and Defect Resolution (DDR) team in Oracle’s Server Technologies Division.

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. Troubleshoot, tune, and optimize your Oracle database efficiently and successfully every time This book explains how to take full advantage of the revolutionary Oracle Wait Interface to quickly pinpoint--and solve--core problems and bottlenecks, and increase productivity exponentially.

Oracle security expert David Knox explains how to design and develop an integrated, secure Oracle environment.
“In my experience in the security world, including 32 years at the Central Intelligence Agency, I’ve not found anyone with more experience in the theory and practice of protecting your data than David Knox.” --Dave Carey, former Executive Director of the CIA

Survival Guide for System Administrators

Configure, manage, and optimize SQL Server 2000 for peak performance with help from this unique resource. Inside, you'll find immediate solutions to problems involving database and server settings, multiple instances, startup parameters, service packs, stored procedures, and much more. The book also covers the many administrative features built in to SQL Server 2000, including SQL Server Agent, Enterprise Manager, Multi Server Administration, and System Monitor. Get this book and save yourself hundreds of hours of troubleshooting time.

• Manage SQL Server, including memory and security
• Optimize and automate administration using SQL Server Agent and other tools
• Debug jobs
• Monitor and tune SQL Server using the system monitor and alerts
• Optimize T-SQL and stored procedures
• Scale SQL Server using linked servers and Distributed Partitioned Views (DPVs)
• Troubleshoot database performance
• Implement disaster recovery procedures

TAKE COMMAND--Specific command-line utilities relating to the topic at hand

CODE BLUE--Things to do when your system is in trouble

BUG ALERT--Common and little-known problems and pitfalls

Develop Integrated Mobile Applications

Design, deploy, and manage flexible mobile applications on the Oracle platform. From the exclusive publishers of Oracle Press Books, Oracle9"i Mobile explains how to use and extend the mobile services available in Oracle9"iAS Wireless and integrate with other Oracle technologies. Mobilize any e-business, reach new customers, and deliver critical information to mobile users with the most scalable and reliable mobile infrastructure available.Administer wireless services with Oracle9"iAS Wireless Take advantage of Oracle9"iAS Wireless prebuilt services Build applications in Oracle9"iAS Wireless multichannel XML and Java/JSP Use transcoding to adapt and mobilize legacy applications Develop location-based features into your mobile applications Use Mobile Personal Information Management and Mobile E-mail services Implement Oracle9"iAS Wireless mCommerce Service Build, test, and deploy mobile applications using the Oracle9"iAS Mobile Studio

“In this book, Mr. Price takes you from making simple database connections to using object-relational features and covers such essential topics as Oracle9IAS Containers for J2EE (OC4J), JDeveloper, and performance tuning. Read this book and learn how to leverage the full power of Oracle’s implementation of JDBC.”
--Thomas Kurian, Senior Vice President, Oracle Server Technologies, Oracle Corporation

From the authentic Oracle Press comes the definitive guide to writing JDBC programs for use with the Oracle8i and Oracle9i databases, including details on Oracle extensions. In addition, JDBC support in the Oracle9i database as well as in Oracle9i Internet Application Server (via the containers for J2EE) is covered.

Explore connectivity options, then delve into optimization methods that can be implemented in the Crystal environment, including the use of SQL Expressions and SQL Commands. Coverage includes an execution plan, optimization of indexes, and reduction of parsing, and Oracle-specific features such as external tables, Heterogeneous Connectivity, and Oracle Flashback. Common difficulties when using Oracle are described, and solutions provided.