Logar
Evento
/

Oracle Database 11g: Introduction to SQL

Oracle Database 11g: Introduction to SQL

Banner - Oracle Database 11g: Introduction to SQL
Mostrar
  • De 05/06 às 08:30 até: 24/07 às 12:30
  • Rua São José, 90 - 2° andar, Centro - Rio de Janeiro/Rio de Janeiro - Brasil

Descrição

Carga Horária: 42 horas

 

 

Frequência: terças e quintas-feiras.

 


Objetivos:

Este curso apresenta o Banco de Dados Oracle 11g, os principais conceitos de bancos de dados relacionais e a linguagem SQL.

 

 

Descrição:

Este curso ensina a recuperar dados de tabelas com o comando SELECT, a empregar funções SQL para gerar e recuperar dados, a executar comandos de manipulação de dados (RML) para atualizar dados no Banco de Dados Oracle 11g, a controlar acesso de usuários e gerenciar objetos de esquema e a procurar dados usando subconsultas avançadas.

 

 

Conteúdo Programático:

 

Introduction

 

  • List the Oracle Database 11g main features
  • Provide an overview of: components, internet platform, apps server and developer suite
  • Describe relational and object relational database designs
  • Review the system development life cycle
  • Describe different means of storing data
  • Review the relational database concept
  • Define the term data models
  • Show how multiple tables can be related


Retrieving Data Using the SQL SELECT Statement

 

  • Define projection, selection, and join terminology
  • Review the syntaxes for the basic SQL SELECT statements
  • Use Arithmetic and Concatenation operators in SQL statements
  • List the differences between SQL and iSQL*Plus
  • Log into the database using iSQL*Plus
  • Explain the iSQL*Plus interface
  • Categorize the different types of iSQL*Plus commands
  • Save SQL statements to script files


Restricting and Sorting Data

 

  • Limit rows using a selection
  • Using the WHERE clause to retrieve specific rows
  • Using the comparison conditions in the WHERE clause
  • Use the LIKE condition to compare literal values
  • List the logical conditions AND, OR, NOT
  • Describe the rules of precedence for the conditions shown in this lesson
  • Sort rows with the ORDER BY clause
  • Use ampersand substitution in iSQL*Plus to restrict and sort output at run time


Using Single Row Functions to Customize Reports

 

  • Show the differences between single row and multiple row SQL functions
  • Categorize the character functions into case manipulation and character manipulation types
  • Use the character manipulation functions in the SELECT and WHERE clauses
  • Explain and use the DATE and numeric functions
  • Use the SYSDATE function to retrieve the current date in the default format
  • Introduce the DUAL table as a means to view function results
  • List the rules for applying the arithmetic operators on dates
  • Use the arithmetic operators with dates in the SELECT clause


Reporting Aggregated Data Using the Group Functions

 

  • Describe and categorize the group functions
  • Use the group functions
  • Utilize the DISTINCT keyword with the group functions
  • Describe how nulls are handled with the group functions
  • Create groups of data with the GROUP BY clause
  • Group data by more than one column
  • Avoid illegal queries with the group functions
  • Exclude groups of data with the HAVING clause


Displaying Data From Multiple Tables

 

  • Show the join tables syntax using SQL 99 syntax
  • Use table aliases to write shorter code and explicitly identify columns from multiple tables
  • Issue a SQL CROSS JOIN statement to produce a cartesian product
  • Use the NATURAL JOIN clause to retrieve data from tables with the same named columns
  • Create a join with the USING clause to identify specific columns between tables
  • Create a three way join with the ON clause to retrieve information from 3 tables
  • List the types of outer joins LEFT, RIGHT, and FULL
  • Add additional conditions when joining tables with the AND clause


Using Sub queries to Solve Queries

 

  • List the syntax for sub queries in a SELECT statements WHERE clause
  • List the guidelines for using sub queries
  • Describe the types of sub queries
  • Execute single row sub queries and use the group functions in a sub query
  • Identify illegal statements with sub queries
  • Execute multiple row sub queries
  • Analyze how the ANY and ALL operators work in multiple row sub queries
  • Explain how null values are handled in sub queries


Using the SET Operators

 

  • Use the UNION operator to return all rows from multiple tables
Ler mais

Localização

Programação

Este evento não possui atividades no momento.

Planta do Evento

A planta do evento não está disponível.

Contato

Preencha os campos abaixo para enviar e-mail ao organizador.

Campos Obrigatórios
Campos Obrigatórios
Ao se cadastrar, você concorda com nossos Termos de uso.
Ajaxloader

Compartilhar evento por e-mail


Para continuar, faça login ou cadastre-se.

Recomende este evento para sua rede.

Selecione os usuários que deseja recomendar este evento.