Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases

Learning databases through Treehouse

Hey all

Total database noob here. I'm at an advanced-enough stage of web development to be wanting to make bulk edits to a site via a database. I've done a lot of reading around the subject. My web host has recommended using PHPMyAdmin, which in theory seems to do what I want.

I've been able to export a CSV file of all the data I require from PHPMyAdmin... At this point my knowledge runs out! I understand that by using SQL I can in theory alter the content of these tables... My question: based on the above, can someone with more knowledge than me tell me if the Treehouse courses on SQL are going to help me achieve my end goal? I've read the synopsis of each SQL course, but can't see a whole lot about PHPMyAdmin, hence am concerned I would be doing a lot of learning that wouldn't actually solve my problem.

Help!

3 Answers

Jonathan Grieve
MOD
Jonathan Grieve
Treehouse Moderator 91,253 Points

In answer to your question yes the SQL courses that were brought out earlier this year should teach you everything you need to manage databases in phpmyadmin.

You'll learn things like the basics, how to use SQL to generate reports and edit the individual records themselves. Once you have them learned through the courses you should have all you need to know what's going on in the queries phpMyAdmin gives you.

Thanks for the feedback! Have just finished the Basics course and totally agree, they are looking like they'll do the job. Really appreciate your time.

Konrad Pilch
Konrad Pilch
2,435 Points

You just need to figure it out.

Well, create a database, create something like users , give it rows e.g. 4 id, username, password, first name and there you go.

Now there are other things like insert, browse, just check them out. You just really need to dive into it. I had no idea how godaddy database works, but when i sat for two days i understood how it works, and the tuts ther arent' really helpful.

Just go and try things out. Click in each tab, see what it does.

Hope this helps somewhat.

Thanks for the help Konrad, much appreciated - thought this might be the case! Am now working my way through the courses and already have a better handle on things.

Anjali Pasupathy
Anjali Pasupathy
28,883 Points

The courses are far from exhaustive, but they're good practice, and they provide links to sources that are incredibly helpful. I learned a lot by just reading through the links provided in the Teacher's Notes. Wikipedia and Microsoft both have great resources for learning about SQL, and links to both are in the Teacher's Notes.

I hope this helps!

Thanks for the ideas Anjali, will be sure to check out the other recourses too!

Anjali Pasupathy
Anjali Pasupathy
28,883 Points

You're welcome! I hope you find what you're looking for! (: