<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
Learning SQL for a beginner
Learning SQL for a beginner
Rate Topic
Display Mode
Topic Options
Author
Message
waqqas.zia
waqqas.zia
Posted Thursday, August 02, 2012 2:10 AM
Grasshopper
Group: General Forum Members
Last Login: Thursday, April 11, 2013 9:49 AM
Points: 19,
Visits: 75
Hi Guys,
Im looking to learn SQL server and database management but with a wealth of resources, websites and books im struggling on where to begin.
A little bit about me and my SQL abilities:
Ive done a degree in Mechanical Engineering but graduated at the height of the recession and somehow managed to get a job as a Business Information Analyst,
My company has had redundancies and they have told me that i am now incharge of the DataWarehouse
Ok so in terms of my SQL abilities:
I taught myself SQL Language, to a level where i can now quite confidently query anything within our database using all types of joins and aggregate functions.
I can import data from excel and linked servers (Already established) into the warehouse
T-SQL is something which really baffles me so any pointers on where to begin so i could become more competent at what im doing would be fantastic
Many Thanks
Post #1338995
Koen Verbeeck
Koen Verbeeck
Posted Thursday, August 02, 2012 2:26 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 9:06 AM
Points: 9,367,
Visits: 6,465
Since you already know the basics of SQL, you can read this TSQL book by Itzik Ben-Gang (it's not that easy, but you'll learn a lot from it):
Microsoft® SQL Server® 2008 T-SQL Fundamentals
A more introductory book perhaps is the following:
Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012
It's on prerelease for the moment.
Since you're in charge of the Datawarehouse, you should read up on the Kimball methodology if that is what your company uses:
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition)
Also, get up to speed with BI development in general using the SQL Server BI stack:
MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® 2008 Business Intelligence Development and Maintenance (Self-Paced Training Kits)
And for the accidental DBA:
Troubleshooting SQL Server: A Guide for the Accidental DBA
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1339006
demonfox
demonfox
Posted Thursday, August 02, 2012 3:03 AM
Ten Centuries
Group: General Forum Members
Last Login: Saturday, May 18, 2013 6:46 PM
Points: 1,074,
Visits: 1,076
waqqas.zia (8/2/2012)
Hi Guys,
My company has had redundancies and they have told me that i am now incharge of the DataWarehouse
what company is that !! :P
a better way to start- get to the basics, subscribe to sqlservercentral ; read the daily article, go through previous articles .. that would do , i think
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1339019
waqqas.zia
waqqas.zia
Posted Thursday, August 02, 2012 3:09 AM
Grasshopper
Group: General Forum Members
Last Login: Thursday, April 11, 2013 9:49 AM
Points: 19,
Visits: 75
I have been reading articles on SSC and i do find them extreemly well written and informative, however i need some form of structured learning.
Ive taught myself all i know with help from SSC and other forums,
Ill look up the books above and see how i get along,
In terms of qualifications for the near future,
do you think it would be advisable to do a Microsoft certification?
Post #1339022
Koen Verbeeck
Koen Verbeeck
Posted Thursday, August 02, 2012 3:14 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 9:06 AM
Points: 9,367,
Visits: 6,465
Sure, you can get a certification. You'll need some real life experience though.
But at least it will force you to look at aspects of SQL Server you're not familiar with.
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1339024
waqqas.zia
waqqas.zia
Posted Thursday, August 02, 2012 3:15 AM
Grasshopper
Group: General Forum Members
Last Login: Thursday, April 11, 2013 9:49 AM
Points: 19,
Visits: 75
Cool
Ok...ill get reading and will be in touch...
Thanks for all the advice
Post #1339025
Koen Verbeeck
Koen Verbeeck
Posted Thursday, August 02, 2012 3:18 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 9:06 AM
Points: 9,367,
Visits: 6,465
No problem, glad to help
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1339026
erics44
erics44
Posted Thursday, August 02, 2012 3:32 AM
SSC Veteran
Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 266,
Visits: 512
i was chucked in the deap end much like you seem to have been and it worked for me, i picked the basics of TSQL quite quick
still learning lots and lots daily 10 years later :)
Post #1339031
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
