Excel as Your Database

Excel As Your Database guides those of you who need to manage facts and figures--yet have little experience, budget, or need for a full-scale relational database management system. You'll learn how to use Excel to enter, store, and analyze your data.

This book is written and organized in a way that assumes you have some familiarity with Excel, but not with databases. The book features quick-start solutions, practice exercises, troubleshooting tips, and best practices.

* This book covers Excel 2007 and 2003.
* The author clarifies not just how to use a technique, but under what realistic scenarios.
* The text features step-by-step, how-to procedures.
* Try-it-out exercises are based on realistic sample data.

Download Here

Oracle High Performance Tuning for 9i.and.10g

There are three parts to tuning an Oracle database: data modeling,
SQL code tuning and physical database configuration.

A data model contains tables and relationships between tables.
Tuning a data model involves normalization and de-normalization.
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.

Poorly written SQL code is often a culprit of performance problems
and is expensive to rectify. However, tuning of SQL code is
generally cheaper than changing the data model. SQL code tends to
be contained inside independent blocks within applications or
stored procedures.

Physical database tuning involves hardware resource usage,
networking and various other Oracle things such as configuration
and file distribution. Physical configuration is often a culprit of
poor performance where Oracle is installed with defaults, and never
altered by an expert.

Download Here

First Look 2007 Microsoft Office System

Book Description:

What�s inside the newest release of the Microsoft Office system? How will the new interface change the way you work and make you more self-sufficient and effective? How can your business put the new workflow capabilities to work right away in this new world of work? With FIRST LOOK 2007 MICROSOFT OFFICE SYSTEM, well-known author and columnist Katherine Murray gives you an special introduction to the next generation of Microsoft Office. You�ll get an expert overview of new and enhanced applications, features, and capabilities in addition to advance insights and straight talk from the Office product group, Discover the new user interface and revolutionize the way you use Office; learn about the Live Preview feature that allows you to see how a format will look before you make a change; introduce yourself to the new collaboration products and services, including Microsoft Office Groove. In addition, learn about enhancements to existing Office applications, including new graphics capabilities in Microsoft Office PowerPoint, easier database creation with Microsoft Office Access, easier time-management capabilities in Microsoft Office Outlook, and improved charting capabilities in Microsoft Office Excel.

It�s an exclusive, guided preview for business decision makers, early adopters, and users�and anyone else who wants to start planning and hit the ground running with the next generation of Office.

Download e-book

Windows Vista Inside Out

Book Description
Written by the authors of the immensely popular Microsoft Windows XP Inside Out, this book packs hundreds of timesaving solutions, troubleshooting tips, and workarounds for using the latest version of the Microsoft Windows operating systemall in concise, fast-answer format. Dig into the work-ready tools and resources that help you take your Windows Vista experience to the next level. Get the answers you need to use the new features of Windows Vista, including the sidebar and gadgets, and the Windows slideshow. Youll also discover how to use new features in Microsoft Windows Media Player and Microsoft Internet Explorer 7. Get up-to-date information on how to configure and customize your desktop, how to use new security-enhanced features, and more.

From the Publisher
Key Book Benefits:

-Award-winning INSIDE OUT format makes hundreds of tips, tricks, and workarounds easy to find and easy to use -Includes coverage of new features in Windows Vista, Windows Media Player, and Internet Explorer 7 -Details how to configure and customize your desktop and how to use security-enhanced features

Download Here