Database Development
I am able to design, set up and maintain many of the popular database systems, including MySQL, SQL Server and Access. I can also migrate data from existing systems and sources into a more efficient database.
Databases are the key to Content Management Systems (CMS), Dynamic
Web Sites and Dynamic Web Applications. A database that has been well
designed enables a feature rich means of data storage and handling.
A Dynamic Web Site is generated from information stored in the database
and displayed to the user via an Application Server. This is the opposite
to 'static' Web Sites, which are created from plain text and HTML code.
One of the major advantages of a Dynamic Web Site is that content can
be altered and amended easily by changing the data stored in the database.
Traditional HTML requires the actual HTML code and text to be altered
on every page affected by the information change. With a Dynamic Web
Site the data is changed once in the database and the change is reflect
across every location where the data is displayed.
Content Management Systems
A Content Management System (CMS) allows complete control over a Dynamic Web Site by using a Web Application to control the database. Content can be added, deleted or changed in the database (and therefore across the whole Web Site) via an intuitive user interface consisting of input fields and forms. A major advantage of a CMS is the user requires no or very little technical programming ability!
In addition to the benefits of a CMS, by harnessing the power of a database
it is possible to create Web Sites that allow information to be submitted
by users and stored (with their permission of course!). This information
could dictate the type of content the users views. For example, perhaps
the users prefers to view information related to where he/she lives or their
occupation. These and other users preferences can be collected, stored
in the database and used to provide a custom user experience of your
Web Site.
Also you may want to utilise a database to provide an Administration
area as part of your Web Site but accessible only by employees. This
area could be used to produce Sales reports or Email distribution lists.
Again by including a database into your Web Site it is possible to create
this type of functionality and much more!
I have experience designing, creating and maintaining various databases
and CMS including MySQL, SQL Server and Microsoft Access. It is possible
that you may already have an existing database system (or even spreadsheets
or Word documents) in place and wish to use the information to drive
your website. I am able to convert most data sources into a structured
and planned database ready to drive your Web Site.
Contact me about a Database project
If you have a project, please click the 'Proposal' button to view a form that will allow you to submit your contact details and an outline of the project you are proposing.