Video: Not All Queries Are Created Equal – Using Having and Where Clauses in SQL ServerBy Paul Ballard
Want to learn how a slight change to two very similar queries can result in syntax errors in SQL Server? In this video excerpt from Pinal Dave and Vinod Kumar’s course SQL Server Questions and Answers you’ll find out, along with gaining some valuable insight into how SQL Server aggregate functions work with the Having and Where clauses. In the full course Pinal and Vinod unravel other SQL Server misconceptions regarding topics like locks and transactions, unique indexes and null, and datetime types.
Pinal Dave is a Microsoft Technology Evangelist (Database and BI). He has written over 2000 articles on the subject on his blog at http://blog.sqlauthority.com. He is the co-author of three SQL Server books – SQL Server Programming, SQL Wait Stats and SQL Server Interview Questions and Answers. Vinod Kumar has worked with SQL Server extensively since joining the industry over a decade ago. Before joining Microsoft, he was a Microsoft MVP for SQL Server for more than 3 years. He is a well-known speaker at all major Microsoft and third party technical conferences.
If you’d like to discover the misconceptions you may have about SQL Server, this course is for you. In the comment links let us know what common misconceptions you’ve found and how you have proven them wrong.
You can watch the full HD version of this video along with the other 2 hrs 40 min of video found in this professional course by subscribing to Pluralsight. Visit SQL Server Questions and Answers to view the full course outline. Pluralsight subscribers also benefit from cool features like mobile apps, full library search, progress tracking, exercise files, assessments, and offline viewing. Happy learning!
About the Author
Paul Ballard is a Chief Architect specializing in large scale distributed system development and enterprise software processes. Paul has more than twenty years of development experience including being a former Microsoft MVP, a speaker at technical conferences such as Microsoft Tech-Ed and VSLive, and a published author. Prior to working on the Windows platform, he built software using a vast array of technologies including Java, Unix, C, and even OS/2.
- New course: SQL Server Questions and Answers
- New Course: SQL Server Performance: Indexing Basics
- Meet the Author: Pinal Dave and Vinod Kumar on SQL Server Questions and Answers
- Video: Make MVVM Simple With Knockout
- Video: Learn NoSQL From The Comfort of CouchDB
- Video: Access OData Across Site Barriers with JSONP in jQuery
- Video: Secure the Cloud Using the Amazon Web Services .NET SDK
- Pluralsight “New Releases” Newsletter – March 13, 2012
- Shake Hands With A Shark!
- SQL Server Sequence Contest: Win a Netbook and More!