We provide databases for website designers, application developers, direct marketing and market research. We supply website content, marketing lead databases, directory data for location based services and other business listings.
A database is a collection of raw data. It's a system for organizing and storing data which can then be manipulated, sorted and queried (using SQL) to produce information for the end user. A table is a set of data within a database. For example, a database named 'Online shop' may have a table called 'customers'. An organization may have multiple tables within a database, for different purposes. For example, an online shop may have a table for customers and a table for orders.
SQL stands for Structured Query Language and it's a programming language designed for managing data in a database. The language can be used to form queries which are then run to update, select and delete records.
For example, the most common operation is the SELECT statement. Take the following query SELECT `last_name` FROM `customers`. This query will simply retrieve all customers' last names from the 'customers' database.
The database dumps available on this website are used to create and insert data into an existing database.
We will shortly be opening an SQL tutorial section on this website so check back soon!