Course not currently available

Data Analysis with Oracle 11g - workshop Training Course

Course

In Manchester ()

£ 5,170 VAT inc.

Description

  • Type

    Course

For who
Workshops are dedicated to end users, data analysts and software testers. Workshop participants do not need to be computer scientists, but employees who need efficiently and effectively use the Oracle database, processing and analyzing information contained in it
Exams and Certificates
The training plan includes, among others material required to pass the exam: 1Z0-051 Oracle Database 11g: SQL Fundamentals I, the first step to getting most certifications Oracle's Database
Purpose of training
The training is designed to familiarize participants with the Oracle database, the basic tools and techniques of data collection. Particular emphasis in this training is the acquisition of substantially correct and reliable data.
The content of the training
The organization of the working environment
Introduction to the relational model of data storage
Techniques for the collection, analysis and synthesis of information stored in the database
Modify the information stored in the database
Note
The workshops are based on the software version 11g XE

About this course

Knowledge-wide information technology.
Efficient movement in the workplace Windows or Linux

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Database
  • SQL
  • Database training
  • Data analysis

Course programme

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
Regular expressions The analysis of aggregated data
  • grouping Functions
  • DISTINCT clause
  • The GROUP BY clause and HAVING.
  • Summary (clauses ROLLUP, CUBE, GROUPING)
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)
Analytic Functions
  • Generating summaries
  • Definition window
  • Statistical Functions
  • New features in Oracle 11g
Inquiries Pivot (PIVOT, UNPIVOT) Tables and referential integrity
  • Managing tables (CREATE, ALTER, DROP, RENAME)
  • Referential integrity (constraints)
Data manipulation (DML)
  • INSTRUCCIONES INSERT, UPDATE, DELETE
  • Operacja na dużych zbiorach (INSERT FIRST, ALL INSERT, MERGE)
Concurrent users work
  • Transactions
  • Locks
  • FLASHBACK
Brief overview of schema objects
  • vistas
  • sequences
  • indexes

Additional information

35 hours (usually 5 days including breaks)

Data Analysis with Oracle 11g - workshop Training Course

£ 5,170 VAT inc.