Fill in this short quiz to get your FREE Learn SQL Server Intuitively eBook
Complete our survey and we’ll send you your FREE Learn SQL Server Intuitively eBook. This is our THANK YOU for you. Keep it simple :-)
Training
FREE Webinar to present Learn SQL Server Intuitively. Transact-SQL: The Solid Basics
A FREE webinar that will present Learn SQL Server Intuitively. Transact-SQL: The Solid Basics book and will teach you how to: create tables, insert, update and delete data into them select data from existing tables aggregate data will take place Sat, Aug 13, 2016 10:00 AM – 11:00 AM Eastern Daylight Time […]
The Intuitive Way to Understand the Zig-Zag JOINing with IIF()
In a real world scenario, we can sale in our online store on standard or discounted prices. In this exercise we use three tables to demonstrate the zig-zag JOIN:
Learn SQL Server Intuitively Transact-SQL: The Solid Basics book is on the way
I am very happy to announce that my first book, dedicated to Microsoft SQL Server from the Learn Intuitively series is now on KickStarter.
The Intuitive way to understand the JOINs in SQL Server
When we write a DML query that is using JOINed tables as data source, first we need to understand the way SQL Server is manipulating the data. The clauses in the DML query statement are ordered as follows: SELECT FROM… JOIN WHERE GROUP BY HAVING ORDER BY Behind the scene […]