Subquery in SQL | MySQL Tutorial For Beginner | Great Learning

? 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 Subquery in SQL. A Subquery is a query within a query.

It is also called Inner query or a Nested query which again refers to a query within another SQL query and embedded within the WHERE clause. A subquery is used to return data that will be used in the main query as a condition to further restrict the data to be retrieved.

Subqueries can be used with the SELECT, INSERT, UPDATE, and DELETE statements along with the operators like =, IN, BETWEEN, etc. Subqueries also can be used with INSERT and UPDATE statements. To know more about this amazing and essential topic, watch the video till the end.

Following pointers will be covered in this video:
00:00:00 Introduction
00:01:18 Problem Statement
00:01:56 What is a Subquery?
00:02:24 How Many Parts are There in a Subquery?
00:02:38 How Subquery Executes?
00:03:42 Type of Subquery
00:05:00 Demo for Subqueries

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#subqueries #GreatLearning