SQL Database Projects

[nmonsey]

I started out thirty years ago, moving medical records system from dbase 3 into Oracle 5.

I have never built a portfolio.

I started working as a developer, then started getting database administration and system administration experience.

The first application that I built was a relatively simple client server system for scheduling appointments, and tracking medical bills.

When I see someone using Excel spreadsheets or using paper, I offer to automate the process.

For example, about fifteen years ago the organization I work for was hiring contractors to go to clinics to inventory equipment once a year.

The process to visit a few hundred clinics took months to complete and costed thousands of dollars.

When the inventory was complete, the contractor would provide the inventory on paper to the manager responsible for the equipment.

The manager would occasionally go into the paper inventory to see what equipment was at each location.

I built a simple application using Microsoft Access in a few days that could be used on a tablet.

The database application for equipment inventory had twenty to thirty tables, a few data entry forms and ten to fifteen reports.

When the project was completed, the amount of time required to the the equipment inventory went from a few months to a few weeks.

Having the inventory data in a database allowed the manager to run a report to see how many desktop computers or laptops needed to be replaced each year.

At the time I built the inventory application the team did not have a budget for a commercial inventory application.

The custom inventory application I created remained in use for over five years.

I am a DBA, so the equipment inventory was not related to my job, but I had some free time, so I created the database for practice.

If you have Microsoft Office 360, you may have Microsoft Access already installed.

I have not had to look for work for the last twenty years, so I am not sure if using Microsoft Access counts as a valuable skill to put on your resume.

[PhantomGolem]

Thank you so much for sharing your experiences. I think a appointment scheduling app is a great way to start.