So we knew from SQL data warehouses, select, project, join are really useful, and we can string these operators together to build some pretty cool and interesting applications.
to augment their existing SQL queries for their daily reporting in order to identify a problematic interaction between a new firmware version and a subset of the vehicle
you just write SQL queries um sort of um because SQL doesn't actually do these sort of things um but these are pretty
needless to say uh SQL doesn't do this um so I built a custom database that
It should be like a SQL to your last one.
And we do it through the SQL Sandbox.
We would take-- people would run a SQL query for their problem set and submit the dataset as their answer.
changes um that's you know SQL 2.0 I think is what this might be called and then this one's even more complicated um
Okay, it's SQL .
hit that kind of sticking point in learning Python or SQL or Excel modeling, it's actually the group discussion that will happen in iLab that gives them
One thing we do really well is teach SQL to novices.
We make it very simple to play with SQL right away.
So it was an engineering thing to build this little SQL Sandbox.
You ever heard of SQL ?
But one of the innovations I kept pushing for was something called the SQL Sandbox.
60% of US job listings last year required you to know SQL .
So if you and I have, say, a SQL database, or we have something like Tableau, or a BI tool, this is probably what we're working with.
We created a technical track, where we worked through SQL and R, but a lot of our students already had that done, like maybe many in this room.
by exploiting a web app, usually with something like SQL injection.
He's been high all along using PHP, jQuery and SQLite.
That's why it catches what other tools miss, logic errors, bad conditions, math mistakes, even security vulnerabilities, like SQL injections.
You invent the spreadsheet, you invent the word processor, you invent the database, you invent SQL , right?
And we can go in, and we can drill in this exact data, or we can generate a SQL query to dump this
We take all comers, English majors, non-technical people, and we start doing SQL queries using the SQL Sandbox.
And Don Chamberlain and Raymond Boyce, who SQL , or S-Q-L, as a special purpose
Male Presenter: I think one of the things you've said previously is that you have to, the people are still using SQL injection, then there's something wrong.
Look at Sony, they were hacked 12 times, and I think like 10 of those hacks were SQL injection hacks, alright so the developers are obviously, they either bought the code from somebody