Relational Databases Certification

Chapters

1Relational Concepts and Architecture

2SQL Fundamentals: DDL, DML, and Querying

3Data Modeling and Normalization

4Keys, Constraints, and Data Integrity

5Joins, Subqueries, Views, and Set Operations

Inner and Outer Joins Cross and Self Joins Semi and Anti Joins Join Conditions and Predicates Join Order and Associativity Correlated Subqueries EXISTS and IN Patterns Scalar and Table Subqueries Derived Tables and Inline Views Common Table Expressions Views: Creation and Security Updatable Views and Limitations UNION, INTERSECT, EXCEPT Pivot and Unpivot Techniques Working with Hierarchies

6Indexes, Execution Plans, and Query Optimization

7Transactions, Concurrency, and Isolation

8Advanced SQL and Procedural Features

9Operations, Security, and Monitoring

10Backup, Recovery, Replication, and Cloud Operations

Courses/Relational Databases Certification/Joins, Subqueries, Views, and Set Operations

Joins, Subqueries, Views, and Set Operations

9 views

Master relational querying patterns for combining, filtering, and shaping datasets across multiple tables.

Content

13 of 15

UNION, INTERSECT, EXCEPT

Original version

1 views

Versions:

Version 22714

Watch & Learn

AI-discovered learning video

Sign in to watch the learning video for this topic.

Sign in Sign up free

Start learning for free

Sign up to save progress, unlock study materials, and track your learning.

Bookmark content and pick up later
AI-generated study materials
Flashcards, timelines, and more
Progress tracking and certificates

Free to join · No credit card required

Unlock this content

Sign up free to view this chapter, save your progress, and unlock study modes.

Full chapters & explanations
Flashcards & practice
Track progress

Sign in Create free account

Speed Challenge

Comments (0)

Please sign in to leave a comment.

No comments yet. Be the first to comment!

Ready to practice?

Sign up now to study with flashcards, practice questions, and more — and track your progress on this topic.

Study with flashcards, timelines, and more

Earn certificates for completed courses

Bookmark content for later reference

Track your progress across all topics