What you will learn?

Description

Get started with SQL in Oracle Database

  • Learn how to create users, grant them privileges, and remove them in Oracle Database
  • Manage tables with CREATE TABLE, ALTER TABLE, and DROP TABLE
  • Learn how to write SQL queries with SELECT
  • Fast data access: How to create and use indexes in Oracle Database
  • Ensure data quality: Keys, Constraints and Referential Integrity
  • Does your database pass the ACID test? Transactions, Concurrency and Consistency
  • Code data logic in the database server: create a PL/SQL stored procedure
  • Understand SQL performance: How to create an execution plan | Explain the Explain Plan white paper (PDF)

Exam & Certification

Oracle Database SQL 1Z0-071