| Author |
Topic |
|
pgh333
Starting Member
5 Posts |
 Posted - 2011-07-12 : 21:40:58
|
| I did a little with SQL a while back but need a total refresher. I got a book "Sams Teach yourself SQL". It suggests downloading MySQL for the examples, but it wont work for me. I tried downloading another program but its too complex(I dont even know where to create databases and sql files to import, etc). Would using access/excel be my best bet? Im getting frustrated cause I'm getting stuck before I can even start. ANY advice would be appreciated. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-12 : 22:31:41
|
| Download the free SQL Server ExpressOnce you've installed it, please post back with any help you need. It is VERY well documented too. And MySQL and Access can't touch SQL Server for range of features, connectivity and robustness. |
 |
|
|
pgh333
Starting Member
5 Posts |
Posted - 2011-07-12 : 23:10:42
|
| Thanks for the quick advice, much appreciated. Im going to look into it tomorrow for sure and hope it helps me out. At this point all I wanna do is get familiar with the basic commands. Run some commands on a database or two and see some output, thats all. Any more info/suggestions from you or anyone else will help. |
|
|
|
pgh333
Starting Member
5 Posts |
Posted - 2011-07-13 : 23:15:08
|
| One step closer i think. I downloaded Microsoft Sql Server 2008 R2 and it is giving me an import wizard. Where can I create databases to practice with? I still don't seem to get the big picture on where to write sql code, etc.....I only downloaded it a few mintutes ago so I'll look tomorrow |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-07-14 : 05:26:02
|
quote:
Originally posted by russell
... And MySQL and Access can't touch SQL Server for range of features, connectivity and robustness.
I'm gonna gave to object to that, especially the robustness. MySQL is actually pretty awesome if you're happy working in a *nix world. If we're only talking about the windows version then what you're saying would be fairly accurate but MySQL is surprisingly good for a free product. I worked for a phone company a short while back and their entire core system was based on MySQL...we're talking tables with +500 mill rows and it was blazing fast if you kept your queries in order. But you won't get Management Studio and you don't get sqlteam.com which pretty much rules it out for me  - LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-07-14 : 05:28:43
|
| pgh333: I hope you installed the management tools as well? You'll need SQL Server Management Studio Express to get anything sensible from your express database.- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
pgh333
Starting Member
5 Posts |
Posted - 2011-07-15 : 15:07:34
|
| Thanks for the help everyone, i was tied up and didnt get a chance to work on it anymore last night. I'll try to make some more progress tonight and post. |
|
|
|
|
Program to use