I need to learn SQL in 3 days.

Chrono

Diamond Member
Jan 2, 2001
4,959
0
71
Can someone tell me the basics of SQL and the things you can do with it. Also, how complicated can things become once you get more in depth with it? I've forgotten a lot of the SQL commands, but of course I can brush up. Only thing I need is a better understanding of what you can do with it. Thanks.
 

NikPreviousAcct

No Lifer
Aug 15, 2000
52,763
1
0
Yeah, I had that problem too. It's not possible, but FRICKIN GOOGLE has tons of references to quickly teach you what you need to know when you find out that you need to know it, when it comes to SQL.
 

Deeko

Lifer
Jun 16, 2000
30,213
12
81
I learned the basics for my job in a morning, using an online tutorial or two...easy stuff
 

pancho619

Platinum Member
Feb 4, 2000
2,467
0
0
I saw a book at Borders Bookstore titled "Learn SQL in 72 hours". Might want to check there.
 
Oct 9, 1999
15,216
3
81
SQL for dummies will help.

remember if you want to select something "select pussy from playboywomendatabase where pussy is red"

remember that statement and you learnt everything that is to learn.
 

Originally posted by: Chrono
Can someone tell me the basics of SQL and the things you can do with it. Also, how complicated can things become once you get more in depth with it? I've forgotten a lot of the SQL commands, but of course I can brush up. Only thing I need is a better understanding of what you can do with it. Thanks.
Translated as:
"I've never used SQL, and I barely actually know what it is. Please help me as I am way over my head in a project I took on at work/school."

Have fun. ;)
 

mugs

Lifer
Apr 29, 2003
48,920
46
91
Learning SQL is easy, the syntax is very simple and there aren't a lot of commands. Being able to use it for something, that's a whole different thing.
 

Schrodinger

Golden Member
Nov 4, 2004
1,274
0
0
SQL is pretty damn easy. I learned by cutting my teeth on Oracle. Find a personal/academic version. Grab a book at the store. Learn these:

SELECT

INSERT
UPDATE
DELETE
MERGE

CREATE
ALTER
DROP
RENAME
TRUNCAT

COMMIT
ROLLBACK
SAVEPOINT

GRANT
REVOKE

BOOM I just taught you data retrieval, the data manipulation language (dml), data definition language (ddl), transaction control and data control language (dcl)

:D
 

DJFuji

Diamond Member
Oct 18, 1999
3,643
1
76
SQL is actually one of the easier things to learn in IT. Imagine trying to learn C++ in 3 days.
 

Feldenak

Lifer
Jan 31, 2003
14,090
2
81
Originally posted by: mugs
Learning SQL is easy, the syntax is very simple and there aren't a lot of commands. Being able to use it for something, that's a whole different thing.

 

daniel1113

Diamond Member
Jun 6, 2003
6,448
0
0
Originally posted by: SampSon
Originally posted by: Chrono
Can someone tell me the basics of SQL and the things you can do with it. Also, how complicated can things become once you get more in depth with it? I've forgotten a lot of the SQL commands, but of course I can brush up. Only thing I need is a better understanding of what you can do with it. Thanks.
Translated as:
"I've never used SQL, and I barely actually know what it is. Please help me as I am way over my head in a project I took on at work/school."

Have fun. ;)

Hahaha... best post of the day, bar none.
 

kranky

Elite Member
Oct 9, 1999
21,019
156
106
There are some keywords, and some tables. And indexes. And rollback stuff and logging. And ANSI-compliant something. Then there are the statements, with parentheses and special characters. There's some collating order thing that is important.

You get a lot of data, and put it in a straight line (or maybe it's called a row, I don't remember). Then you line up your keys and set them on the tables. You can't have a lot of keys, because it would jeopardize the access rights for security. They get joined together somehow.

Data goes in, and you take it back out, but it still stays there unless you change it, or not. Then you can print it but that part is hard, because you have to put brakes on the pages.

I think there's more to it than that, though.