Oracle Database 12c: SQL Fundamentals

Course Description:

The Oracle Database 12c: SQL Fundamentals course is a 5-day course that is designed to teach students the basics of the SQL language and the Oracle Relational Database Management System (RDBMS).

Students will become familiar with the differences in the working environment between a traditional on-premise database installation and the Oracle database service cloud-computing platform.

The course will also cover intermediate-level SQL topics such as writing database queries using the SQL-99 syntax and exploiting the power of built-in functions that extend the capabilities of SQL.

This course takes a holistic approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning experience.

Students will learn how to complete of an application schema definition by creating database objects such as relational views, sequences, synonyms, indexes and others to compliment the table definitions.

The course will also cover the topic of data integrity and how this is protected using declarative constraints. Students will also learn about database object security and database performance. This course is taught using version 12c, but the topics are applicable for either version 11g or 12c.

Topics covered in the course include:

• Relational Databases & Data Models

• Selection & Setup Of The Database Interface

• Using The Database Interface

• Introduction To The Sql Language

• The Select Statement

• Restricting Results With The Where Clause

• Sorting Data With The Order By Clause

• Pseudo Columns, Functions & Top-n Queries

• Joining Tables

• Using The Set Operators

• Summary Functions

• Aggregating Data Within Groups

• Use Ddl To Create & Manage Tables

• Use Dml To Manipulate Data

• Understanding The Data Models

• About The Sql-99 Standard

• Enhancing Groups With Rollup & Cube

• Using The Case Expression

• Sql Functions: Numeric Handling

• Sql Functions: Date Handling

• Database Objects: About Database Objects

• Database Objects: Relational Views

• Database Objects: Indexes

• Database Objects: Creating Other Objects

• Database Objects: Object Management Using Ddl

• Database Objects: Security

• Data Integrity Using Constraints

Target Student:

• This course is intended for Oracle professionals, both business and systems professionals.