Solved

SQL Server Training

Posted on 2007-11-22
9
216 Views
Last Modified: 2010-03-19
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
Comment
Question by:algotube
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 12

Assisted Solution

by:dlan75
dlan75 earned 25 total points
ID: 20336308
Hi,
Best books are the one from O'Reilly, unfortunately I have no good online training in mind.
0
 
LVL 55

Assisted Solution

by:Jaime Olivares
Jaime Olivares earned 75 total points
ID: 20336310
A little tutorial and reference:
http://w3schools.com/sql/
0
 
LVL 55

Expert Comment

by:Jaime Olivares
ID: 20336322
Of course you can download the MS SQL Server Books Online from MSDN:
http://msdn2.microsoft.com/en-us/sql/bb428874.aspx
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 35

Expert Comment

by:David Todd
ID: 20336324
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
 
LVL 6

Expert Comment

by:PaultheBroker
ID: 20336776
Robert Vieira: Professional SQL 2000 Programming is actually excellent.  Not a 2005 book admittedly, but still a pretty good MSSSQL reference.
0
 

Author Comment

by:algotube
ID: 20337068
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
 
LVL 55

Assisted Solution

by:Jaime Olivares
Jaime Olivares earned 75 total points
ID: 20337078
if you are a 7 years DBA my MS SQL Online Books proposal is perfect for you.
0
 
LVL 35

Accepted Solution

by:
David Todd earned 150 total points
ID: 20337171
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
 

Author Comment

by:algotube
ID: 20338843
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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Not selecting duplicate data 6 64
Following an example - removing duplicate strings 4 67
sql query help 2 62
kill process lock Sql server 9 74
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question