Course: Oracle Database 12c: SQL Fundamentals (exam 1Z0-061)

$0.00

$0.00 incl. vat

duration: 16 hours |

Language: English (US) |

access duration: 180 days |

Details

In this Oracle® Database training course you will get an introduction of the Oracle database management system in combination with SQL.

You will learn to write subqueries and multiple queries into a single querie.

Finally you will get extensive knowledge to you so you will learn to use effective SQL commands for business data. After completing this course you are also prepared for the Oracle 1Z0-061 exam.

Among subjects that covered are Entity Relationship Model, SQL Developer, HR Schema, AUTOTRACE, Distinct, MOD function, Sysdate, Trunc functions, Case Expressionand far more.

Result

After completing this course you are familiar with Oracle Database 12c in combination with SQL. You are also prepared for the Oracle 1Z0-061. This exam is for everyone who wants to be a OPN Certfied Specialist.

Prerequisites

We recommend basic knowledge of databases.

Target audience

Database Administrators

Content

Oracle Database 12c: SQL Fundamentals (exam 1Z0-061)

16 hours

Oracle Database 12c - Introduction to SQL: Relational Database and SQL Developer

start the course
describe the features of Oracle Database 12c
describe the salient features of Oracle Cloud 12c
describe relational and object relational database management systems
define the concepts of a relational database
describe the data model
describe the Entity Relationship Model
use the primary and foreign keys to relate multiple tables
recognize the relational database terminology
use SQL to query a database and its development environments
describe sample schemas in Oracle Database
list the key features of Oracle SQL Developer
create a database connection within SQL Developer
browse through the database objects and structures within SQL Developer
create a new schema object using SQL Developer
use SQL Worksheet to execute SQL and PL/SQL statements and format SQL code
work with SQL statements and scripts using SQL Developer
execute saved script files using various methods in SQL Developer
use snippets in SQL Developer
use the Recycle Bin in SQL Developer to recover or purge dropped objects
debug procedures and functions
display built-in database reports in SQL Developer
create a user-defined report in SQL Developer and organize them in folders
configure links to external tools and search engines within SQL Developer
customize the SQL Developer interface and environment
use the Data Modeler in SQL Developer
connect to the database and browse the tables in the HR schema using SQL Developer

Oracle Database 12c - Introduction to SQL: SQL*Plus and SELECT Statement

start the course
describe the features of SQL and SQL*Plus
describe the SQL*Plus editing commands
use the LIST, n, APPEND and CHANGE SQL*Plus editing commands
describe the SQL*Plus file commands
use the SAVE and START SQL*Plus file commands
use the SERVEROUTPUT and SPOOL SQL*Plus commands
use the AUTOTRACE SQL*Plus command
describe and use the basic SELECT statement
recognize the rules and guidelines for constructing valid SQL statements in SQL Developer and SQL*Plus
describe and use the arithmetic expressions in SQL
apply the standard order of precedence in SQL arithmetic expressions
identify how null values are defined in SQL and how they affect arithmetic expression outcomes
define column aliases in the SELECT list
use the concatenation operator to create a character expression in the SQL statement output
use literal character strings in a SELECT statement
use the alternative quote (q) operator to select a quotation mark delimiter
eliminate duplicate rows from SQL statement output using the DISTINCT qualifier
display the structure of a table using the SQL*Plus DESCRIBE command
select data from different tables, describe tables, perform arithmetic calculations, and specify column names using aliases

Oracle Database 12c - Introduction to SQL: Restrict, Sort, and Customize Output

start the course
describe the limiting of rows selected in a query and how to use the WHERE clause in a SQL statement
use character strings and dates in a WHERE clause in a SQL statement
use the comparison operators in a WHERE clause in a SQL statement
use the BETWEEN and IN operators in a WHERE clause in a SQL statement
use the LIKE operator and combine wildcard characters in a WHERE clause in a SQL statement
use the NULL and logical operator conditions in a WHERE clause in a SQL statement
use the AND, OR and NOT operators in a WHERE clause in a SQL statement
define the rules of precedence in a WHERE clause in a SQL statement
use the ORDER BY clause to sort the data returned by a SQL statement
use the ROW_LIMITING_CLAUSE to limit the number of rows returned by a SQL statement
describe the use of substitution variables in a SQL statement and use a single-ampersand substitution variable to provide a value in a SQL statement
use substitution variables for column names, expressions and text in a SQL statement
reuse a substitution variable by making use a double-ampersand substitution variable in a SQL statement
use the DEFINE and VERIFY commands to create, assign, and verify a substitution variable when using SQL Developer
write a SQL statement using the WHERE clause and pass a substitution variable to the SQL statement
identify the types of SQL functions in a SQL statement and describe single-row functions
use character functions in a SQL statement
use the case-conversion functions in a SQL statement
use the character-manipulation functions in a SQL statement
use the nesting functions in a SQL statement
use the numeric ROUND and TRUNC functions in a SQL statement
use the MOD function in a SQL statement
work with dates and the RR date format in a SQL statement
use SYSDATE, CURRENT_DATE and CURRENT_TIMESTAMP functions in a SQL statement
use arithmetic operators with dates in a SQL statement
describe and use date-manipulation functions MONTHS_BETWEEN, ADD_MONTHS, NEXT_DAY, LAST_DAY in a SQL statement
use the numeric ROUND and TRUNC functions with dates
write a SQL statement using the CHARACTER, NUMBER, and DATE functions

