11g New Features of the SQL and PLSQL

Tuesday, May 31, 2011

Read more...

Oracle APEX Forms Conversion Overview Powerpoint Presentation

Monday, May 30, 2011

Read more...

Oracle The Java EE 6 Tutorial March 2011

Sunday, May 29, 2011



Document Information

Preface

Part I Introduction

1.  Overview

2.  Using the Tutorial Examples

Part II The Web Tier

3.  Getting Started with Web Applications

4.  JavaServer Faces Technology

5.  Introduction to Facelets

6.  Expression Language

7.  Using JavaServer Faces Technology in Web Pages

8.  Using Converters, Listeners, and Validators

9.  Developing with JavaServer Faces Technology

10.  JavaServer Faces Technology Advanced Concepts

11.  Configuring JavaServer Faces Applications

12.  Using Ajax with JavaServer Faces Technology

13.  Advanced Composite Components

14.  Creating Custom UI Components

15.  Java Servlet Technology

16.  Internationalizing and Localizing Web Applications

Part III Web Services

17.  Introduction to Web Services

18.  Building Web Services with JAX-WS

19.  Building RESTful Web Services with JAX-RS

20.  Advanced JAX-RS Features

21.  Running the Advanced JAX-RS Example Application

Part IV Enterprise Beans

22.  Enterprise Beans

23.  Getting Started with Enterprise Beans

24.  Running the Enterprise Bean Examples

25.  A Message-Driven Bean Example

26.  Using the Embedded Enterprise Bean Container

27.  Using Asynchronous Method Invocation in Session Beans

Part V Contexts and Dependency Injection for the Java EE Platform

28.  Introduction to Contexts and Dependency Injection for the Java EE Platform

29.  Running the Basic Contexts and Dependency Injection Examples

30.  Contexts and Dependency Injection for the Java EE Platform: Advanced Topics

31.  Running the Advanced Contexts and Dependency Injection Examples

Part VI Persistence

32.  Introduction to the Java Persistence API

33.  Running the Persistence Examples

34.  The Java Persistence Query Language

35.  Using the Criteria API to Create Queries

36.  Creating and Using String-Based Criteria Queries

37.  Controlling Concurrent Access to Entity Data with Locking

38.  Improving the Performance of Java Persistence API Applications By Setting a Second-Level Cache

Part VII Security

39.  Introduction to Security in the Java EE Platform

40.  Getting Started Securing Web Applications

41.  Getting Started Securing Enterprise Applications

Part VIII Java EE Supporting Technologies

42.  Introduction to Java EE Supporting Technologies

43.  Transactions

44.  Resource Connections

45.  Java Message Service Concepts

46.  Java Message Service Examples

47.  Advanced Bean Validation Concepts and Examples

48.  Using Java EE Interceptors

Part IX Case Studies

49.  Duke's Tutoring Case Study Example




Read more...

oracle9i database Real Application Clusters on Linux

Saturday, May 28, 2011

oracle9i database Real Application Clusters on Linux Powerpoint Presentation


Read more...

Managing RAID on Linux

Thursday, May 26, 2011



Description

Managing RAID on Linux covers everything system administrators need to know to put together a system that can support RAID. You will learn about the different types of RAID, along with associated technologies and issues, and how to choose the best RAID system for your needs. With a step-by-step, hands-on approach, the author guides you through the installation of either Linux software RAID or a hardware RAID card. 
Redundant Array of Independent Disks (RAID) technology is becoming a standard feature of computer systems that support mission-critical services like file sharing, mail exchange, or Web servers. RAID offers two benefits to these essential systems: improved I/O performance and fail-safe data storage.
Although bandwidth problems on networks are well documented, the internal data transfer bottleneck that exists at the hardware level in each system can also leave you with perplexing performance issues. RAID is a cost-effective and easy-to-manage way to alleviate this bandwidth problem by distributing the I/O load seamlessly across multiple disks and controllers.
RAID also provides uninterrupted data access through disk mirroring and parity algorithms. That means systems can remain online even during a disk or controller failure. RAID is scalable, making it robust enough for large, high-traffic sites and small, critical systems. By using RAID, system administrators can combine single disks into terabytes worth of data storage.
Managing RAID on Linux covers everything system administrators need to know to put together a system that can support RAID. You will learn about the different types of RAID, along with associated technologies and issues, and how to choose the best RAID system for your needs. With a step-by-step, hands-on approach, the author guides you through the installation of either Linux software RAID or a hardware RAID card. The book shows how to build an array and optionally install a high-performance file system. Contents include:
  • An introduction to RAID and Linux
  • Planning and architecture of your RAID system
  • Building a software RAID
  • Software RAID tools and references
  • Building a hardware RAID
  • Performance and tuning of your RAID system
RAID has become the low-cost solution of choice to deal with the ever-increasing demand for data storage space. Written for system administrators, power users, tech managers, and anyone who wants to learn about RAID technology, Managing RAID on Linux sidesteps the often-confusing vendor-specific approach you'll find elsewhere to give you the straight story on RAID. Even non-Linux users will find this book full of valuable material.


 

Read more...

D70842GC10 BEA WebLogic Portal 9/10: System Administration

Saturday, May 21, 2011

What you will learn
This course trains experienced BEA WebLogic Server 9/10 system administrators on the configuration and management of applications built with BEA WebLogic Portal 9/10. Students will learn how to stage and tune portal applications and their relational data, and to propagate these changes to a highly available production environment. Course labs have been validated on BEA WebLogic Portal 10.
 
Learn to:
Initialize a domain and database to support BEA WebLogic Portal applications
Propagate portal data from staging to production environments
Configure and secure portal desktop components

Prerequisites
BEA WebLogic Server domains, servers and clusters
BEA WebLogic Server performance tuning
Security realms and providers
Keystores and certificates
Data sources
Security Assertion Markup Language (SAML)
Familiarity with essential concepts of BEA WebLogic Portal
Ant scripting fundamentals
BEA WebLogic Server 9/10: Advanced System Administration


Course Objectives
Propagate portal data from staging to production environments
Manage and secure portal resources
Delegate portal administrative capabilities
Initialize a domain and database to support BEA WebLogic Portal applications
Manage federated portal resources
Configure and tune a content repository
Index and search content and other information using autonomy


Course Topics

Product installation

Portal production architecture

Portal domains and applications

Product database schema

Shared libraries

Portal deployment plans

BEA WebLogic Portal Administration Console

Portal desktop management

Community management

Federated portal administration

Content repository administration

User profile management

Visitor entitlements

Delegated administration

Portal cache manager

Autonomy search administration

Propagation tool

BEA AquaLogic Analytics

 

Read more...

D70800GC10 BEA WebLogic Portal 8.1 Develop Enterprise Portals Ed 1

This course trains experienced Web application developers to create sophisticated enterprise portals using the full capabilities of BEA WebLogic Portal 8.1. BEA WebLogic Workshop 8.1 is the development environment. This training prepares you to create real-world interactive, portal solutions that integrate with back end applications such as a content management system. You will become more productive designing and developing a highly interactive portal and maintaining real time information flow. This course features BEA Ed.Lab, a revolutionary learning environment offered exclusively by BEA. BEA Ed.Lab eliminates the gap between technical training and real-world implementation.
Learn to:
  • Build highly interactive portal applications
  • Develop personalization rules and user profiles to create a sophisticated user Web experience
  • Incorporate business processes, Web services and content from other Web sites into an enterprise portal



Read more...

D17276GC10 Oracle Database 10gReal Application Clusters Vol 2

Read more...

D17276GC10 Oracle Database 10g Real Application Clusters Vol-1


What you will learn

This course offers students an introduction to the general features and capabilities of Oracle Database 10g Release 1 for Oracle Real Application Clusters (RAC).

Students learn how to configure and administer a database for use with Real Application Clusters. The course also explains how to setup and use Automatic Storage Management (ASM) in a Real Application Clusters environment. Lectures are reinforced with hands-on practices designed to walk the student through the RAC administration.

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.


Audience
Database Administrators

Course Objectives
Identify Real Application Clusters components
Install, create, administer, and monitor a Real Application Clusters database
Use configuration and management tools for Real Application Clusters databases
Migrate your database storage to Automatic Storage Management
Setup services for workloads management, and applications high availability
Develop a backup and recovery strategy for Real Application Clusters databases
Review high availability best practices

Course Topics

Introduction
Define a cluster
Define Oracle Real Application Clusters
List the advantages of using RAC
Define scalability
High availability and RAC

