Stream: Virtual Room 2
Time: 14:00 - 15:00
Most of the application developers are used to use joins - cross joins, inner and outer joins. All resonate well. However, what if we start speaking about lateral join, anti join, self join, does it look familiar to you ?
What if we take a look at the predicate evaluation phases in relation to joins - before, during, and after; especially in case of multi-table joins. Did you know that you can even use joins to unmask the masked data? Do you understand the difference between the join types available in Db2? These are some of the questions we will be addressing.
In this presentation we will go through the basics to more advanced topics on joins. We will also show some useful tricks with joins.
There is currently no attachment for The joy of joins
Emil is an experienced Principal Software Architect with a demonstrated history of working in the computer software industry. Skilled in IBM Db2, Agile Methodologies, Databases, and IBM Mainframe. Strong engineering professional with a Ph.D. focused in Mathematical engineering from Czech Technical University in Prague. Emil is also an active member of the International Db2 User Group (IDUG), member of IDUG content committee, speaker at international conferences, and an IBM Champion since 2015.
Emil is an experienced Principal Software Architect with a demonstrated history of working in the computer software industry. Skilled in IBM Db2, Agile Methodologies, Databases, and IBM Mainframe. Strong engineering professional with a Ph.D. focused in Mathematical engineering from Czech Technical University in Prague. Emil is also an active member of the International Db2 User Group (IDUG), member of IDUG content committee, speaker at international conferences, and an IBM Champion since 2015.
Emil is an experienced Principal Software Architect with a demonstrated history of working in the computer software industry. Skilled in IBM Db2, Agile Methodologies, Databases, and IBM Mainframe. Strong engineering professional with a Ph.D. focused in Mathematical engineering from Czech Technical University in Prague. Emil is also an active member of the International Db2 User Group (IDUG), member of IDUG content committee, speaker at international conferences, and an IBM Champion since 2015.
Emil is an experienced Principal Software Architect with a demonstrated history of working in the computer software industry. Skilled in IBM Db2, Agile Methodologies, Databases, and IBM Mainframe. Strong engineering professional with a Ph.D. focused in Mathematical engineering from Czech Technical University in Prague. Emil is also an active member of the International Db2 User Group (IDUG), member of IDUG content committee, speaker at international conferences, and an IBM Champion since 2015.
Emil is an experienced Principal Software Architect with a demonstrated history of working in the computer software industry. Skilled in IBM Db2, Agile Methodologies, Databases, and IBM Mainframe. Strong engineering professional with a Ph.D. focused in Mathematical engineering from Czech Technical University in Prague. Emil is also an active member of the International Db2 User Group (IDUG), member of IDUG content committee, speaker at international conferences, and an IBM Champion since 2015.
Emil is an experienced Principal Software Architect with a demonstrated history of working in the computer software industry. Skilled in IBM Db2, Agile Methodologies, Databases, and IBM Mainframe. Strong engineering professional with a Ph.D. focused in Mathematical engineering from Czech Technical University in Prague. Emil is also an active member of the International Db2 User Group (IDUG), member of IDUG content committee, speaker at international conferences, and an IBM Champion since 2015.
Click here to give some Feedback so we can make it even better next year!