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 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])

10 hours ago | [YT] | 2

Rajesh Umraoโ€’Data&AI

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

10 hours ago | [YT] | 3

Rajesh Umraoโ€’Data&AI

Why is EXISTS often faster than IN?

1 day ago | [YT] | 3

Rajesh Umraoโ€’Data&AI

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

2 days ago | [YT] | 5

Rajesh Umraoโ€’Data&AI

What happens when you ROLLBACK after a TRUNCATE?

2 days ago | [YT] | 9

Rajesh Umraoโ€’Data&AI

Which SQL object stores the execution plan but not data?

5 days ago | [YT] | 6

Rajesh Umraoโ€’Data&AI

In SQL, What does COUNT(column_name) ignore?

6 days ago | [YT] | 7

Rajesh Umraoโ€’Data&AI

Which join can return rows even when the join condition never matches?

6 days ago | [YT] | 6

Rajesh Umraoโ€’Data&AI

What is the main difference between RANK() and DENSE_RANK()?

1 week ago | [YT] | 8

Rajesh Umraoโ€’Data&AI

Which clause is evaluated after GROUP BY but before ORDER BY?

1 week ago | [YT] | 4