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 trialLaura Kyle
19,794 PointsResource 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
Java Web Development Techdegree Graduate 22,175 PointsI 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:
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...
Daniel Totten
Full Stack JavaScript Techdegree Graduate 21,008 PointsDaniel Totten
Full Stack JavaScript Techdegree Graduate 21,008 PointsJust a note: the Database Foundations course has been taken down and re-directs to the SQL Basics course.