It has been more than 3 months since we have started experimenting with a new concept in SQL in Sixty Seconds. Every Wednesday, we putt a fresh new interesting concept out via video. Rick Morelan, Vinod Kumar and myself – the three of us decided to do something new and something exciting. We decided to create a short video which will consider the attention span of the viewer, keep them focused and help them learn something new through our teaching.
We all liked the idea of SQL in Sixty Seconds. As the name suggests, you will not watch content for more than a minute. We did our best to keep the video down to single minute, well, in most of the cases. There are cases when we could not accommodate the content in sixty seconds so the video had to roll for over few more seconds. In the end, we try to come up with an extremely short video which is able to teach some learning on SQL Server. So far we have 10 videos out for the SQL in Sixty Seconds series.
SQL in Sixty Seconds
Here are the details to our SQL in Sixty Seconds series. It has a total of 10 videos and a total cumulative time of around 15 minutes for all the videos.
Episode 01 – Subquery to CTE
Episode 02 – T-SQL Errors and Reactions
Episode 03 – T-SQL Constructs – Declaration and Initialization
Episode 04 – Function: Is Leap Year
Episode 05 – T-SQL Errors and Reactions Demo
Episode 06 – SQL Server Performance: Indexing Basics
Episode 07 – Table Variables and Transactions
Episode 08 – Using MAXDOP 1 for Single Processor Query
Episode 09 – T-SQL Constructs – += and *=
Episode 10 – Installing AdventureWorks Sample Database
We need your help
We seriously need your help by means of rating our videos. All you have to do is to answer these three simple questions:
1. Which is your most favorite SQL in Sixty Seconds Episode? and Why?
2. Which is your least favorite SQL in Sixty Seconds Episode? and Why?
3. What next you would like to see in SQL in Sixty Seconds?
Just leave your answers in comment area.
Selection of Winner
On May 1st, we will go over the complete list. Rick, Vinod and I have also picked our most favorite episode and least favorite episode. You may call it a co-incidence or an accident, but our choice was exactly the same. Yes, three of us have selected the same video for best and least favorite videos. We will select the winner who has exactly the same selection as our selection. In case of a tie, we will look at the third question and as well as your answers to the “Why” follow-up question asked in the first and second questions.
We have decided to have more than one prize. This time, we’re giving away three prizes for the winners:
- SQL Server Interview Questions and Answers Book – 1 winner
- SQL Wait Stats – 1 winner
- Pluralsight FREE learning code – 5 winners
If you stay in a country where we cannot ship these books, we will send you the appropriate Pluralsight FREE learning code.
Reference: Pinal Dave (http://blog.sqlauthority.com)