IMDb Launching a Database and Social Network for Music?
Saturday, December 1st, 2007Conditional Compilation for Oracle Database 10g
Thursday, November 15th, 2007In this fifth part of a nine-part series on PL SQL you ll learn how conditional compilation lets you compile selected parts of a program when you re working with Oracle Database 1 g. It is excerpted from chapter 2 of the book em Oracle PL SQL ...
Compiling PL/SQL Code for an Oracle Database
Thursday, November 1st, 2007In this third part of a nine-part series on managing PL SQL code you ll learn how to compile PL SQL source code how to use the optimizing compiler and more. It is excerpted from chapter 2 of the book em Oracle PL SQL Programming ...
Database Details and PHP
Thursday, June 28th, 2007Picking up from where we left off last week we ll be discussing shortcuts query responses metadata and more. This article is excerpted from chapter eight of the book em Programming PHP Second Edition em written by Kevin Tatroe Rasmus ...
Database Techniques and PHP
Thursday, June 21st, 2007Picking up where we left off last week in our discussion of databases and PHP we ll talk about connecting issuing a query and more. This article is excerpted from chapter eight of the book em Programming PHP Second Edition em written ...
PHP, MySQL and the PEAR Database
Thursday, May 31st, 2007In this conclusion to a three-part series you will add PEAR into the mix of what you have already learned. This article is excerpted from chapter 9 of em Learning PHP and MySQL em written by Michele Davis and Jon Phillips O Reilly ...
Storing PHP Sessions in a Database
Wednesday, May 2nd, 2007There are many reasons to utilize sessions when creating a web-based application using PHP. Session information by default is stored in a file on your web server. But what if that becomes a problem In this article I ll talk about why you might want to ...
Oracle Database Fundamentals
Tuesday, May 1st, 2007In this article we will mainly focus on basic database development using Oracle. We will learn how to create new tables alter them insert data into the database update data retrieve data delete data and drop tables. We have lots to do so let ...
Abstracting Database Access Using Polymorphism with Objects in PHP 5
Wednesday, March 21st, 2007Polymorphism is an object-oriented programming concept that can be difficult to understand. This article the first of a three-part series walks you through the basics of Polymorphism so that you can make use of it in your own applications. The specific example in this article will show you ...
Optimizing the Logical Database Structure
Friday, August 25th, 2006In this final article of our series you will learn more ways of organizing your data to achieve better query performance. It is excerpted from chapter 13 of the em MySQL Certification Guide em written by Paul Dubois et al. Sams 2 ...
Advanced MySQL Database Administration
Saturday, July 8th, 2006If you need to administer MySQL this article gets you off to a good start. In this section we discuss running multiple MySQL servers on the same machine and the MySQL Query cache. The final installment of a multi-part series it is excerpted from chapter four ...
Disaster Prevention and Recovery with the MySQL Database
Thursday, June 22nd, 2006If you need to administer MySQL this article gets you off to a good start. In this section we discuss the issues of disaster prevention and recovery. The fifth of a multi-part series it is excerpted from chapter four of the book em MySQL Administrator s ...
MySQL Database Administration
Thursday, May 25th, 2006If you need to administer MySQL this article gets you off to a good start. The first of a multi-part series it is excerpted from chapter four of the book em MySQL Administrator s Guide em written by Paul Dubois Sams ISBN ...
Storing Sessions in a Database
Monday, May 1st, 2006I've added another free article to my growing collection: Guru Speak: Storing Sessions in a Database This article creates the necessary functions in steps, so that you hopefully better understand the final product and can make your own modifi...
Database Programming in Python: Accessing MySQL
Wednesday, February 22nd, 2006While data storage for applications is no longer considered complex it is now simplified to the point that flexibility is sacrificed. There is a good compromise however. In this article you will learn how to access a a MySQL database with Python.... (Advertisement) Refurbished and Used Networking Equipment ...
Database Design Using Key-Value Tables
Monday, February 13th, 2006In the following article we are going to cover the use of key-value tables in a database design. They can help you with flexibility in design but will trip you up in other areas such as data filtering if you are not careful. I assume that the ...
Upgrading to Oracle Database 10g, concluded
Thursday, February 2nd, 2006Want to upgrade to Oracle Database 1 g but not sure how Fortunately there are a number of ways to do it. This article the second of two parts describes these methods and guides you as to which one to use depending on your ...
Upgrading to Oracle Database 10g
Thursday, January 26th, 2006Want to upgrade to Oracle Database 1 g but not sure how Fortunately there are a number of ways to do it. This article the first of two parts describes these methods and guides you as to which one to use depending on your ...
Large Database Features In Oracle, conclusion
Thursday, December 15th, 2005When you are working with large databases with Oracle Database 1 g there are certain topics with which you need to be familiar. These topics are covered in this article which is the second of two parts. It is excerpted from chapter nine of the book em ...
Large Database Features In Oracle
Thursday, December 8th, 2005When you are working with large databases with Oracle Database 1 g there are certain topics with which you need to be familiar. These topics are covered in this article the first of two parts. It is excerpted from chapter nine of the book em Oracle Database ...
