IT Training > Database / Business Intelligence > Oracle
logo

Oracle Database 11g: SQL Fundamentals

This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. This course can prepare for the exam N° 1Z0-051.

Reserve

Course Description

Description

This course introduces students to the fundamentals of SQL using Oracle Database 11g database technology. In this course students learn the concepts of relational databases and the powerful SQL programming language.

The students also learn to use single row functions to customize output, use conversion functions and conditional expressions and use group functions to report aggregated data. Demonstrations and hands-on practice reinforce the fundamental concepts.

In this course, students use Oracle SQL Developer as the main tool and SQL*Plus is available as an optional tool.

Structure of the course

  • Introduction
  • Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data From Multiple Tables Using Joins
  • Using Sub-queries to Solve Queries
  • Using the SET Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects

Prerequisites

Suggested Prerequisites :

Familiarity with data processing concepts and techniques

Who Should Attend this course ?

  • Application Developers
  • End Users
  • Forms Developer
  • Functional Implementer
  • PL/SQL Developer
  • Portal Developer
  • Reports Developer
  • Technical Consultant

Check also