Page 66 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Sarabjit Kumar, Lovely Professional University Unit 4: Advanced SQL

Unit 4: Advanced SQL Notes

CONTENTS
Objectives

Introduction
4.1 Subqueries
4.2 Nested Subqueries
4.3 Complex Queries

4.4 Views
4.5 Joined Relations
4.5.1 Inner Join
4.5.2 Natural Join

4.5.3 Left Outer Join
4.5.4 Full Outer Join
4.6 Summary
4.7 Keywords

4.8 Self Assessment
4.9 Review Questions
4.10 Further Readings

Objectives

After studying this unit, you will be able to:

 Describe subqueries and nested subqueries
 Explain complex queries
 Define views

 Discuss joined relations
Introduction

In this unit, we give you the details of some of the advanced features of Structured Query
Language. We will discuss Assertions and Views, Triggers, Standard Procedure and Cursors.
The concepts of embedded and dynamic SQL and SQLJ, which is used along with JAVA, are also
been introduced. Some of the advanced features of SQL have been covered. We will provide
examples in various sections rather than including a separate section of examples. The examples
given here are in a SQL3 standard and will be applicable for any commercial database management
system that supports SQL3 standards.

LOVELY PROFESSIONAL UNIVERSITY 59