Oracle SQL: Beginner Oracle 12c

  • 15 Courses | 12h 19m 50s
  • 8 Books | 52h 44m
  • Includes Lab
Likes 261 Likes 261
 
Master Oracle SQL in-depth.

COURSES INCLUDED

Relational Database Concepts
As an administrator or developer, it's important to understand the object-relational aspects of Oracle Database 12c. Learn about data models, the Entity Relationship Model, and the Oracle HR sample schema.
10 videos | 43m has Assessment available Badge
SQL Developer
Oracle offers a free integration development environment, SQL Developer. Learn about SQL Developer, including creating connections, using SQL Worksheet, debugging, modeling data, and linking to external tools.
16 videos | 1h 7m has Assessment available Badge
SQL*Plus Commands
SQL*Plus is an interactive and batch query tool that is installed with every Oracle Server and client installation. Learn about the features and functionality of SQL*Plus, including editing, file, and output commands.
7 videos | 27m has Assessment available Badge
SELECT Statement, Expressions, & Operators
SQL*Plus provides a convenient way to work with Oracle data. Learn to retrieve data using SELECT statements with arithmetic expressions, NULL values, column aliases, and literal strings. In addition, learn how to handle duplicate rows.
12 videos | 46m has Assessment available Badge
Restricting Output
Database tables often hold a large number of rows, which aren't necessarily sorted. Learn how to selectively return only a subset of rows, sorted and customized, using operators, conditions, wildcards, and clauses.
10 videos | 45m available Badge
Working with Substitution
Learn how to build dynamic queries in Oracle Database 12c using substitution variables and the DEFINE and VERIFY commands.
5 videos | 23m available Badge
Customizing Output
In Oracle Database 12c, you have the ability to use functions to return and analyze data in a large variety of ways. Learn about character, case-conversion, numeric, nesting, date, and numeric functions.
13 videos | 59m available Badge
Data Conversion
Frequently when retrieving data stored in an Oracle database it needs to be converted, manipulated, or aggregated. Learn about the Oracle conversion functions and conditional expressions.
13 videos | 54m available Badge
Aggregating Data
Grouping data according to specific conditions allows you to create more effective reports and analyze data in more productive ways. Explore group functions, grouping data, and the clauses used for grouping in Oracle Database 12c.
12 videos | 47m available Badge
Working with Joins
It's important to minimize data redundancy in a relational database. Learn how to view information across multiple tables with joins and use advanced SELECT features to obtain values based on an unknown conditional value.
17 videos | 1h 4m available Badge
Working with Subqueries
It's not uncommon to need more than one query to get to the data results you require. Learn about using subqueries to solve problems in Oracle Database 12c.
11 videos | 39m available Badge
Data Manipulation Language
Oracle Database 12c objects contain data, and that data needs to be managed. Learn about manipulating tables by inserting, updating, deleting, and truncating rows.
14 videos | 1h 6m available Badge
Database Transactions
It's important to ensure that the SQL statements that make up a transaction succeed or fail as a group. Explore the concepts of database transaction control using the COMMIT, ROLLBACK, and SAVEPOINT commands.
10 videos | 50m has Assessment available Badge
Working with SET Operators
SET operators allow you to combine the results of two queries into one. Learn how to use SET operators and match SELECT statements in Oracle Database 12c.
8 videos | 27m