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

Which track should I take to ready myself for Database Design and Development class?

Hi. Is there a beginner's track for databases? I saw the Mongo one but that looks too advanced for me.

Thanks!

4 Answers

r h
r h
68,552 Points

There is the "SQL Basics" under Library -> Databases (https://teamtreehouse.com/library/topic:databases) and there is a "Database Foundations" under Library -> Development Tools (https://teamtreehouse.com/library/database-foundations)

I would recommend taking the SQL basics track. I personally haven't taken it, but it looks like they go over SQL syntax (which in my opinion is not to difficult to learn).

If you are taking a SQL class you will most likely be using MAMP, Sequel Pro, or MySQLWorkbench.

Most developers only learn the basic CRUD operations, but you can also do more complex things like functions and procedures, conditionals etc.

Jason Anders
MOD
Jason Anders
Treehouse Moderator 145,858 Points

I would definitely do the two that Ryan has linked to. The SQL basics course is simple and gives you the basics. It's a bit fast paced, only because it is a basics class and is just showing you the starting foundations for SQL. From there you can move to the very in-depth Database Foundations. This is much more detailed and will probably take 6+ hours to complete, but you will have a strong understanding of the Database structure (by no means an expert yet, but enough that you can move forward from there).

Once those are done, you'll have to decide if you are only going to work with the Database, or with a language that interacts with it. Treehouse also has courses on PHP and Databases ... Python and Databases ... ect.

Keep coding! And good luck with your path. :)

Thanks