Architecture and Concepts
List the various components of Cluster Ready Services (CRS) and Real Application Clusters (RAC)
Describe the various types of files used by a RAC database
Describe the various techniques used to share database files across a cluster
Describe the purpose of using services with RAC

RAC Installation and Configuration Part I
Outline Oracle 10g RAC Installation
Preinstallation Tasks
Cluster Setup Tasks
Installing OCFS
Installing Cluster Ready Services

RAC Installation and Configuration Part II
Install Database Software
Launching VIPCA with root.sh
Database Precreation Tasks
Creating the Cluster Database
Database Postinstallation Tasks
Administering Enterprise Manager Jobs in Real Application Clusters
Node Addition and Deletion and the SYSAUX Tablespace
AWR snapshots in RAC

RAC Database Instances Administration
Understand the EM Cluster Database Home Page
Starting and Stopping RAC Instances
RAC Initialization Parameter Files
Adding a Node to a Cluster
Deleting Instances from a RAC Database
Quiescing RAC Databases
Administering Alerts with Enterprise Manager

Administering Storage in RAC Part I
Describe automatic storage management (ASM)
Install the ASM software
Set up initialization parameter files for ASM and database instances
Start up and shut down ASM instances
Add ASM instances to the target list of Database Control
Use Database Control to administer ASM in a RAC environment

Administering Storage in RAC Part II
Manage redo log groups in a RAC environment
Manage undo tablespaces in a RAC environment
Use SRVCTL to manage ASM instances
Migrate database files to ASM
Manage and recover the OCR file and voting disk

Services
Configure and manage services in a RAC environment
Use services with client applications
Use services with the Database Resource Manager
Use services with the Scheduler
Set performance-metric thresholds on services
Configure services aggregation and tracing

High Availability of Connections
Configure client side connect-time load balancing
Configure client side connect-time failover
Configure server side connect-time load balancing
Benefit from Fast Application Notification (FAN)
Configure server-side callouts
Configure the server and client-side ONS
Configure Transparent Application Failover (TAF)

Managing Backup and Recovery in RAC
Configure RAC Recovery Settings with EM
Configure RAC Backup Settings with EM
Initiate Archiving
Configuring RMAN
RAC Backup and Recovery Using EM

RAC Performance Tuning
Determine RAC specific tuning components
Tune instance recovery in RAC
Determine RAC specific wait events, global enqueues, and system statistics
Implement most common RAC tuning tips
Use the Cluster Database Performance pages
Use Automatic Workload Repository and Automatic Database Diagnostic Monitor in RAC

Design for High Availability
Design a Maximum Availability Architecture in your environment
Determine the best RAC and Data Guard topologies for your environment
Configure the Data Guard Broker configuration files in a RAC environment
Patch your RAC system in a rolling fashion



Read more...

Oracle9i Real Application Clusters D34316 Oracle9i Real Application Clusters

Contents

What's New in Real Application Clusters?

Part I Cluster Database Processing Fundamentals

1 Introduction to Real Application Clusters

    What Is Real Application Clusters?
    The Benefits of Real Application Clusters

        Lower Overall Cost of Ownership
        Expanded Scalability
        High Availability
        Transparency
        Buffer Cache Management
        Row Locking
        Multiversion Read Consistency
        Recovery Manager, Online Backups, and Archiving

2 Real Application Clusters Systems Architecture

    Overview of Cluster Database System Components

        Nodes and Their Components
        Cluster Interconnect and Interprocess Communication (Node-to-Node)

    Memory, Interconnect, and Storage
    The High-Speed IPC Interconnect
    Shared Disk Storage and the Cluster File System Advantage

3 Real Application Clusters Software Architecture

    The Operating System-Dependent Clusterware

        The Cluster Manager
        The Node Monitor
        The Interconnect

    Real Application Clusters Shared Disk Components
    Real Application Clusters-Specific Daemon and Instance Processes

        The Global Services Daemon
        Instance Processes Specific to Real Application Clusters

    The Global Cache and Global Enqueue Service

        Application Transparency
        Global Resource Directory with Distributed Architecture
        Resource Mastering and Affinity
        GCS and GES Interaction with the Cluster Manager

