Oracle Database 12c SQL Fundamentals exam 1Z0-061 E-Learning Kurs
€139,00
€159,00
Informationen
Oracle Database 12c SQL Fundamentals exam 1Z0-061 E-learning
Order this great E-learning 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
Haben Sie nicht gefunden, wonach Sie suchen?
Lassen Sie uns helfen!
Lassen Sie uns helfen!
Eigenschaften
Produkt
Allgemeine Eigenschaften
| Studiengebühr: | 5 Stunden Dauer plus Übungen (variabel) |
| Sprache: | Englisch |
| Online-Zugang: | 1 Jahr |
| Teilnahmebescheinigung: | Ja, nach 70% der erfolgreichen Einsätze |
| Fortschrittsüberwachung: | Ja |
| Geeignet für Handys: | Ja |
| Preisgekröntes E-Learning: | Ja |
Bewertungen
Lesen oder schreiben Sie einen Kommentar