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!
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! :)
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!
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 !!
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 ruclips.net/p/PLNIs-AWhQzcl9QXUSb0GRTxa2XlTHqDE8&feature=shared Thanks for watching!
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!
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
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.
@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.
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.
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
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.
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.
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.
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?
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?
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;
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!
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...
***** 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... :(
I've spent over an hour trying to connect to sql server. For some reason it doesn't let me log in using my PC name. Tried the Microsoft website, but can't find out why I have the problem :(
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.
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
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.
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?
10 years later and still an amazing tutorial, thank you sir!
Happy to hear you found it useful, thanks for taking the time to comment!
@@WiseOwlTutorials Sadly I don't think the movies database is available for download any more. Can you repost that? Thanks!
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!
You are the best teacher i've had - in college, in grad school, in high school, and in elementary school. Thank you.
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! :)
What a brilliant video. Absolutely loved how much details and explanation was provided. It wasn’t overwhelming and so easy to understand. Amazing!! 👌🏽
Thanks for watching!
After 12 years, iranian college using sql 2008 and wow im here so great!
Btw the video is amazing
Happy to hear that it's still useful, thank you for watching!
articulate and explanatory. Just love the way how you get the concept across with such ease. one of the best tutorials i have found
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.
you have NO idea how helpful ALL your videos have been! Thank you!
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!
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!
Excellent introduction for my first go at SQL query writing
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 !!
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 ruclips.net/p/PLNIs-AWhQzcl9QXUSb0GRTxa2XlTHqDE8&feature=shared
Thanks for watching!
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!
Wonderfully explained, nice pace and relaxing voice too. Thumbs up!
After finding your videos very useful I am recommending the query-writing playlist to my colleagues at work. Thank you!
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
GREAT TUTORIAL!!! I really enjoyed the breakdown of shortcuts and all that came with it. GREAT job! Thank you.
Loved this - so very helpful and your voice is very soothing to listen to as I learn!
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.
@Kaleb Alessandro Instablaster :)
@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.
@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
@Kaleb Alessandro no problem :)
This is a really excellent 12 video playlist. Thank you for producing and making available.
Wow, I am a beginner and watching this video helped a lot. Thank you looking forward to more of your videos.
Very engaging, explanatory, I cant wait to watch more.
Thanks alot...
i was looking for video of this kind since ages now ..................simply awesome ....
The greatest Sql video I have ever seen! Thank you so much.. Greetings from Turkey :)
Dear Wise owl thank you for uploading such Useful video's i am sure these will be very helpful for others.
Great explanation. Should make life much easier, thanks Wise Owl
This is excellent. I'm so glad I stumbled on it. Thank you very much.
This guide is really the best starting for sql query! Thank you for your very useful tutorial :)))
Thank you so much for providing excellent videos. They are very well explained! Thanks once again!!
I’ am totally new to SQL. Thanks for your vids
Very clear video indeed considering i am an absolute novice. Thanks indeed.
Thanks for your teaching video. Your voice is cool to hear and understand.
Thanks for very nice tutorials without Indian accent :)
Brilliant
@Dr Moriarty Yes, prejudiced in favor of decent English. How benighted of him.
SQL or NoSQL, Indians are expert 😂 Britishers please wake up to reality - you no longer rule the world
Very well explained! Amazing!
Thanks for watching!
Excellent intro to T-SQL playlist!
Very helpful content! Thank you!!
You're very welcome Ryan, thanks for the comment!
Very informative video, great job! Very grateful for this instruction
Long Live the Wise Owl
:D thanks Adriano!
Very well explained. Well done.
You are a legend. Nice Tutorials
Excellent explanation, thanks
Simple yet very informative!
Thank you so much for the video. i am going to watch all of them. very useful
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.
Great walk through, very helpful video. Thanks!
Excellent videos my good man
great video, very well explained & straight to the point , thanks for uploading
Thank you very much! Very helpful videos
You should consider adding Donate button!
Very helpful video and guidance! Thank you so much :)
Thank you very much for this video
You're welcome Justin, thanks for watching!
you explained it really well!
very well done !
Awsome Videos!
Tnx from bottom of my heart.
Great video, thank you for posting. Very helpful!
Great tutorial
Absolutely brilliant!!
Thank you so much :)
Thank you very much Andrew
Very good lesson
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
i was able to copy paste script and create one. thank you so much. :)
This is so helpful, does it apply to the latest SQL though (for example if there is a 2015 service)?
Jessica Belfield sa
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.
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.
This video series is great! Is there a video showing how you filled the tables and columns with data prior to the queries?
nice tutorial
really helpful
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.
thanks a lot ur tutorial very useful.
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?
I need to learn postgres SQL, do you have any tutorial on that?
Thank you! very useful...Love it
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?
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;
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!
Great help. Thanks.
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...
ran the script from the link, but still no movie database. It complied and ran, but I still don't see the database itself
Good tutorial, but how to add database to Microsoft SQL Server Studio. I am having some problems.
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
How do I get the sample databases to follow the tutorials?
Thanks
Hi, I couldn't download the training, there seems to be a problem occurred when I click the link, please help.
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?
***** 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... :(
I could not find anything under database diagram folder. I've downloaded the script and run it on MSM. Please reply me.
I've spent over an hour trying to connect to sql server. For some reason it doesn't let me log in using my PC name. Tried the Microsoft website, but can't find out why I have the problem :(
What version are you using?... Thanks!
@Mansoorsadat depends, what kind of macros are they? What do they do?
Do you just simply hit 'Enter' or 'Return' to start a new command line. Does it automatically indent?
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.
This may already have been asked, how can you integrate a pre developed DB from MS access and run in studio to develop queries?
it was too good :) thanx
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
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.
Downloaded
GenerateUpdatedMoviesDatabase & GenerateMoviesDatabase
Ran both but no tables got created !
Please help.
***** No error messages, just nothing got populated. Not too is there is a way to share with screen shots
thank you very much for the great, great tutorial. is there anywhere I can download the movies Database, for practice purposes? Thank you
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
Hi! Check out the links in the video description!
Thanks for the info
how can we descripe table that we had créating???? because desc dont work here
Could you please tell how to add that file to database
Hi, the IntelliSense feature is not working for me even if its checked under options. Could you pls help??
That udemy crap is over-rated. You Sir, are gold.
Thanks so much! :D
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?