There's a lot of flexibility available in how you create tables to store data in an Oracle 12c database. Learn about how to create tables, choose the proper data type for columns, set constraints, and change or delete existing tables.
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.
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.
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.
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.
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.
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.
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.
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.
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.