Training Oracle Database 12c R2 SQL

Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Explore the introductory concepts of
Oracle Database 12c R2 SQL: Data Manipulation Language and Transaction Control Language
Once an Oracle 12c relational
Oracle Database 12c R2 SQL: Using Basic SELECT statements
Explore how to retrieve data using
Oracle Database 12c R2 SQL: Conversion Functions and Conditional Expressions
Frequently when retrieving data
Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables
Explore how to join tables together
Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views
Explore the basics of data
Oracle Database 12c R2 SQL: Using the Set Operators
Discover how to write SQL queries by
Oracle Database 12c R2 SQL: Managing Schema Objects
Explore how to work with constraints
Oracle Database 12c R2 SQL: Data Definition Language (DDL)
Explore how to create a table and
Oracle Database 12c R2 SQL: SQL*Plus
SQL*Plus is an interactive and batch
Oracle Database 12c R2 SQL: Restricting and Sorting Data
Database tables hold a large number
Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output
Database tables may hold a large
Oracle Database 12c R2 SQL: Reporting Aggregated Data Using the Group Functions
Discover how to obtain summary
Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries
Subqueries are very useful when you
Oracle Database 12c R2 SQL: Creating Other Schema Objects
Explore the basics of creating and
Oracle Database 12c R2 SQL: Controlling User Access
Discover how to control database
Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries
Discover how to use the DEFAULT