DB2, Microsoft SQL Server, Oracle and PostgreSQL all support recursive queries using CTEs. Note that Oracle also offers an alternative syntax using the CONNECT BY construct, which we will not discuss ...

Analyze database contents using basic, intermediate and advanced SQL statement syntax and usage. Demonstrate capability to query data from multiple tables using SQL JOINS. Create and modify database ...

This course will introduce students to the basics of PL/SQL subprograms. Students will learn how to write and invoke PL/SQL procedures, functions and packages. Using Oracle's 11g Enterprise Database ...