Home		Rustcraft Productions
Web Site Comments
Pricing
SQL Comments		View Sample WebSites

Let's talk Databases.

What is SQL and What are Databases? 

• Databases are a simply a collection of data held in an organized and relational manner. The data may be almost anything for numbers to photos or software programs. The data is arranged in some logical fashion. For instance, all the first names are in the first column of the data. The data is relational means that associated with a name may be a list of bank transactions belonging to (related to) the individual described in another table, and the relationship is noted between the two.
• SQL is Structured Query Language. The SQL statement is simply an instruction of what data to retrieve. It could be as simple as:
  SELECT * FROM TABLE1;
  Or get (select) all data (*) from the table named TABLE1. Of course, it can be substantially more complex. The statement might contain multiple tables related in specified fashions. The data have math functions applied to it before returning. These statements can become very complex.
• Most SQL databases contain multiple tables. In larger databases, it may be easy to consider 300 or more tables. The tables contain unique data. Multiple tables should not contain the same data. Each table is related to another table or to all tables by a "Key". This key indicates which data goes with data in another table.
• Other items such as views, triggers, or procedures all have a special part in the databases. The SQL statements are the heart of the databases.



• REPORTS
• Reports are the output of the database in general. The reports consist of a tabular summary or listing of the database. The SQL statements are the tools selecting the data to be presented in these reports. The reports are then formatted using various programs. SQL Server 2005 Reporting Services is one common reporting scheme for large databases. Microsoft Access is a common reporting scheme for smaller systems.



• SQL in RUSTCRAFT
• Rustcraft will generally be using MSSQLSERVER. Other databases are available upon request. The databases designed and populated or transferred by Rustcraft will be using the latest standards for normalization and control. These will be capable of handling low to mid volume traffic. For high traffic cases, special considerations must be made. For these databases please contact Rustcraft by phone or email.
• Databases are the home of the passwords and client information. Databases are the home of your catalog, your prices, your order information, all that data that makes your web site worthwhile.
  Databases are the heart of your concerns, second only to the attractiveness and accessibility of your web site. These three items make your web site useful, or a bomb. Let Rustcraft help.