Oracle Corporation Oracle Database 12c SQL Fundamentals exam 1Z0-061 E-Learning
Oracle Database 12c SQL Fundamentals exam 1Z0-061 E-Learning
€159,00
Oracle Corporation

Oracle Database 12c SQL Fundamentals exam 1Z0-061 E-Learning

EUR 159,00 Excl. btw
  • Koop 2 voor €155,82 per stuk en bespaar 2%
  • Koop 3 voor €154,23 per stuk en bespaar 3%
  • Koop 4 voor €152,64 per stuk en bespaar 4%
  • Koop 5 voor €151,05 per stuk en bespaar 5%
  • Koop 10 voor €143,10 per stuk en bespaar 10%
  • Koop 25 voor €135,15 per stuk en bespaar 15%
  • Koop 50 voor €127,20 per stuk en bespaar 20%

Training Oracle Database 12c SQL Fundamentals exam 1Z0-061- Online E-Learning training. Bestellen en direct starten voor de beste prijs.

  • E-Learning - Online toegang: 365 dagen
  • Taal: Engels (US)
  • Certificaat van deelname
Op voorraad
Bestel voor 16:00 uur en start vandaag.
Aantal
- +
  • Voor 23:00 uur besteld, morgen in huis
  • Certificaat van deelname
  • Bedrijven bestellen op factuur
  • Betaal in 3x geen extra kosten 0% rente en zonder BKR met in3
  • Meer informatie? Neem contact op over dit product
Productomschrijving

Oracle Database 12c SQL Fundamentals exam 1Z0-061

E-Learning

Bestel deze geweldige E-Learning Training Oracle Database 12c SQL Fundamentals exam 1Z0-061 online, 1 jaar 24/ 7 toegang tot rijke interactieve video’s, spraak, praktijkopdrachten, voortgangsbewaking door rapportages en testen per onderwerp om de kennis direct te toetsen. Na de cursus ontvangt u een certificaat van deelname.


Cursusinhoud

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

Specificaties
Duur 16 uur
Taal Engels
Certificaat van deelname Ja
Online toegang 365 dagen
Voortgangsbewaking Ja
Award Winning E-learning Ja
Geschikt voor mobiel Ja
Wat onze klanten zeggen

average of 0 review(s)

Geen reviews gevonden
Help ons en andere klanten door het schrijven van een review
Mijn account
You are not logged in. Log in to make use of all the benefits. Or create an account now.
Taal
Winkelwagen
Uw winkelwagen is leeg
Menu
Zoeken
Search suggestions
Geen cursussen of trainingen gevonden...
Wij slaan cookies op om onze website te verbeteren. Is dat akkoord? Ja Nee Meer over cookies »