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 th-cam.com/users/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. th-cam.com/video/y780MwhY70s/w-d-xo.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. th-cam.com/users/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
I enjoyed this video. Friends if you want to answer what is the diff bet CHAR and PAT INDEXS in the interview then this is the best video. Thanks a bunch
It's the best video tutorial, even if it is to compare with the courses wich I bought. I'm reading also the book Querying Microsoft SQL Server 2012 Training Kit and I can see the quality of your video's. Thank's for your work.
Thanks Venkat for providing such comprehensive tutorial. I have been practicing sql questions online and came across a question to find median of a column. I would love you to do a tutorial on writing a sql for finding the median of a column in a table (for example median salary per department).
Hi, Very soon as soon as I am done with sql server. If you can subscribe to my channel, you will be getting updates when I upload new videos. Thank You.
select ID, Name, SUBSTRING(Email,1,2)+REPLICATE('*',2)+SUBSTRING(Email, CHARINDEX('@',Email),LEN(Email)) from tblPerson I think len(email) is better because anyways there are no characters after the last .domain name. It saves the trouble of calculating the remaining length but still for other situations we might need the exact remaining length. Nice explaination. Just watching one by one.
Hello Sir! I really appreciate your hard work simplifying SQL in the best way ever, I admit I never found anyone who can do it in the best way as you do. Thus, I really want to be like you, you're my role model, I am doing my best for the moment, however, I just want to know how much it took you to learn using SQL just as you do now ? A year, two ... ? I am actually making sure to learn all of what you provided in here and I am learning fast, does this mean if I ever finished all of your tutorial videos, and eventually will be able to use all of the queries you provided that I am well qualified to use SQL ? I hope you would answer me so soon. regards.
Thank you very much for taking time to give feedback. Means a lot. Very glad you found the videos useful. It's practise, practise and practise. I have been using SQL for over 15 years now. Experience will naturally get you confident and YES, if you are confident with the concepts discussed in these videos you will be able to use SQL like a PRO. Hope this answers your question.
Hi venkat, Could you please tell me how to write the below sql statement in Oracle Patindex(‘%0-9%’, alphanumeric column) How to give range in instr function??
How can i split this into two columns like ID and Description 867 Other infectious and parasitic diseases diagnoses with mcc Integer value in Id column and rest will be in Description column]
I believe this query is for the demonstration purpose, to only show how to replace the output result, even though actual use case would be to replace data stored in the table, as in your query. Thanks for the info.
I don't understand the idea of SPACE-function. I understand how it works, but I don't understand why it exists. SPACE(5) = REPLICATE(' ', 5), right? Why separate function is needed?
STUFF is simpler if compared to REPLICATE function inside Substring. Sample Code on STUFF with REPLICATE:: SELECT Name,STUFF(Email,2,3,REPLICATE('*',5)) from tblPerson;
Mask all characters between the first letter and the @ sign: select *, stuff(Email, 2, len(Email) - (len(Email) - charindex('@', Email) + 2), replicate('*', len(Email) - (len(Email) - charindex('@', Email) + 2))) as StuffedEmail from tblEmployee
Enjoying this lecture .
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
th-cam.com/users/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.
th-cam.com/video/y780MwhY70s/w-d-xo.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
th-cam.com/users/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
Venkat for president ❤️... Love your video tutorials bro, wish I could meet you one day, you are an amazing teacher
I did not understand when my teacher taught me, but you made it so easy and now loving the subject , you have a pleasant voice too, Thank you sir
So almost all STRING functions you have described. Thank U a lot ! You are amazing!
I enjoyed this video.
Friends if you want to answer what is the diff bet CHAR and PAT INDEXS in the interview then this is the best video.
Thanks a bunch
It's the best video tutorial, even if it is to compare with the courses wich I bought. I'm reading also the book Querying Microsoft SQL Server 2012 Training Kit and I can see the quality of your video's. Thank's for your work.
Thanks Venkat for providing such comprehensive tutorial. I have been practicing sql questions online and came across a question to find median of a column. I would love you to do a tutorial on writing a sql for finding the median of a column in a table (for example median salary per department).
Hi, Very soon as soon as I am done with sql server. If you can subscribe to my channel, you will be getting updates when I upload new videos. Thank You.
Hi Venkat ,your videcs are awesome and easily understandable,thanks a lot for making it
thanks venkat, this is quite easy to grasp
This is free. It it were not free, I would not mind paying $50 or so to take a class from you. I follow a long and I understand it.
Lucid and concise. Thank you.
Nice video. Helped me in learning new functions in almost no time. Thank you Venkat.
Thanks, simple and the best explanation.
select ID, Name, SUBSTRING(Email,1,2)+REPLICATE('*',2)+SUBSTRING(Email, CHARINDEX('@',Email),LEN(Email)) from tblPerson
I think len(email) is better because anyways there are no characters after the last .domain name. It saves the trouble of calculating the remaining length but still for other situations we might need the exact remaining length. Nice explaination. Just watching one by one.
Super explanation love to learn from you
The Best, Simply the Best...
Hi Venkant , Your videos are of high quality . Thanks for making it . Could you please make a video of finding first monday of the month
Thank you. I have found out that most of the videos on TH-cam are better taking classes at school.
Thank You Sir
Very helpful Video..Very Nice Sir
thanks .. these videos helped me alot
Loved watching this
thank you..
Hello Sir! I really appreciate your hard work simplifying SQL in the best way ever, I admit I never found anyone who can do it in the best way as you do. Thus, I really want to be like you, you're my role model, I am doing my best for the moment, however, I just want to know how much it took you to learn using SQL just as you do now ? A year, two ... ? I am actually making sure to learn all of what you provided in here and I am learning fast, does this mean if I ever finished all of your tutorial videos, and eventually will be able to use all of the queries you provided that I am well qualified to use SQL ? I hope you would answer me so soon.
regards.
Thank you very much for taking time to give feedback. Means a lot. Very glad you found the videos useful. It's practise, practise and practise. I have been using SQL for over 15 years now. Experience will naturally get you confident and YES, if you are confident with the concepts discussed in these videos you will be able to use SQL like a PRO. Hope this answers your question.
Awesome :)
nice explanation
awesome
Perfect
Hi nice videos for learning .Can you please provide the SQL Server interview questions link please....
Hi venkat,
Could you please tell me how to write the below sql statement in Oracle
Patindex(‘%0-9%’, alphanumeric column)
How to give range in instr function??
Venkat, Are you planning to upload tutorials for ASP.NET as well? If so when would that happen?
How can i split this into two columns
like
ID and Description
867 Other infectious and parasitic diseases diagnoses with mcc
Integer value in Id column and rest will be in Description column]
Just for Info actual query to replace .com with .net in the table would be
UPDATE tblEmployee SET Email=REPLACE(Email,'.com','.net')
I believe this query is for the demonstration purpose, to only show how to replace the output result, even though actual use case would be to replace data stored in the table, as in your query. Thanks for the info.
I don't understand the idea of SPACE-function. I understand how it works, but I don't understand why it exists. SPACE(5) = REPLICATE(' ', 5), right? Why separate function is needed?
How can I get the data you are working on? I would like to practice all the functions
Create the tables that he shows for yourself. Even better practice. :)
STUFF is simpler if compared to REPLICATE function inside Substring.
Sample Code on STUFF with REPLICATE:: SELECT Name,STUFF(Email,2,3,REPLICATE('*',5)) from tblPerson;
I want to split comma separated string e.q '1,2,3' as IN parameter to query
Select TRIM (' Hello World'); How to remove Extra spaces Between "Hello World" And which Function we need to use in MS-SQL?
Mask all characters between the first letter and the @ sign:
select *, stuff(Email, 2, len(Email) - (len(Email) - charindex('@', Email) + 2),
replicate('*', len(Email) - (len(Email) - charindex('@', Email) + 2))) as StuffedEmail from tblEmployee