• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

SQL Server Training

Hello everyone, I will be starting a new adventure in the new year.  I will be working with MS SQL Server.  I was wondering if you can point me to any good URL or books that you have used in  learning SQL Server.

Thanks for your time and very much appreciated.
0
algotube
Asked:
algotube
  • 3
  • 2
  • 2
  • +2
4 Solutions
 
dlan75Commented:
Hi,
Best books are the one from O'Reilly, unfortunately I have no good online training in mind.
0
 
Jaime OlivaresCommented:
A little tutorial and reference:
http://w3schools.com/sql/
0
 
Jaime OlivaresCommented:
Of course you can download the MS SQL Server Books Online from MSDN:
http://msdn2.microsoft.com/en-us/sql/bb428874.aspx
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
David ToddSenior DBACommented:
Hi,

I'm curious as to why you state that you are starting a new adventure and be working with SQL Server, and yet you suggest that you are intermediate on this subject.

Can you give a few more particulars - your background, what you will be doing with SQL Server, and what versions do you anticipate that being with.

Cheers
  David
0
 
PaultheBrokerCommented:
Robert Vieira: Professional SQL 2000 Programming is actually excellent.  Not a 2005 book admittedly, but still a pretty good MSSSQL reference.
0
 
algotubeAuthor Commented:
David,
              How are you doing? Sorry I did not reliaze that I had put intermediate in my question (I only wish I was a intermediate).  I have been a Oracle DBA for 7 years but our SQL Server DBA will be retiring and I will be taking over his role. At this point and time I don't know If I will be doing both jobs.
Will be meeting with my manager and SQL Server DBA next week and will know more on what I will be doing with SQL Server and what versions we have.

Regards
0
 
Jaime OlivaresCommented:
if you are a 7 years DBA my MS SQL Online Books proposal is perfect for you.
0
 
David ToddSenior DBACommented:
Hi,

I've done the opposite - worked on SQL and occassionally had to look at Oracle.

In very broad terms, both databases use SQL for queries, and need much of the same stuff to happen, so you need to know the differences for SQL, and some heads-up on what admin stuff needs to be done with a little how-to.

So Books-On-Line, and maybe something like Microsoft® SQL Server™ 2005 Administrator's Companion would be my recommendation.

Again: It depends on what you are doing. SQL 2005 is such a wide product, that a reporting specialist say could spend half a career using SQL Reporting Services, and not need to know much about SQL Admin ...

Cheers
  David
0
 
algotubeAuthor Commented:
Thank you all for you advice very much appreciated.  If I get stuck I will post a few questions...

Thanks again and have a great weekend.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now