OCA12c – 1Z0-061 – Additional Reading 06

[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test. Chapter 6: Manipulating Data explores how to manipulate data – adding, removing, and updating data. The chapter also covers how transaction control works. 9 Managing Tables Using DML Statements 9.1 Truncate data 9.2 Insert rows into a table 9.3 Update rows in a table 9.4 … Read more

OCA12c – 1Z0-061 – Additional Reading 05

[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