[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test.

Chapter 7: Creating Tables and Constraints explains how to create and manage tables and constraints. It also discusses the various data types available in Oracle Database 12c to store data.

  • 10 Introduction to Data Definition Language
    • 10.1 Categorize the main database objects
    • 10.2 Explain the table structure
    • 10.3 Describe the data types that are available for columns
    • 10.4 Create a simple table
    • 10.5 Explain how constraints are created at the time of table creation
    • 10.6 Describe how schema objects work

Reading Material

 

1Z0-061 Objectives List

Oracle Database 12c OCA Certification

[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 Delete rows from a table
    • 9.5 Control transaction

Reading Material

1Z0-061 Objectives List

Oracle Database 12c OCA Certification

[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 and nonequijoins
    • 7.2 Join a table to itself by using a self-join
    • 7.3 View data that generally does not meet a join condition by using OUTER joins
    • 7.4 Generate a Cartesian product of all rows from two or more tables
  • 8 Using Subqueries to Solve Queries
    • 8.1 Define subqueries
    • 8.2 Describe the types of problems that the subqueries can solve
    • 8.3 Describe the types of subqueries
    • 8.4 Write single-row and multiple-row subqueries
    • 8.5 Using the SET operators
    • 8.6 Describe set operators
    • 8.7 Use a set operator to combine multiple queries into a single query
    • 8.8 Control the order of rows returned

Reading Material

1Z0-061 Objectives List

Oracle Database 12c OCA Certification

%d bloggers like this: