Friday, September 28, 2007

Oracle 10g SQL Statement Tuning Course

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!

2 comments:

H.Tonguç Yılmaz said...

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

Mariam said...

I was wondering if you ever considered changing the
structure of your blog? Itts vesry well written; I love what youve got to say.
But maybe you could a little more in the
way of content so people could conmect wiith it better.
Youve got an awful lot of twxt for only having 1 or 2
pictures. Maybe you could space it out better?

Windows (powershell) counterparts of Linux commands

You may find Windows mostly powershell equivalent of frequently used Linux commands here. I will update this post, with newer ones by the ti...