Oracle 11g - SQL language for developers - Workshop

nobleprog

Corso

A Milano

Prezzo da consultare

Chiama il centro

0294759467

Hai bisogno di un coach per la formazione?

Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.

I migliori corsi di Oracle

Vedi tutti

Vedi tutti

Descrizione

  • Tipologia

    Corso

  • Luogo

    Milano

For who
Workshops are dedicated as a first step for developers and designers of applications based on Oracle databases. Participants do not need to have any prior knowledge of the Oracle database, or other relational database systems, even though such knowledge may be useful.
Exams and Certificates
The plan covers the training material required to pass the exam 1Z0-047 Oracle Database SQL Expert and obtain the title of Oracle Database SQL Certified Expert
Purpose of training
The workshop aims to familiarize participants with the Oracle database techniques to build database structures and data manipulation. Particular emphasis is placed on the participant to see across the board, which offers opportunities to design and build applications Relational Database Management System, Oracle Database, and to be able to independently work with her.
The content of the training
Introduction to database technology and the organization of the work environment
Acquisition and modification of data
Construction of the repository application
Safety and concurrency runtime
Notes
The workshops are based on the software version 11g XE

Sedi e date

Luogo

Inizio del corso

Milano
Visualizza mappa
Piazza Duomo, Via Torino 2, 20123

Inizio del corso

Consultare

Profilo del corso

Knowledge-wide information technology.

Domande e risposte

Aggiungi la tua domanda

I nostri consulenti e altri utenti potranno risponderti

Chi vuoi che ti risponda?

Inserisci i tuoi dati per ricevere una risposta

Pubblicheremo solo il tuo nome e la domanda

Opinioni

Materie

  • SQL

Programma

Introduction to the Oracle database

  • Database Architecture
  • Relational model database
  • Users diagrams sessions
  • Tools
Introduction to the SELECT statement
  • Screening and selection (WHERE clause)
  • Sorting
  • Data types, operators, and service NULL
  • Built-in scalar functions
  • Actions to date
  • National and regional settings in SQL
The analysis of aggregated data
  • Funkcje grupujące
  • Klauzula distinct
  • Klauzule GROUP BY and having
Retrieving data from multiple tables
  • Inner and outer joins (INNER JOIN, OUTER JOIN)
  • ANSI SQL syntax, and other methods connectors (SELF JOIN, NATURAL JOIN)
  • Collective operators (UNION, UNION ALL, INTERSECT, MINUS)
Subqueries
  • Subqueries simple
  • Correlated subqueries
  • Operators EXISTS and NOT EXISTS
  • Other types of subqueries
Inquiries hierarchical and samples
  • Construction of the tree (CONNECT BY PRIOR clause and START WITH)
  • The SYS_CONNECT_BY_PATH
  • Data samples (SAMPLE clause)
Data manipulation (DML)
  • "INSTRUCCIONES INSERT, UPDATE, DELETE
  • Operacja na dużych zbiorach (INSERT FIRST, ALL INSERT, MERGE)
Dictionary system Concurrent users work
  • Transactions
  • Locks
  • FLASHBACK
Users and Permissions
  • Creating and modifying user patterns
  • Permissions and roles
Managing data storage - logical layer
  • Tables, temporary tables, index-organized tables
  • Limitations
  • Indexes
  • The views, sequences, synonyms, materialized views
  • Units stored PL / SQL
Modeling and restore the data model using Oracle SQL Modeler Moving Data
  • A logical copy of the data - datapump import and export
  • Loading data - sqlLoader
  • External tables
  • Links database
Automating tasks
  • dbms_jobs, dbms_scheduler

Categorie correlate

Chiama il centro

0294759467

Hai bisogno di un coach per la formazione?

Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.

Oracle 11g - SQL language for developers - Workshop

Prezzo da consultare

I migliori corsi di Oracle

Vedi tutti

Vedi tutti