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.
Adam Duffield30,493 Points
Any chance of a course on database optimization anytime soon?
Pretty much explained above, I know it's not beginner level but my company are very on top of their website optimization but the only area they are missing is DB optimization, wondered if Treehouse could give me any pointer? I'm thinking along the lines of indexing my most commonly used tables but a Treehouse course would be awesome!
Steven Parker215,939 Points
I wouldn't think "soon". The Modifying Data With SQL course was just released. The next database course will be Reporting With SQL. It's due later this month, but currently has no trailer and can't be bookmarked yet.
Future courses are generally announced a month or more in advance of release, and no others have been announced yet.
Ken AlgerTreehouse Teacher
As Steven Parker mentioned, there are no courses in the pipeline for SQL optimization. I would point you to a couple of online references to get you headed in that direction though.
- 8.4 Optimizing Database Structure
- How to Optimize a MySQL Database using phpMyAdmin
- Database optimization techniques you can actually use
That last one is a bit dated, but the concepts are sound.
Post back with further questions.
Happy coding, er querying.