OCA12c – 1Z0-061 – Additional Reading 05

by

[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test. Chapter 5: Using Joins and Subqueries explains how data from multiple tables can be related via joins, subquries. and by using SET operators. 7 Displaying Data from Multiple Tables Using Joins 7.1 Write SELECT statements to access data from more than one table using equijoins … Read more

OCA12c – 1Z0-061 – Additional Reading 04

by

[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test. Chapter 4: Using Group Functions explains data aggregations, Oracle’s built-in group function, and nesting of functions. 6 Reporting Aggregated Data Using the Group Functions 6.1 Identify the available group functions 6.2 Describe the use of group functions 6.3 Group data by using the GROUP BY … Read more