December 22, 2011 at 10:08 am
Hi Guys,
I want to learn T-SQL Programming but don't know from where to get starts ?
so if you send me some advices ,guidenece or work flow will be very helpful.
Mahalo ( Thank You)
Happy Holidays
December 22, 2011 at 10:30 am
We have a whole series of articles: http://www.sqlservercentral.com/stairway/75773/
December 22, 2011 at 12:08 pm
I started with a book, SQL Server Bible, way back when. That worked for me.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 22, 2011 at 12:16 pm
logicinside22 (12/22/2011)
I want to learn T-SQL Programming but don't know from where to get starts ?so if you send me some advices ,guidenece or work flow will be very helpful.
1- Build your own lab e.g. download and install SQL Server on your home computer, Express Edition would do it.
2- Check Books On Line a.k.a. BOL - which comes for free with SQL Server
3- Start practicing!
_____________________________________
Pablo (Paul) Berzukov
Author 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.December 22, 2011 at 2:35 pm
I do have sql server enterprise installed and have some books also ,i am just confused from where to start first.
but thanks for guidence.
happy Holidays and Marry Xmas
December 22, 2011 at 3:00 pm
logicinside22 (12/22/2011)
I do have sql server enterprise installed and have some books also ,i am just confused from where to start first.but thanks for guidence.
happy Holidays and Marry Xmas
Okay... install AdventureWorks sample database, analyze it so to understand what it does and start writting queries to answer business alike questions like: How many orders we got per region? Which are the sales-persons assigned to each region? etc.
Each time you bump into an issue would be a learning opportunity.
_____________________________________
Pablo (Paul) Berzukov
Author 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.December 22, 2011 at 5:31 pm
logicinside22 (12/22/2011)
I do have sql server enterprise installed and have some books also ,i am just confused from where to start first.but thanks for guidence.
happy Holidays and Marry Xmas
Not sure what level you're at but start with basic understanding, so learn the Syntax first even though you may not understand the whole query you will slowly know what it's trying to achieve.
Then start building queries with basic select statements, followed by the use of other operators "AND/OR", learn the "ORDER BY" clauses before moving into other areas.
I find this site helpful http://www.w3schools.com its a great beginner site that gives you easy to use examples compared to sites like MSDN where it can confuse anyone.
Forums such as this www.SQLServerCentral.com are great ways to learn. Ask questions (there is never anything to stupid to ask) & read other peoples posts.
Also best to use everyday examples that relate to you - I find it easier to get the result, if your work/learning is based on Sales, try to work our how many People sold item A, how many B and how many sold A & B.
Hopefully that helps.
Tava
December 23, 2011 at 7:10 am
Wonderful that really helps me . nice explanation . Yes i am regular member of SQLSERVERCENTRAL.com but i was posting and checking stuff related to DBA only but now i feel to learn more T-sql ofcourse that helps me lot also.
Thank you so much .
Happy Holidays
December 23, 2011 at 7:53 am
I feel that the best way to start learning about SQL is to get a good book, install SQL Server on your home system and work through the examples on your computer as you read them in the book.
I personally recommend any of Louis Davidson's books on SQL Server Database Design. He takes a case study and walks you through the design process, explaining the database design concepts and illustrating with lots of code samples as he goes along.
I have found his books to be excellent, because he explains "mid-level" concepts in a way that anyone can understand. Thus he avoids two problems that a lot of technical books have: either they are too complex for the beginner to understand or they are so basic that they don't explain anything useful.
Also, as a DBA who has to wade through a lot of crap code at work, I really bemoan the fact that most SQL developers don't learn much about database design. Thus they end up writing a lot of queries that "work" when the data sets are small, but that I then have to fix when the data sets get large.
I actually started with one of Louis Davidson's books, and I feel that it helped me tremendously to have a clear understanding of the fundamental design principles as I learned the various T-SQL techniques. It is like having a good framework to help you organize everything that you learn later.
Just my two cents. 🙂 Good luck to you!
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply