April 21, 2011 at 3:26 am
Hi,
I want learn SQL server but want to do it self study - company I work for don't want to send me on a course.
What is the best or most preferred place on the online that I can get learning material from...and hopefully its free 🙂
April 21, 2011 at 5:15 am
You're going to be hard pressed to find a good, comprehensive training program that is also completely free. How about picking up a book? I was one of the authors on "Beginning SQL Server 2008 Administration" It'll get you started.
Otherwise, you might want to take a look at some of the videos offered through sqlshare.com, but they're not broken down in a comprehensive set of lessons. This is the Microsoft training portal for SQL Server. Might be bits of things in there.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 22, 2011 at 3:50 am
There are loads of free stuff available but here is something from Microsoft.. http://www.microsoft.com/events/series/technetsqlserver2008.aspx
April 22, 2011 at 1:38 pm
i'm currently studying for the MS Database Programming cert, 70-433 exam, to accomplish the same thing. The book that accompanies this exam is fairly straight forward and coincides with MS's Adventureworks example database.
May 1, 2011 at 1:09 pm
Most of the people I have worked with who attended SQL training courses still failed to make any real impact as a DBA. I would suggest the best way to learn SQL is simply getting your hands dirty with the actual product. Download the express edition and use some of the resources mentioned previously. Start playing around with Adventureworks and think of a project of your own. Make mistakes and learn from them. Mr Google and this site in particular have always managed to point me in the right direction when I have been staring at an unfathomable SQL problem.
Good Luck.
May 2, 2011 at 12:05 pm
maverickza (4/21/2011)
Hi,I want learn SQL server but want to do it self study - company I work for don't want to send me on a course.
What is the best or most preferred place on the online that I can get learning material from...and hopefully its free 🙂
You said you want to learn SQL, which is different from learning SQL Server. If all you need to know if how to query a SQL Server database, then start out with a book on just SQL. If you pick up a book on SQL Server Administration, then you'll likely be overwhelmed with a lot of information that you don't need. Maybe go to a bookstore, browse some SQL books, and see which one speaks to you. The following is one suggestion.
SQL In A Nutshell
http://oreilly.com/catalog/9780596518851/preview
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 3, 2011 at 8:56 am
Here is a free ebook on beginning SQL (emphasis on SQL not SQL Server). Just click on the links for the chapters to get started.
http://www.informit.com/library/library.aspx?b=STY_Sql_24hours
May 3, 2011 at 9:03 am
Second vote for SQL in a nutshell for SQL.
If you want SQL Server, pick up any SQL Server 2008 admin book. They're all about 80% the same. Go through it page by page, work through the exercises. That will help you learn in an organized fashion.
You can subscribe to the newsletter here, which will help you pick up tips and tricks, but I'd really recommend an organized book first. You can also pick up this one from us, and it might give you a good start as well: http://www.sqlservercentral.com/articles/books/67441
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply