Access
Standalone or integrated database design, development and data management

Oracle
PL/SQL package development and integration (via Toad)

Sql Server
T-SQL, Stored Procedures (via Enterprise Manager)

MySQL
Database design and content maintenance (via phpMyAdmin)
  • Home
  • Projects
  • Database
  • Websites
  • PC Support
  • Consultancy
  • Contact Me
Database design considerations
A database is a collection of data items that are organised in such a way as to enable one, via a structured querying language (SQL), to locate and extract those stored items. The physical structure of a database is therefore dependent upon the application’s processing requirements (whether simple querying, group reporting and/or content updating) in terms of the response times and data volumes involved. The design process also needs to consider such things as the number of potential users and the capacity of the database.

MS Access
  • Create normalised table structures, indexing and stored procedures
  • Generate ODBC link tables to external databases if required
  • Data import/export in CSV or XLS format
  • VB/VBA application integration via ADO, DAO, RDO or ODBC

Oracle
  • Create tables, views, triggers, stored procedures and PL/SQL packages
  • Maintain database environment using Toad (Quest) or PL/SQL Developer
  • VB/VBA application integration via ADO
  • SQL efficiency reviews

SQL Server
  • Create tables, views, triggers, functions and stored procedures
  • VB/VBA application integration via ADO

MySQL
  • Create and populate tables (import/export) and indices via phpMyAdmin
  • Database driven web sites, read/generate RSS/XML data feeds
  • User interactive applications, secure browser-based site maintenance