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

General Discussion

Andrew Chalkley
STAFF
Andrew Chalkley
Treehouse Guest Teacher

Introducing Database Foundations

In the Programming section of our library you'll see a new Foundations course, Database Foundations.

The first stage, Introduction to Data, Databases and SQL, is up and ready using our new SQL code challenge engine. If you're interested in databases please check it out!

14 Answers

Very excited.

Brilliant, I really need this.

I've been waiting for, it's gonna be awesome :star:

I am all over this one - thanks for rolling it out so quickly Andrew.

Oh awesome! Will it include things that blow my mind like indexes? (I glanced through the lessons and didn't see the index mentioned)

Andrew Chalkley
STAFF
Andrew Chalkley
Treehouse Guest Teacher

Hi Sara,

We'll be covering that in Securing and Maintaining a MySQL Database where we'll talk about performance as part of some of the maintenance tasks.

Regards,

Andrew

Is normalization covered in this series?

Dear uncle Andrew, This new course is well-wicked. At the end of the introductory section's code challenge, two things happen:

  1. the "Congratulations" popup appears before you can see the results of the selection process, so it's a bit hard to see what I've done.
  2. on-click of the "Booya" button I am redirected to Ruby Foundations, huh?

Just thought you'd like to know,

Andrew Chalkley
STAFF
Andrew Chalkley
Treehouse Guest Teacher

I'm glad you're enjoying the course so far Jen.

I'll let the App/Dev Team know re your popup issues.

Also the redirect thing is probably because DB Foundations is in the Programming Learning Adventure and since the other stages are in production phase it pushes you to the next available stage. Confusing! I know!

I have what might be a simple question for some. I was thinking that the part with the terminal would probably apply if you were installing MySQL by itself vs installing as part of MAMP, which is what I have (version 2.1.2 specifically). I am in MySQL workbench and I am using OS X 10.8.2. It gets to the Testing Host Machine Settings, and then both Check location of start/stop commands and Check MySQL configureation file both fail and have the following error message pops up in red: "Error: /usr/local/mysql/support-files/mysql.server start is invalid". What do I need to do differently for my setup than what is in the video? Thanks.

Also, it has, in the Message Log: Operation failed: /usr/local/mysql/support-files/mysql.server start is invalid

Kevin - A quick Google of your error message suggested this article on configuring MySQL Workbench to work with MAMP

One thing to note is that there is a typo in the article, where the author suggests using the path /Applications/MAMP/bin/stoptMysql.sh, that's a typo, it should actually be /Applications/MAMP/bin/stopMysql.sh instead.

source: http://dba.stackexchange.com/questions/10361/mysql-workbench-create-new-server-instance-error


If you are still having trouble create a new thread for your issue, and we will try to get you sorted out.

Remember the rule of thumb: your issue, your thread

Thanks James! That article got me running! And I'll keep that in mind about the thread thing in the future. Sorry.