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!
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!
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! :)
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
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!
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!
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.
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?
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
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.
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?
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.
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
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
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?
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.
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 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.
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...
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.
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;
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) ?
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!
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!
You are the best teacher i've had - in college, in grad school, in high school, and in elementary school. Thank you.
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!
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!
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!
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.
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
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
you have NO idea how helpful ALL your videos have been! Thank you!
articulate and explanatory. Just love the way how you get the concept across with such ease. one of the best tutorials i have found
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!
After finding your videos very useful I am recommending the query-writing playlist to my colleagues at work. Thank you!
GREAT TUTORIAL!!! I really enjoyed the breakdown of shortcuts and all that came with it. GREAT job! Thank you.
Very well explained! Amazing!
Thanks for watching!
I’ am totally new to SQL. Thanks for your vids
Thanks alot...
i was looking for video of this kind since ages now ..................simply awesome ....
This is a really excellent 12 video playlist. Thank you for producing and making available.
Very clear video indeed considering i am an absolute novice. Thanks indeed.
Very helpful content! Thank you!!
You're very welcome Ryan, thanks for the comment!
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!
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
Dear Wise owl thank you for uploading such Useful video's i am sure these will be very helpful for others.
Wow, I am a beginner and watching this video helped a lot. Thank you looking forward to more of your videos.
Great explanation. Should make life much easier, thanks Wise Owl
Very engaging, explanatory, I cant wait to watch more.
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 :)
Wonderfully explained, nice pace and relaxing voice too. Thumbs up!
This guide is really the best starting for sql query! Thank you for your very useful tutorial :)))
Thanks for your teaching video. Your voice is cool to hear and understand.
Excellent intro to T-SQL playlist!
Thank you very much for this video
You're welcome Justin, thanks for watching!
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.
Excellent explanation, thanks
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
Long Live the Wise Owl
:D thanks Adriano!
Thank you very much Andrew
Thank you so much for providing excellent videos. They are very well explained! Thanks once again!!
Very good lesson
Tnx from bottom of my heart.
Thank you very much! Very helpful videos
You should consider adding Donate button!
Very informative video, great job! Very grateful for this instruction
The greatest Sql video I have ever seen! Thank you so much.. Greetings from Turkey :)
Thank you so much for the video. i am going to watch all of them. very useful
Very well explained. Well done.
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.
Agreed!
This is excellent. I'm so glad I stumbled on it. Thank you very much.
This video series is great! Is there a video showing how you filled the tables and columns with data prior to the queries?
you explained it really well!
Great tutorial
Very helpful video and guidance! Thank you so much :)
very well done !
You are a legend. Nice Tutorials
thanks a lot ur tutorial very useful.
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.
Excellent videos my good man
Simple yet very informative!
Great walk through, very helpful video. Thanks!
Thanks for the info
Awsome Videos!
great video, very well explained & straight to the point , thanks for uploading
That udemy crap is over-rated. You Sir, are gold.
Thanks so much! :D
nice tutorial
really helpful
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?
Great help. Thanks.
Thank you it is very useful video
Absolutely brilliant!!
Thank you so much :)
Thanks a lot
Good tutorial, but how to add database to Microsoft SQL Server Studio. I am having some problems.
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. :)
awesome!
Thank you! very useful...Love it
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.
Great video, thank you for posting. Very helpful!
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?
This is so helpful, does it apply to the latest SQL though (for example if there is a 2015 service)?
Jessica Belfield sa
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.
Your delivery is ridiculous!
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
Thankyou Sir , really appreciate ur reply.
regards
Sam
Thanks a lot! :)
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
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?
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.
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!
it was too good :) thanx
thank you very much for the great, great tutorial. is there anywhere I can download the movies Database, for practice purposes? Thank you
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.
What version are you using?... 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...
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.
I need to learn postgres SQL, do you have any tutorial on that?
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;
@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?
WiseOwlTutorials, I recognise that accent anywhere, do you come from North-West Wales? 🤔
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) ?
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