Minha Conta
Recuperar Senha

Digite seu endereço de e-mail que foi cadastrado e enviaremos seus dados de acesso.

Minha Conta

A senha deve conter no mínimo 6 caracteres.

Ao se cadastrar, você concorda com a Política de Privacidade e Segurança

Mudar Data: Photoshop CS6 Módulo I
Preço
15/09 a 26/09 Manhã 4000,00
15/09 a 26/09 Manhã 4000,00
15/09 a 26/09 Manhã 4000,00
15/09 a 26/09 Manhã 4000,00
  Itens Preço
Carrinho de Compras
O carrinho está vazio.
INVESTIMENTO TOTAL:0,00

Esqueci minha senha

Foi enviado um e-mail para com os dados de acesso.

Curso Oracle 11g - Introduction to SQL

O curso Oracle 11g - Introduction to SQL te ensina, de forma prática, a escrever subconsultas (subqueries), combinar várias consultas (queries) em uma única consulta (query) usando operadores SET e reportar dados agregados usando funções de grupo. Aprenda ainda a criar relatórios de dados classificados e restritos, executar instruções de manipulação de dados (DML), controlar o acesso ao banco de dados para objetos específicos, gerenciar objetos de esquema e com views de dicionário de dados, recuperar linha e coluna de dados a partir de tabelas e muito mais.
Garanta um desempenho rápido, confiável, seguro e fácil de gerenciar. Otimize as cargas de trabalho de banco de dados, reduza os custos de TI e ofereça uma maior qualidade de serviço, permitindo a consolidação de banco de dados em nuvens.
Para o melhor aproveitamento do curso Oracle 11g - Introduction to SQL, é imprescindível ter conhecimentos em conceitos de processamento e técnicas de processamento de dados.

