![]() You can't have a space in your table name. ![]() For example, the students from before will now see these messages: To help those new SQLers out, I added more specific messages using simple regex-based checks. Students spelling INTEGER as INTERGER and not noticing that extra 'R'.įor most syntax errors, students used to see "syntax error near " and nothing else - so they knew something was wrong near a line of their SQL but had no other clues about why their SQL was wrong.Students missing semi-colons after SELECT or INSERT statements.Students putting a whitespace in their table name.Some of the errors kept popping up - here were the top 3: When that happens, I get a JIRA report with their code and any other colorful language they'd like to express :) A few weeks ago, I triaged nearly 2,000 reports from our first 3 challenges, and I was fascinated to see the huge variety of syntax errors. But a big fraction of them struggle to write SQL correctly the first time and bang their head over syntax errors. Many of those figure out how to write correct SQL and pass the challenges. We've now had thousands of learners attempt the SQL challenges in our SQL course. In our courses, students first learn how a concept works in an interactive talk-through and then they work through a step-by-step SQL-writing challenge. We teach SQL on Khan Academy by embedding SQLite.js inside our real-time editor.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |