Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
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
Requirements
Knowledge-wide information technology.
35 Hours
Testimonials (2)
I like fact, that after each section we had exercises. It helps to remember discussed topic.
Adam Bińczycki
Course - Oracle 11g - SQL language for developers - Workshop
Good atmosphere during the training.