Oracle Database 12c R2 SQ (Online Courses)
Elevate your career trajectory with our premier online course, designed to sharpen your competitive edge. Explore our curated selection of top-tier digital programs to hone your skills and propel your professional journey forward. Experience transformative learning tailored to empower your career advancement in today's dynamic landscape.
Price on Request
Start Learning
This Course Includes
-
11 hours 20 minutesof self-paced video lessons -
12 Programscrafting your path to success -
Completion Certificateawarded on course completion
Oracle Database 12c R2 SQL: Controlling User Access
Price on Request
35 minutes
Discover how to control database access to specific objects and add new users with different levels of access privileges.
Perks of Course
Certificate: Yes
CPD Points: 37
Compliance Standards: AICC
Oracle Database 12c R2 SQL: Conversion Functions & Conditional Expressions
Price on Request
1 hour 5 minutes
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.
Perks of Course
Certificate: Yes
CPD Points: 66
Compliance Standards: AICC
Oracle Database 12c R2 SQL: Creating Other Schema Objects
Price on Request
50 minutes
Explore the basics of creating and using sequences and views in Oracle Database 12c SQL.
Perks of Course
Certificate: Yes
CPD Points: 49
Compliance Standards: AICC
Oracle Database 12c R2 SQL: Data Definition Language (DDL)
Price on Request
1 hour
Explore how to create a table and work with the various constraints associated with a table in Oracle Database 12c.
Perks of Course
Certificate: Yes
CPD Points: 62
Compliance Standards: AICC
Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language
Price on Request
1 hour
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.
Perks of Course
Certificate: Yes
CPD Points: 59
Compliance Standards: AICC
Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables
Price on Request
1 hour 5 minutes
Explore how to join tables together to view information across multiple tables and examine the more advanced features of the SELECT statements.
Perks of Course
Certificate: Yes
CPD Points: 66
Compliance Standards: AICC
Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries
Price on Request
1 hour 5 minutes
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.
Perks of Course
Certificate: Yes
CPD Points: 67
Compliance Standards: AICC
Oracle Database 12c R2 SQL: Restricting & Sorting Data
Price on Request
1 hour
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.
Perks of Course
Certificate: Yes
CPD Points: 59
Compliance Standards: AICC
Oracle Database 12c R2 SQL: SQL*Plus
Price on Request
45 minutes
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.
Perks of Course
Certificate: Yes
CPD Points: 45
Compliance Standards: AICC
Oracle Database 12c R2 SQL: Using Basic SELECT statements
Price on Request
1 hour
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.
Perks of Course
Certificate: Yes
CPD Points: 59
Compliance Standards: AICC
Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Price on Request
50 minutes
Explore the introductory concepts of working with Oracle Database 12c, including relational database management concepts and terminologies and Oracle Live SQL.
Perks of Course
Certificate: Yes
CPD Points: 49
Compliance Standards: AICC
Oracle Database Instance Overview
Price on Request
1 hour 5 minutes
To work with Oracle database instances, you must understand the new multitenant architecture in Oracle Database 12c. Explore the memory, process, and storage architectures and how they work together.
Perks of Course
Certificate: Yes
CPD Points: 67
Compliance Standards: AICC