Jump to content
Grumpy

How did you learn to develop databases?

Recommended Posts

It took me quite a while to get a hang of how relational databases worked and why. It wasn't until I had some real world examples to compare it to that a light bulb went off in my head and it all started to make more sense. In my case, it was while I was managing Pay Per Click campaigns for my employers that I started to see a real use case for them. 

 

I tried learning Access several years ago without much luck, then ended up getting some formal training in Filemaker - which I found to be much more intuitive. Soon after that training I redesigned a student database for my employer, then at my following job took it a step further working with their data team to build in house reporting around our Pay Per Click campaigns that merged our internal data with the reports from the search engines. During this job I also gained a lot of experience working with Cognos - a web based front end for our companies internal data.

Share this post


Link to post
Share on other sites

I first started learning the concept of databases by using Access 97 for work.

I was always being asked to create them for projects.   So I learned the concepts of how to normalize,  and not duplicate data etc.

 

My first databases were so bad,  basically 1 big table with 20 columns lol. 

 

Then for fun,  I wanted to learn PHP and MySQL so I started one of those Mafia Text based games to keep me motivated in it.   So that helped me really get the concept of creating the proper tables and linking etc down.    Since if I didn't do it right,  it always burned me down the road when I wanted to tweak things.

 

In my current job,  I don't really do anything with DBs anymore hopefully later I will again. 

But my Mafia game is still online and being used about 8 years after I started it! 

Share this post


Link to post
Share on other sites

My knowledge of databases is limited, I'm still from the time of Access and Excell. I was for a while with Moodle and MySQL, but my job lead me in another direction so I never got too deep on that.

Share this post


Link to post
Share on other sites

I started out with MySQL databases in school where we learned most of the basics, but we didn't do it for long because it wasn't actually mandatory to learn about databases. Afterwards I came across a few MySQL, Microsoft Access and Microsoft SQL databases but they are all roughly the same so it's not that big of a deal how you start out. I wouldn't consider myself good at databases but I'm a quick learner so it isn't too hard for me to solve most problems.

Share this post


Link to post
Share on other sites

I had the Databases subject in my undergraduation and it included Laboratory sessions as well. We were fortunate to have an excellent professor teach us the subject and every week, we had project assignments to strengthen our knowledge on the topics covered that week. SQL was very new to us and it did not take much time to actually get a hold of the programming language. We had some PL/SQL sessions as well and some hands on sessions to cover it up. Now, at work, I use SQL daily and I owe it all to my professor that I am finding it relatively easy in doing the everyday work.

Share this post


Link to post
Share on other sites

Oddly enough, my experience has first begun in the school. I believe it was 7th grade, as we were bound to pick our own subjects to study. Me and my friends being gamers wanted to study computers, and so has my journey begun. I've studied databases over the years, html, visual c, javascript and much more. Was very informative, gotta say!

Share this post


Link to post
Share on other sites
On 12/11/2013 at 11:24 PM, enim said:

I'm probably different then most.  I worked for a company with a dedicated analytics team who...wasn't always as quick to do adhoc reports or fix problems as I wanted.  So, I threw MySQL on a virtual ubuntu machine, read w3schools...and now I'm finishing the study guide for my certification.  In about 5 months, I've gone from nothing to pretty crafty. 

 

Helps a lot that its a lot like speaking.

Best way to learn right here from trial and error in my opinion 👍

Share this post


Link to post
Share on other sites
Posted (edited)


You can learn SQL. It is one of the popular languages for web database development. From there you can create a MySQL database for your site.

Edited by Sohani30

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...