Oracle SQL Bootcamp

PT0285
Summary
Students learn the fundamentals of SQL and PL/SQL and understand the benefits of the programming languages using Oracle database technology. In this course students learn the concepts of relational databases. This course provides the essential SQL skills that allow developers to write queries and manipulate data in tables.Students use Oracle SQL Developer to develop these program units. SQL*Plus and Jdeveloper are available as optional tools.
Prerequisites
Familiarity with data processing and programming concepts.
Duration
5 Days/Lecture & Lab
Audience
Programmers, Analysts, Database Administrators, and those responsible for the development or maintenance of application systems which access an Oracle database.
Topics
  • Data Retrieval Operations
  • Multi-Table Operations
  • Data Manipulation Operations
  • Security
  • Miscellaneous SQL
  • Overview of PL/SQL
  • Variables and Constants
  • PL/SQL Executable Statements
  • Embedding SQL Within PL/SQL
  • Handling Exceptions
  • PL/SQL Built-in Functions
  • Subprograms
  • Introduction to PL/SQL on the Server

Related Scheduled Courses