Oracle Tutorials 2013: Database Design & Security
Tuesday, 30 April 2013 from to (Europe/Zurich)
CERN ( 30-7-018 - Kjell Johnsen Auditorium )
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.