Pular para o conteúdo

[email protected]
Contato

Curitiba 41 3204.1999 | Brasil 4007.2186
Tel

Whatsapp 41 98754.3534
Whatsapp
SoftSell
MENUMENU
  • HOME
  • TREINAMENTOS E CERTIFICAÇÕES
    • CALENDÁRIO DE TREINAMENTOS
    • Certificações em TI
    • Check Point
      • CCSA – Check Point Certified Security Administrator
      • CCSE – Check Point Security Engineering
      • Check Point CCSA+CCSE – Bundle R.80
    • Cisco
      • Cisco Digital Network Architecture Implementation Essentials (DNAIE) v2.0
      • Cisco SD-WAN Operation and Deployment (ENSDW) v1.0
      • Designing Cisco Enterprise Networks (ENSLD) v1.0
      • Implementing and Administering Cisco Solutions (CCNA) v1.0
      • Implementing and Configuring Cisco Identity Services Engine (SISE) v3.0
      • Implementing and Operating Cisco Enterprise Network Core Technologies (ENCOR) v1.0
      • Implementing and Operating Cisco Security Core Technologies (SCOR) v1.0
      • Implementing Cisco Application Centric Infrastructure (DCACI) v1.0
      • Implementing Cisco Catalyst 9000 Switches (ENC9K) v1.0
      • Implementing Cisco Enterprise Advanced Routing and Services (ENARSI) v1.0
      • Implementando Cisco Enterprise Wireless Networks (ENWLSI) v1.1
      • Implementing Secure Solutions with Virtual Private Networks (SVPN) v1.0
      • Securing Email with Cisco Email Security Appliance (SESA) v3.1
      • Securing the Web with Cisco Web Security Appliance (SWSA) v3.0
      • Understanding Cisco Wireless Foundations (WLFNDU) v1.0
    • CompTIA
      • Linux+ CompTIA
      • Security+ CompTIA
      • Webinar – Cibersegurança e o Mercado de Trabalho
    • EC-Council
      • CASE JAVA Training & Certification
      • CEH v11
      • CHFI
      • CND v2
      • CSA - Certified SOC Analyst
      • CSCU Certified Secure Computer User
      • ECIH
      • Webinar CEH – Certified Ethical Hacker v10
    • Extreme Networking
      • Campus EXOS Switching and Routing
    • F5
      • Configuring F5 Advanced WAF (previously licensed as ASM)
      • F5 ADM BIG IP – Administering BIG-IP
      • F5 BIG-IP DNS (Antigo GTM)
      • F5 Configuring BIG-IP (AFM): Advanced Firewall Manager
      • F5 Configuring BIG-IP (APM): Access Policy Manager
      • F5 LTM – Configuring BIG-IP Local Traffic Manager
      • F5 Troubleshooting BIG-IP
    • Fortinet
      • FortiGate (I) Security v6
      • FortiGate (II) Infrastructure v6
      • NSE 5 – FortiAnalyzer
      • NSE 5 – FortiManager
      • NSE 7 - Enterprise Firewall
    • Furukawa
      • Data Cabling System & MCT Fluke Networks
      • FCP Fibras Ópticas
      • FCP Fibras Ópticas | Módulo Emendas Ópticas
      • FCP Fibras Ópticas | Módulo Medição em Redes Ópticas
      • FCP Fibras Ópticas | Módulo Redes Externas
      • FCP Master
      • FCP Update
      • FCP Professional
      • FTTx Conceitos e Projetos
      • FTTx Equipamentos | Módulo 1 Networking
      • Webinar
    • Infoblox
      • CDAT – Core DDI Advanced Troubleshooting 8.x
    • Java
      • Java Performance Tuning
      • Java SE 8 Fundamentals
      • Java SE 8 New Features
      • Java SE 8 Programming
      • OO Analysis & Design Using UML
    • Microsoft
      • 10990CC Analyzing Data With SQL Server Reporting Services
      • 20483 Programação em C#
      • 207031BC Administering System Center Configuration Manager
      • 20740CC Installation, Storage and Compute with Windows Server 2016
      • 20741BC Networking with Windows Server 2016
      • 20742BC Identity with Windows Server 2016
      • 20761 Querying Data with Transact-SQL
      • 20762C Developing SQL Databases
      • 20764 Administering a SQL Database Infrastructure
    • MySQL
      • MySQL Cluster
      • MySQL for Developers
      • MySQL for Administrators
      • MySQL for Beginners
      • MySQL Fundamentals
      • MySQL Performance Tuning
    • Oracle
      • Database 12c ASM Administration
      • Database 12c Clusterware Administration
      • Database 12c Data Guard Administration
      • Database 12c Novos Recursos Para Administradores
      • Database 12c Performance Management and Tuning
      • Database 12c RAC Administration
      • Database 12c R2 Administration Workshop
      • Database 12c R2 Backup & Recovery
      • Database 12c R2 Install and Upgrade Workshop
      • Database 12c R2 New Features for Adm 2
      • Database 18c Managing Multitenant Architecture
      • Database Coud for Oracle DBAs
      • Database Program with PL/SQL Ed 2
      • Database SQL and PL/SQL New Features Ed 1
      • Database SQL & PL/SQL Fundamentals
      • Database SQL Workshop II
      • Data Integrator 12c Integration and Administration Ed 3 NEW
      • Exadata Database Machine 12c Administration Workshop
      • Introduction to SQL
      • SQL Tuning for Developers
      • WebLogic Server 12c Adm 1
      • WebLogic Server 12c Adm 2
      • WebLogic Server 12c JMS Adm
      • WebLogic Server 12c Performance Tuning
      • WebLogic Server 12c Troubleshooting
    • Palo Alto Networks
      • PAN 210 – Firewall 9.1 Essentials: Configuration and Management
      • PAN 214 – Firewall 8.1: Optimizing Firewall Threat Prevention
      • PAN 220 – Palo Alto Panorama: Managing Firewalls at Scale v9
      • PAN 318 – Prisma Access Sase Security: Design and Operation
      • PAN 330 – Firewall: Troubleshooting v9
    • Salesforce
      • Salesforce ADX 201
      • Salesforce ADX 251
      • Salesforce ADX 261
      • Salesforce DEX 450
      • Salesforce EEB101 + JB101
    • SoftSell
      • Gerenciamento Win Server 2012
      • Gestão de Projetos
      • Gestão de Projetos na era da Indústria 4.0
      • Linux Essentials
      • Pentest for Red Teams - Buffer Overflow Windows e Linux
      • Pentest for Red Teams – Web Application
      • Redes e Novas Tecnologias
    • SonicWall
      • SonicWall Network Security Administrator (SNSA)
      • SonicWall Network Security Professional (SNSP)
    • Veeam
      • Veeam Certified Engineer V9
    • VMWare
      • VMware vSphere: Install, Configure, Manage v6.7 – VMware
  • SOLUÇÕES DE TI
    • Fábrica de Softwares e BI
    • Produtos e Equipamentos de TI
    • Serviços de TI
      • Computação em Nuvem
      • Gerenciamento de TI
      • IBM Cloud
      • Suporte Infraestrutura
  • INSTITUCIONAL
    • Sobre a SoftSell
  • BLOG
