{"id":2134,"date":"2014-01-26T12:31:16","date_gmt":"2014-01-26T07:01:16","guid":{"rendered":"http:\/\/sqlhints.com\/?page_id=2134"},"modified":"2016-04-01T01:55:20","modified_gmt":"2016-03-31T20:25:20","slug":"tutorialsqlserver","status":"publish","type":"page","link":"https:\/\/sqlhints.com\/tutorialsqlserver\/","title":{"rendered":"Sql Server Tutorial"},"content":{"rendered":"

Introduction<\/h1>\n

Welcome to Sqlhints.com\u2019s Sql Server Tutorial. This Tutorial consists of list of lessons suited for newbee to intermediate programmers or anyone who would like to gain familiarity with the Sql Server Development and Administration. These lessons will help you get a quick head-start with Sql Server. The lessons are designed in such way that theory is explained by means of examples instead of writing long story.<\/p>\n

This Tutorial is work in progress, will be adding Tutorials periodically and update the existing lessons based on the feedback from the community. Do visit us back regularly and spread a word about this Tutorial to the community if you really learnt something new and like us on Facebook page Sqlhints<\/a>.<\/p>\n

I hope you all will enjoy this Tutorial, happy learning and best of luck!<\/p>\n

Lists of Lessons which will be covered in this Tutorial<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Lesson 1:<\/strong><\/td>\nVariables and Data Types<\/a><\/td>\n<\/tr>\n
Lesson 2:<\/strong><\/td>\nWorking with Databases<\/a><\/td>\n<\/tr>\n
Lesson 3:<\/strong><\/td>\nWorking with Tables<\/a><\/td>\n<\/tr>\n
Lesson 4:<\/strong><\/td>\nConstraints – PRIMARY KEY, UNIQUE KEY, FOREIGN KEY, CHECK, and DEFAULT<\/a><\/td>\n<\/tr>\n
Lesson 5:<\/strong><\/td>\nQuerying Data Using SELECT<\/a><\/td>\n<\/tr>\n
Lesson 6:<\/strong><\/td>\nJoins \u2013 INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN,CROSS JOIN & SELF JOIN<\/a><\/td>\n<\/tr>\n
Lesson 7:<\/strong><\/td>\nUNION AND UNION ALL<\/a><\/td>\n<\/tr>\n
Lesson 8:<\/strong><\/td>\nLooping constructs in Sql Server<\/a><\/p>\n
Lesson 9:<\/strong><\/td>\nDML Statements – INSERT, UPDATE, and DELETE Statements<\/td>\n<\/tr>\n
Lesson 10:<\/strong><\/td>\nStored Procedures<\/a><\/td>\n<\/tr>\n
Lesson 11:<\/strong><\/td>\nUser Defined Functions<\/a><\/td>\n<\/tr>\n
Lesson 12:<\/strong><\/td>\nViews<\/a><\/td>\n<\/tr>\n
Lesson 13:<\/strong><\/td>\nTriggers<\/a><\/p>\n
Lesson 14:<\/strong><\/td>\nIndexes<\/td>\n<\/tr>\n
Lesson 15:<\/strong><\/td>\nTransactions<\/td>\n<\/tr>\n
Lesson 16:<\/strong><\/td>\nException Handling<\/a><\/td>\n<\/tr>\n
Lesson 17:<\/strong><\/td>\nTable Variable and Temporary Tables<\/a><\/td>\n<\/tr>\n
Lesson 18:<\/strong><\/td>\nBackUp And Restore<\/td>\n<\/tr>\n
Lesson 19:<\/strong><\/td>\nImport and Export<\/td>\n<\/tr>\n
Lesson 20:<\/strong><\/td>\nSecurity in Sql Server<\/td>\n<\/tr>\n
Lesson 21:<\/strong><\/td>\nNew Features in Sql Server 2008<\/a><\/td>\n<\/tr>\n
Lesson 22:<\/strong><\/td>\nNew Features in Sql Server 2012<\/a><\/td>\n<\/tr>\n
Lesson 23:<\/strong><\/td>\nNew Features in Sql Server 2014<\/a><\/td>\n<\/tr>\n
Lesson 24:<\/strong><\/td>\nNew Features in Sql Server 2016<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Background for this Sql Server Tutorial:<\/h1>\n

In 2011 my wife joined as a Technical Trainer in one of the Leading Chain of Institute in Bangalore as .Net Technical Trainer. But just into her third\/fourth week of Job, she has been requested to give training to the Students who joined for Sql Server Development and Administration Courses. She called me up and asked what should I do as She was not knowing much about Sql Server, then I told her don\u2019t worry I will train you go-ahead and agree for giving the Sql Server Training.<\/p>\n

As usual googled and tried for multiple sites and could not find one site which covers all the Sql Server features in Tutorial format from Basic to Advance. For each topic needed to hop between different sitres. So I have decided to put my Sql Server 10 year experience prepare myself the lessons with Sql Script on daily basis after my office hours. Every day I use to prepare the Script files which was having little theory in it and trained her the same night and next day morning same lesson she use to explain to the students. And the outcome was students were very impressed with her presentation and the examples which she use to demo in very easy to understand way. And in her carrier as a Technical Trainer spanning 8 months she successfully completed 9 Sql Server batches.<\/p>\n

And sometime at the end of 2011 I gave the same script to one of my friend who wanted to learn Sql Server. The result was he became fluent in Sql Server just by going through the Script files which I have prepared for training my wife.<\/p>\n

And recently on 11th Jan, 2014 post my Presentation at the Microsoft Office on \u201cException Handling In Sql Server\u201d got amazing Feedback. Some of the messages posted in the Facebook SQLBangalore user group were \u201cThanks Basavaraj Biradar! Your session was divine!\u201d , \u201cThanks Basavaraj for your excellent session\u201d and so on. And many of the community members asked me to share the script which I have prepared and one of them specifically asked my advice on which site he as to refer to learn the Sql Server from basic to advance, then I told him I am not sure about one site but you need to hop around multiple sites.<\/p>\n

The above incidents made me to share the Sql Server Tutorials which I have prepared for my wife to the Community and make more and more peoples learn Sql Server without much effort. As the Tutorials which I have prepared for my wife were in RAW format and it was not having the Sql Server 2012 and 2014 features in it. Some of the tutorials I have already published but need to organize them in the format of a Tutorial. So as and when I am done with updates to a particular Tutorial I will publish it. So it will be a continuous journey, need all your feedback and support to accomplish this dream project.<\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction Welcome to Sqlhints.com\u2019s Sql Server Tutorial. This Tutorial consists of list of lessons suited for newbee to intermediate programmers or anyone who would like to gain familiarity with the Sql Server Development and Administration. These lessons will help you get a quick head-start with Sql Server. The lessons are designed in such way that … Continue reading Sql Server Tutorial<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-2134","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P3xNAz-yq","_links":{"self":[{"href":"https:\/\/sqlhints.com\/wp-json\/wp\/v2\/pages\/2134","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlhints.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sqlhints.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sqlhints.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlhints.com\/wp-json\/wp\/v2\/comments?post=2134"}],"version-history":[{"count":20,"href":"https:\/\/sqlhints.com\/wp-json\/wp\/v2\/pages\/2134\/revisions"}],"predecessor-version":[{"id":2205,"href":"https:\/\/sqlhints.com\/wp-json\/wp\/v2\/pages\/2134\/revisions\/2205"}],"wp:attachment":[{"href":"https:\/\/sqlhints.com\/wp-json\/wp\/v2\/media?parent=2134"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}