Advanced SQL
Docsity.com
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Advanced SQL: Learning Relational Set Operators, SQL Joins, Subqueries, and Functions, Slides of Introduction to Database Management Systems
An in-depth exploration of advanced sql concepts, including the use of union, union all, intersect, and minus set operators, sql join syntax, different types of subqueries and correlated queries, and various sql functions for manipulating dates, strings, and other data. Additionally, it covers creating and using updatable views, triggers, and stored procedures, as well as oracle-specific date/time, numeric, and string functions.
Typology: Slides
2012/2013
1 / 62
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Advanced SQL: Learning Relational Set Operators, SQL Joins, Subqueries, and Functions and more Slides Introduction to Database Management Systems in PDF only on Docsity!
Advanced SQL
In this chapter, you will learn:
- About the relational set operators UNION, UNION ALL, INTERSECT, and MINUS
- How to use the advanced SQL JOIN operator syntax
- About the different types of subqueries and correlated queries
- How to use SQL functions to manipulate dates, strings, and other data
UNION Query Result
UNION ALL Query Result
MINUS Query Results
INTERSECT Alternative
SQL Join Expression Styles
NATURAL JOIN Result
JOIN ON Result
Outer Joins
- Returns not only rows matching join condition but also rows with unmatched values
- Three types:
- Left
- Right
- Full
RIGHT JOIN Result
FULL JOIN Result
WHERE Subquery Examples
IN Subquery Example