Cart
You have no items in your shopping cart
Oracle Training Oracle Database 12c SQL Fundamentals exam 1Z0-061
Training Oracle Database 12c SQL Fundamentals exam 1Z0-061
€289,00

Cheaper somewhere else?

Let us know!

+31367601019 [email protected]

Training Oracle Database 12c SQL Fundamentals exam 1Z0-061

Brand: Oracle
|
Click to enlarge
€289,00 Excl. tax
€349,69 Incl. tax
In stock
|
Order before 4:00 PM and start today.
You have got counting... hours
  • Gecertificeerde docenten
  • Beste opleider 2018
  • Cursist staat centraal
Information

Order this great Elearning Training Oracle Database 12c SQL Fundamentals exam 1Z0-061 online, 1 year 24/7 access to rich interactive videos, voice, practice assignments, progress monitoring through reports and tests per subject to test the knowledge directly. After the course you will receive a certificate of participation..

Course content

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

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

 

Product tags
Heeft u niet gevonden wat u zocht?
Let us help!
Specifications
Product
General properties
Availabilty: 16 hours
Language: English
Certificate of participation: Yes
Online access: 90 days
Progress monitoring: Yes
Award Winning E-learning: Yes
Suitable for mobile: Yes
Reviews
average of 0 review(s)
No reviews found
Read or write a review
Write a review




Please accept cookies to help us improve this website Is this OK? Yes No More on cookies »