Rajesh Umrao‒Data&AI

I simplify the complex world of 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬, 𝐃𝐚𝐭𝐚 𝐒𝐜𝐢𝐞𝐧𝐜𝐞 into bite-sized, actionable insights.
______________________________________
🧑🏼‍💼ᗩᗷOᑌT ᗰE:
Hey, I’m Rajesh— 𝐒𝐞𝐧𝐢𝐨𝐫 𝐀𝐧𝐚𝐥𝐲𝐬𝐭 and proud 𝐍𝐈𝐓 𝐇𝐚𝐦𝐢𝐫𝐩𝐮𝐫(𝐇𝐏) alumnus.
𝐋𝐢𝐧𝐤𝐞𝐝𝐈𝐧: www.linkedin.com/in/rajeshumrao/
______________________________________
🔍𝐖𝐇𝐀𝐓 𝐘𝐎𝐔'𝐥𝐥 𝐄𝐗𝐏𝐋𝐎𝐑𝐄:
①𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 & 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲: SQL, Python, Power Bi and more
②𝗠𝗮𝗰𝗵𝗶𝗻𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 & 𝗔𝗜: ML, AI, Algorithms, Deep Learning
______________________________________

Rajesh Umrao‒Data&AI

What happens if no WHERE clause is used in a DELETE statement?

1 hour ago | [YT] | 2

View 0 replies

Rajesh Umrao‒Data&AI

In SQL, Which constraint ensures that a column cannot contain duplicate AND NULL values?

3 hours ago | [YT] | 3

View 0 replies

Rajesh Umrao‒Data&AI

The output of following python code
>>> for num in range(2,5,1):
>>> print(num, end=", ")

23 hours ago | [YT] | 3

View 0 replies

Rajesh Umrao‒Data&AI

In SQL, What is the purpose of EXISTS?

2 days ago | [YT] | 4

View 2 replies

Rajesh Umrao‒Data&AI

What will be the output of the following Python code?
list1 = ['Rajesh' , 'Umrao' , 'Data' , 'AI' ]
list2 = [ name.lower() for name in list1]
print (list2[1][0])

3 days ago | [YT] | 5

View 0 replies

Rajesh Umrao‒Data&AI

In SQL, What does NULLIF(a, b) return if a = b?

3 days ago | [YT] | 4

View 0 replies

Rajesh Umrao‒Data&AI

Why is EXISTS often faster than IN?

4 days ago | [YT] | 3

View 0 replies

Rajesh Umrao‒Data&AI

In SQL, Which function is best to replace NULL with a calculated value?