These are the best free tutorials I have ever seen hands down. Amazing education, thank you!
@S2100211
3 жыл бұрын
Another very good video explaining something that is quite complicated. My SQL understanding and knowledge of SQL has improved 100% since I started watching this set of videos. A million thanks for all your hard work in making this look easy.
@WiseOwlTutorials
3 жыл бұрын
You are very welcome indeed! Very happy to hear that you found it useful and thanks for taking the time to leave us a comment, it's much appreciated!
@samadoonhersi
10 жыл бұрын
Better than what they teach us in University, you are amazing!
@MegaDixen
2 жыл бұрын
Universitys teachers 70% time suck as
@aw1789
7 жыл бұрын
You're a great teacher who is definitely doing what you were born to do. I don't know where I'd be without your videos. Thanks a lot!
@mistery4437
8 жыл бұрын
I never thought teaching can be so compelling. Absolutely riveting. Thanks Andy.
@ThatOneRightThere
3 жыл бұрын
Such a well done video, made learning Cursor processors and when to use them so much easier than shifting through documentation online. Definitely going to check out other tutorials by WiseOwl.
@WiseOwlTutorials
3 жыл бұрын
Thank you so much Jacob, happy to hear that you found it useful and thank you for taking the time to add a comment!
@houstonfirefox
2 жыл бұрын
Very well done! The Relative Operations come in handy for stepping through Year Quarters of a project I'm working on now. Bravo!
@WiseOwlTutorials
2 жыл бұрын
Happy to hear that you found it useful, thanks for watching!
@ezekieltorres3798
4 ай бұрын
Brilliantly concise material. Thank you for the guide.
@WiseOwlTutorials
4 ай бұрын
Thank you!
@BijouBakson
3 жыл бұрын
that's a lot of information in less than 30 minutes. Great thing we can play it on repeat.
@WiseOwlTutorials
3 жыл бұрын
Thanks!
@DukensteinA1
5 жыл бұрын
This is one of the best tutorials I’ve seen.
@WiseOwlTutorials
5 жыл бұрын
Thanks! Appreciate the comment and thanks for watching!
@digitalbruno1
9 жыл бұрын
Wonder if anyone else feels that Andrew sounds a lot like Sir David Attenborough. Only this is a SQL 'documentary' if you will ;) Thank you very much for these videos Andrew. Very educating and so easy to understand. I got my job learning SSRS by viewing your videos. Much respect to you.
@digitalbruno1
9 жыл бұрын
Thank you Andrew. I got this job from watching your videos and learning SQL and SSRS within about a week. I've also recommended your channel to a lot of my friends in India, here in Canada and the US. We're all very grateful to you for passing on this knowledge and wish you all the best. Thanks again!
@Fifwayte
Жыл бұрын
Very nice video even 10 years later, thank you
@WiseOwlTutorials
Жыл бұрын
Glad you liked it, thanks for watching!
@BoazNahumPlus
Жыл бұрын
Fantastic presentation. Very clear and well edited.
@WiseOwlTutorials
Жыл бұрын
Thanks for watching!
@BRelding92
9 жыл бұрын
Hi Andy, these videos are "super dope". Really well explained and very easy to understand. I'm currently doing an MSCA and think I will be using your videos extensively. Cheers!
@alireza2295
8 жыл бұрын
Thanks mate for making such useful and easy-to-understand videos. I am thinking of sharing my experience with our managers to see if they are willing to arrange an on-site training for our analysts within the organisation.
@dmnreddy
10 жыл бұрын
Too good, Thank you so much for your dedication towards the presentations.
@MicheleStrom
5 жыл бұрын
For anyone following along with the video and using the Movies database that's linked above, note that you won't have the FilmCumulativeOscars column in your tblFilms table, you'll need to add it in.
@S2100211
3 жыл бұрын
Thanks for this update. I thought I had done something wrong again when I couldn't find the field.
@MicheleStrom
3 жыл бұрын
@@S2100211 HTH
@EEldred505
10 жыл бұрын
Very helpful, really appreciate your videos. They are easy to understand and I always learn what I am looking for.
@krismaly
11 жыл бұрын
Good examples of curser usage. I enjoyed the video. I suggest people watch this video. Thanks
@gospodintanev6783
4 жыл бұрын
That voice and pronunciation!!! You are the voice in the listening part of the ESOL exam aren't you ?!
@suvradeepbanerjee6801
3 жыл бұрын
The 16 dislikes are from trojan horses sitting on Host's desktop. Great tutorial as always thanks!
@WiseOwlTutorials
3 жыл бұрын
😀
@EnduranceT
7 жыл бұрын
Hands down best SQL Server tutorials on KZitem and probably the net. There are poor fools paying a lot of money for INFERIOR training to this. Glad I'm not one of them :)
@TheQciap
10 жыл бұрын
Andrew, what you do here is amazing! :D It is really understandable even for the guy like me who is not native. But there one more thing you could do to make it even more fantastic. :) Simply to provide us - students your database to practice with short video what you attach it to our SQL Server. For us the most important is simply practice, practice and one more time, watching video is not enough. If there is an option like it here forgive me as I am still the beginner in this field (but with great passion) Best regards man!!!
@MicheleStrom
5 жыл бұрын
Thanks Andrew! This is a great video series.
@moisescuca6112
10 жыл бұрын
Excelent tutorial, so useful
@hildesong817
3 жыл бұрын
Thanks for the tutorial!
@WiseOwlTutorials
3 жыл бұрын
You're very welcome Hilde!
@pariuripecartonase9464
7 ай бұрын
Amazing work, thanks
@WiseOwlTutorials
7 ай бұрын
You're welcome, thanks for watching!
@masegosetshogwe3513
7 жыл бұрын
Really Amazing Tutorials ,we appreciate your help a whole lot.
@GaryHutsonVBA
10 жыл бұрын
Sorry Andrew. The link was hiding since the changes to KZitem's interface. I have now found the files. Great job!
@Justme7888
10 жыл бұрын
much much better then what they teach us at mi university,thanks!!!
@andremyszko
4 жыл бұрын
thank u so much WiseOwl!
@Derowik
9 жыл бұрын
Thank you Andrew.This lessons and your VBA course explain programming very well. One question , with your last example I'm getting error: "invalid column name FilmCumulativeOscars"
@lb794
4 жыл бұрын
great video! You are very good at explaining. Question, how would you do a nested cursor and when is it really necessary?
@firozahmad5860
5 жыл бұрын
Really appreciate what you are doing for educating us. From where can I get databases to practice on? Thanks
@jonathanlusby4213
8 жыл бұрын
Exactly what I needed. Thank you.
@damiancollier5051
8 жыл бұрын
Impressive tutorials. With cursors, why are scroll and forward only used? Why not just leave it as cursor with all fetch options available?
@SpoolinMP5
11 жыл бұрын
Amazing, thank you very much. They way its constructed helped a lot.
@marcin2x4
5 жыл бұрын
13:07 - why the FETCH NEXT FROM is nested in the BEGIN/END block instead of being outside? So not having that instruction at line 27 will create infinite loop?
@I677000
10 жыл бұрын
Could you make tutorial about Index, with explanation of reasons to use, how to create and how to maintain them?
@karolames1
10 жыл бұрын
The video is absolutely great!
@eduardokeane
11 жыл бұрын
thanks Sir, greetings from Perú.
@TheRealMrPants
10 жыл бұрын
Great video! In the while loop syntax, why is correct to use SET @TotalOscars+=@FilmOscars rather than just SET @TotalOscars+@FilmOscars Also, maybe you have one and I haven't seen it, but do you plan a video on FOR XML and working with XML in SQL Server? Thanks!!
@mnewmark2855
10 жыл бұрын
***** As a SQL Server/TSQL novice I find your videos incredibly helpful and done with excellent clarity and pace. Thank you for making them available!
@chamelion1red
8 жыл бұрын
Very nice And Useful.......go gr8 bro
@JoeG2324
11 жыл бұрын
really nice video on cursors. I had a question. On your website, I saw a lot of excel vba videos. Could you do some youtube videos on excel vba?
@ankitagurav284
9 жыл бұрын
hiii sir u r vedio is superb thank a lot
@selvadav
11 жыл бұрын
Awesome sir, can you present it for Triggers.?
@MuhammadKhankhan
11 жыл бұрын
you are awesome MR.
@kylearnold4491
7 жыл бұрын
What program setup do people use to program SQL code like this? I have MySQL with XAMPP apache server and the two database languages conflict to where the syntax is always wrong. Really frustrating trying to learn from these tutorials and have MySQL constantly telling me I'm wrong.
@armanwirawan7099
Жыл бұрын
I have a question regarding the print @filename + ‘was released on ‘ + CCONVERT(char(10), filmdate,103) 1. How did sql knows to put jn filmid in convert(char(10)) 2. What does the 103 at the end means why dis you put it there? Thank you
@WiseOwlTutorials
Жыл бұрын
Hi Arman! We have a video on working with dates which explains how it works here kzitem.info/news/bejne/smiuznWXn6KDfaQ You can see the full list of date format codes here learn.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver16 I hope it helps!
@rcasturi55
8 жыл бұрын
Great instruction. Thanks .
@romanvidrevich9973
9 жыл бұрын
I am trying to wrap my head around why @@fetch_status= 0, would result in a true response from the server instead of 1. Could you please elaborate? Thank You
@alaaabdelnabi6088
5 жыл бұрын
thanks for wonderful tutorial m, How i can use "Wildcard" in selecting statment for the crusor ???
@jens3737
8 жыл бұрын
Thank you wise owl
@cheathack
10 жыл бұрын
Great tutorial!
@puurusottamsaha8971
11 жыл бұрын
very nice sir..!! speechless..!
@AshfaaqCurimbaccus
4 жыл бұрын
the best !
@arghyanandy6469
5 жыл бұрын
'Specifies that the membership and order of rows in the cursor are fixed when the cursor is opened.' what does the word 'membership' from the above sentence refers to?
@WiseOwlTutorials
5 жыл бұрын
Hi Arghya, "membership" in this context means that the rows exist in or belong to the cursor. i hope that helps!
@raidibelo973
7 жыл бұрын
Thank You So much
@jackroark6928
6 жыл бұрын
Out of all of you who have commented such nice things as "amazing", "easy to understand", "riveting". "super dope", "excellent", "superb", "Very helpful", "really appreciate", "better than college/university", "absolutely great", "best free tutorials", "helped me get a job", etc., etc....How many of you have donated at least $1.00 using the link in the description? :-)
@java1370
10 жыл бұрын
Very Good
@eduardokeane
11 жыл бұрын
Yes, triggers please!
@arbteampraetorians3452
5 жыл бұрын
tnks a lot dude
@YesYou123333
8 жыл бұрын
Why do you need two fetch statements?
@samirhasanov7894
8 жыл бұрын
first is right after the opening. second one to keep fetching on.
@crypticparadigm2180
5 жыл бұрын
This is nice, but the implementation yields a duplicate on the last loop.
Пікірлер: 91