Тёмный
The Engineer's Desk
The Engineer's Desk
The Engineer's Desk
Подписаться
Hi Guys,
Welcome to The Engineer's Desk.
This channel will have the contents related to below topics.
General Awareness
Programming in .NET/C#
React.Js
JavaScript
SQL
Web API
Data Structure and Algorithm
Data Science
Aptitude
Reasoning

As We go, We will be covering all the interview question asked in the software organization interview.

Thanks for visiting !! Keep Learning !! Keep Growing.

I am always open for collab.
For collab or any business query
reach out to : singh.pankajkumar764@gmail.com

How to debug SQL Server Stored Procedures
4:45
7 месяцев назад
How to use JOIN with LINQ in C#
3:07
9 месяцев назад
Комментарии
@AmitKumar-ly2rv
@AmitKumar-ly2rv 2 дня назад
Can you please teach us the difference between Varchar and Varchar 2
@AmitKumar-ly2rv
@AmitKumar-ly2rv 2 дня назад
Can you please show us the use of ROUND and TRUNC too.
@katimboallan4605
@katimboallan4605 2 дня назад
Thx, as Developer/DBA, this is important.
@vivektarab16
@vivektarab16 2 дня назад
00:00
@vivektarab16
@vivektarab16 2 дня назад
00:00
@vivektarab16
@vivektarab16 2 дня назад
00:00
@StephenBrincat
@StephenBrincat 4 дня назад
Thanks for the video, what if your file name changes daily as this one where name will be like 2024-09-26T23_10_13+00_00Exp Del & Inv Details Ev 71, and first part is different every day 2024-09-26T23_10_13+00_00
@arjunkg9944
@arjunkg9944 5 дней назад
error
@mohmmedyaseen5858
@mohmmedyaseen5858 6 дней назад
How to become expert in sql?
@theengineersdesk7930
@theengineersdesk7930 6 дней назад
Practice
@bhupendrakumar7811
@bhupendrakumar7811 7 дней назад
Sir You have amazing teaching skills, it's rare like KUDVENKAT sir
@theengineersdesk7930
@theengineersdesk7930 5 дней назад
Thanks a lot
@Krishna-yj9ju
@Krishna-yj9ju 7 дней назад
Bhai android k compatible pen tab bata do teaching purpose se
@Krishna-yj9ju
@Krishna-yj9ju 7 дней назад
Bhai mere tab ,me type c slot hai bas aur koi nahi earphone jack bhi nhi hai Ye batao pen tab connect kardu toh mic kaise connect Karu 😢 Plz help
@theengineersdesk7930
@theengineersdesk7930 7 дней назад
Ye buy kar lo...c port hub amzn.in/d/5oTZiYS
@sapb1tamil
@sapb1tamil 7 дней назад
Not working 😂
@AnbuAnbu-xj8bx
@AnbuAnbu-xj8bx 8 дней назад
Can any one say which programming language he used, Thanks in Advance❤.
@souvikdas9110
@souvikdas9110 9 дней назад
Could you please share the database for practice...?
@souvikdas9110
@souvikdas9110 9 дней назад
Could you please share the database for practice?
@beginnersbook2003
@beginnersbook2003 11 дней назад
I have a question regarding a table I created. The table contains only one column that have 30 unique date . Now, I would like to display these values horizontally, with each value occupying a separate cell. Could you please assist me with a query that can achieve this?
@chennakesavasreeramadas5504
@chennakesavasreeramadas5504 11 дней назад
Select * from table Group by salary Having count salary>1
@2Cubists
@2Cubists 11 дней назад
Straightforward and Simple ! I like it , Keep it up 👍
@theengineersdesk7930
@theengineersdesk7930 11 дней назад
Thanks
@Suma7777-qh4nn
@Suma7777-qh4nn 11 дней назад
Ur very gery fast not able to understand
@theengineersdesk7930
@theengineersdesk7930 11 дней назад
🫠
@rahulrandilvlogs5708
@rahulrandilvlogs5708 12 дней назад
Jio cinema not working
@theengineersdesk7930
@theengineersdesk7930 12 дней назад
What's the issue?
@caveatashish
@caveatashish 12 дней назад
with cte as ( select *, dense_rank() over (order by salary desc) as cnt from EmployeeSalaries ) select * from cte where cnt =3
@aboobackersiddique3497
@aboobackersiddique3497 12 дней назад
Y r v not writing e. Employeeid=m.managerid
@PrakashNagaraj1993
@PrakashNagaraj1993 12 дней назад
And concat with virat😅
@BhargaviYerrajodu
@BhargaviYerrajodu 11 дней назад
😂
@Vikasyadav__743
@Vikasyadav__743 10 дней назад
it is not dynamic
@rachamaduguchaitanya2135
@rachamaduguchaitanya2135 12 дней назад
Good explanation
@theengineersdesk7930
@theengineersdesk7930 12 дней назад
Thanks
@Suma7777-qh4nn
@Suma7777-qh4nn 13 дней назад
Not able to understanding ur so fast what u do yo should teach step by step slowly boss
@theengineersdesk7930
@theengineersdesk7930 12 дней назад
Pause and watch please, it's just a minute to explain everything, so need to be bit faster
@aamirsohail3381
@aamirsohail3381 13 дней назад
Bro you are doing great work. Don't listen to them, there will always be someone who'll complain no matter how good you do.
@theengineersdesk7930
@theengineersdesk7930 13 дней назад
Thanks ♥️
@KenNR88
@KenNR88 13 дней назад
Which one has lower execution cost??
@InvincibleMan99
@InvincibleMan99 13 дней назад
Thanks buddy How much time was given ?
@theengineersdesk7930
@theengineersdesk7930 13 дней назад
90 minutes
@InvincibleMan99
@InvincibleMan99 13 дней назад
@@theengineersdesk7930 I am going to appear in a test at naggaro, in that test there will be 30 aptitude and 30 skill questions, time given is 50 mins, so basically i have r to do 60 ques in 50 mins,what do you think what could be the complexity level of aptitude ?
@theengineersdesk7930
@theengineersdesk7930 13 дней назад
Medium level questions
@mysteriousbox564
@mysteriousbox564 14 дней назад
Is it full stack interview series or sql series ?
@theengineersdesk7930
@theengineersdesk7930 14 дней назад
Have you seen the playlist?
@irajeshtailor
@irajeshtailor 14 дней назад
Something is missing in your video? From where Manager name is coming ? I mean which table
@theengineersdesk7930
@theengineersdesk7930 14 дней назад
It's the same table...Managers are nothing but employee
@irajeshtailor
@irajeshtailor 14 дней назад
​@@theengineersdesk7930 oh didn't notice. Understood thanks
@rushivanjare97
@rushivanjare97 14 дней назад
Can we use inner join
@theengineersdesk7930
@theengineersdesk7930 14 дней назад
If you use inner join it will not show those employees who are not reporting to any manager
@Sai97738
@Sai97738 14 дней назад
Can we use self join for this case
@theengineersdesk7930
@theengineersdesk7930 14 дней назад
This is self join only
@ncrcottonbalesseeds118
@ncrcottonbalesseeds118 15 дней назад
Using rowid to delete duplicate records
@mahavirsinghrajpurohit8004
@mahavirsinghrajpurohit8004 16 дней назад
Great, make more videos
@theengineersdesk7930
@theengineersdesk7930 16 дней назад
Thanks
@BLUEsnowballl
@BLUEsnowballl 16 дней назад
can someone tell me .. whats the purpose of doing this when i can simply import the dat from csv
@theengineersdesk7930
@theengineersdesk7930 16 дней назад
You can automate the process using this
@BLUEsnowballl
@BLUEsnowballl 16 дней назад
@@theengineersdesk7930 by automate u mean... if i add something in excel after bulk insert and rerun the insert query i can get that new data as well?? right
@theengineersdesk7930
@theengineersdesk7930 16 дней назад
Let's say you have written a stores procedure and scheduled it to run daily which pulls the latest records from CSV and put that into database (obviously you will have to modify the query I showed you to check for recent records), this is useful there
@ashleshatiwari9461
@ashleshatiwari9461 17 дней назад
Very useful content ❤
@theengineersdesk7930
@theengineersdesk7930 17 дней назад
Thank you ♥️
@Mustaffa136
@Mustaffa136 18 дней назад
Watch with speed ×1.5 thank me later
@shreyeshyerramilli9723
@shreyeshyerramilli9723 18 дней назад
This 100days sql series is very helpful Thank you
@theengineersdesk7930
@theengineersdesk7930 18 дней назад
Glad it helped ✨
@msantosh786
@msantosh786 19 дней назад
Thanks ❤❤
@theengineersdesk7930
@theengineersdesk7930 19 дней назад
@ankan674
@ankan674 19 дней назад
Which is faster in giving the results.. union or union all?
@theengineersdesk7930
@theengineersdesk7930 19 дней назад
Union all is faster because it doesn't remove duplicates and not even sort it...
@abhinavtripathi6778
@abhinavtripathi6778 19 дней назад
Can I add this on my website ??
@theengineersdesk7930
@theengineersdesk7930 19 дней назад
Yes why not
@vincentgyekye7887
@vincentgyekye7887 20 дней назад
Simple 😊
@theengineersdesk7930
@theengineersdesk7930 19 дней назад
Thanks
@NandhaKumar-ep3ov
@NandhaKumar-ep3ov 20 дней назад
BB. Q. 😊qqqqqqqqqqqqqq!¡!!!1+++!!¡!!6¡!6¡!!!6!!!6!¡!!.!¡;😊😊😊😊
@kingsleyarisah6354
@kingsleyarisah6354 20 дней назад
Great content
@theengineersdesk7930
@theengineersdesk7930 20 дней назад
Thanks a ton
@katimboallan4605
@katimboallan4605 20 дней назад
Nice explanation. Thx
@theengineersdesk7930
@theengineersdesk7930 20 дней назад
Welcome
@shaikhibrahim8302
@shaikhibrahim8302 21 день назад
Sir which application/software are you using in this video? because i have been using oracle 11 g command line from last 10 the inreface of oracle command line is very complicated i am facing issue to parcticing SQL and PLSQL questions.can you please provide me a link of application/software that are you using in your video Thank you.
@theengineersdesk7930
@theengineersdesk7930 21 день назад
This is SQL server management studio (ssms)
@kuldeepkandwal5348
@kuldeepkandwal5348 21 день назад
Nice videos
@theengineersdesk7930
@theengineersdesk7930 21 день назад
Thanks
@katimboallan4605
@katimboallan4605 22 дня назад
Great, thx
@theengineersdesk7930
@theengineersdesk7930 22 дня назад
✨♥️