Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

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,547 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,623 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