The course is addressed to programmers, team leaders, senior developpers.

Too often we have seen in production relatively small aplications with (relative) small amount of date performing poor due to lack of fundamental database knowledge of the programming team, of the team leader. These knowledge cannot be repleced by database tools suggesting hints, as it might affect the way the application is designed. Too often we have seen developpers (and companies) relying on ORM frameworks and tools only! Often a mistake payed on next little bigger project...

Course outline:

1.Prepared statements

What they mean and how performance is gained
When to use and when to avoid
Drawbacks
Stored procedures

2.Basic index facts

Index types and structures
Index minimization
When not use (and why full table scan is good)
Clustered index/IOT

3.Execution plan fundamentals

Access paths
Join algorithms
The importance of statistics
Bind variables

4.Transactions

What are transactions
Transaction properties
Locking
Isolation levels and issues they avoid
Versioning
Autocommit

5.Bulk insert

Benefits
How to use it
Drawbacks

6.Connection pooling