Oracle Database 12c - Introduction to SQL: Data Conversion and Aggregating Data

start the course
describe the use of implicit and explicit data conversion within SQL statements
use the TO_CHAR function to convert a date to a character data type in a SQL statement
describe elements of the Date Format Model in SQL
use the TO_CHAR Function to convert a number to a character datatype in a SQL statement
Use the TO_NUMBER and TO_DATE function to convert a character data type to a number or date format in a SQL statement
use the TO_CHAR and TO_DATE functions with the RR date format to return data for a previous century in a SQL statement
describe general functions when working with data pertaining to null values
use the NVL and NVL2 function when working with null values in a SQL statement
use the NULLIF and COALESCE functions when working with null values in a SQL statement
use conditional expressions to provide the use of the IF-THEN-ELSE logic in a SQL statement
use the CASE expression to facilitate a conditional inquiry in a SQL statement
use the DECODE function to facilitate conditional inquiry in a SQL statement
describe how to use group functions to return one result based on a set of rows in a SQL statement
use the AVG and SUM functions to group numeric data in a SQL statement
use the MIN and MAX functions to group numeric, character, and date data types in a SQL statement
use the COUNT and COUNT DISTINCT functions in a SQL statement
work with null values when grouping a set of rows in a SQL statement
create groups of data in a SQL statement
describe how to create groups of data and work with the GROUP BY clause in a SQL statement
use with the GROUP BY clause on multiple columns in a SQL statement
describe illegal queries when using the GROUP BY function in a SQL statement
use the HAVING clause to restrict grouped rows returned in a SQL statement
use nesting of group functions to a depth of two functions in a SQL statement
write SQL statements using the TO_CHAR, TO_DATE, DECODE functions and the CASE Expression
write SQL statements using the GROUP BY and HAVING functions

Oracle Database 12c - Introduction to SQL: Working with Joins and Subqueries

start the course
describe how to obtain data from multiple tables using JOINS in a SQL statement
join tables automatically based on columns with matching data types and names to retrieve data in a SQL statement
use the USING clause to specify columns used for an equijoin to retrieve records in a SQL statement
use aliases with the USING clause and use prefixes to join multiple tables in a SQL statement
use the ON clause when you specify join conditions in the WHERE clause in a SQL statement
using a three-way join to join three tables in a SQL statement
use the AND clause or the WHERE clause to apply additional conditions to a join in a SQL statement
use a self-join to join a table to itself in a SQL statement
use a join condition containing a non-equijoin in a SQL statement
use an OUTER join to return records with no direct match in a SQL statement
describe the differences between an INNER and OUTER join
use a left outer join in a SQL statement
use a right outer join in a SQL statement
use a full outer join in a SQL statement
describe the generation of a Cartesian product returned by a SQL statement
create cross joins in a SQL statement
use a subquery to solve a problem in a SQL statement
describe the rules, guidelines, and types of subqueries used in a SQL statement
use a single-row subquery to return one row in a SQL statement
display data from a main query using a group function in a subquery to return a single row in a SQL statement
use a subquery in the HAVING clause of a SQL statement
identify common errors that occur when an incorrect number of rows is returned by a single-row subquery in a SQL statement
describe multiple-row subqueries in a SQL statement
use the IN, ANY, and ALL operators in multiple-row subqueries in a SQL statement
use a multiple-column subquery to return more than one column to the outer query in a SQL statement
describe NULL values in a subquery and use the NOT IN operator in a SQL statement
display data from multiple tables using joins in a SQL statement
combine two queries by making use of a subquery in a SQL statement

Oracle Database 12c - Introduction to SQL: Data Manipulation Language

