Overclockers Australia Forums
OCAU News - Wiki - QuickLinks - Pix - Sponsors  

Go Back   Overclockers Australia Forums > Software Topics > Programming & Software Development

Notices


Sign up for a free OCAU account and this ad will go away!
Search our forums with Google:
Reply
 
Thread Tools
Old 21st April 2012, 9:34 PM   #1
Mifferz Thread Starter
Member
 
Join Date: Nov 2002
Location: Melbourne
Posts: 1,254
Default MSSQL / SQL practice and answers

So I need to improve my SQL skills, are there any good online sites which give tutes/activities with answers? And provides downloadable tables so I can practice.

Yes I'm a big baby and want my hand held
__________________
NINTENDO™ DS Lite
Owners Club Member #0086

Member #31 of the Nintendo Owner's Club
Member #57 of the Sony Ericsson Owner's Club
Mifferz is offline   Reply With Quote

Join OCAU to remove this ad!
Old 21st April 2012, 9:39 PM   #2
zach
(Banned or Deleted)
 
Join Date: May 2009
Location: chermside.bris.qld.au:80
Posts: 3,622
Default

http://msdn.microsoft.com/en-us/sqlserver

+

Northwind lol (http://www.microsoft.com/download/en....aspx?id=23654)
Adventureworks (http://msftdbprodsamples.codeplex.com)

What do you want to improve specifically?

Garden variety queries with JOINS and UNIONS or

TSQL/DBA stuff? There's plenty of build in MS sprocs and triggers to make DBA stuff easy, MSDN has those too (sp_helpdb etc etc).
zach is offline   Reply With Quote
Old 21st April 2012, 9:57 PM   #3
Mifferz Thread Starter
Member
 
Join Date: Nov 2002
Location: Melbourne
Posts: 1,254
Default

Thanks, will take a look at them.

Quote:
"Garden variety queries with JOINS and UNIONS or"
Yep and selects based on conditions, and heaps more advanced stuff.

Background: I did basic SQL at uni years ago, my last job I rarely wrote my own SQL, and when I did I usually looked at previous scripts written by others and had to spend heaps of time googling.

Current job requires a lot more of SQL writing so here I am
__________________
NINTENDO™ DS Lite
Owners Club Member #0086

Member #31 of the Nintendo Owner's Club
Member #57 of the Sony Ericsson Owner's Club
Mifferz is offline   Reply With Quote
Old 7th May 2012, 3:40 PM   #4
purehybrid
Member
 
Join Date: Sep 2004
Location: Melbourne
Posts: 4,152
Default

SQL is rediculously easy to learn if you just need to pull/manipulate specific data. It's really only when you need to be creating the most efficient/optimised queries that it gets a bit whacky So don't stress too much... just run with the links above and play around with the adventureworks stuff. You'll be smashing out data/reports/etc in no time
__________________
i7 920 / 6gb / 460gtx OC
Completed trades ($3,750+ total) - Hotdog_Hotdog, mecka, dimsyrak, MotoMan, [MadHatteR], melbnut, crag_v, jimmytim903, Quittersss, Azzan

[/URL]
purehybrid is offline   Reply With Quote
Old 8th May 2012, 1:09 AM   #5
SchRAMBO
Member
 
SchRAMBO's Avatar
 
Join Date: Mar 2002
Location: Perth
Posts: 2,060
Default

HeidiSQL Is bloody awesome for importing an SQL database and then able to query it with one liner SQL commands and instantly see the outcome. I'm no SQL guru either but I find this helpful for learning too.

I'm the same with Mifferz, hardly touch the stuff and just hack other peoples scripts and the power of Google-fu.
__________________
Linux Registered user #355379 - Click here to install Debian GNU/Linux
Gaming; >> PSN tehowl || Steam schrambo
SchRAMBO is offline   Reply With Quote
Old 8th May 2012, 3:26 PM   #6
rm -rp ./Matt*
Member
 
rm -rp ./Matt*'s Avatar
 
Join Date: Sep 2008
Location: in the computer
Posts: 621
Default

tizag has really good efficient tutorials, http://www.tizag.com/sqlTutorial/
rm -rp ./Matt* is offline   Reply With Quote
Reply

Bookmarks

Sign up for a free OCAU account and this ad will go away!

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +10. The time now is 4:01 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd. -
OCAU is not responsible for the content of individual messages posted by others.
Other content copyright Overclockers Australia.
OCAU is hosted by Internode!