The IT DB is pleased to announce a new series of Oracle tutorials with the proposed schedule. Note that these tutorials will take place in the Filtration Plant (Building 222) and that no registration is required.
Monday 4 June
09:00 Oracle Architecture, Przemyslaw Adam Radowiecki
The objective is to go through Oracle database physical and logical structures, highlighting the consequences of some of Oracle's internal design choices for developers of database applications. The presentation defines Oracle-related basic terms and illustrates them based on the database architecture.
The following topics will be discussed:
• Database with its physical and logical structures (tablespace, segment, extent, block, database user, schema, user's quota)
• Single instance (significant memory structures: buffer cache, shared pool)
• Real Application Cluster (RAC)
• Connecting to the database (TNS, database service)
• SQL statement processing (hard and soft parsing, cursor, cursor sharing, execution plan)
10:00 Database and Application Design, Katarzyna Maria Dziedziniewicz-Wojcik
The primary goal of this presentation is to show how to design a scalable application using Oracle that performs. We will start with schema design that allows storing the data in a way that is efficient, scalable and makes those data easily retrievable. In that part focus will be put on ER model and best practices in schema design. Later we will explain in detail SQL statement processing, with a number of tips/and tricks. The last part will talk about building a robust application using privileges, different connection types and a number of other features.
11:00 Database Security, Szymon Jozef Skorupinski & Daniel Gomez Blanco
During the Database Security Tutorial we will focus on Oracle Database security from the developers' point of view. We'll cover a few topics, including authentication, roles and privileges, auditing, encryption and SQL injection attacks.
Tuesday 5 June
09:00 SQL and Advanced SQL, Marcin Blaszczyk
SQL (Structured Query Language) is a programming language designed for managing data in relational database management systems. The aim of the tutorial is to provide an overview of the SQL language basic capabilities and several selected advanced SQL features available in the Oracle Database Management System. The main part of this tutorial will focus on the use of advanced SQL such as: complex queries, analytical functions, set operators, views and temporary tables, materialized views, indexes and partitioning.
10:30 PL/SQL, Zbigniew Baranowski & Stephan Petit
PL/SQL is Oracle's procedural extension of SQL. In this tutorial we will present the basic concepts behind PL/SQL and the general appearance of a PL/SQL program, covering general structure, control statements and basic units of the PL/SQL language.
We will then focus on best scripting practices -things that each developer should know in order to write efficient code and avoid common traps.
Friday 8 June
09:00 Tuning, Luca Canali & Dawid Wojcik & Eric Grancher
In this session, you will learn how to understand what prevents your application from running as fast as you would like (wait event, SQL monitor, Oracle Enterprise Manager, etc.). In the second part, we will share some indications on how to improve the performance (execution plan, table and index statistics, hinting, SQL baseline, etc.).
You will also learn the key points of how to address complex performance issues in a systematic way and to address performance issues in a quantitative way. A few examples and common pitfalls will be presented.
10:30 Oracle tools and Bindings with languages, Mariusz Piorkowski & Others
This tutorial provides an introduction to common Oracle database administrative tools: how they work, how to install and configure them, how efficiently we can use them. We’ll also provide some practice examples of usage. We will cover the following tools: PL/SQL Developer, rlwrap, Benthic Software – (Golden 6.0) and SQL Developer.
The second part of this presentation will address the topic of language bindings, including OCI, OCCI, JAVA, Perl and Python, for example.
For more information, please see the Indico page.