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
Andrew Chalkley
Treehouse Guest TeacherHelp QA SQL Basics Needed
Hello world!
The course is SQL Basics is almost ready and I'm needing a handful of you to take it for a spin.
The QA process is a time for people to spot any glaring mistakes, spelling mistakes, broken links, mistakes in teachers notes, clarification on code challenge/quiz questioning and completion emails. And any other feedback.
The course is due to go live next week on Wednesday, 16th December so QA should be complete by end-of-day Monday, 14th.
Please use my email to provide feedback. Don't talk about the course here on the Community forum until it's officially released - this is to avoid confusion.
I'll let you know when the invites have been sent and if you've been selected.
Regards,
Andrew
13 Answers
Andrew Chalkley
Treehouse Guest TeacherAnyone who posts after this now won't be on QA. You can enjoy the course when it launches on Wednesday!
This course covers a smaller scope of what Database Foundations does but is more in-depth. We have several SQL courses coming out in Q1 of 2016 that's going to replace a the content in Database Foundations. This is the first step.
Brendan Whiting
Front End Web Development Techdegree Graduate 84,738 PointsI would love to test drive. How do I sign up?
Andrew Chalkley
Treehouse Guest TeacherJust by replying on this thread.
Emails will be sent out later today / tomorrow.
Ratik Sharma
32,885 PointsMe! Me! Me!
Kyle Meyer
5,459 PointsI'm super pumped about this course. SQL is so fundamental to every web application and yet almost every framework out there abstracts SQL away from the programmer. Can I join the QA?!
Rob Allessi
8,600 PointsKonrad Pilch I saw your comment above mentioning you sent us an email and that we didn't respond. I show that your last email sent to us at help@teamtreehouse.com was on December 8th asking about resetting your account and we responded very quickly with how the reset will be done and asking you to please confirm that you understand and if you'd like us to proceed with the full account reset.
Konrad Pilch
2,435 PointsOh! Thank you. I see them now, they are in my spam folder.... Other emails arrive from you guys just normally. Never saw any of the support email till now :/ thank you.
Nicolas Hampton
44,638 PointsBeen waiting on the databases re-vamp for a while, sign me up!
Kali Brayfield
23,356 PointsI would love to!
Thomas Rhodes
8,246 PointsI would love to qa the sql course
Mark Preston
5,150 Pointssure! Haven't done a QA in a while :) Sounds good
seanstandefer
4,903 PointsSorry I'm late to the band wagon, I'd also like to assist!
Andrew Chalkley
Treehouse Guest TeacherIt's going live Wednesday :)
Chaz Watkins
9,879 PointsIf not too late, I would like to checkout SQL Basics
Andrew Chalkley
Treehouse Guest TeacherIt's going live Wednesday :)
Steven Parker
231,261 PointsI understand the official QA is over, but I wanted to point out that using single quote (') instead of double quote (") on the challenges returns the same correct sql result, but the answer is considered wrong ("bummer!").
Andrew Chalkley
Treehouse Guest TeacherWhich one in particular? I just did one and it still passed. For example with this challenge I did wig_lady in single quotes and it worked.
Steven Parker
231,261 PointsHere's one of them - "Filtering by Dates" challenge 1:
-- X Bummer! You're missing the date of the 1st October 2015 ("2015-10-01")
> select * from results where away_team = 'Hessle' and played_on >= '2015-10-01'
id home_team home_score away_team away_score played_on
4 Mosborough 6 Hessle 18 2015-10-10
Clearly the sql ran correctly but the answer was considered wrong. Changing the quotes caused it to accept the answer.
One of the other ones was "Finding Data that Matches a Pattern" challenge 1, where the same thing occurred depending on what quotes were used around "%t-shirt%".
Andrew Chalkley
Treehouse Guest TeacherThanks Steven Parker! These are now fixed! I'd have given you an exterminator badge but you already have one :)
Steven Parker
231,261 PointsYes, I've earned that one a few times over already. But you can always pick a "best answer". :)
seanstandefer
4,903 PointsDo you have a space for posting bugs? I have found a couple of low priority typing errors in your quiz questions.
Andrew Chalkley
Treehouse Guest TeacherEmail andrew@teamtreehouse.com! Thanks!
Konrad Pilch
2,435 PointsKonrad Pilch
2,435 PointsSounds already awesome!
Will be there anything like using Functions to make things like registration easier? INSERT INTO users or whatever and when calling the function, we will create a new user, and then login with it.
If im right, we use SQL and all that for this kind of stuff, and it would be cool to have something like that.
Andrew Chalkley
Treehouse Guest TeacherAndrew Chalkley
Treehouse Guest TeacherKonrad Milch "Modifying Data With SQL" will show all CRUD operations. This should be released end of January. Then there's "Reporting With SQL" which will show more functions probably February. Then a course surrounding more of the joining and relational side of SQL in probably March/April.
As for authentication etc, they'll be in more language specific courses.
Konrad Pilch
2,435 PointsKonrad Pilch
2,435 PointsThank you Andrew :D I can't wait! Soo excited! :D I did basics outside here, but then, here at treehouse, everything is 99% better :D
OH i just remembered. Is it possible i can have a reset of point in my WordPress, JavaScript and Ruby courses please? Iv send an email to support twice, didn't get any response. I just want to start fresh and its easier to keep track off.