Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful. I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you ruclips.net/user/kudvenkatplaylists?view=1&sort=dd If you need DVDs or to download all the videos for offline viewing please visit www.pragimtech.com/kudvenkat_dvd.aspx Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. ruclips.net/video/y780MwhY70s/видео.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. ruclips.net/user/kudvenkat If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them. Good Luck Venkat
Guys lets just not consume the content but also share Venkat's keen dedication towards teaching... literally its been 12 years since this video...we should share his channel as much as possible with our juniors and working collegues.. I wish I could ve watched this video earlier... he is so clear.... bcz of him I cracked the interview... as a senior analyst in reputed MNC I was using linkedin learning earlier which just waste of money infront of him... Thanks a lot Sir.. loads of respect and love ❤ You will always be my hero for SQL
Thank you very much. I don't have to pay for any class because your vid tutorial is too excellent, easy to understand. You are naturally born to be a trainer
Hi Suresh, thank you very much for the feedback. I am really glad these videos are helpful to you. Training videos are uploaded on a daily basis. If you want to receive email alerts when new videos are uploaded, please subscribe to my youtube channel.
Hi Venky, You are son of Goddess Saraswati the God of Knowledge. Here in North America I feel very proud to be an Indian! Your intentions of helping people around the world to learn is your best Karma. God bless you!
kudvenkat Hi , venkat Sir you videos are really good and i am learning a lot from them . I have one request . Can you provide Us some practicals questions to perform using your videos ? It will help us to try new thing . from Beginner to intermediate . Like Practice " create login Page " , Create some sort of Display page , create something different . Something like which is used in current market .. Problem is i am going for interview as a fresher and they say normal crud operations are basic thing you need to learn more . I can't find how to apply all these into some small project and modules . I hope you understand what i wanted to say . It will be really helpful . Awaiting your reply :) Thanks
Hello Prem - Thank you very much for the feedback. Means a lot me. I have included all the sql tutorial videos, slides and text articles in sequence on the following page. Hope you will find it handy. www.pragimtech.com/courses/sql-server-tutorial-for-beginners/ When you have some time, can you please leave your rating and valuable feedback on the reviews tab. It really helps us. Thank you. Good luck and all the very best with everything you are doing.
Hello Mr.Venkat, Your tutorial on SQL Views made my life easy at work. I have been scratching my head since a month to understand views since I never got a chance to work on SQL. Trust me , I have been through 100 videos to get the best of what I want.. Sooner I saw your video, I subscribed your channel. Keep Educating and inspiring newbies like me ... Sarika Reddy
You are fantastic. I came across your video after looking for DML triggers and I ended up watching more. I clicked subscribe botton imediately 👀thank you for your amazing work, my life is much easier now 🙏
Excellent lesson - thank you! You answered some questions 'on the side', if you will. I was looking for specific information and got 'extra credit'. You taught me things I didn't even know I needed to know!
Hello Venkat, As far as I remember, in store procedure you said that we can use them whenever we need to give limited access to someone. So, I would like to know how is view different from stored procedure? Thanks.
+Nancy Chikara A View Can't Accept a Parameter but a Stored Procedure Can Do So.A View Won't Be Able to Modify a Table...A Stored Procedure can do so.You Can Insert,Update Or Delete a Row Using Views..A Stored Procedure Restricts You From Doing So.A View Can Be Used in Large Queries as A Fundamental Unit.For Example in Joins.
Column names in each view or function must be unique. Column name 'dep_id' in view or function 've' is specified more than once.???why this error is coming??can you tell me??
@kudvenkat when it comes to row/column security or hiding data, once we create the views with selected data, how do we then restrict the user with just these data? I am still a begineer learning about sql. Sorry if I don't nake sense.
+Ravi Sankar Reddy Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful. I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you ruclips.net/user/kudvenkatplaylists?view=1&sort=dd If you need DVDs or to download all the videos for offline viewing please visit www.pragimtech.com/kudvenkat_dvd.aspx Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. ruclips.net/video/y780MwhY70s/видео.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. ruclips.net/user/kudvenkat If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them. Good Luck Venkat
Hi Venkat, thank you for the explanation. i wanted t ask if we run a view having select query from a table and normal select query on the same table. Which one will be faster or will they be same?
Hi Venkat , I have a doubt,I am new to SQL, after listing this video ,i got a question,i.e.. Here view is similar to stored procedure..we have stored procedure to save the selected query and we can use it later,here why we need to create the view again ? is it not same with stored procedure.. please help me.
Uttam Kumar Yadav even if some non-IT person see the name of the table, he cannot see the data from table since he needs authority to be granted from admin.
🙏 many many thanks
Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful.
I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you
ruclips.net/user/kudvenkatplaylists?view=1&sort=dd
If you need DVDs or to download all the videos for offline viewing please visit
www.pragimtech.com/kudvenkat_dvd.aspx
Slides and Text Version of the videos can be found on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use my youtube channel.
ruclips.net/video/y780MwhY70s/видео.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
ruclips.net/user/kudvenkat
If you like these videos, please click on the THUMBS UP button below the video.
May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them.
Good Luck
Venkat
Om Prakash can increase youtube views?..
This guy is the best programming tutor on the web. Seriously...
I strongly agree with ur word.
i agree 💯
Guys lets just not consume the content but also share Venkat's keen dedication towards teaching... literally its been 12 years since this video...we should share his channel as much as possible with our juniors and working collegues..
I wish I could ve watched this video earlier... he is so clear.... bcz of him I cracked the interview... as a senior analyst in reputed MNC
I was using linkedin learning earlier which just waste of money infront of him...
Thanks a lot Sir.. loads of respect and love ❤
You will always be my hero for SQL
Thank you very much. I don't have to pay for any class because your vid tutorial is too excellent, easy to understand. You are naturally born to be a trainer
Hi Suresh, thank you very much for the feedback. I am really glad these videos are helpful to you. Training videos are uploaded on a daily basis. If you want to receive email alerts when new videos are uploaded, please subscribe to my youtube channel.
Thank you ever so much I am a new user of SQL and I find you videos so helpful. You are just brilliant
HATS OFF man the way you describe all the tutorials.
Awesome tutorials for beginners.
Hi Venky, You are son of Goddess Saraswati the God of Knowledge. Here in North America I feel very proud to be an Indian! Your intentions of helping people around the world to learn is your best Karma. God bless you!
Hi Sanjay,
Thank you very much for taking time to give feedback. I am very glad you found these videos useful.
kudvenkat Hi , venkat Sir you videos are really good and i am learning a lot from them . I have one request . Can you provide Us some practicals questions to perform using your videos ? It will help us to try new thing . from Beginner to intermediate . Like Practice " create login Page " , Create some sort of Display page , create something different . Something like which is used in current market .. Problem is i am going for interview as a fresher and they say normal crud operations are basic thing you need to learn more . I can't find how to apply all these into some small project and modules . I hope you understand what i wanted to say . It will be really helpful . Awaiting your reply :) Thanks
God of knowledge is ganesh and the goddess is Saraswati
YES, HE IS actually RIGHT, i also want practice question.
Sure he is.
I am big fan of your sql tutorial. i learn so many things in sql and join the sql company few days ago . Thanks a lot sir ...
This is the best SQL courses I've ever watched. Thank you so much for your hard work on this!
Do I have to watch all 149 for basic knowledge in SQL, if not then how many slides are sufficient?
You are brilliant! You are made to teach others! Thank you!!
Sir, your explanation makes everything easy to understand for everyone, In my group everyone following you only. Thanks a lot for everything
Hello Prem - Thank you very much for the feedback. Means a lot me. I have included all the sql tutorial videos, slides and text articles in sequence on the following page. Hope you will find it handy.
www.pragimtech.com/courses/sql-server-tutorial-for-beginners/
When you have some time, can you please leave your rating and valuable feedback on the reviews tab. It really helps us. Thank you. Good luck and all the very best with everything you are doing.
Hello Mr.Venkat,
Your tutorial on SQL Views made my life easy at work. I have been scratching my head since a month to understand views since I never got a chance to work on SQL.
Trust me , I have been through 100 videos to get the best of what I want.. Sooner I saw your video, I subscribed your channel.
Keep Educating and inspiring newbies like me ...
Sarika Reddy
Really Thank you very much Sir ..
Every video of your class is a Diamond of SQL server ..
Explained really well sir.. itna tou kabhi class may b samaj ni aaya tha jitna video may dekhke samaj aaya. Thank u so much keep Teaching 😊
Best SSMS videos on youtube. Thank you!
I learn from you more than my college! Thank you
Still so useful. Love you Venkat Sir. Thank you for all your efforts.
Brilliant, as usual. Right to the important points and application. No rambling.
Great, I come back to review your videos often!
Con mi modesto ingles, entiendo todo!. Muy buena explicación. Felicitaciones y gracias.
Miguel
All your videos are very clear in explanation and hats off to your effort taken
Thanks' a lot, nice explanation any body can easily understand. The way of explanation is awesome..
You are fantastic. I came across your video after looking for DML triggers and I ended up watching more. I clicked subscribe botton imediately 👀thank you for your amazing work, my life is much easier now 🙏
what a clarity of expressions u have... commendable sir.... salute to u
i am following every videos of u sir.....its very easy to understand.keep ur good work sir..god bless u.
best persons should be appreciated for their work.... thanks
your explanation is very clear n perfect
Great Video. It deserves many Thumbs up. Thank you !!
Hi sir really good explanation...your example are really good .after watvhing your videos I get confidents on that topic..
Thanks a lot venkat.
you are so great .....
explained topics so simply.
sir ..all these videos are very useful .thank you very much
Hi Venkat your sessions are excellent. Thank you very much.
Thanks for great tutorials. I am really grateful to your contribution. Very much appreciated lectures.
I really appreciate the way have explained. Thanks Bro
I understood the concept of Table and view.
You makes it soooo easy man.
Thanks a million 🙏
I appreciate. It was really helpful. I just wanted to find a view description but now I am going to watch other videos.
Awesome explanation ... You are really a pro!
excellent video as usual. Just a tip: use table alias names on joining. So much easier and quicker to use.
Excellent lesson - thank you! You answered some questions 'on the side', if you will. I was looking for specific information and got 'extra credit'. You taught me things I didn't even know I needed to know!
Very helpful. You are a great teacher!
simply superb god bless you mate!!
Thanks, Your Video is very easy to understand.
Thank you Sir for your detailed and easy to learn videos.
Hi venkat, you are a great teacher.
Thank you very much my good sir. It is 2018 and your video really is still relevant and it helped me understand what a view is.
Thank you very much for all your great efforts.
Amazing
So simple and super useful
thanks you very much
Regards from Ukraine
Thanks, sir :) All the videos are very well explained :)
Hello Venkat,
As far as I remember, in store procedure you said that we can use them whenever we need to give limited access to someone. So, I would like to know how is view different from stored procedure?
Thanks.
+Nancy Chikara A View Can't Accept a Parameter but a Stored Procedure Can Do So.A View Won't Be Able to Modify a Table...A Stored Procedure can do so.You Can Insert,Update Or Delete a Row Using Views..A Stored Procedure Restricts You From Doing So.A View Can Be Used in Large Queries as A Fundamental Unit.For Example in Joins.
+Rudra Shivgan Thank you Rudra! your explanation just answered my question
@@rudrashivgan5476 we can insert, updated, delete using sp not by views please check
I love you
all of ur videos are excellent...
What is the difference between valued table function & Views ??
we call each to get a table right ?
It's really great. Thanks ..
very nice explanation sir i liked it....
thank you for your great explaining .
thanks sir..u saved me,,thanks a lot.
Nice explanation, thanks 👍
you are really really wonderful ......!!!!
Excellent video -- Thank you!
Thanks, this has been very helpful!
Your videos are great!
Thank you so much for ur videos
Could you please do a Playlist videos in SSRS, SSIS, SSAS, POWER BI.
Great explanation!!!
Thanks a lot for your session.
Your save lot of lifes...
thanks for this video
i am loving it
its very useful,thanks a lot......
I LOVE YOU MAN!!! :D
Hi Venkat,
Please include DML (Insert and Update) in views, great video
Your content is awesome dude
Thanks a ton Venkat!
Great video!
need to dig further into knowing SSMS.. :) this is a good vid
thanks for such a nice videos
Great tutorials :))))
Thanks for the tutorials
excellent job!
i became ur fan sir
Column names in each view or function must be unique. Column name 'dep_id' in view or function 've' is specified more than once.???why this error is coming??can you tell me??
very useful for beginners,
Awesome explanation ()
Thank you so much...but I have a question "what is the difference between CTE, procedure and view?"
Very nice explanation
@kudvenkat when it comes to row/column security or hiding data, once we create the views with selected data, how do we then restrict the user with just these data?
I am still a begineer learning about sql. Sorry if I don't nake sense.
thanks a lot...for ur videos:-)
Awesome, thank you!
Good explanation venkat
+Ravi Sankar Reddy Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful.
I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you
ruclips.net/user/kudvenkatplaylists?view=1&sort=dd
If you need DVDs or to download all the videos for offline viewing please visit
www.pragimtech.com/kudvenkat_dvd.aspx
Slides and Text Version of the videos can be found on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use my youtube channel.
ruclips.net/video/y780MwhY70s/видео.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
ruclips.net/user/kudvenkat
If you like these videos, please click on the THUMBS UP button below the video.
May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them.
Good Luck
Venkat
Hi Venkat, thank you for the explanation. i wanted t ask if we run a view having select query from a table and normal select query on the same table. Which one will be faster or will they be same?
hi "kudvenkat" I WANT JUST TO SAY TNKE U VERY MCH
Hi Venkat ,
I have a doubt,I am new to SQL, after listing this video ,i got a question,i.e..
Here view is similar to stored procedure..we have stored procedure to save the selected query and we can use it later,here why we need to create the view again ? is it not same with stored procedure..
please help me.
awesome! thanks!
Sir I respect u so much . I follow all videos u uploaded . But how can non-it user use sql query sir ?
Appreciate it . Do you have Pandas series like this ?
Thanks a lot!
excellent man
Hi venkat, do you have any plans in the near future on preparing videos on SSBI,Reporting services etc
super explanation
PLS CAN YOU DO MORE VIDEOS ON SQL ADMINISTRATION AND DATA WAREHOUSE ? PLS
in view if user will do "sp_helptext [viewname] " then he can see the table name. how it secure there ?
Uttam Kumar Yadav even if some non-IT person see the name of the table, he cannot see the data from table since he needs authority to be granted from admin.