4 Scalability in Real Application Clusters

    Scalability Features of Real Application Clusters
    All System Types Benefit from Real Application Clusters

        Transaction Systems and Real Application Clusters
        Data Warehouse Systems and Real Application Clusters

    Levels of Scalability

        Network Scalability
        Network Scalability and Client/Server Connectivity
        Operating System Scalability

Part II Resource Coordination in Real Application Clusters
5 Real Application Clusters Resource Coordination

    Overview of Real Application Clusters Resource Coordination

        The Contents of the Global Resource Directory
        Real Application Clusters Synchronization Processes
        Enqueues
        Past Images

    Resource Modes and Roles

        Resource Modes
        Resource Roles
        Global Cache Service Operations

    System Change Number Processing

        Lamport SCN Generation

6 Cache Fusion and the Global Cache Service

    Overview of Cache Fusion Processing

        Concurrent Reads on Multiple Nodes
        Concurrent Reads and Writes on Different Nodes
        Concurrent Writes on Different Nodes
        Write Protocol and Past Image Tracking

    Resource Control, Cache-to-Cache Transfer, and Cache Coherency
    Block Access Modes and Buffer States
    Cache Fusion Scenarios

        Requesting a Changed Block for a Modification Operation
        Writing Blocks to Disk

    Real Application Clusters Recovery and Cache Fusion

7 Resource Coordination by the Global Enqueue Service

    Global Enqueue Service Processing
    Global Enqueue Concurrency Control
    Resources Managed by the Global Enqueue Service

        Dictionary Cache Locks
        Library Cache Locks

Part III Implementing Real Application Clusters
8 Real Application Clusters Storage Considerations

    Overview of Storage in Real Application Clusters
    Datafiles in Real Application Clusters

        Datafile Verification in Real Application Clusters
        Adding Datafiles in Real Application Clusters

    Parameter File Storage in Real Application Clusters

        Location of the Server Parameter File

    Redo Log File Storage in Real Application Clusters
    Automatic Segment-Space Management
    Managing Undo Space in Real Application Clusters

        Private and Public Rollback Segments

9 Manageability Tools for Real Application Clusters Environments

    Overview of Manageability in Real Application Clusters
    Manageability for Real Application Clusters Installation, Setup, and Configuration
    Manageability for Real Application Clusters Administration

        Oracle Enterprise Manager
        The Database Configuration Assistant
        The Server Control (SRVCTL) Utility
        Global Services Daemon Administration Commands

    Manageability for Real Application Clusters Performance Monitoring

        Monitoring Performance with Oracle Enterprise Manager
        Monitoring Performance with Statspack

    Manageability for Real Application Clusters Backup and Recovery

Part IV High Availability and Real Application Clusters
10 High Availability Concepts and Best Practices in Real Application Clusters

    Understanding High Availability
    Configuring Real Application Clusters for High Availability

        Cluster Components and High Availability

    Disaster Planning
    Failure Protection Validation
    Failover and Real Application Clusters

        Failover Basics
        Client Failover
        Uses of Transparent Application Failover
        Server Failover

    Failover Processing in Real Application Clusters

        Detecting Failure
        Reorganizing Cluster Membership
        Performing Database Recovery

    High Availability Configurations

        Default N-Node Configurations
        Basic High Availability Configurations
        Shared High Availability Node Configurations
        Full Active Configurations with Real Application Clusters Guard II

    Deploying High Availability

Part V Reference
A Restrictions

    Compatibility
    Restricted SQL Statements
    Maximum Number of Datafiles

B Using Multi-Block Lock Assignments (Optional)

    When to Use Locks
    How to Use Locks
    Lock Granularity
    Understanding Lock Management




Read more...

Oracle Siebel CRM 8 Developer's Handbook

Friday, May 20, 2011


Oracle Siebel CRM 8 Developer's Handbook
Publisher: Pa.ckt Pu.blish.ing 2011 | 576 Pages | ISBN: 1849681864 | PDF + code | 12 MB + 1.3 MB

Oracle's Siebel CRM is market-leading Customer Relationship Management software. Unmatched in functionality and scalability, Siebel enhances a company's sales performance, improves customer satisfaction, and provides a robust Customer Relationship Management system for an organization.

