Database Programming

SQL is a query language used with relational databases. INSERT, UPDATE and DELETE manipulate tables while SELECT, FROM and WHERE are useful commands for returning data.

Oct 5, 2009 - Jennifer Graham

Structured query language (SQL) is used to create databases, and retrieve and manipulate data. It is the standard query language for relational database management system

Sep 17, 2009 - Jennifer Graham

At times in MYSQL an unnatural sort is required. This article presents an easy to maintain set of tables where sorting a table in any order can be easily defined.

Sep 2, 2009 - Don Waterfield

In MYSQL the sorting of recordset data can be easily setup and maintained with a few custom tables and a little thought.

Sep 1, 2009 - Don Waterfield

The advent of relational databases ushered in more efficient data storage practices. It lessened the unwanted duplication of data and made information more consistent.

Aug 30, 2009 - Jennifer Graham

When not properly linked, badly connected tables can cause inefficiency to data retrieval. Eventually the database needs to be fixed by hand, at cost.

Nov 30, 2008 - Harry P. Schlanger

A basic SQL concept that should be mastered is that of "joins." Joins allow for the display of data from different tables to be combined with specific relationships.

Jun 20, 2008 - Dan Hartshorn

SQL programming is at the heart of today's Web 2.0 applications. Learn the basic 4 commands SELECT, UPDATE, INSERT and DELETE.

Jun 17, 2008 - Dan Hartshorn

Ready to start programming SQL Server 2005? Here is a concise walk-through of the steps for obtaining and installing all the necessary software.

Jun 16, 2008 - Dan Hartshorn

An industry application written in Access 2007 is presented for inspection to learn how applications can be made more professional, using macros and VBA programming.

Apr 17, 2008 - Harry P. Schlanger