Oracle Tutorials 2013: Database Design & Security

Tuesday, 30 April 2013 from to (Europe/Zurich)
at CERN ( 30-7-018 - Kjell Johnsen Auditorium )
Description
The primary goal of this presentation is to show how to design a scalable application within Oracle that performs and how to easily create an APEX GUI accessing data in that application. 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. We will talk about building a robust application using privileges, different connection types and number of other features. In the last part a small APEX application will be created using the designed data structure.
During Database Security presentation we will focus on Oracle Database security from developers point of view. We'll cover few topics, i.e. users, roles and privileges, encryption and SQL injection attacks.
Go to day
  • Tuesday, 30 April 2013
    • 14:00 - 15:00 Database and Application Design 1h0'
      Speaker: Katarzyna Maria Dziedziniewicz-Wojcik (CERN)
      Material: Slides powerpoint file pdf file
    • 15:00 - 15:20 Coffee Break
    • 15:20 - 16:20 Oracle Database Security for Developers 1h0'
      Speaker: Szymon Skorupinski (CERN)
      Material: Slides powerpoint file pdf file