Oracle DB

Be an Oracle Man

Onemli Aciklama:
Oracle yazilarimi daha once fesoft.org da yaziyordum. Buraya aktarirken resimleri direkt referansli olarak tasimistim. Bazi resimlerde ulasim sorunu var. Bir suredir Oracle yazilarimi pdfe aktarmaya calisiyorum.Bitince paylasacagim. Bu konuda bana yardimci olmak icin iletisim kurabilirsiniz.

Oracle Ders 1 – Kurulum
Oracle Ders 2 – Temel Select Sorgusu
Oracle Ders 3 – Create Table(Tablo Olusturma) ve Yonetme
Oracle Ders 4 – Constraints (Kisitlamalar) – 01
Oracle Ders 5 – Constraints (Kisitlamalar) – 02
Oracle Ders 6 – Constraints (Kisitlamalar) – 03
Oracle Ders 7 – Data Manipulation & Transaction Control – 01
Oracle Ders 8 – Data Manipulation & Transaction Control – 02
Oracle Ders 9 – Sequence
Oracle Ders 10 – Index – BTree Index
Oracle Ders 11 – Index – Bitmap Index
Oracle Ders 12 – Index – Function Based Index
Oracle Ders 13 – Index – Index Organized Tables (IOT)
Oracle Ders 14 – Synonym
Oracle Ders 15 – Kullanici Olusturma ve Yonetimi – 01
Oracle Ders 16 – Kullanici Olusturma ve Yonetimi – 02 Roller
Oracle Ders 17 – Restricting Rows & Sorting Data
Oracle Ders 18 – Join – 01
Oracle Ders 19 – Join – 02
Oracle Ders 20 – Set Operators
Oracle Ders 21 – Single Row Functions – 01
Oracle Ders 22 – Single Row Functions – 02
Oracle Ders 23 – Single Row Functions – 03
Oracle Ders 24 – Single Row Functions – 04
Oracle Ders 25 – Single Row Functions – 05
Oracle Ders 26 – Group Functions – 01 Aggregate Functions
Oracle Ders 27 – Group Functions – 02 Group By & Having
Oracle Ders 28 – Group Functions – 03 Statistical Group Functions
Oracle Ders 29 – Group Functions – 04 Enhanced Aggregation
Oracle Ders 30 – SubQueries – 01 Single Row SubQuery
Oracle Ders 31 – SubQueries – 02 Multiple Row SubQuery
Oracle Ders 32 – SubQueries – 03 Multiple Column SubQuery
Oracle Ders 33 – SubQueries – 04 Nested SubQuery
Oracle Ders 34 – SubQueries – 05 DML SubQuery
Oracle Ders 35 – Merge
Oracle Ders 36 – Views – 01 Simple View
Oracle Ders 37 – Views – 02 Complex View – 01
Oracle Ders 38 – Views – 03 Complex View – 02
Oracle Ders 39 – Views – 04 Complex View – 03
Oracle Ders 40 – Views – 05 Materialized View

Leave a Reply

Your email address will not be published. Required fields are marked *