Oracle Database 12c Administrator Certified Associate

COURSES INCLUDED

ORACLE DATABASE 12C R2 SQL: USING STRUCTURED QUERY LANGUAGE (SQL)
Explore the introductory concepts of working with Oracle Database 12c, including relational database management concepts and terminologies and Oracle Live SQL.
10 videos | 50m Assessment

ORACLE DATABASE 12C R2 SQL: DATA MANIPULATION LANGUAGE & TRANSACTION CONTROL LANGUAGE
Once an Oracle 12c relational database has been created with objects, the data in these objects needs to be managed. Discover how to insert, update, delete, and truncate rows.
12 videos | 59m Assessment

ORACLE DATABASE 12C R2 SQL: USING BASIC SELECT STATEMENTS
Explore how to retrieve data using SQL SELECT statements including arithmetic expressions, NULL values, column aliases, and literal strings. You will also learn how to deal with duplicate rows.
12 videos | 59m Assessment

ORACLE DATABASE 12C R2 SQL: CONVERSION FUNCTIONS & CONDITIONAL EXPRESSIONS
Frequently when retrieving data stored in an Oracle database, the data needs to be converted, manipulated, or aggregated. Discover Oracle conversion functions and conditional expressions.
13 videos | 1h 7m Assessment

ORACLE DATABASE 12C R2 SQL: DISPLAYING DATA FROM MULTIPLE TABLES
Explore how to join tables together to view information across multiple tables and examine the more advanced features of the SELECT statements.
11 videos | 1h 7m Assessment

ORACLE DATABASE 12C R2 SQL: USING THE SET OPERATORS
Discover how to write SQL queries by using set operators.
8 videos | 40m Assessment

ORACLE DATABASE 12C R2 SQL: MANAGING OBJECTS WITH DATA DICTIONARY VIEWS
Explore the basics of data dictionary views. Discover how to create views on tables. Synonyms, sequences, and indexes, and how to create them is also covered.
6 videos | 34m Assessment

ORACLE DATABASE 12C R2 SQL: MANAGING SCHEMA OBJECTS
Explore how to work with constraints and alter existing objects in Oracle Database 12c. Working with external tables and naming an index at time of creating a PRIMARY KEY constraint is also covered.
13 videos | 1h 12m Assessment

ORACLE DATABASE 12C R2 SQL: DATA DEFINITION LANGUAGE (DDL)
Explore how to create a table and work with the various constraints associated with a table in Oracle Database 12c.
12 videos | 1h 3m Assessment

ORACLE DATABASE 12C R2 SQL: SQL*PLUS
SQL*Plus is an interactive and batch query tool that is installed with every Oracle server and client installation. This course will teach you the features and functionality of SQL*Plus.
8 videos | 45m Assessment

ORACLE DATABASE 12C R2 SQL: RESTRICTING & SORTING DATA
Database tables hold a large number of rows, which are often not sorted in any specific order. Learn how to selectively return only a subset of rows, sorted and customized.
12 videos | 1h Assessment

ORACLE DATABASE 12C R2 SQL: USING SINGLE-ROW FUNCTIONS TO CUSTOMIZE OUTPUT
Database tables may hold a large number of rows, which are often not sorted in any specific order. Discover how to selectively return only a subset of table rows, sorted and customized.
13 videos | 1h 11m Assessment

ORACLE DATABASE 12C R2 SQL: REPORTING AGGREGATED DATA USING GROUP FUNCTIONS
Discover how to obtain summary information, such as averages, for groups of rows in SQL. Explore how to group rows in a table into smaller sets and how to specify search criteria for groups of rows.
12 videos | 1h 7m Assessment

ORACLE DATABASE 12C R2 SQL: USING SUBQUERIES TO SOLVE QUERIES
Subqueries are very useful when you need to select rows from a table with a condition that depends on the data in the table itself. Explore the types, syntax, and guidelines for using subqueries in Oracle.
11 videos | 1h 23m Assessment

ORACLE DATABASE 12C R2 SQL: CREATING OTHER SCHEMA OBJECTS
Explore the basics of creating and using sequences and views in Oracle Database 12c SQL.
12 videos | 50m Assessment

ORACLE DATABASE 12C R2 SQL: CONTROLLING USER ACCESS
Discover how to control database access to specific objects and add new users with different levels of access privileges.
11 videos | 37m Assessment

ORACLE DATABASE 12C R2 SQL: MANIPULATING DATA USING ADVANCED QUERIES
Discover how to use the DEFAULT keyword in INSERT and UPDATE statements. Multitable INSERT statements, the MERGE statement, performing flashback operations, and tracking changes are also covered.
11 videos | 1h 7m Assessment