Written by Oracle employee and Siebel expert, Alexander Hansal, this book is a complete practical guide to configuring, automating, and extending Siebel CRM applications. You will learn how to configure the Siebel CRM user interface objects as well as the underlying business layer objects by using real-life case study examples. In addition, you will learn to safely configure the Siebel data model.


You will learn how the object types in the Siebel Repository are related to each other and how they are organized in different layers. The book then teaches you to configure the Siebel CRM user interface objects such as views and applets as well as the underlying business layer objects by using real-life case-study examples. Always having one eye on performance and upgradeability, you will learn to safely configure the Siebel data model.


Understanding and using the Siebel event framework for automation is also a key focus area of the book. You will gain a thorough and solid understanding of integration objects to support EAI interfaces.


Chapters on Siebel Workflow, Task UI, and scripting prepare you for the most complex automation requirements and ensure that you hit the road running on your first Siebel implementation projects.


If you already consider yourself an experienced Siebel consultant, be prepared for some unprecedented insights and pro tips.


What you will learn from this book :


Understand object types and their relationships in the Siebel Repository

Learn how to use Siebel Tools
Create symbolic strings to support multi-lingual applications
Configure business components, joins, and fields
Configure static and dynamic pick lists
Create multi-value fields
Configure access control
Implement user properties to control special behavior
Create drill-downs and applet toggles to support navigation
Configure menu items and buttons using the Siebel event framework
Use preconfigured business services
Support EAI interfaces and reports with integration objects and EAI Siebel Adapter
Automate business processes with Siebel Workflow
Support process-based navigation with Siebel Task UI
Extend the Siebel business logic with scripting
Migrate configuration changes between environments with Application Deployment

Read more...

Achieving Extreme Performance with Oracle Exadata

Sunday, May 15, 2011





Achieving Extreme Performance with Oracle Exadata Summary:


M-gH | 2011 | ISBN: 0071752595 | 432 pages | PDF | 6,1 MB

Maximize Oracle Exadata Capabilities Leverage all of the powerful features available in the Oracle Exadata Database Machine using the proven techniques inside this Oracle Press guide. Written by Oracle experts, Achieving Extreme Performance with Oracle Exadata shows you how to take full advantage of this complete, optimized package of software, servers, and storage. Best practices for enterprise deployments, high availability, administration, backup and recovery, data warehousing, online transaction processing, consolidation, and migration are included in this authoritative resource. Take advantage of the tightly integrated hardware and software in the Oracle Exadata Database Machine
Work with Oracle Exadata software features, including Smart Scans, Oracle Exadata Hybrid Columnar Compression, storage indexes, Oracle Exadata Smart Flash Cache, and I/O Resource Manager
Understand Oracle Exadata Database Machine balanced hardware architecture
Architect, administer, and monitor Oracle Exadata Storage Servers
Deploy data warehouses on the Oracle Exadata Database Machine
Run online transaction processing (OLTP) workloads on the Oracle Exadata Database Machine
Consolidate databases with and migrate databases to the Oracle Exadata Database Machine.



Achieving Extreme Performance with Oracle Exadata



Read more...

IBM Cognos 8 Report Studio Cookbook





IBM Cognos 8 Report Studio Cookbook By Abhishek Sanghani
Publisher: Packt Publishing 2010 | 272 Pages | ISBN: 1849680345 | PDF | 7.5 MB

Over 80 great recipes for taking control of Cognos 8 Report Studio

Learn advanced techniques to produce real-life reports that meet business demands
Tricks and hacks for speedy and effortless report development and to overcome tool-based limitations
Peek into the best practices used in industry and discern ways to work like a pro
Part of Packt's Cookbook series-each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible

In Detail
Cognos Report Studio is widely used for creating and managing business reports in medium to large companies. It is simple enough for any business analyst, power user, or developer to pick up and start developing basic reports. However, when it comes to developing more sophisticated, fully functional business reports for wider audiences, report authors will need guidance.

This book helps you understand and use all the features provided by Report Studio to generate impressive deliverables. It will take you from being a beginner to a professional report author. It bridges the gap between basic training provided by manuals or trainers and the practical techniques learned over years of practice.

This book covers all the basic and advanced features of Report Authoring. It begins by bringing readers on the same platform and introducing the fundamental features useful across any level of reporting. Then it ascends to advanced techniques and tricks to overcome Studio limitations.Develop excellent reports using dimensional data sources by following best practices that development work requires in Report Studio. You will also learn about editing the report outside the Studio by directly editing the XML specifications.

