Sql Subqueries From Novice To Mastery

Sql Subqueries: From Novice To Mastery
Published 2/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz

Language: English | Size: 2.74 GB | Duration: 2h 29m
Master Advanced SQL Subqueries: Nested, Correlated, Scalar, the Weird & Complex Parts for Better Data Retrieval
What you’ll learn
How to write subqueries to select data from single and multiple tables.
The different ways to create subqueries that return a single value or multiple values.
How to use subqueries in the SELECT, FROM, WHERE, and HAVING clauses.
The concept of correlated subqueries, which depend on values from the outer query, and how to use them in SQL.
How to use subqueries to solve complex problems such as finding maximum or minimum values and records that don’t have corresponding entries in other tables.
The difference between IN, EXISTS, and ANY/ALL operators in subqueries and when to use each one.
How to use subqueries to create more complex queries and better understand the structure and relationships in a database.
Hands-on practice with a variety of subquery examples, exercises, and challenges to build skills and confidence in using subqueries in SQL.
Requirements
Basic SQL knowledge. This includes familiarity with SQL syntax and basic SQL commands
MySQL WorkBench
Description
This course is designed to help you master the art of SQL subqueries and take your data management skills to the next level. Whether you’re a beginner or an experienced SQL user, you’ll learn how to effectively use subqueries to extract and manipulate data from your databases.Throughout the course, you’ll learn about the different types of subqueries, including nested, correlated, scalar, row, column, and inline view subqueries. You will also acquire other SQL techniques such as JOIN,EXISTS, WHERE, HAVING, GROUP BY, and many more. You’ll also learn how to use these techniques to solve real-world problems, and how to combine subqueries with other SQL techniques for maximum efficiency.By the end of the course, you’ll have a deep understanding of how subqueries work and how to use them to extract the information you need from your databases. With this knowledge, you’ll be able to create complex and powerful queries that help you analyze and manage your data like never before.Whether you’re using MySQL, PostgreSQL, Microsoft SQL Server, or Oracle Database this course will give you the skills and knowledge you need to work with subqueries in your own databases. Whether you’re looking to improve your data management skills for work or just want to learn something new, this course is the perfect place to start.The course is structured to provide a comprehensive understanding of SQL subqueries, starting from the basics and gradually building up to more advanced techniques. The course includes a combination of theoretical lessons, practical exercises, and hands-on projects to give you hands-on experience working with subqueries.You’ll learn from an experienced instructor who has years of experience working with SQL and subqueries, and you’ll have access to a supportive online community where you can ask questions. Whether you’re just starting out or looking to brush up on your skills, this course has everything you need to master SQL subqueries and advance your data management skills.Enroll in this course today and start taking your data management skills to the next level!
Overview
Section 1: Introduction
Lecture 1 Database (Datasets) for the course
Lecture 2 Importance of Subquery
Lecture 3 Beginning Subquery – With Example I
Lecture 4 CODE: Beginning Subquery – With Example I
Lecture 5 Beginning Subquery – With Example II
Lecture 6 CODE: Beginning Subquery – With Example II
Lecture 7 Beginning Subquery – With Example III
Lecture 8 CODE: Beginning Subquery – With Example III
Lecture 9 Nested Subquery – SubQuery with LIKE
Lecture 10 CODE: Nested Subquery – SubQuery with LIKE
Lecture 11 Nested Subquery – Mangers of Employee SubQueries
Lecture 12 CODE: Nested Subquery – Mangers of Employee SubQueries
Lecture 13 Nested Subquery – Employee Territories
Lecture 14 CODE: Nested Subquery- Employee Territories
Lecture 15 Nested Subquery – CategoryName
Lecture 16 CODE: Nested Subquery – CategoryName
Lecture 17 Nested Subquery – Suppliers
Lecture 18 CODE: Nested Subquery – Suppliers
Lecture 19 Nested Subquery – Product Ordered
Lecture 20 CODE: Nested Subquery – Product Ordered
Lecture 21 Nested Subquery – Employee Without Orders
Lecture 22 CODE: Nested Subquery – Employee Without Orders
Lecture 23 Nested Subquery – Employees with same region
Lecture 24 CODE: Nested Subquery – Employees with same region
Lecture 25 Nested Subquery – Territories not assigned to employee
Lecture 26 CODE: Nested Subquery – Territories not assigned to employee
Lecture 27 Nested Subquery – Freight of orders
Lecture 28 CODE: Nested Subquery – Freight of orders
Lecture 29 Nested Subquery – Supplied categories of seafood
Lecture 30 CODE: Nested Subquery – Supplied categories of seafood
Lecture 31 Nested Subquery – customers in the same city
Lecture 32 CODE: Nested Subquery – customers in the same city
Lecture 33 Nested Subquery – Employees with same manager
Lecture 34 CODE: Nested Subquery – Employees with same manager
Lecture 35 Nested Subquery – Products with reorderLevel
Lecture 36 CODE: Nested Subquery – Products with reorderLevel
Lecture 37 Nested Subquery – Supplier who live in Spain
Lecture 38 CODE: Nested Subquery – Supplier who live in Spain
Lecture 39 Nested Subquery – Territories names Assigned to Employees
Lecture 40 CODE: Nested Subquery – Territories names Assigned to Employees
Lecture 41 Nested Subquery – Products Supplied by Same Company
Lecture 42 CODE: Nested Subquery – Products Supplied by Same Company
Lecture 43 Nested Subquery – Customers who placed orders
Lecture 44 CODE: Nested Subquery – Customers who placed orders
Lecture 45 Nested Subquery – Products never ordered
Lecture 46 CODE: Nested Subquery – Products never ordered
Lecture 47 Nested Subquery – Territories never assign to Employees
Lecture 48 CODE: Nested Subquery – Territories never assign to Employees
Lecture 49 Nested Subquery – Customers Who Never Placed Orders
Lecture 50 CODE: Nested Subquery – Customers Who Never Placed Orders
Lecture 51 Nested Subquery – Employees not assigned to Territories
Lecture 52 CODE: Nested Subquery – Employees not assigned to Territories
Lecture 53 Nested Subquery – Order Placed in 2008
Lecture 54 CODE: Nested Subquery – Order Placed in 2008
Lecture 55 Nested Subquery – Employees who have the same territories
Lecture 56 CODE: Nested Subquery – Employees who have the same territories
Lecture 57 Nested Subquery – Products ordered by customers
Lecture 58 CODE: Nested Subquery – Products ordered by customers
Lecture 59 Nested Subquery – Employees Managed by Funk
Lecture 60 CODE: Nested Subquery – Employees Managed by Funk
Lecture 61 Nested Subquery – Suppliers who supplied products to a customers
Lecture 62 CODE: Nested Subquery – Suppliers who supplied products to a customers
Lecture 63 Nested Subquery – Customers who placed order more than 30
Lecture 64 CODE: Nested Subquery – Customers who placed order more than 30
Lecture 65 Nested Subquery – Employees with same territory
Lecture 66 CODE: Nested Subquery – Employees with same territory
Lecture 67 Nested Subquery – Customer Ordered Beverages Products
Lecture 68 CODE: Nested Subquery – Customer Ordered Beverages Products
Lecture 69 Nested Subquery – Suppliers for London Customers
Lecture 70 CODE: Nested Subquery – Suppliers for London Customers
Those with basic SQL knowledge who wish to improve,Data analysts, business intelligence professionals, and aspiring SQL developers who want to improve their SQL skills,Database administrators who want to write more efficient and complex SQL queries,Anyone who has struggled with SQL subqueries in the past and wants to learn how to use them effectively,Individuals who want to become an expert in using SQL subqueries for data analysis and data management tasks.