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 Modifying Data with SQL Adding Data to a Database Adding a Row to a Table

Laura Kyle
Laura Kyle
19,794 Points

Resource suggestions for learning about schema design?

In this video for example, Andrew mentions that some values are required as set by whoever designed the schema. Is schema design discussed in an existing Treehouse course that I may have missed? Or might anyone have suggestions for a resource or two for getting started on designing my own database?

Thanks so much!

1 Answer

Alexander Nikiforov
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Alexander Nikiforov
Java Web Development Techdegree Graduate 22,160 Points

I think you should take:

https://teamtreehouse.com/library/database-foundations

I didn't take it yet, I just looked at the lectures there and it looks like Andrew does create schemas there. Take a look at this one, e.g:

https://teamtreehouse.com/library/database-foundations/creating-tables-and-manipulating-data-with-sql/manipulating-schema-and-data

I also just googled about schema creating: it turned out there lots of tools out there:

https://www.quora.com/What-is-the-best-free-DB-schema-design-tool

And since MySQL Workbench is in that list, you should definitely take the course in development tools above, because MySQL workbench is there.

I also should mention that in all languages, there are usually database frameworks, that help you create schema behind: There is peewee for Python, Hibernate for Java.

They help you create schema using language and framework you are working with, when you create Web Application for example with Java, Python or other...