Provide richness to the user interface by adding JavaScript and HTML tags. The main focus is on the practical use of various powerful features that Report Studio has to offer to suit your business requirements.

Learn techniques and hacks to make the best out of your Cognos 8 Report Studio.



IBM Cognos 8 Report Studio Cookbook

Read more...

Best java interview material - Java/J2EE Job Interview Companion 2nd Edition




This book is useful to the java beginners that are attending for interviews


SECTION 1 Interview questions and answers on:

Java

Fundamentals
Swing
Applet
Performance and Memory issues
Personal and Behavioral/Situational
Behaving right in an interview
Key Points

SECTION 2 Interview questions and answers on:

Enterprise Java

J2EE Overview
Servlet
JSP
JDBC / JTA
JNDI / LDAP
RMI
EJB
JMS
XML
SQL, Database, and O/R mapping
RUP & UML
Struts
Web and Application servers.
Best practices and performance considerations.
Testing and deployment.
Personal and Behavioral/Situational
Key Points

SECTION 3 Putting it all together section.

How would you go about…?


1. How would you go about documenting your Java/J2EE application?

2. How would you go about designing a Java/J2EE application?

3. How would you go about identifying performance problems and/or memory leaks in your Java application?

4. How would you go about minimizing memory leaks in your Java/J2EE application?

5. How would you go about improving performance of your Java/J2EE application?

6. How would you go about identifying any potential thread-safety issues in your Java/J2EE application?

7. How would you go about identifying any potential transactional issues in your Java/J2EE application?

8. How would you go about applying the Object Oriented (OO) design concepts in your Java/J2EE application?

9. How would you go about applying the UML diagrams in your Java/J2EE project?

10. How would you go about describing the software development processes you are familiar with?

11. How would you go about applying the design patterns in your Java/J2EE application?

12. How would you go about designing a Web application where the business tier is on a separate machine from the presentation tier. The business tier should talk to 2 different databases and your design should point out the different design patterns?

13. How would you go about determining the enterprise security requirements for your Java/J2EE application?

14. How would you go about describing the open source projects like JUnit (unit testing), Ant (build tool), CVS (version control system) and log4J (logging tool) which are integral part of most Java/J2EE projects?

15. How would you go about describing Service Oriented Architecture (SOA) and Web services?

SECTION 4 Emerging Technologies/Frameworks

Test Driven Development (TDD).
Aspect Oriented Programming (AOP).
Inversion of Control (IoC) (Also known as Dependency Injection).
Annotations or attributes based programming (xdoclet etc).
Spring framework.
Hibernate framework.
EJB 3.0.
JavaServer Faces (JSF) framework.

SECTION 5 Sample interview questions …

Java
Web Components
Enterprise
Design
General



Best java interview material - Java/J2EE Job Interview Companion 2nd Edition



Read more...

IBM Cognos 8 Business Intelligence: The Official Guide





Dan Volitich "IBM Cognos 8 Business Intelligence: The Official Guide"
McGraw-Hill Osborne Media | 2008-05-07 | ISBN: 0071498524 | 700 pages | PDF | 45 MB

The Only Authorized Guide to IBM Cognos 8 Business Intelligence

Develop, deploy, and maintain a complete BI solution across your enterprise. IBM Cognos 8 Business Intelligence: The Official Guide shows you how to take full advantage of the robust service-oriented architecture and simplified role-based user interfaces. Learn how to create, share, and analyze data-rich reports that lead to increased productivity and better business decisions. Featuring real-world insight and expert tips, this is a must-have guide for IBM Cognos 8 Business Intelligence users of all levels, from administrators to end users.

* Measure and monitor performance using dashboards and scorecards
* Assign user roles and privileges
* Provide complete and consistent access to a broad range of data sources via Cognos Connection
* Use Cognos 8 Go! to extend BI to Office applications, mobile devices, and search engines
* Enable business users to create reports with Query Studio
* Develop new insights by exploring data in multiple dimensions and perspectives with Analysis Studio
* Build Dimensional Reports with Report Studio
* Use Event Studio to identify and deliver mission-critical information
* Create, modify, organize, and publish a model from Cognos Framework Manager
* Implement sound security measures
* Take advantage of the management tools in Cognos Administration to ensure maximum reliability and availability

