SQL Saturday 115 Pre-Con

É com orgulho que a Comunidade SQLPort anuncia que este ano, no dia anterior ao já anunciado SQLSaturday, vamos realizar um Workshop de dia inteiro com um conhecido especialista holandês - Hugo Kornelis. O tema do Workshop será "An effective (though uncommon) approach to database design" e vai centrar-se no desenho de bases de dados, tópico de interesse e utilidade fundamental para Programadores e Arquitectos de Software.

Para financiar os custos de trazer Hugo a Portugal, estamos a pedir uma pequena taxa de inscrição. Todo o dinheiro que restar após o pagamento das despesas será partilhado entre o Hugo Kornelis e a PASS.

O Workshop decorrerá no dia 16 de Março, para todos os registados, nas instalações dos Serviços Desconcentrados de Lisboa do Instituto Português da Juventude, localizados na Zona Norte do Parque Expo.

Agenda:

08:40 – Recepção e Registo
09:00 – Workshop
10:40 – Coffee-Break
11:00 – Workshop
13:00 – Almoço Livre
14:00 – Workshop
15:40 – Coffee Break
16:00 – Workshop
17:45 – Encerramento, Sorteio de Prémios e Convívio

 


Content (4 Blocks):

Basics:
Physical, logical, and conceptual model:
 -Universe of Discourse (UoD)
 -Principles of modeling
Initial model:
 -Verbalization
 -Diagramming

Constraints
How to test:
 -Types of constraints
 -Uniqueness
 -Mandatory Role
 -Subset, Equality, Exclusion
 -Frequency, Value
 -Other constraints

Transformations
Subtype analysis:
 -Fact type / Entity type transformation
 -Nominalisation / denominalisation

Relational model
Logical model:
 -Grouping
 -Lexicalizing
 -Transforming to relational model
Physical model:
 -Optimizations to consider

Preços:

Até final de Fevereiro (Early Bird):
Para membros da SQLPort: 50€
Público em geral: 75€
 
Em Março:
Para membros da SQLPort: 75€
Público em geral: 100€

Top 30 membros do ano 2011: 50€ (em qualquer período)

Para efectuar reserva por favor use o seguinte endereço de email: workshops@sqlport.com.


Sobre Hugo Kornelis:

Hugo is co-founder and R&D lead of perFact BV, a Dutch company that strives to improve analysis methods and to develop computer-aided tools that will generate completely functional applications from the analysis deliverable. The chosen platform for this development is SQL Server.

In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences.

Sobre a sessão:

In database design a lot of effort is spent on ensuring that database designs are perfectly normalized and slated for great performance. But there is one aspect that, though even more important, tends to get a lot less attention: correctness. If a database is completely normalized and performs brilliantly, but won't store the data that the business needs, or allows modification that should be rejected as violating business rules - what use is it?

In this precon, Hugo Kornelis presents a method that enables the database designer to find out exactly what the business needs are. Common pitfalls, such as miscommunications due to abstraction and jargon are avoided because the method relies completely on using concrete examples in the jargon of the business. The method presented tells you exactly what questions to ask, how to ask them, and how the answers to your question should be incorporated in your data model.

At the end of this day, you'll be able to make a conceptual data model for every application, and to transform that data model into a (completely normalized) logical database design.