>>> Try our online JOIN Types Course Today! As I have been working on the SQL Server JOIN Types poster, I have received several questions around the difference between a CROSS JOIN, and a FULL OUTER JOIN. After looking at the Venn diagrams for the two, they are both shown as the same, however they are not the same by …
Here is a quick video training on how to use the T-SQL DATEPART function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. And here is the sample code to go with the video tutorial: See Also Additional Training on my YouTube Channel Free SQL Query Training 70-461 exam preparation
Here is a quick video tutorial on how to use the T-SQL GetDate function on SQL Server 2012, SQL Server 2014 or newer. This was originally part of my free SQL query training for the 70-461 certification exam. Here is the sample code that goes with the video. See Also Additional Training on my YouTube Channel Free SQL Query Training 70-461 …
Here is a quick video tutorial on how to use the T-SQL CASE function on SQL Server 2012, SQL Server 2014 0r newer. This was originally part of my free SQL query training for the 70-461 certification exam. Here is the sample or demo code from the video tutorial. More Info: Additional Training on my YouTube Channel Free SQL Query Training …
>>> Try our JOIN Types Course Today! After learning the INNER JOIN when querying SQL Server, the LEFT OUTER JOIN and RIGHT OUTER JOIN are often what people attempt to learn next. The reason that I say attempt is that most people don’t get OUTER JOINs right the first time they learn it. This becomes very clear when interviewing developers and …
Here is a short video tutorial that shows how to use the CHOOSE function in T-SQL on SQL Server 2012, SQL Server 2014 or Newer. This was originally part of my free SQL query training for the 70-461 certification exam. Here is the sample code that goes along with the CHOOSE function training. This sample code has been tested and confirmed …
Here is a short video tutorial that shows how to use the COALESCE function in T-SQL on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. Here is the first sample code from the video: And then the code that shows the performance differences: More Info: Additional Training on my YouTube Channel …
Here is a quick video tutorial on how to use the IIF function on SQL Server 2012, SQL Server 2014 0r newer. This was originally part of my free SQL query training for the 70-461 certification exam. Here is the sample code from the video. More Info: Additional Training on my YouTube Channel Free SQL Query Training
>>> Try our JOIN Types Course Today! The INNER JOIN has to be the most common JOIN type in SQL Server. This is where we will start on our journey to understand all the JOIN types in SQL Server. The best way that I have discovered to represent JOINing tables is to use Venn Diagrams that show what overlaps, what …
In this presentation we will be training on TSQL Functions, there will be three sections. Date and Time Functions Logical Functions User Defined Functions Here is the link to the Google On Air Broadcast where you can watch live (or recorded later) for free. https://plus.google.com/events/cb0pj9ghp5elt6i241kstphcvr0 Here are the slides. And here is the broadcast at YouTube: This session will be …