SQL Debugging | Common Programming Mistakes | Dates

In this video, we debug a SQL Query and identify some commonly made mistakes while writing SQL Queries using Date values.
Must Do Data Analytics Certifications -
Google Data Analytics Professional Certificate
imp.i384100.net/OR37oQ
Google Advanced Data Analytics Professional Certificate
imp.i384100.net/eK1WmQ
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Instagram - / learn.knowstar
Blog - know-star.blogspot.com/
Facebook - / knowstartrainings
Linkedin - www.linkedin.com/company/know...
Email - [e-mail]

[@designanddecor8964]

Your content is so unique and so helpful. Thanks a lot.

[@LearnatKnowstar]

Thank You!

[@abinashkumar1533]

I love your super sweet voice with great patience while teaching

[@LearnatKnowstar]

Thank You!

[@jjohn108]

Awesome..!! Expecting more such videos.
Thank you 👍

[@LearnatKnowstar]

More to come!

[@blse2000]

Amazing, Thank you.

[@LearnatKnowstar]

Thank You!

[@cs151_subramanianm4]

Super 🎉..do more videos like this ❤

[@LearnatKnowstar]

Coming Soon!

[@chintu2691994]

I always format my date and then use between in where or case quarries.

[@ayeoh47]

thanks

[@LearnatKnowstar]

Thank You!

[@sidduroy7171]

Hello kirti, we could have used CAST of date keyword to get correct output?. Please let me know your thought

[@LearnatKnowstar]

That's correct. I had planned to cover this syntax but forgot about it :-) We can use CAST but it is not the best way as we do not want to apply a function if there is an index on the column.

[@mahendravarma4746]

Hi Team, I dropped an email to learn at know start regarding new batch for DATASTAGE, can you please share details if you have

[@AbhishekKumar-gf4db]

Good knowledge regarding issue finding

[@LearnatKnowstar]

Thank You!

[@ragulmarley4900]

Data set link please for practice really helpful

[@LearnatKnowstar]

Will post soon!

[@ragulmarley4900]

@@LearnatKnowstar thank u so much way u teaching please upload begin to advanced sql video from scratch

[@vaibhavkhairnar7313]

Is there any video on SQL profile for debugging ??

[@praveenshukla7824]

No