Oracle 10g SQL Statement Tuning Course

By deryaoktay

A good, informative and broadening course authored by Hasan Tonguç Yılmaz. It lasted for 4 days hands on course. As a brief it consists of following topics, and exercises:

  • Oracle SQL hints
  • Oracle performance related views, and PLSQL packages
  • BULK collect
  • SQL bind variables
  • Heap, Index Organized, Partitioned, Clustered tables
  • Oracle sources regarding SQL statements (SQL Reference: http://tahiti.oracle.com, Package examples: http://psoug.org/library.html, For problems , articles, and solutions: http://metalink.oracle.com/, http://otn.oracle.com, http://asktom.oracle.com/tkyte/)
  • Indexes, FTS
  • Join methods, join orders

I will add above list later!

One Response to “Oracle 10g SQL Statement Tuning Course”

  1. H.Tonguç Yılmaz Says:

    Derya hoşgeldin :)

    Eğitim ile ilgili daha detaylı içerik bakan olursa diye paylaşıyorum;
    http://tonguc.blogspot.com/2007/09/turkcell-akademi-oracle-database-10g.html

Leave a Reply