i am a newbie . help me to learn sql server
-
hi all, please guide me with some links to learn the basics of sql server
-
the Stairways series is a great start:
http://www.sqlservercentral.com/stairway/
there is a LOT of different subjects, and they build up in complexity and understanding as you go through each stairway.
I'd recommend starting there.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
In addition, there are several good books you can get that will step you through various tasks.
One such is coming out next month
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
Lowell (7/20/2012)
the Stairways series is a great start:http://www.sqlservercentral.com/stairway/
there is a LOT of different subjects, and they build up in complexity and understanding as you go through each stairway.
I'd recommend starting there.
And, don’t hesitate to post your questions in respective forums if you try something & find difficulty in understand/resolve something. Folks here are very friendly, they will help you.
Happy Learning!
-
The Stairways are a great way to learn about particular topics.
Your question about learning SQL Server is more like "how do I learn about government" than "how do I learn to drive a car with a manual transmission". It's very open ended. SQL Server is a huge product, with so many parts that none of us knows it all. It really depends if you are learning to program against SQL Server or administer it.
In either case, I'd also recommend picking up a book (either an admin or t-sql book, depending on what you want to learn) and going through it.
-
Build you own lab a.k.a. install SQL Server on your home computer then go to Books Online a.k.a. BOL (installed alongside SQL Server) and read the chapter about architecture.
After that, start practicing... practicing... practicing on the example databases.
Read the newbies section of this forum, try to answer questions by yourself and check your candidate answer with what senior guys are saying.
What's your background?
_____________________________________
Pablo (Paul) BerzukovAuthor of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice. -
+1
The only key is to set-up and get-started. The sooner you do the sooner you learn.
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
Don't forget to check out the latest SQL Server 2012 book coming your way:
http://tsql.solidq.com/books/tsqlfund2012/
Itzik Ben-Gan's awesomeness 🙂
-Lokesh
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
I would recommend checking out Microsoft Virtual Academy as a good place to learn SQL Server 2012. They have some really awesome expert led courses. It's a great option for learning at your own pace AND the courses are all free. Good luck!.
-
If you are not making mistakes, you are not learning anything new 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/ -
Depending on your experience, the stairway on DML is a good place to start. http://www.sqlservercentral.com/stairway/75773/
Then, since so many people seem to struggle with design, here's a stairway for that. http://www.sqlservercentral.com/stairway/72400/
All the stairways start out with the basics and progress through more in-depth information as you go through them. I'd recommend them to anyone interested in learning a particular topic.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply