SQL, where to start...
So, I have another possible internship for this summer. I've been told my knowledge is for the most part good, I just need to be familiar with using SQL. All I know is that it's a relational database, and it's somehow related to PHP. I was curious of any of you have used SQL, and where you think I should start? I need kind of a crash course on it right now
Structured Query Language.
It's not a relational database, but a way to communicate with them.
First of all, be aware of the model. Understand primary and foreign keys, and how do you map relationships to tables.
Then learn the language.
_ queries (where, inner join)
_ table creation and update (constraints)
_ aggregate queries (count, avg, ..., group by, having)
_ transactions (rollback)
Later you will need triggers, but that is coupled with the engine that you use.
Also take a look at what SQL injection is. http://xkcd.com/327/
It's not a relational database, but a way to communicate with them.
First of all, be aware of the model. Understand primary and foreign keys, and how do you map relationships to tables.
Then learn the language.
_ queries (where, inner join)
_ table creation and update (constraints)
_ aggregate queries (count, avg, ..., group by, having)
_ transactions (rollback)
Later you will need triggers, but that is coupled with the engine that you use.
Also take a look at what SQL injection is. http://xkcd.com/327/
closed account (z05DSL3A)
| ResidentBiscuit wrote: |
|---|
| ...familiar with using SQL. |
SQL Server Central[1] can be a good resource.
Also w3 schools[2] may be worth a look
---==#==---
[1] http://www.sqlservercentral.com/Forums/
[2] http://www.w3schools.com/sql/default.asp
Thanks for replies! I was just told SQL, so I'm assuming the mean the former. And yea I've looked up SQL injection before when I was doing some research on secure programming. Funny comic though :)
Perhaps not the most ethical way to learn SQL, but the most fun way, is through learning SQL injection :)
That's how I'm doing it anyway.
That's how I'm doing it anyway.
Not if you don't do it where you're not supposed to.
http://www.hackthissite.org/ is good for learning SQL injection among other things, in a safe and legal environment. Much more fun than other programming (related) puzzle games.
http://www.hackthissite.org/ is good for learning SQL injection among other things, in a safe and legal environment. Much more fun than other programming (related) puzzle games.
:O Thanks for the link. Looks like my hypothetical productive day is shot haha
Topic archived. No new replies allowed.