How did you learn to develop databases?

[OhioTom76]

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.

[chrisfromwa]

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! 

[Peninha]

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.

[Navii]

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.

[Kaushik]

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.

[Bravosi]

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!

[Sarah Alfred]

Dark room always leads individual to discover something new, I learn database in my uni but at starting it was too boring but later on I started enjoying database.

[Nathan]

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 👍

[matthewjohn938]

I am also in learning phase and I like Microsoft Access, Microsoft SQL Server, I think with this forum I will get many suggestions for the query related to Database....

Thanks

[Sohani30]

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 April 22, 2019 by Sohani30

[John Aeliya]

I'm really figuring out how to create databases on my college,so I'm kinda still in procedure of learning