I am your big fan.. your teaching style

In the 3rd question when we use the window function we can't use the where condition. We need to make a subquery for this.

Kindly make a video on "How to create student account for creating ADF account (without using credit card)"

Thanks for this video

In the query to delete the duplicates the query will also print the record which is duplicate as one of the record is ranked as 1

you forgot to write DELETE from CTE instead of select to remove dub records

How can I access the sample data that you are using?

Hello, I was asked the following questions for AWS Developer role. Please make a video on this. Thanks. Q1. We have *sensitive data* coming in from a source and API. Help me design a pipeline to bring in data, clean and transform it and park it. Q2. So where does pyspark come into play in this? Q3. Which all libraries will you need to import to run the above glue job? Q4. What are shared variables in pyspark Q5. How to optimize glue jobs Q6. How to protect sensitive data in your data Q7. How do you identify sensitive information in your data Q8. How do you provision a S3 bucket? Q9. How do I check if a file has been changed or deleted? Q10. How do I protect my file having sensitive data stored in S3 Q11. How does KMS work? Q12. Do you know S3 glacier? Q13. Have you worked on S3 glacier?

getting error in MySQL workbench

In Query2 Can we write like : select * into Empl from Employee i.e. without any where condition ? It also works without where condition right ?

What is 1=1 and 1=2?

what does WHERE 1=2 mean?