Conteúdo Programático do Curso

  • TópicoIntroduction to Oracle Database
    • List the features of Oracle Database 11g.
    • Discuss the basic design, theoretical, and physical aspects of a relational database.
    • Categorize the different types of SQL statements.
    • Describe the data set used by the course.
    • Log on to the database using SQL Developer environment.
    • Save queries to files and use script files in SQL Developer.
  • TópicoLearn to Restrict and Sort Data
    • Write queries that contain a WHERE clause to limit the output retrieved.
    • List the comparison operators and logical operators that are used in a WHERE clause.
    • Describe the rules of precedence for comparison and logical operators.
    • Use character string literals in the WHERE clause.
    • Write queries that contain an ORDER BY clause to sort the output of a SELECT statement.
    • Sort output in descending and ascending order.
  • TópicoInvoke Conversion Functions and Conditional Expressions
    • Describe implicit and explicit data type conversion.
    • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions.
    • Nest multiple functions.
    • Apply the NVL, NULLIF, and COALESCE functions to data.
    • Use conditional IF THEN ELSE logic in a SELECT statement.
  • TópicoDisplay Data From Multiple Tables Using Joins
    • Write SELECT statements to access data from more than one table.
    • View data that generally does not meet a join condition by using outer joins.
    • Join a table to itself by using a self join.
  • TópicoThe SET Operators
    • Describe the SET operators.
    • Use a SET operator to combine multiple queries into a single query.
    • Control the order of rows returned.
  • TópicoUse of DDL Statements to Create and Manage Tables
    • Categorize the main database objects.
    • Review the table structure.
    • List the data types available for columns.
    • Create a simple table.
    • Decipher how constraints can be created at table creation.
    • Describe how schema objects work.
  • TópicoControl User Access
    • Differentiate system privileges from object privileges.
    • Create Users.
    • Grant System Privileges.
    • Create and Grant Privileges to a Role.
    • Change Your Password.
    • Grant Object Privileges.
    • How to pass on privileges?
    • Revoke Object Privileges.
  • TópicoManage Objects with Data Dictionary Views
    • Explain the data dictionary.
    • Use the Dictionary Views.
    • USER_OBJECTS and ALL_OBJECTS Views.
    • Table and Column Information.
    • Query the dictionary views for constraint information.
    • Query the dictionary views for view, sequence, index and synonym information.
    • Add a comment to a table.
    • Query the dictionary views for comment information.
  • TópicoData Management in Different Time Zones
    • Time Zones.
    • CURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMP.
    • Compare Date and Time in a Sessions Time Zone.
    • DBTIMEZONE and SESSIONTIMEZONE.
    • Difference between DATE and TIMESTAMP.
    • INTERVAL Data Types.
    • Use EXTRACT, TZ_OFFSET and FROM_TZ.
    • Invoke TO_TIMESTAMP,TO_YMINTERVAL and TO_DSINTERVAL.
  • TópicoRegular Expression Support
    • Use the Regular Expressions Functions and Conditions in SQL.
    • Use Meta Characters with Regular Expressions.
    • Perform a Basic Search using the REGEXP_LIKE function.
    • Find patterns using the REGEXP_INSTR function.
    • Extract Substrings using the REGEXP_SUBSTR function.
    • Replace Patterns Using the REGEXP_REPLACE function.
    • Usage of Sub-Expressions with Regular Expression Support.
    • Implement the REGEXP_COUNT function.
  • TópicoRetrieve Data Using the SQL SELECT Statement
    • List the capabilities of SQL SELECT statements.
    • Generate a report of data from the output of a basic SELECT statement.
    • Select All Columns.
    • Select Specific Columns.
    • Use Column Heading Defaults.
    • Use Arithmetic Operators.
    • Understand Operator Precedence.
    • Learn the DESCRIBE command to display the table structure.
  • TópicoUsage of Single-Row Functions to Customize Output
    • Describe the differences between single row and multiple row functions.
    • Manipulate strings with character function in the SELECT and WHERE clauses.
    • Manipulate numbers with the ROUND, TRUNC, and MOD functions.
    • Perform arithmetic with date data.
    • Manipulate dates with the DATE functions.
  • TópicoAggregate Data Using the Group Functions
    • Use the aggregation functions to produce meaningful reports.
    • Divide the retrieved data in groups by using the GROUP BY clause.
    • Exclude groups of data by using the HAVING clause.
  • TópicoUse Sub-queries to Solve Queries
    • Describe the types of problem that sub-queries can solve.
    • Define sub-queries.
    • List the types of sub-queries.
    • Write single-row and multiple-row sub-queries.
  • TópicoData Manipulation Statements
    • Describe each DML statement.
    • Insert rows into a table.
    • Change rows in a table by the UPDATE statement.
    • Delete rows from a table with the DELETE statement.
    • Save and discard changes with the COMMIT and ROLLBACK statements.
    • Explain read consistency.
  • TópicoOther Schema Objects
    • Create a simple and complex view.
    • Retrieve data from views.
    • Create, maintain, and use sequences.
    • Create and maintain indexes.
    • Create private and public synonyms.
  • TópicoManagement of Schema Objects
    • Add, Modify, and Drop a Column.
    • Add, Drop, and Defer a Constraint.
    • How to enable and Disable a Constraint?
    • Create and Remove Indexes.
    • Create a Function-Based Index.
    • Perform Flashback Operations.
    • Create an External Table by Using ORACLE_LOADER and by Using.
    • ORACLE_DATAPUMP.
    • Query External Tables.
  • TópicoManipulate Large Data Sets
    • Use Subqueries to Manipulate Data.
    • Retrieve Data Using a Subquery as Source.
    • Insert Using a Subquery as a Target.
    • Usage of the WITH CHECK OPTION Keyword on DML Statements.
    • List the types of Multitable INSERT Statements.
    • Use Multitable INSERT Statements.
    • Merge rows in a table.
    • Track Changes in Data over a period of time.
  • TópicoRetrieve Data Using Sub-queries
    • Multiple-Column Subqueries.
    • Pairwise and Nonpairwise Comparison.
    • Scalar Subquery Expressions.
    • Solve problems with Correlated Subqueries.
    • Update and Delete Rows Using Correlated Subqueries.
    • The EXISTS and NOT EXISTS operators.
    • Invoke the WITH clause.
    • The Recursive WITH clause.

Confira todas as datas deste treinamento

Início Término Período Unidade
Por favor, aguarde...Por favor, aguarde...

Treinamentos Corporativos?

Preencha o formulário que
entraremos em contato





Certificados de segurança
Seguranca Seguranca
Formas de pagamento
Formas de Pagamento

Conheça algumas profissões relacionadas ao curso

O curso Oracle 11g - Introduction to SQL é ideal para quem deseja se introduzir no segmento de programação e construir um repertório com base em soluções efetivas e rápidas utilizando a plataforma Oracle.
O curso Oracle 11g - Introduction to SQL é o início perfeito para quem deseja se tornar um DBA completo, com domínio das técnicas e recursos mais modernos do mercado.
Com o curso Oracle 11g - Introduction to SQL o formado está apto para criar aplicações e desenvolver soluções completas utilizando a plataforma Oracle, atuando como desenvolvedor desktop.
ICS

Certificações Impacta deste curso:

Recomendamos para você