SQL Server Queries Part 1 - Writing Basic Queries

By Andrew Gould

You can view a written version of this tutorial at:

You can download the script to create the Movies database used in this video at the following link:

You can see the range of resources and courses we offer in SQL Server here:

[focusiam]

10 years later and still an amazing tutorial, thank you sir!

[andrehorochiwsky]

The BEST comprehensive end-to-end SQL query series published (written and video).   The format, flow, and examples in this 12 part series is exactly what I needed to get up and running quickly.  Making the DB downloadable was a real help as well.   Great job guys, thanks!

[GeetaCLall]

You are the best teacher i've had - in college, in grad school, in high school, and in elementary school. Thank you.

[ntomee]

I'm really happy for these videos. I learnt SQL selects through your vids 2 years ago. Today I use it on a daily basis and helps me during work. It was more efficient than reading books, because I tried that that time prior your vids. Keep it going, nice job! :)

[hrsh]

After 12 years, iranian college using sql 2008 and wow im here so great!
Btw the video is amazing

[shohelkasamji]

What a brilliant video. Absolutely loved how much details and explanation was provided. It wasn’t overwhelming and so easy to understand. Amazing!! 👌🏽

[craignewman]

Thank you!!! I use SQL day to day at a basic level - yet i learnt so many little great gems in this video. Thanks again.

[jeffreyjhouser]

Oh yes, absolutely! I've just started to use SQL Server And although I will be taking some formal courses in the near future, Your videos are clear, concise and very informative. They are some of the best I have come across and I look forward to seeing the rest as time goes on!

[chrisfischer]

Your videos on SQL Server Queries are superb!  I'm getting up to speed on using SQL Server 2012 and these videos are a godsend.  Many thanks!

[mosawimmz]

you have NO idea how helpful ALL your videos have been! Thank you!

[mohdalisyed]

articulate and explanatory. Just love the way how you get the concept across with such ease. one of the best tutorials i have found

[TonyK]

Excellent introduction for my first go at SQL query writing

[gameacctskorphalo]

Very nice....thank you. Just what I need. I'll start running my very first SQL queries next week. I've been exposed to SQL but never, ever had to query data myself. After I get comfortable here I think I'll move to creating Excel Live! Reports. Thank you again

[charlyclerfeuille]

Thank you very much ! In this one video, I already learned more "basics" (starting by code presentation, thanks !) than in the 10+hour I wasted on an inside company SQL. Clear, concise, great.

BUT, if providing the database is an essential help, as a full beginner few weeks ago I would not have been able to install it by myself alone => adding a Part 0 "How to install the Movies DB for training" would be helpful. (as would be a "How to import an excel file as DB", it seems awfully complicated even in 2023).
Going to part 2 right now. Thanks again !!

[MsDKAV]

After finding your videos very useful I am recommending the query-writing playlist to my colleagues at work. Thank you!

[nagrajlove]

Thanks alot...
 i was looking for video of this kind since ages now awesome ....

[chromebiatch]

Wonderfully explained, nice pace and relaxing voice too. Thumbs up!

[gcong]

GREAT TUTORIAL!!! I really enjoyed the breakdown of shortcuts and all that came with it. GREAT job! Thank you.

[fotoni]

Thanks for very nice tutorials without Indian accent :)

[David_F]

This is a really excellent 12 video playlist. Thank you for producing and making available.