Course Outline
Introduction to the database Oracle
- Database architecture Database relational model Users, schemas, sessions Database tools Oracle
Introduction to the SELECT statement
- Projection and selection Sorting Data types, operators and NULL handling Built-in scalar functions Date operations Locales and locales in SQL Queries Top N
Regular expressions
Aggregated data analysis
- Grouping functions DISTINCT clause GROUP BY and HAVING clauses Totals (ROLLUP, CUBE, GROUPING clauses)
Retrieving data from multiple tables
- Inner and outer joins (INNER JOIN, OUTER JOIN) ANSI SQL syntax and other join methods (SELF JOIN, NATURAL JOIN) Collective operators (UNION, UNION ALL, INTERSECT, MINUS)
Subqueries
- Simple subqueries Correlated subqueries EXISTS and NOT EXISTS operators Other types of subqueries Subqueries as a data source, creating views
Hierarchical queries and samples
- Tree building (CONNECT BY PRIOR and START WITH clause) SYS_CONNECT_BY_PATH function Data samples (SAMPLE clause)
Analytical functions
- Generating summaries Window definition Statistical functions
Pivot queries (PIVOT, UNPIVOT)
Tables and constraints
- Table Management (CREATE, ALTER, DROP, RENAME) Constraint Integrity (CONSTRAINTS)
Data Manipulation (DML)
- INSERT, UPDATE, DELETE statements Operations on large sets (INSERT FIRST, INSERT ALL, MERGE)
Concurrent work of users
- Transactions Locks Ensuring data consistency over time Retrospective queries Versioning queries
Requirements
The workshops are dedicated to end users, data analysts and software testers. Workshop participants do not have to be IT specialists, but employees who need to efficiently and effectively use the database Oracle, processing and analyzing the information contained therein.
Testimonials (9)
wiedza i przekłady
Jan Maksymowski
Course - Oracle 11g - Język SQL dla administratorów - warsztaty
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
Szkolenie było przygotowane perfekcyjnie, najbardziej podobał mi się sposób prowadzenia oparty przykładach pisanych w czasie rzeczywistym z dokładnym omówieniem jaki wpływ na bazę danych mają poszczególne instrukcje.
Joanna Dymarczyk
Course - Oracle 11g - Programowanie w PL/SQL I - warsztaty
Podczas szkolenia zostały bardzo szczegółowe - jak na dwa dni szkolenia - omówione wszystkie moduły, a na tym mi najbardziej zależało.
Bernadetta - Urząd Komisji Nadzoru Finansowego
Course - SQL Advanced
It was the best remote training I have ever attended. Even though the trainer did not force contact with the participants or become familiar in order to gain attention, he constantly gained my attention. The substantive level is very high. :)
Wioleta Angielczyk - Urząd Komisji Nadzoru Finansowego
Course - Master Data Services - Wprowadzenie
Machine Translated
Lot of content and exactly the requested one.
Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The smoothness of the training flow.
Alby Geronimo - Aarki, Inc.
Course - SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
I liked that he had actual know how of when to use each technology, that's valuable.
Radu Mazilu - eMAG IT Research
Course - Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems
I appreciated Folio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).