Oracle Database SQL and PL/SQL New Features
Publicada em 10 de abril de 2018 na categoria
Slider
logo_oracle

Database SQL and PL/SQL New Features Ed 1

Sobre este Treinamento

What you will learn

The Oracle Database 12c: SQL and PL/SQL New Features training introduces you to the new features available in Oracle Database 12c. Expert Oracle University instructors will help you explore the latest features available in SQL language and feature enhancements in PL/SQL, data types, language performance and data warehousing. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.

Learn To:

  • Understand the FETCH clause to limit the rows returned by a SQL query;
  • Take advantage of the invisible and hidden columns;
  • Make use of the IDENTITY column to automatically generate the number column;
  • Utilize the ACCESSIBLE BY clause to create a white list of PL/SQL units;
  • Grant roles to PL/SQL packages and standalone stored procedures;
  • Understand Synchronous Materialized Views;
  • Identify ways to improve query performance against OLAP cubes;
  • Gain an understanding of the Oracle Database Exadata Express Cloud Service.

Benefits to You

When you walk away from this course, you will have gained a better understanding of the data warehousing new features available in Oracle Database 12c. This includes maintaining multiple partitions and SQL for pattern matching.

Carga Horária: 2 dias

GARANTIR MINHA VAGA!

Pré-requisito

Knowledge of Oracle Database, Structured Query Language (SQL), Basic programming concepts such as IF-THEN statements, loops, procedures and functions.

Application Developers
Database Administrators
Project Manager
System Analysts

