Welcome to Sqlhints.com’s 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.
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.
I hope you all will enjoy this Tutorial, happy learning and best of luck!
Lists of Lessons which will be covered in this Tutorial
|Lesson 1:||Variables and Data Types|
|Lesson 2:||Working with Databases|
|Lesson 3:||Working with Tables|
|Lesson 4:||Constraints – PRIMARY KEY, UNIQUE KEY, FOREIGN KEY, CHECK, and DEFAULT|
|Lesson 5:||Querying Data Using SELECT|
|Lesson 6:||Joins – INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN,CROSS JOIN & SELF JOIN|
|Lesson 7:||UNION AND UNION ALL|
|Lesson 8:||Looping constructs in Sql Server|
|Lesson 9:||DML Statements – INSERT, UPDATE, and DELETE Statements|
|Lesson 10:||Stored Procedures|
|Lesson 11:||User Defined Functions|
|Lesson 16:||Exception Handling|
|Lesson 17:||Table Variable and Temporary Tables|
|Lesson 18:||BackUp And Restore|
|Lesson 19:||Import and Export|
|Lesson 20:||Security in Sql Server|
|Lesson 21:||New Features in Sql Server 2008|
|Lesson 22:||New Features in Sql Server 2012|
|Lesson 23:||New Features in Sql Server 2014|
|Lesson 24:||New Features in Sql Server 2016|
Background for this Sql Server Tutorial:
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’t worry I will train you go-ahead and agree for giving the Sql Server Training.
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.
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.
And recently on 11th Jan, 2014 post my Presentation at the Microsoft Office on “Exception Handling In Sql Server” got amazing Feedback. Some of the messages posted in the Facebook SQLBangalore user group were “Thanks Basavaraj Biradar! Your session was divine!” , “Thanks Basavaraj for your excellent session” 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.
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.