SQL Server Queries Part 1 - Writing Basic Queries

[@focusiam2027]

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

[@WiseOwlTutorials]

Happy to hear you found it useful, thanks for taking the time to comment!

[@caseydill7714]

@@WiseOwlTutorials Sadly I don't think the movies database is available for download any more. Can you repost that? Thanks!

[@andrehorochiwsky3627]

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.

[@hrsh369]

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

[@WiseOwlTutorials]

Happy to hear that it's still useful, thank you for watching!

[@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! :)

[@shohelkasamji11]

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

[@WiseOwlTutorials]

Thanks for watching!

[@craignewman6696]

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!

[@charlyclerfeuille4212]

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 !!

[@WiseOwlTutorials]

You're very welcome! Agreed - this SQL series is one of the first we created and could use an updated tutorial including the topics you suggested. We did this already in a later SQL series where we added videos explaining how to install the software, how to construct a database from scratch and how to run a script to install the Movies database which you might find useful kzbin.info/aero/PLNIs-AWhQzcl9QXUSb0GRTxa2XlTHqDE8&feature=shared Thanks for watching!

[@chrisfischer7918]

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

[@gameacctskorphalo5338]

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

[@TonyK55]

Excellent introduction for my first go at SQL query writing

[@MsDKAV]

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

[@chromebiatch]

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

[@rossmolloy]

Thanks it is so helpful. Just started a new job and this was just perfect. I will look at the rest of the uploads in the next few weeks, you are a star wiseowl!

[@nagrajlove]

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

[@gcong2]

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

[@katlivengood3168]

Loved this - so very helpful and your voice is very soothing to listen to as I learn!

[@kalebalessandro2978]

you prolly dont give a shit but does any of you know a way to log back into an Instagram account..? I stupidly forgot my password. I appreciate any tips you can offer me.

[@enzoguillermo5302]

@Kaleb Alessandro Instablaster :)

[@kalebalessandro2978]

@Enzo Guillermo I really appreciate your reply. I found the site on google and I'm in the hacking process atm. Takes a while so I will get back to you later with my results.

[@kalebalessandro2978]

@Enzo Guillermo It worked and I finally got access to my account again. I am so happy:D Thanks so much, you saved my account :D

[@enzoguillermo5302]

@Kaleb Alessandro no problem :)

[@vec2735]

Very engaging, explanatory, I cant wait to watch more.

[@David_F579]

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

[@NRHTX1]

Wow, I am a beginner and watching this video helped a lot. Thank you looking forward to more of your videos.

[@uchihaitachi072]

Dear Wise owl thank you for uploading such Useful video's i am sure these will be very helpful for others.

[@sanatkarsatih]

The greatest Sql video I have ever seen! Thank you so much.. Greetings from Turkey :)

[@Nation010]

Very clear video indeed considering i am an absolute novice. Thanks indeed.

[@nicwarburton8090]

Great explanation. Should make life much easier, thanks Wise Owl

[@nguyenthanhmy1702]

I’ am totally new to SQL. Thanks for your vids

[@bhumi0907]

Thank you so much for providing excellent videos. They are very well explained! Thanks once again!!

[@yinglim5387]

This guide is really the best starting for sql query! Thank you for your very useful tutorial :)))

[@princetitus1230]

Thanks for your teaching video. Your voice is cool to hear and understand.

[@ArabDude123]

This is excellent. I'm so glad I stumbled on it. Thank you very much.

[@kamran_desu]

Excellent intro to T-SQL playlist!

[@markobojovic2242]

Very well explained! Amazing!

[@WiseOwlTutorials]

Thanks for watching!

[@fotoni2]

Thanks for very nice tutorials without Indian accent :)

[@benjaminfaulkner1376]

Brilliant

[@plekkchand]

@Dr Moriarty Yes, prejudiced in favor of decent English. How benighted of him.

[@risebyliftingothers]

SQL or NoSQL, Indians are expert 😂 Britishers please wake up to reality - you no longer rule the world

[@ZiemsRyan]

Very helpful content! Thank you!!

[@WiseOwlTutorials]

You're very welcome Ryan, thanks for the comment!

[@andresjimenez8135]

Very informative video, great job! Very grateful for this instruction

[@jefferyansah3248]

You are a legend. Nice Tutorials

[@RoshanTamilsellvan]

I would kiss your legs for teaching me this. My degree lecturer don't even deserved to be your shoes. Thanks man. I will pray to god for you good being.

[@red_star_MN]

great video, very well explained & straight to the point , thanks for uploading

[@MoeSukkar]

Thank you so much for the video. i am going to watch all of them. very useful

[@adrianoianase]

Long Live the Wise Owl

[@WiseOwlTutorials]

:D thanks Adriano!

[@rahulravi5143]

Very helpful video and guidance! Thank you so much :)

[@estelaarango3276]

Excellent explanation, thanks

[@Frostbyt3zGaming]

This video series is great! Is there a video showing how you filled the tables and columns with data prior to the queries?

[@4dotsofcolor]

Great walk through, very helpful video. Thanks!

[@DamianWalczak]

Thank you very much! Very helpful videos You should consider adding Donate button!

[@justinbanza4751]

Thank you very much for this video

[@WiseOwlTutorials]

You're welcome Justin, thanks for watching!

[@rokrman22]

Best Tutorials ever! I've Learnt all VBA with this genious!! and now entering SQL Server World. Short Question Andrew, I know for oracle you have Oracle SQL and Oracle PL/SQL and I tought it was the same for SQL Server... MS SQL Server sintaxys and TSQ-SQL .... but in most tutorials I'm seeing only TSQ SQL.... so MS SQL Server has only TSQ SQL and not simple queries as regular Oracle SQL?

[@jeffreyjhouser]

Simple yet very informative!

[@alimeshkot2855]

Very well explained. Well done.

[@C3Daddy0]

Excellent videos my good man

[@laxmisidhu4483]

Tnx from bottom of my heart.

[@geeli398]

Thank you very much Andrew

[@tejasvi0claw]

Absolutely brilliant!! Thank you so much :)

[@sitharaskumar139]

you explained it really well!

[@varmelar9844]

Create a table with following rules and regulations ma 1)Id should b identity 2)Name should allow only starting Letter with a to p 3)city should not allow Chennai,cbe, Salem 4) department should allo only cse,it,ece, 5) college default should b anna university 6) per should above only 70% 7) year of passing should be between 65 to 85 8) mailid should not allow null values 9)ph num should b primary key 10) designation should b unique constraints 11) salary default should b 0

[@denisovan]

What is the fastest way to aggregate 1mln rows of data (lets say just 2 columns)? 1. Advanced Filter unique with smth 2. Power query 3. ADODB. 4. D Functions like DSum or Pivot Table 5. Custom functions 6. Dictionary and loop or 7. any other suggestions? It would be great if you make a comparison video with tips and tricks like application. Screenupdating false etc.

[@nigeligwebuike3088]

Fantastic videos, well presented and easy to follow. Thank you so much! Andrew, please let us know how you set your IntelliSense to do keyword upper casing. Thank you.

[@laxmisidhu4483]

Very good lesson

[@JustinHawthorne]

Great video, thank you for posting. Very helpful!

[@kerolosmoner]

thanks a lot ur tutorial very useful.

[@digitalbruno1]

Thank you for the videos, Andrew. I am now so passionate about SQL that I wanted to make my own tutorials. I was wondering if it would be OK with you if I used your Movies Database in my video tutorials so viewers could download and learn from it as well.

[@carolina11b]

very well done !

[@juddin03]

Great tutorial

[@djalsovec88]

