Sql Server Tutorial

Introduction

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 12: Views
Lesson 13: Triggers

Lesson 14: Indexes
Lesson 15: Transactions
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.

31 thoughts on “Sql Server Tutorial

  1. Hello Basarvaj,

    Please let me know when you will upload the tutorial on Trigger (Lesson 12) and Index (Lesson 13). You have explained the database concept in excellent way :).

    Thanks & Regards,
    Vijay Singh

  2. very usefull.
    i want to know about, IDENTIFY THE SIMILARITIES AND DIFFERENCES (RANGE; DATA ACCESS TOOLS,RECOVERY,AUDIT,DISTRIBUTED DATA MANAGEMENT,BACKUP,TRANSACTION PROCESSING) IN MSSQL 2014 VS ORACLE 11G

    1. Thank you Sagara. I have never worked on Oracle, will not be able to help with your request. If you want to contribute with a guest post on this topic, I will be happy to post it on your behalf.

    1. Hi George Jaison N J,

      If everything goes as planned, this coming may you can see a series of articles on Indexes with extensive list of examples.

      Thanks,
      Basavaraj

      1. Dear Basavaraj,

        First of all, Thanks for sharing your knowledge.
        Please share your thoughts and inputs on
        Lesson 13: Triggers
        Lesson 14: Indexes
        Lesson 15: Transactions

        Regards,
        Chiran

        1. Hi Chiran,

          Posted four articles on Triggers. Working on the articles on Indexes and Transactions

          Thanks,
          Basavaraj

  3. Hi Basavaraj, Thanks for sharing nice tutorial. It is very helpful.
    When you are planning to post tutorial#9, 14, 15, 18, 19 and 20. Eagerly waiting for it.

    Nice Work. Keep it up. God Bless you.

  4. Topics are very well explained and organized. Thanks Basavraj for creating such a nice knowledge base.
    Eagerly awaiting your post on Indexes.

Leave a Reply

Your email address will not be published. Required fields are marked *