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.
its really soooo niceeeee
i want share ur scripts
Hi,
Basarvaj
its really soooo niceeeee.
And i want that please post the tutorial on event in sql server.
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
This is so easy to understand by reading your tutorial. Please keep updating.
Thank you Tariq
Nice explanation
Sir when are you going to update the tutorial for
Lesson 13: Triggers
Lesson 14: Indexes
Lesson 15: Transactions
Sir when are you going to update the tutorial for
Triggers
Indexes
Transactions
Hi Raj,
I will try to do it at the earliest.
Thanks,
Basavaraj
A few years ago I’d have to pay someone for this inaoimftron.
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
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.
hello i want full study material
very helpful article. Keep it up.
Please start posting the tutorial on Indexes in SQL Server.
Eagerly waiting for it.
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
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
Hi Chiran,
Posted four articles on Triggers. Working on the articles on Indexes and Transactions
Thanks,
Basavaraj
Very use full tutorials
Please provide SSRS Tutorials series
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.
Great work sir………
Hi Sir,
could you please upload Indexes lesson
Topics are very well explained and organized. Thanks Basavraj for creating such a nice knowledge base.
Eagerly awaiting your post on Indexes.
I can not stay silently until i give 5 star
Thanks Prasad… Appreciate your comments
sir i am your regular sites reader and i learn so thikable very helpful so i am request to u that please upadate the
Security in Sql Server,import &export,backup &restore ,transaction tutorial part
Thanks Krbablu for your comments… Will try to post the missing articles at the earliest
hi sir,
extremely helpful tutorials you have prepared to learn sql server, also well explained in a matter easy to understand.
Excellent Tutorial. Thank you very much for your effort!!
Very Useful tutorials. I fall in love with the clean explanation at first read itself
Thanks Subbu. I’m glad you found it useful.
Hi Sir
Thanks for sharing and explaining the concepts very beautifully. Could you please share your inputs on Indexes and Transactions.
I work as a junior sql developer and I want to learn advance topics in sql server related to my work place