Oracle Database 11g: SQL Fundamentals I

Course code

OD11gSQL

Duration

3 Days, 24 Acad. Hours

Download pdf

Course Overview

Objectives

Prerequisites

Course Outline

Course Overview

Course overview

This Oracle Database 11g: SQL Fundamentals I – Self-Study Coursec is designed to teach you the fundamentals of SQL using Oracle Database 11g database technology. Using the powerful Structured Query Language (SQL), the data contained within relational databases can be retrieved, managed and manipulated.

Objectives

Course objectives

To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting
To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return value
To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE
To recognize the steps for creating, defining, and dropping tables, manipulating how their data can be viewed, and using schema objects to generate integers, improve queries

Prerequisites

Audience

Administrator
Architect
Database Administrator
Developer

Course Outline

Course Topics

1.Oracle Database 11g: Using SQL to Query Your Database

Using SQL in Oracle Database 11g
Retrieving, Restricting and Sorting Data
Using Single-Row Functions

2. Oracle Database 11g: Conversion Functions, Group Functions, and Joins

Conversion Functions and Conditional Expressions
Group Functions and Joins

3. Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation

Using Subqueries and Set Operators
Manipulating Data

4. Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms

Using DDL Statements to Create and Manage Tables
Creating Other Schema Objects

Back to trainings (Oracle)

Request the training

Oracle Database 11g: SQL Fundamentals I

Course code:

OD11gSQL

Duration:

3 Days, 24 Acad. Hours

Apply

Download pdf