Data modeling with PostgreSQL at the core of Software Development
Wednesday, October 22 at 13:05–13:35
Data structures and their relationships are key to software design. For most, how data is organized is even more important than the application code itself, because the code, the flowcharts and the processes will be derived and become straightforward from the data structure and their relationships. Learning how to model your data and how to design your schema in PostgreSQL becomes fundamental to create a successful software project. How would you store and organize the data? Which data types would you use? Will there be any constraints? And most importantly, which types of questions will your application be able to answer directly from the data?
Honoring Mikhail Tal, the Magician from Riga, eighth World Chess Champion, in this talk we will go through the design of an application to track the results of a chess tournament. You will learn some principles of data modeling, letting PostgreSQL guarantee data integrity. We will see how to build the business logic of the application in the data model itself, giving you extra powers as a software developer.
