Database Programming
Feature Writer Articles in Database Programming
|
How to Use a MySQL Database in a Perl Program
A MySQL database will always form a suitable backend for any application, and the Perl programmer will find that this can be achieved very easily.
|
|
How to Use Business Rules in a MySQL Database
Business rules are incredibly important to every organisation. They can be made application independent by placing them in a MySQL database.
|
|
How To Create an OpenOffice.org Database Log On
When looking an OpenOffice.org database there is no way of adding user accounts. Not directly, anyway. The secret is to use a little bit of SQL.
|
|
How to Create a Self Registering Base Database
With the release of OpenOffice.org 3.1 the programmer can do something important. They can add a macro to a database and they can run it automatically.
|
|
How to Create OpenOffice.org Database Macros
Release 3.1 of OpenOffice.org gives programmers a new facility - the ability to save macros as part of a database file.
|
|
How to Update A MySQL Database with C#
It is important to keep the contents of a database up to date. It's fortunate, therefore, that C# and the MySQL .NET connector make that an easy task.
|
|
How to Add Records to MySQL With C#
As well as viewing data in a MySQL database, a C# programmer can add information by using the SQL insert statement and the MySQL .NET connector
|
|
Connecting to MySQL from PowerShell
PowerShell is Microsoft's .NET scripting language. If the programmer combines this with the MySQL .NET connector then they can build a very powerful database application
|
|
Programming Inner and Outer Joins in a Query
SQL queries can extract data from single or multiple tables. How that data is extracts greatly affects what the programmer can obtains - and it all comes down to the join
|
|
Working with Records and Fields in VBScript
VBScript (the scripting language for Visual Basic) can make the processing of records and fields in a recordset very easy for the database programmer.
|
|
Microsoft Access Stored Queries and VBscript
A programmer does not actually have to open a Microsoft Access database in order to create or modify a stored query - that can be done by using VBScript
|
|
How to Use SQL Statements with VBScript
The contents of a database (such as Microsoft Access) can be examined and modified by using VBScript and the insert, update, delete and select statements.
|
|
Using Microsoft Access without Microsoft Access
Microsoft Access is a very powerful database - so powerful that that a VBScript programmer doesn't even need to install it in order to use it.
|
|
How to Create an Access Database with VBScript
There is no need for a database designer to manually create a Microsoft Access database - they can automate the process using VBScript.
|
|
MySQL Stored Procedures and Triggers
MySQL stored procedures and triggers are a powerful tool in the hands of a database developer. This articles looks at how to use them to automate tasks on a database.
|
|
MySQL Stored Procedures and Functions
Oracle, unlike MySQL, has stored procedures and functions available for the database developer, giving Oracle a major advantage. That's all changed with MySQL 5.
|
Contributing Articles in Database Programming
|
Introduction to SQL: SELECT, FROM, WHERE & More
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.
|
|
Introduction to SQL: Getting Started
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
|
|
MYSQL Custom Field Sorting Revisited
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.
|
|
MYSQL Custom Field Sorting
In MYSQL the sorting of recordset data can be easily setup and maintained with a few custom tables and a little thought.
|
|
What is a Relational Database Management System?
The advent of relational databases ushered in more efficient data storage practices. It lessened the unwanted duplication of data and made information more consistent.
|
|
Applying Referential Integrity to a Database
When not properly linked, badly connected tables can cause inefficiency to data retrieval. Eventually the database needs to be fixed by hand, at cost.
|
|
Transact-SQL Primer: Inner Join
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.
|
|
SQL Server Transact-SQL Primer
SQL programming is at the heart of today's Web 2.0 applications. Learn the basic 4 commands SELECT, UPDATE, INSERT and DELETE.
|
|
Install SQL Server 2005 Express
Ready to start programming SQL Server 2005? Here is a concise walk-through of the steps for obtaining and installing all the necessary software.
|
|
Programming MS Access Applications
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.
|
Related Topics
leading contributors
More in Technology
Latest Articles