Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Learning SQL for a beginner Expand / Collapse
Author
Message
Posted Thursday, August 2, 2012 2:10 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, October 20, 2013 3:13 PM
Points: 20, Visits: 79
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
Posted Thursday, August 2, 2012 2:26 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:54 AM
Points: 13,731, Visits: 10,687
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
Posted Thursday, August 2, 2012 3:03 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 7:15 PM
Points: 1,129, Visits: 1,163
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
Posted Thursday, August 2, 2012 3:09 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, October 20, 2013 3:13 PM
Points: 20, Visits: 79
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
Posted Thursday, August 2, 2012 3:14 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:54 AM
Points: 13,731, Visits: 10,687
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
Posted Thursday, August 2, 2012 3:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, October 20, 2013 3:13 PM
Points: 20, Visits: 79
Cool

Ok...ill get reading and will be in touch...

Thanks for all the advice
Post #1339025
Posted Thursday, August 2, 2012 3:18 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:54 AM
Points: 13,731, Visits: 10,687
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
Posted Thursday, August 2, 2012 3:32 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 6:36 AM
Points: 286, Visits: 572
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 »

Add to briefcase

Permissions Expand / Collapse