Oracle Database 12c Upgrade Hands On Lab

Recently I tweeted the download link for the Virtual Box OVA file for 12c upgrade Hands on Lab. “Oracle Database 12c (12.1.0.2) Upgrade and Migration hands-on Lab” http://t.co/Zb4eTzw3qL — Biju Thomas (@bijoosX) September 12, 2015 Since 11g free extended support is ending in the next few months, this is the time DBAs are busily planning to … Read more

OCA12c – 1Z0-061 – Additional Reading 07

[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 … Read more

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

OCA12c – 1Z0-061 – Additional Reading 04

[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

OCA12c – 1Z0-061 – Additional Reading 03

[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test. Chapter 3: Using Single-Row Functions discusses the single-row functions and conversion functions available, with details on how and where to use them. 4 Using Single-Row Functions to Customize Output 4.1 Describe various types of functions available in SQL 4.2 Use character, number, and date functions … Read more

OCA12c – 1Z0-061 – Additional Reading 02

[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test. Chapter 2: Introducing SQL introduces you to writing simple queries using SELECT statement. It also introduces you to filtering and sorting data. 2 Retrieving Data Using the SQL SELECT Statement 2.1 Explain the capabilities of SQL SELECT statements 2.2 Execute a basic SELECT statement 3 … Read more

OCA12c – 1Z0-061 – Additional Reading 01

[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test. Chapter 1: Introducing Oracle Database 12c RDBMS introduces you to the features of Oracle Database 12c and the aspects of relational database. 1.1 Describe the features of Oracle Database 12c 1.2 Describe the salient features of Oracle Cloud 12c 1.3 Explain the theoretical and physical … Read more