What is a database?
A database in its simplest form is an organized collection of data. The collected information could be in any number of electronic file formats. A database can be stored locally on your computer or remotely over the internet. An example of a database could be an address book or historical sports scores. A database could also be as simple as an alphabetical arrangement of names in an address book or as complex as thumb print records. Many databases start small as a list in a word-processing program or spreadsheet like Microsoft Excel. As the list grows bigger the information may eventually get transferred to higher end software like Microsoft Access.
What is database administration?
Database administration (DBA) is the process of designing, implementation, and maintenance of a company database. Database administration usually invloves an individual or team known as "Database Administrator(s)", and work closely with a Database Analyst, Programmer Analyst, and/or Systems Manager. The role of a database administrator includes the development and design of a database structure, monitoring and improving database performance, capacity, and planning for future expansion requirements. This also includes implementing security measures to safeguard the database from hardware failures, viruses.
We specialize in the following database engines:
Oracle Database 8, 9, 9i, 10g, 11g
Microsoft Access 97/2000/2002/2003/2007
Microsoft SQL Server 2000/2005
Dbase IV and V
Flat CSV and/or Text Files
We specialize in the following areas of database administration:
Setting up, maintaining and configuring an database
Upgrading from older version database to newer versions
Designing and implemting tables correctly
Designing well written queries for various end user reports
Properly fine-tuning databases for speed and efficiency
Backing up/Restoring databases data for safe keeping
Implementing security for user accessing the database
Converting Data from one database to another
Designing Custom Software using a variety of databases
Working with websites and linking them to databases
Several Database Related Articles:
Deciding what Database to Use When Designing an Application
Oracle: How To Changes a Fields Data Type
How to install PHP, MySql and IIS and make them work together
Tips when connecting VB.NET Application to a Database
Mobile Apps /