Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Databases

View:  
Sorted by:  

Storing Data with PHP — Flat File or Database?

Many applications require the long-term storage of information. In PHP scripts, you can make information available within sessions — periods of time that users spend at your Web site — by using methods [more…]

Creating a New User in Oracle9i

Creating a new life is a big responsibility — you have to feed it and change it every day for years. Creating a new user in Oracle9i also carries some responsibilities, but generally the user won't wake [more…]

Tuning Into Ten Short, Useful Perl Programs

Some people believe that short programs aren't good for very much, but that's not so with Perl. Just a couple lines of Perl code can go a long way. This article lists some handy teeny, tiny Perl programs [more…]

Building Protocol State Machines in UML 2

When you want to show the sequence of events an object reacts to — and the resulting behavior — you use the UML notation that creates behavioral state diagrams [more…]

Understanding WebLogic Database Access

Entity beans provide a convenient interface between your program and the database. These beans hold data that must eventually be stored in some permanent form, most commonly a relational database. J2EE [more…]

Discovering Database Things You Can Do with Oracle9i

You just installed Oracle9i. Now, it's time to learn something about databases and what they can do! Take a look at three scenarios to get a feel for what databases do in real life. Let your imagination [more…]

Acting on Agents in Unicenter TNG

Agents play an important role in the Unicenter TNG architecture. Agents are specialized programs that Unicenter TNG uses to monitor managed objects, which comprise network resources such as database servers [more…]

Modifying Oracle9i Object Tables and Object Types

Here you have an interesting problem. When you make an object table, you identify what object type is to be used for each row in the object table. The attributes that you see when you look at the table [more…]

Using Unicenter TNG to Enhance Performance Management

The Unicenter TNG performance management tools compile system utilization data and accounting data, enabling activities such as capacity planning, accounting charge-back for allocating computer system [more…]

Understanding Objects and the Oracle9i Database

Oracle9i technically can be called an object-relational database — that's something that's new to Oracle.This term means that Oracle9i contains all the features of a relational database combined with some [more…]

Setting Calendar Preferences in Goldmine

When you click the Calendar tab to display the Goldmine Calendar preferences dialog box, most of the choices are pretty self-explanatory. You can set up GoldMine to reflect your normal working hours and [more…]

The GoldMine Interface

If you are sitting in front of GoldMine for the first time, you will quickly become comfortable with the navigation because it's very much like many other applications. Read on to understand the Goldmine [more…]

How Goldmine 8.0 Differs from Goldmine 6.0

The Premium Edition of GoldMine contains the first truly significant upgrades to GoldMine since version 6. Not only are they significant, but these enhancements are truly positive, showing off FrontRange's [more…]

Backing Up Data with Unicenter TNG

ARCserveIT, the storage management segment of Unicenter TNG's Enterprise Management component, provides the software necessary to produce backups, restore data, and manage media. Backups can be tricky, [more…]

Tracking System Abuse with Unicenter TNG

Okay, you've set the rules and relayed them to the user community via company policy memos, e-mail reminders, self-service training exercises, and every other mode of communication you can think of. And [more…]

Discovering Everything that GoldMine Can Do

GoldMine tracks all the names, addresses, phone numbers, and basic contact information you will ever need. If you never use GoldMine as anything more than an electronic Rolodex, you will have gotten your [more…]

SQL Criteria for Normal Forms

To ensure that database tables are designed in such a way that they will hold your data reliably, you need to be sure that they are not subject to modification anomalies. Normalizing your databases will [more…]

SQL Data Types

Here’s a list of all the formal data types that ISO/IEC standard SQL recognizes. In addition to these, you may define additional data types that are derived from these. [more…]

SQL Value Functions

These SQL value functions perform operations on data. There are all kinds of operations that could conceivably be performed on data items, but these are some that are needed most often. [more…]

SQL WHERE Clause Predicates

Predicates boil down to either a TRUE or a FALSE result. You can filter out unwanted rows from the result of an SQL query by applying a WHERE clause whose predicate excludes the unwanted rows. [more…]

SQL Set Functions

The SQL set functions give you a quick answer to questions you may have about the characteristics of your data as a whole. How many rows does a table have? What is the highest value in the table? What [more…]

SQL For Dummies Cheat Sheet

This Cheat Sheet consists of several helpful tables and lists, containing information that comes up repeatedly when working with SQL. In one place, you can get a quick answer to a number of different questions [more…]

Crystal Reports 9 Expert Tools Toolbar

With the release of Crystal Reports 9 came the Database Expert and its toolbar. Through the Expert you can select and connect to a data source and perform other tasks. The Expert toolbar and its buttons [more…]

Crystal Reports 9 Insert Tools Toolbar

The business reports you create with Crystal Reports 9 can be enhanced with inserted materials such as tables, charts, and maps. The following figure shows the Crystal Reports 9 Insert Tools toolbar: [more…]

Crystal Reports 9 Standard Toolbar

You can produce great reports with Crystal Reports 9, and to help you do just that, you need to be familiar with the buttons on the basic toolbar. The following figure shows the Crystal Reports 9 standard [more…]

Advertisement

Sign Up for RSS Feeds

Computers & Software
Win an iPad Mini! Enter to win now.

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!