Databases

Proficiency: Advanced
Years of Experience: 8

A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add, access, and process data stored in a computer database, you need a database management system such as MySQL Server. Since computers are very good at handling large amounts of data, database management systems play a central role in computing, as standalone utilities, or as parts of other applications.

 

I have been using databases for organizing data longer than I have been working on websites. Databases are a great way of making a huge amount of data easily accessible, searchable, and ….. well, useful!

I believe I have a very high organizational ability, and can create interactive tables in the most logical manner; which is very important down the road when the tables are filled with thousands of entries.

My strongest database system is MySql. MySql is the database system that is normally installed on Apache servers and works very well with PHP. Using PHP I can query an MySql database to give me access to any and all data I have stored. I can cut that data any which way that I need for a project – even across barely related tables. I know how to add data, remove data, modify existing data, and most importantly I know how to deliver the relevant data to the server side script in order to make the site dynamic.

I have experience with MsSql databases as well. MsSql is the database system installed on Microsoft servers. While it is not my favorite system, I do know how to use it. I have experience going directly into the management system and modify or create the saved parameters that make  the database work.

My first database system I used was Microsoft Access. It was my first experience with a “relational database”. It was amazing to be able to store data in many different dimensions of tables, and track large amounts of data through queries.

I also have experience with proprietary databases, and can work with them just as easily. I worked with the proprietary Kodak imaging database when I worked at photography installations.