Course not currently available
Data Analysis with Oracle 11g - workshop Training Course
Course
In Manchester ()
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
Reviews
Subjects
- Database
- SQL
- Database training
- Data analysis
Course programme
- Database Architecture
- Relational model database
- Users diagrams sessions
- Tools
- 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
- grouping Functions
- DISTINCT clause
- The GROUP BY clause and HAVING.
- Summary (clauses ROLLUP, CUBE, GROUPING)
- 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 simple
- Correlated subqueries
- Operators EXISTS and NOT EXISTS
- Other types of subqueries
- Construction of the tree (CONNECT BY PRIOR clause and START WITH)
- The SYS_CONNECT_BY_PATH
- Data samples (SAMPLE clause)
- Generating summaries
- Definition window
- Statistical Functions
- New features in Oracle 11g
- Managing tables (CREATE, ALTER, DROP, RENAME)
- Referential integrity (constraints)
- INSTRUCCIONES INSERT, UPDATE, DELETE
- Operacja na dużych zbiorach (INSERT FIRST, ALL INSERT, MERGE)
- Transactions
- Locks
- FLASHBACK
- vistas
- sequences
- indexes
Additional information
Data Analysis with Oracle 11g - workshop Training Course