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. In this tutorial we will be discussing Pattern Matching and Null value concepts in MySQL.
Just as the name suggests, this technique matches or finds a specific pattern in the database. A logical operator called “LIKE” is a great example of pattern matching. The LIKE operator is used in the WHERE clause of the SELECT , UPDATE , and DELETE statements to filter rows based on pattern matching. It finds a similar pattern in the database that we have added in the code after LIKE keyword.
There are many such operators that are used in pattern matching. We’ll also get familiar with the concept of Null Value. “NULL” is used to represent an empty value in a database. 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:08 Pattern Matching in SQL
00:01:52 MySQL Workbench Demo
00:12:08 What is NULL Value in SQL?
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, enrol 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
#MySQL#patternmatching #NULLvalueconcept #GreatLearning