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

Laura Kyle
Laura Kyle
19,794 Points
Posted by 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,175 Points
Alexander Nikiforov
.a{fill-rule:evenodd;}techdegree seal-36
Alexander Nikiforov
Java Web Development Techdegree Graduate 22,175 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...