Público-alvo

Conteúdo

Tópicos Principais:

  • Create Invisible and Hidden columns in a table
  • Understand enhanced DDL capabilities using ONLINE keyword
  • Identify additional new features available in SQL Language
  • Identify the increased length limits of data types
  • Configure database for extended data type
  • Understand SQL IDENTITY column
  • Identify SQL Column enhancements defaulting on explicit NULL and using a sequence
  • Identify additional feature available in Data Types such as ANYDATA, and GATEWAY
  • Understand fine grained access controls for packaged procedures
  • Define invoker’s rights function that can be result cached
  • Implement ACCESSIBLE BY clause
  • Grant roles to PL/SQL packages and standalone stored subprograms
  • Identify PL/SQL functions that can run faster in SQL
  • Maintain Multiple Partitions
  • Use FETCH clause in SQL queries
  • Gain an understanding of the Oracle Database Exadata Express Cloud Service

Course Introduction

  • Course Objectives
  • Course Agenda
  • Schemes used in this course
  • Classroom account information
  • Overview of SQL Developer 4.0
  • Review the Oracle Database 12c SQL and PL/SQL documentation and additional resources

SQL Language Enhancements

  • SQL Row Limiting Clause
  • Invisible and Hidden Columns
  • Enhanced DDL capabilities using ONLINE keyword
  • Additional features in SQL Language

Data Types Enhancements

  • Increased Length Limits of Data Types
  • Using SQL IDENTITY Column
  • SQL Column enhancements
  • ANYDATA type Enhancements
  • GATEWAY Enhancements

Declare PL/SQL Variables

  • List the different Types of Identifiers in a PL/SQL subprogram
  • Usage of the Declarative Section to Define Identifiers
  • Use variables to store data
  • Identify Scalar Data Types
  • The %TYPE Attribute
  • What are Bind Variables?
  • Sequences in PL/SQL Expressions

PL/SQL Enhancements

  • What is a White List?
  • Understanding Invoker’s right and Definer’s right
  • Granting Roles to PL/SQL packages and standalone stored subprograms
  • PL/SQL functions that run faster in SQL
  • Additional PL/SQL Enhancements

Data Warehousing Enhancements

  • Multi partition maintenance operations
  • Review of partitioned indexes
  • SQL for Pattern Matching
  • Overview of Synchronous Materialized View Refresh
  • Improving Query Performance Against OLAP Cubes

Oracle Cloud Overview

  • Introduction to Oracle Cloud & Oracle Cloud Services
  • Cloud Deployment Models
  • Evolving from On-premises to Exadata Express
  • What is in Exadata Express?
  • Exadata Express for Users & Developers
  • Oracle Exadata Express Cloud Service
  • Getting Started with Exadata Express
  • Service Console & Web Access through Service Console
Acesse o Calendário de Treinamentos

Atendimento Personalizado

Para saber mais sobre os treinamentos, certificações e soluções de TI da SoftSell, entre em contato com a gente.
É só escolher o seu canal preferido e aguardar breve resposta em horário comercial:

Curitiba: 41 3204.1999
Demais localidades: 4007.2186
WhatsApp : 41 98754.3534
Email: [email protected]
 

ENDEREÇO
Rua Emiliano Perneta, 680 – 9º Andar
Centro – Curitiba – Paraná – 80420-080

    Relacionado

    TREINAMENTOS E CERTIFICAÇÕES

    • Treinamentos e Certificações
    • Certificações em TI
    • Inscrições

    INFRAESTRUTURA DE TI

    • Software e BI
    • Serviços
    • Produtos e Equipamentos

    SOFTSELL

    • Sobre a SoftSell
    • Trabalhe Conosco

    ATENDIMENTO

    Telefone SoftSell Curitiba 41 3204.1999

    Telefone SoftSell Demais localidades 4007.2186

    Whatssap SoftSell WhatsApp 41 98754.3534

    Contato SoftSell [email protected]

     


    Rua Emiliano Perneta, 680 – 9º Andar – Centro – Curitiba – Paraná – 80420-080

    Siga-nos

    • Ver perfil de softsell no Facebook
    • Ver perfil de softsell.treinamentos no Instagram
    • LinkedIn

    SoftSell – Todos os Direitos Reservados | Desenvolvido por Pontodesign

    Pontodesign
    © 2021 SoftSell • Distribuído por GeneratePress
    Voltar ao topo