Today's blog post is to share with my readers that I have partnered with Interskill Learning and produced a series of videos in the Expert Video Series on how to code Db2 applications for performance.
My regular readers know that application performance is a passion of mine. You may also have read my recent book on the topic, A Guide to Db2 Performance for Application Developers. But if you are looking for videos to guide you through the process optimizing your application development for Db2, look no further than the six-part series I recorded for Interskill Learning, Coding Db2 Applications for Performance.
You do not need in-depth pre-existing knowledge of Db2 to gain insight from these video lessons. The outline of the six courses are as follows:
Db2 Coding – Defining Database Performance
- Providing a Definition
- The Four Components
- Diving a Little Deeper
Db2 Coding – Coding Relationally
- What is Relational?
- Relational vs. Traditional Thinking
- What Does It Mean to Code Relationally?
- Unlearning Past Coding Practices
Db2 Coding – General SQL and Indexing Guidelines
- Types of SQL
- SQL Coding Best Practices
- Indexes and Performance
- Stages and Clustering
Db2 Coding – Coding for Concurrent Access
- Introduction to Concurrency
- Locking
- Locking Duration and Binding
- Locking Issues and Strategies
- Query Parallelism
Db2 Coding – Understanding and Reviewing Db2 Access Paths
- Single Table Access Paths
- Multi-table Access Paths
- Filter Factors
- Access Paths and EXPLAIN
Db2 Coding – SQL Coding Tips and Techniques
- Avoid Writing Code
- Reusable Db2 Code
- Dynamic and Static SQL
- SQL Guidelines
- Set Operations
