Get your free certificate of completion for the My SQL Basics Course, Register Now: http://glacad.me/MySQLCourse

SQL is the standard language for Database Management System. It is used for storage, manipulation and retrieval of data in databases. There are so many features in MySQL that make our task so easy. So, In this tutorial we will be discussing one such feature called Case Statement in MySQL.

The CASE statement consists of a series of conditions. It works like an if then else statement. So, the CASE statement returns a value when the first statement is true. Once a condition is true, it will stop reading and processing further and will return the result. If none of the given statements or conditions is true then the value in the ELSE clause will be returned.

In many cases, there’s not any ELSE clause and when none of the conditions are true and we don’t even have an ELSE clause, then NULL is returned. It’s one of the most fun and important topics to learn in MySQL. To know more about this amazing concept which makes our work so easy and interesting, Watch the complete tutorial.

Following pointers will be covered in this video:
00:00:00 Introduction
00:01:02 ANY Operator
00:12:46 ALL Operator
00:15:52 SQL Case Statement
00:28:58 View

Visit Great Learning Academy, to get access to 80+ free courses with 1000+ hours of content on Data Science, Data Analytics, Artificial Intelligence, Big Data, Cloud, Management, Cybersecurity and many more. These are supplemented with free projects, assignments, datasets, quizzes. You can earn a certificate of completion at the end of the course for free. https://glacad.me/3duVMLE

Get the free Great Learning App for a seamless experience, enroll for free courses and watch them offline by downloading them. https://glacad.me/3cSKlNl

About Great Learning:
- Great Learning is an online and hybrid learning company that offers high-quality, impactful, and industry-relevant programs to working professionals like you. These programs help you master data-driven decision-making regardless of the sector or function you work in and accelerate your career in high growth areas like Data Science, Big Data Analytics, Machine Learning, Artificial Intelligence & more.

- For more interesting tutorials, don't forget to subscribe to our channel: https://bit.ly/2s92TDX

- Learn More at https://www.greatlearning.in/

For more updates on courses and tips follow us on:

- Telegram: https://t.me/GreatLearningAcademy
- Facebook: https://www.facebook.com/GreatLearningOfficial/
- LinkedIn: https://www.linkedin.com/company/great-learning/

- Follow our Blog: https://www.greatlearning.in/blog/?utm_source=Youtube
#CasestatementinMySQL #MySQL #OperatorsinMySQL #GreatLearning