Oracle Tutorials 2012

222/R-001 (CERN)



Show room on map
    • 9:00 AM 9:50 AM
      Oracle Architecture 50m
      The objective is to go through Oracle database physical and logical structures, highlighting the consequences of some 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 are 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 statements processing (hard and soft parsing, cursor, cursor sharing, execution plan)
      Speaker: Przemyslaw Adam Radowiecki (CERN)
    • 9:50 AM 10:00 AM
      Break 10m
    • 10:00 AM 10:50 AM
      Database and Application Design 50m
      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 the SQL statements processing, with a number of tips/and tricks. The last part will talk about building a robust application using privileges, different connection types and number of other features.
      Speaker: Katarzyna Maria Dziedziniewicz-Wojcik (CERN)
    • 10:50 AM 11:00 AM
      Break 10m
    • 11:00 AM 11:50 AM
      Database Security 50m
      During Database Security Tutorial we will focus on Oracle Database security from developers point of view. We'll cover few topics, i.e. authentication, roles and privileges, auditing, encryption and SQL injection attacks.
      Speakers: Daniel Gomez Blanco (CERN) , Szymon Jozef Skorupinski (CERN)
    • 9:00 AM 10:20 AM
      SQL and Advanced SQL 1h 20m
      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 is focused on the use of advanced SQL like: complex queries, analytical functions, set operators, views and temporary tables, materialized views, indexes and partitioning.
      Speaker: Marcin Blaszczyk (CERN)
    • 10:20 AM 10:30 AM
      Break 10m
    • 10:30 AM 12:00 PM
      PL/SQL 1h 30m
      PL/SQL is the 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.
      Speakers: Mr Stephan Petit (CERN) , Zbigniew Baranowski (CERN)