start the course
define the Data Manipulation Language in SQL
add rows to a table in the database by using the INSERT SQL statement
work with NULL values during the INSERT SQL statement when adding rows to a table
work with SPECIAL values during the INSERT SQL statement when adding rows to a table
work with specific DATE and TIME values during the INSERT SQL statement when adding rows to a table
save commands with substitution variables to a file and execute the commands in the file
use the INSERT SQL statement to copy rows from one table to another
change data in a table using the UPDATE SQL statement
change data into two columns using a subquery to update the two columns using the UPDATE SQL statement
change the rows in a table based on a different table using the UPDATE SQL statement
remove rows from a table using the DELETE SQL statement
remove rows from a table based on a different table using the DELETE SQL statement
use the TRUNCATE SQL statement to delete all rows from a table
insert and update rows in a table
describe database transactions and how to ensure data consistency during DML, DDL and DCL activity on the database
describe the COMMIT and ROLLBACK SQL statements
describe the control of the logic within transactions
use the ROLLBACK SQL command to undo changes to a defined marker
describe the conditions in which an automatic COMMIT statement is issued and the impact on the database
describe the state of the database before and after a COMMIT SQL command within the database
describe the state of the database before a ROLLBACK SQL command within the database
describe read consistency and its role in the database
describe using the FOR UPDATE clause in a SQL statement
process a transaction using explicit transaction control statements

Oracle Database 12c - Introduction to SQL: Working with SET Operators and DDL

start the course
describe the types of SET operators and their associated guidelines
recognize how the Oracle Server manages SET operators
use UNION and UNION ALL operators returns all rows in a SQL statement
use the INTERSECT operator to return all rows that are common to multiple queries in a SQL statement
use the MINUS operator to return all distinct rows selected by the first query in a SQL statement
describe how the expressions in the SELECT lists of the queries must match in number in a SQL statement
use the ORDER BY clause in set operations in a SQL statement
write reports requested by the HR department using the SET operators
describe the DDL database objects and the associated naming rules
use the CREATE TABLE SQL command to create new tables in the database
identify the different Oracle database data types used when creating a table
define a default value to be assigned to a column when creating a table
define a default value to be assigned to a column when creating a table
describe the syntax for defining constraints when creating a table
describe the use of the NOT NULL and PRIMARY KEY constraints when creating a table
describe the use of the UNIQUE constraint when creating a table
describe the use of the CHECK constraint
describe the use of the CHECK constraint
describe the conditions when a constraint is violated
create a new table and insert rows by combining the CREATE TABLE and the AS subquery option in a SQL statement
change the definition of a table using the ALTER TABLE SQL command
change the definition of a table by adding, modifying, and dropping columns in a table using the ALTER TABLE SQL command
use the SET UNUSED option to mark columns as unused using the ALTER TABLE SQL command
use the ALTER TABLE SQL command to set a table to read only
use the DROP TABLE SQL command to delete a table from the database
work with tables using DDL

TestPrep 1Z0-061 Oracle Database 12c: SQL Fundamentals

Course options

We offer several optional training products to enhance your learning experience. If you are planning to use our training course in preperation for an official exam then whe highly recommend using these optional training products to ensure an optimal learning experience. Sometimes there is only a practice exam or/and practice lab available.

Optional practice exam (trial exam)

To supplement this training course you may add a special practice exam. This practice exam comprises a number of trial exams which are very similar to the real exam, both in terms of form and content. This is the ultimate way to test whether you are ready for the exam.

Optional practice lab

To supplement this training course you may add a special practice lab. You perform the tasks on real hardware and/or software applicable to your Lab. The labs are fully hosted in our cloud. The only thing you need to use our practice labs is a web browser. In the LiveLab environment you will find exercises which you can start immediately. The lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience.

WHY_ICTTRAININGEN

Via ons opleidingsconcept bespaar je tot 80% op trainingen

Start met leren wanneer je wilt. Je bepaalt zelf het gewenste tempo

Spar met medecursisten en profileer je als autoriteit in je vakgebied.

Ontvang na succesvolle afronding van je cursus het officiële certificaat van deelname van Icttrainingen.nl

Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers

Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten

Orderproces

Once we have processed your order and payment, we will give you access to your courses. If you still have any questions about our ordering process, please refer to the button below.

What is included?

Certificate of participation	Yes
Teacher included	Yes
Monitor Progress	Yes
Award Winning E-learning	Yes
Examination possible	Yes
Mobile ready	Yes
Sharing knowledge	Unlimited access to our IT professionals community
Study advice	Our consultants are here for you to advice about your study career and options
Study materials	Certified teachers with in depth knowledge about the subject.
Service	World's best service

Platform

Na bestelling van je training krijg je toegang tot ons innovatieve leerplatform. Hier vind je al je gekochte (of gevolgde) trainingen, kan je eventueel cursisten aanmaken en krijg je toegang tot uitgebreide voortgangsinformatie.

FAQ

Niet gevonden wat je zocht? Bekijk alle vragen of neem contact op.

Cursusnaam
Looptijd
Rentebedrag financiering
Totaal bedrag
Maandbedrag

Vendors

Professions