|
|
|
SQL is pretty useful, but in order to be efficient with it (there are many many ways of doing one thing), I suggest taking a DB course and understand how DBMS process queries and their associated costs.
|
Yes, I would imagine that being the inevitable path.
By looking at a certain twitter account: X Looks as though SQL is easy to exploit.
|
SELECT * FROM TEAM_LIQUID WHERE name = "ShoCkeyy"
D:
Meh, I'm pretty scrubby at SQL, but love it programming.
|
On January 21 2011 10:50 Sky wrote:Yes, http://en.wikipedia.org/wiki/SQL_injection. An english version of the same page. Would imagine that being the inevitable path. By looking at a certain twitter account: XLooks as though SQL is easy to exploit.
Yeah I changed the link before your edit . :p
|
On January 21 2011 10:50 Sky wrote:Yes, I would imagine that being the inevitable path. By looking at a certain twitter account: XLooks as though SQL is easy to exploit. SQL isn't "easy to exploit", but terribly written programs are. And, it's amazing how many programs which connect to SQL databases are badly written. Anyone writing a web application should be seriously weighing the security of their application at every step.
|
|
SQL is very easy to learn. The most important thing is to learn how to optimize your queries. That means you'll need to understand exactly how the database engine will process these.
Another thing is that you need to be aware that even if the "S" in SQL stands for "standard", SQL is far from being standard. It's different on every RDBMS, except for the SELECT FROM WHERE clauses. Most functions like string manipulation functions will be different, the way of using stored procedures will be different, and procedural extension will be different.
|
ROFFLLLL!!!
For programmers, SQL is a very important skill to learn. This is because a lot of the applications that you'll be working on a are database based.
|
You don't really learn SQL, you just use it. It's so simple. As endy said the only nontrivial thing about it is understanding how the queries are processed for the purpose of optimization.
|
|
|
|