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
Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.
I have been following your videos and I found them very useful. I just wanted to thank you for investing so much of your time in creating these super helpful videos. Thanks!
Very good tutorial Venkat. Really clear and easy to follow. This was the first of your tutorials I have seen and I am now planning to start right from the beginning with No.1. Thanks!
Very useful, thank you for sharing this. Another alternative would be 2 to simply add the 'having' keyword after the group by having count(*) >= 2. My 2 cents.
just seeing this video, i have subscribed to your channel and also downloaded 76 of your videos. I'm sure at the end of my completion of these videos, I would turn out to be a mini KudVenkat... :).... Just at the end of this one video I started feeling like a SQL Professional... :)
Thank you very much Venkat, if you come to New York, let me know, I will take you out for dinner to eat Indian food or any food on me. Your a great teacher, I can understand you clearly. Keep it up!!
Hello Toalopez - Wow! That's so kind of you. Thank you very much. I am very glad you found the videos useful. I have included all the sql server tutorial series 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.
Thank you very much, good work as always! Question: general use of -- # temp tables, table variables, CTE and Derived tables are in Stored Procedures and in Function as far as I guessed. where other places we can use them? thank you
Dear Venkat Sir Thank you very much for this awesome topic for achieving same result with different ways but now I'm getting confused which one should be used over other?? Also diff. between Temp table and Table variable
Hi,Mr.Venkat Thanks for Sharing this videos. While in this part 48 You wirte a query to count the total no of emp in the dep. select depname,deptid,count(*)as totalemp from tblemp join tbldep on tblemp.deptid=tbldep.deptid group by DEPNAME,DEPTID . When we see the output where in group by column having two column names so it gives the output based on two columns so it returns output like EG: depname count it 1 it 1 hr 1 hr 1 When we group by depname or group by id it will give proper out put what we required . Please correct me if am i wrong.. Thanks in advance . I am waiting for your asnwer's..
Dear Sir, I thank you for your videos. I would like to know if those videos are still considered as "best practices" nowadays, or we have new technologies available. Thank you
Hello Gaga - This SQL course cover basic and some advanced concepts and yes they are still considered as best practices. Hope this answers your question.
Hi Venkat Nice video....!! thnx for explaing each concept with examples :) but without DerivedTable,View,CTE,TableVariable we can get the output with the following query SELECT D.DEPT_NAME,COUNT(*) AS TOTAL_EMP FROM DEPT D,EMPLOYEE E WHERE D.DPET_ID=E.DPET_ID GROUP BY D.DEPT_NAME HAVING COUNT(*)>1
Hi, venkat could you please make videos on AJAX Controls. I watched a lot of videos but could not understand any of them because they are not a match to the way you explain. So, please make some videos on Ajax controls venkat. I request please...................
In table variable section you mentioned that we can use table variables as parameters between stored procedure. I tried to achieve this. but not working. Please take a look.
Select DeptName, DepartmentId, COUNT(*) as TotalEmployees from tblEmployee join tblDepartment on tblEmployee.DepartmentId = tblDepartment.DeptId group by DeptName, DepartmentId having COUNT(*) >=2 order by DeptName, DepartmentId This query also works we don't have to create view for it or even CTE right??? Could you please explain sir
Magic tables gets created when a trigger is fired. Two magic tables are created inserted which holds new values and deleted which holds the deleted or previous values
Rashmi Sinha hi when u create index on view than a view gets materialzed meaning a view is now can store a data. he sas already done this. please watch indexes session
Hi, I executed a derived table and it work perfectly. But when i try to use CTEs it won´t work. Can i get a little help? The query in the parenthesis gives me a list of "INSUMOS" with FRACCIONR8 ='9802001300'. However, this table still has different "PERMISOR8" in the columns. I´m trying to get only those INSUMOS with PERMISOR8 0203R821001194. I´m only trying to comprehend how to use CTEs, but im not sure this function is available in our system. thank you. WITH R8SEARCH (INSUMOS, DESCRIPTION, FRACCIONR8, PERMISOR8) AS ( SELECT INSUMOS, DESCRIPTION, FRACCIONR8, PERMISOR8 FROM DETALLEI WHERE FRACCIONR8='9802001300' ) SELECT INSUMOS, DESCRIPTION FROM R8SEARCH WHERE PERMISOR8='0203R821001194';
Can anyone please explain in Select DeptName, DepartmentId, Count(*) as TotalEmployees from tblEmployee why it is takin count(DepartmentId) instead of Id column ie count(Id) in tblEmployee.
great video! very useful and very nicely presented! thumbs up :)
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
Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.
Lovely and underrated Channel. I wish this was in the spotlight when I was learning SQL. Thanks a lot for your efforts!
The Best Teacher Ever...:)
Nothing to add. The best video session as always. Feeling better and better in SQL. Different ways of achieving the same results.
This video has so many useful practical knowledge than any other videos in SQL.
Your teaching is very simple and effective, This is how a teacher should explain
I have been following your videos and I found them very useful. I just wanted to thank you for investing so much of your time in creating these super helpful videos.
Thanks!
Great explanation. Clearing too much about this complex matter. Thanks for Brazil.
Really You provide great lectures. God bless You
Nice video .Very simple to understand the all concepts of cte ,view,temporary table,derived tables..
Very good tutorial Venkat. Really clear and easy to follow. This was the first of your tutorials I have seen and I am now planning to start right from the beginning with No.1. Thanks!
Excellent job in explaning the concept of derived tables and CTE, with good examples.
Great explanation with detailed information..love u brother ❣️
Very useful, thank you for sharing this. Another alternative would be 2 to simply add the 'having' keyword after the group by
having count(*) >= 2.
My 2 cents.
Right I was also thinking the same
Now I know why my former coworker used CTE all the time. I always used Table Variables because they reminded me of memory tables in Oracle 8i.
just seeing this video, i have subscribed to your channel and also downloaded 76 of your videos. I'm sure at the end of my completion of these videos, I would turn out to be a mini KudVenkat... :).... Just at the end of this one video I started feeling like a SQL Professional... :)
Very good job here. Beautifully illustrated.
Thanks for the Clarification Venkat!! Great Video and very helpful
Thank you very much Venkat, if you come to New York, let me know, I will take you out for dinner to eat Indian food or any food on me. Your a great teacher, I can understand you clearly. Keep it up!!
Hello Toalopez - Wow! That's so kind of you. Thank you very much. I am very glad you found the videos useful. I have included all the sql server tutorial series 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.
Very simple to understand. Thanks for this video.
thank you for ur great efforts
thumbs up
You're the best boss... great great great explanation.
Thank you! It's clear!
Hi Venkat, really good tutorial.
Hi Kudventak, KUDO to you.
thanks a lot for this video
thanks man that was very helpful
Nice video. Thank you, Sir.
Thank you so much!
Thank you very much, good work as always!
Question: general use of -- # temp tables, table variables, CTE and Derived tables are in Stored Procedures and in Function as far as I guessed. where other places we can use them?
thank you
Thanks Venkat!!!
spot on... may be your full name should be kudos Venkat :)
Dear Venkat Sir
Thank you very much for this awesome topic for achieving same result with different ways but now I'm getting confused which one should be used over other??
Also diff. between Temp table and Table variable
I realized that giving a like before video starts!
Hi sir great video..... can you make a detailed video on optimization of SQL query as well as video on performance tuning
...
Question, @4:59 Line 1 of the query, Doesn't DeptName need to be on both table for any natural join? Or does that not matter for Common tables?
Hi,Mr.Venkat Thanks for Sharing this videos. While in this part 48 You wirte a query to count the total no of emp in the dep.
select depname,deptid,count(*)as totalemp from tblemp
join tbldep
on tblemp.deptid=tbldep.deptid
group by DEPNAME,DEPTID .
When we see the output where in group by column having two column names so it gives the output based on two columns so it returns output like
EG: depname count
it 1
it 1
hr 1
hr 1
When we group by depname or group by id it will give proper out put what we required .
Please correct me if am i wrong.. Thanks in advance .
I am waiting for your asnwer's..
very useful
Dear Sir, I thank you for your videos. I would like to know if those videos are still considered as "best practices" nowadays, or we have new technologies available.
Thank you
Hello Gaga - This SQL course cover basic and some advanced concepts and yes they are still considered as best practices. Hope this answers your question.
Hi Venkat
Nice video....!! thnx for explaing each concept with examples :)
but without DerivedTable,View,CTE,TableVariable we can get the output with the following query
SELECT D.DEPT_NAME,COUNT(*) AS TOTAL_EMP
FROM DEPT D,EMPLOYEE E
WHERE D.DPET_ID=E.DPET_ID
GROUP BY D.DEPT_NAME
HAVING COUNT(*)>1
Hi, venkat could you please make videos on AJAX Controls. I watched a lot of videos but could not understand any of them because they are not a match to the way you explain. So, please make some videos on Ajax controls venkat. I request please...................
why is the DepartmentId not shown when you use CTE? Thank you for your work bro
+Adrian Gg because departmentID is not in the select statement. if added to the select statement it would show up
thanks
In table variable section you mentioned that we can use table variables as parameters between stored procedure.
I tried to achieve this. but not working.
Please take a look.
this is very important feature introduced in sql 2008
Question: Local Temp Table is going to delete anyway after the session ends then why is it good practice to DROP the TEMP Table??
Good question. I am also looking for answer
Select DeptName, DepartmentId, COUNT(*) as TotalEmployees
from tblEmployee
join tblDepartment
on tblEmployee.DepartmentId = tblDepartment.DeptId
group by DeptName, DepartmentId
having COUNT(*) >=2
order by DeptName, DepartmentId
This query also works we don't have to create view for it or even CTE right???
Could you please explain sir
very nice
good video
Pls explain about magic table in sql
Magic tables gets created when a trigger is fired. Two magic tables are created inserted which holds new values and deleted which holds the deleted or previous values
Hi Venkat could you please create one video on Materialized view in SQLSERVER , Thanks in advance
Rashmi Sinha hi when u create index on view than a view gets materialzed meaning a view is now can store a data. he sas already done this. please watch indexes session
Hi, I executed a derived table and it work perfectly. But when i try to use CTEs it won´t work.
Can i get a little help? The query in the parenthesis gives me a list of "INSUMOS" with FRACCIONR8 ='9802001300'. However, this table still has different "PERMISOR8" in the columns. I´m trying to get only those INSUMOS with PERMISOR8 0203R821001194. I´m only trying to comprehend how to use CTEs, but im not sure this function is available in our system.
thank you.
WITH R8SEARCH (INSUMOS, DESCRIPTION, FRACCIONR8, PERMISOR8)
AS
(
SELECT INSUMOS, DESCRIPTION, FRACCIONR8, PERMISOR8 FROM DETALLEI WHERE FRACCIONR8='9802001300'
)
SELECT INSUMOS, DESCRIPTION FROM R8SEARCH WHERE PERMISOR8='0203R821001194';
What is the difference between CTE and Table Variable ... I have been asked this question by interviewer frequently ...
Cte scope is limited to the next line right after the cte declaration. Where as table variable can be used anywhere within the script.
2021
Please I need the code written for this course
Can anyone please explain in
Select DeptName, DepartmentId, Count(*) as TotalEmployees from tblEmployee why it is takin count(DepartmentId) instead of Id column ie count(Id) in tblEmployee.
you are very fast and you know you know
Why didn't you use having here?
Sir, please open your tutorials.blogspot.com.
Anyone in 2025?
Am here
Thankyou