Oracle Tutorials 2013: Database Design & Security

Europe/Zurich
30-7-018 - Kjell Johnsen Auditorium (CERN)

30-7-018 - Kjell Johnsen Auditorium

CERN

190
Show room on map
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.
    • 14:00 15:00
      Database and Application Design 1h
      Speaker: Katarzyna Maria Dziedziniewicz-Wojcik (CERN)
      Slides
    • 15:00 15:20
      Coffee Break 20m
    • 15:20 16:20
      Oracle Database Security for Developers 1h
      Speaker: Szymon Skorupinski (CERN)
      Slides