Nice video, I`m a beginner with SQL, you make my life easier. Do you know some good book which is more straightforward with typing codes/queries and that stuff ? I'm not willing to read a book of 800 pages.

[@aaronbaker2186]

Advantage of comma at the start of a field is that you can comment a line easily without risking an extra comma breaking your code.

[@WiseOwlTutorials]

Agreed!

[@jkhan9807]

Awsome Videos!

[@restartlife407]

Thank you! very useful...Love it

[@Y5FK]

This is a very good tutorial, really helps! I'm new to this so just a quick one for you; you didn't use commit; or rollback; at the en of the query? Is this not needed? Many thanks

[@wibisonoindrawan5756]

nice tutorial really helpful

[@Stephen_T_Stephan]

Watching your video. Just a question for you. Would it not be prudent to supply a link to your database or utilize Northwind or Pubs for tutorial purposes. That way, if people have SQL Server Express installed upon their machine they can use this video as a practical exercise?

[@karamatkhan5345]

Thank you so much . your videos are very helpful. i have installed SQL Server 2012 and SQL Server Management Studio. i want to practice Movie data base of yours. how can i get it? please help

[@karamatkhan5345]

i was able to copy paste script and create one. thank you so much. :)

[@jessicabelfield]

This is so helpful, does it apply to the latest SQL though (for example if there is a 2015 service)?

[@bharathgoud2994]

Jessica Belfield sa

[@nabeelkhan293]

Great help. Thanks.

[@yourdailymusic6906]

What's the point of dbo.films vs films they print out the same result?And what if i want to make a weird alias like '["Film"]'? I was trying to do that but...Thanks for tuts this channel is all i need right now!

[@lawrenceely757]

Great tutorial, but one thing is missing. How do you save the query into an appropriate folder. Reopen. Edit. Then save again. I can't seem to find this basic scenario in any basic tutorials. It is very frustrating.

[@gogishviliioseb4603]

Thanks for the info

[@laxmisidhu4483]

Hi there, I learn sql from ur videos which is fantastic , u gor very deep roots in sql I can say that. but I need ur help PLEASE tell me which book is best to learn MS SQL SERVER 2008 r2 ex and T SQL . Regards Sam

[@laxmisidhu4483]

Thankyou Sir , really appreciate ur reply. regards Sam

[@krismaly]

Thank you it is very useful video

[@rugwizainnocent1881]

thank you very much for the great, great tutorial. is there anywhere I can download the movies Database, for practice purposes? Thank you

[@Robleh100]

I am a seasoned SQL query writer. Here are some questions for you: Is it designed and directed at SSMS 2012 users? Is there an easy way to bring in an Xcel sheet w/o resorting to a flat file and then having to redo the column data types? I am downloading Google Analytics reports of hits to webpages of my web portal and then importing them to SSMS after which, I run queries with TSQL. I want to import the Xcel sheet with the columns defined as they are in Xcel and not have to adjust the table in SSMS after importation of a flat file. I see you have more than one tutorial series. I have been watching SSIS actually should look at query writing. But, I should explore SSIS. It seems I need to download Visual Studio to effectively use SSIS right?

[@in10sken]

please make a tutorial for long field names of tables cause its hard to query if you have like 10 field names...for inserting a data into a table

[@borutudovic1193]

Good tutorial, but how to add database to Microsoft SQL Server Studio. I am having some problems.

[@adarshpatil19]

it was too good :) thanx

[@lightningpop8717]

That udemy crap is over-rated. You Sir, are gold.

[@WiseOwlTutorials]

Thanks so much! :D

[@syedmammar1]

awesome!

[@rempil1888]

Thanks a lot

[@Mansoorsadat]

Hi Andrew - Sorry for the of-topic question. I have built some macros which work in my computer, but not in others. I have googled for the answers, but haven't got one. Can you please advise. Thanks in advance...

[@sc0rn4all]

Thanks a lot! :)

[@wiselonewolfkol512]

i have no experience with computer engineering whatsoever.i understood the whole progress but one thing.do u actually have to already have a database in your compter in order to use sql ( a database language) ?

[@temitopeatanda7811]

SQL will really help me thanks to wiseowl please can i get a link to download the film database so i can use it to practice thanks in advance

[@WiseOwlTutorials]

Hi! Check out the links in the video description!

[@brunosachin]

How did you manage to bring in the file from the desktop onto the server management studio. I am not able to find any of the folders from my computer on the server. Do we have to connect it? How do we do that? this might be a little stupid but I am new to this. Please do help me out with this.

[@FountainRaider]

Your delivery is ridiculous!

[@jymbob69]

This may already have been asked, how can you integrate a pre developed DB from MS access and run in studio to develop queries?

[@eternumllc5822]

sql "new bee" here and im trying to follow along. how do i get the database film you are working on? and all other databases for other training?

[@eternumllc5822]

***** thank you! i found the file downloaded, extracted it but how do I put it into SQL now? Forgive my lack of knowledge on the remedial I am completely new to this trying to learn... :(

[@XxxBoomBoxBeatzzZ]

WiseOwlTutorials, I recognise that accent anywhere, do you come from North-West Wales? 🤔

[@mthwmwn7844]

I am using an excel user interface to scrape data from access using Ado reference library in vba. I am planning on building a dictionary of user inputs to perform a query. Would the below work select where dict.exists(field1)= true;

[@WBrizzle81]

ran the script from the link, but still no movie database. It complied and ran, but I still don't see the database itself

[@thomasprevarin8992]

I need to learn postgres SQL, do you have any tutorial on that?