Also accompanies two bonus documents:
* IBM Cognos SQL Server Installation and Configuration Guide
* IBM Cognos Business Intelligence Certification Guide





IBM Cognos 8 Business Intelligence: The Official Guide


IBM Cognos Business Intelligence Certification Guide

Read more...

SQL Server Cheat Sheet

SQL Server Cheat Sheet


SQL Server Cheat Sheet

Read more...

Beginning SUSE Linux 2nd Edition



Beginning SUSE Linux 2nd Edition (Beginning: from Novice to Professional)

The book shows how to wield total control over your newly installed operating system. It will guide you through system customization opportunities and common tasks like listening to audio CDs and MP3s, watching movies, and performing office- and Internet-related tasks. A large part of the book is dedicated to advanced command-line techniques necessary to maintain your system and become a true Linux master!





Beginning SUSE Linux 2nd Edition


Read more...

Discovering SQL: A Hands-On Guide for Beginners

Sunday, May 8, 2011



Teaching the SQL skills that businesses demand when hiring programmers
If you're a SQL beginner, you don't just want to learn SQL basics, you also want to get some practical SQL skills you can use in the job market. This book gives you both. Covering the basics through intermediate topics with clear explanations, hands-on exercises, and helpful solutions, this book is the perfect introduction to SQL. Topics include both the current SQL:2008 standards, the upcoming SQL:2011 standards, and also how to use SQL against current releases of the most popular commercial SQL databases, such as Oracle, SQL Server, and MySQL.

Introduces SQL concepts, explains SQL statements, and clearly shows how to write efficient and effective SQL code
Uses a hands-on style and a sample database that incorporates all SQL concepts taught in the book; this database will be enhanced through the book as key points and lessons are covered
Covers topics such as how SQL interacts with the sample database via various interfaces, including vendor-provided utilities, programming languages, SQL clients, and productivity software
Includes appendices with primers on database normalization, set theory and bollean algebra, RDBMS software step-by-step setup guides, and database connectivity
Learn how to write effective, efficient SQL code with Discovering SQL: A Hands-On Guide for Beginners.



Discovering SQL: A Hands-On Guide for Beginners

Read more...

Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid

Saturday, May 7, 2011




everage Oracle Database 11g Release 2 High Availability Features Protect your critical business assets and achieve maximum database uptime using the detailed information in this Oracle Press guide. Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, Oracle Real Application Clusters, and Oracle Data Guard, Second Edition provides cost-effective solutions to current availability challenges. Discover how to grid-enable your IT framework, roll out Oracle Real Application Clusters, maintain standby databases, and deploy Oracle Flashback. Monitoring, tuning, and disaster recovery techniques are also covered in this comprehensive resource. Install Oracle Clusterware (as part of Oracle's grid infrastructure) or upgrade from an earlier version
Build test clusters and hosts using Oracle VM
Work with Oracle Automatic Storage Management and Oracle Automatic Storage Management Cluster File System
Create synchronized standby databases using Oracle Data Guard
Reliably archive and restore data with Oracle Recovery Manager
Use Oracle Flashback to identify and undo user errors
Configure Oracle Enterprise Manager Grid Control for management of an Oracle maximum availability architecture environment



Read more...

Database Fundamentals 1st Edition



From the preface: This book helps new database professionals understand database concepts with the right blend of breadth and depth of information. Who should read this book ? This book is tailored for new database enthusiasts, application developers, database administrators, and anyone with an interest in the subject and looking to get exposure such as university students and new graduates.
How is this book structured ? This book is divided into chapters, starting with the basic database concepts and information models in Chapter 1. Chapter 2 covers relational data models. Chapter 3 and 4 explain conceptual modeling and relational database design. In Chapters 5, 6 and 7 the focus is geared towards SQL. Chapter 8 highlights XML data storage and retrieval via SQL and XQuery. Chapter 9 addresses database security aspects. The book then concludes with an overview of various other key technologies and relevant applications that are increasingly popular in the industry today. Exercises and review questions can be found with most chapters. The solutions have been pred in Appendix A.



Read more...
Related Posts with Thumbnails

Sponser Links

Followers

Sponser Links

  ©2009-10 | Disclaimer

Back to TOP