Tuesday, June 7, 2016
Penultimate SQL Lesson before Finals Week
This week's assignments involving SQL Plus have been enjoyable, as it gives me more pleasure to get into the tool and interact with it than design diagrams, although that's not to say that the latter hasn't been important in learning database modeling and design fundamentals. In SQL Plus, we're continuing to spool our file runs, and now applying SQL aggregate commands, as well as Oracle SQL commands to prompt input requests and accept them. Further, we're compounding queries to make subqueries based on the one directly prior.