SQL Training Online

Archives for 2017

by Leave a Comment

Union and Union All – How to use it in SQL Server

 

Union and Union All are very similar, but if you don’t understand the differences, it can cause trouble.

In this video I do a quick demonstration of the Union and Union All Function.

Video: SQL Server Union and Union All


How to use the SQL Server Union and Union All Operators to combine data sets.

I use the Wide World Importers and the following scripts:

select * from [Application].[People]
where PersonID between 1 and 5
union
select * from [Application].[People]
where PersonID between 4 and 9

 

See the original  SQL Union and Union All video.

by Leave a Comment

Big Data Everywhere

Hey guys, I’m on ESPN.com today checking out Russell Westbrook’s 49 points in his return to the NBA after a freak accident.

Russell fell down and a teammate ran into him fracturing his jaw.But, despite surgery a few days ago, he came back with a mask and dropped 49 points.

Now, I’m not a huge Russell Westbrook fan, or a fan of the NBA in general, but that is a pretty cool story.

But, that isn’t what got my attention…

What really got my attention was the commercial that showed up on ESPN before the highlight.

It was about IBM analytics… Watson Analytics.

I thought, “Wow! Analytics and Big Data are main stream.”

It wasn’t normal consumer products like Insurance…

But, it was about data!

This is validation that the BI market is huge.

You don’t see commercials about .Net development, or Java development, but commercials about data and analytics.

You constantly see stuff in the news about Big Data and Analytics.

If the big companies are selling it, businesses need people like us to actually make them work.

This means jobs, higher demand, and ultimately money.

And, it doesn’t have to be crazy complex to get started.

Even the Big Data stuff ends up in relational databases.

If you haven’t checked out my 30 Free SQL videos yet, they have been moved to a free membership site.

You have to provide your email, but it is 100% free.

https://www.sqltrainingonline.com/30-free-videos/

Click it while it is still active.

In the member’s area, it is easier to find all of the videos and it also includes the practice database.

Sincerely,
Joey Blue

P.S.  Getting started with SQL is easiest by just starting with the SQL Query.  That is exactly what this training does.  Don’t wait any longer, start now.
https://www.sqltrainingonline.com/30-free-videos/