ORACLE 10g GÖRSEL EĞİTİM SETİ

ORACLE 10g GÖRSEL EĞİTİM SETİ

• Oracle Nedir. Avantajları - DezAvantajları
• Oracle Kurulumu – 1
• Oracle Kurulumu – 2
• Oracle ArchiveLog
• Oracle Backup Işlemi
• Oracle Backup(RMAN) Task Manager
• Oracle Database Restore(RMAN)

Oracle 10g Express Edition Veritabanı Yönetimi

• Oracle Administrator Tools - Create User
• Oracle Instance Start-Stop
• Oracle Remote Connection Open
• Oracle Listeener.ora Port Changing
• Oracle Http Access
• Oracle Administrator-Stroage
• Oracle Administrator Memory Cache
• Oracle Database Monitor
• Oracle Object Browser – 1
• Oracle Object Browser – 2
• Oracle Object Browser (Trigger,Data,Indexers)
• Oracle Object Browser – Views
• Oracle Object Browser Details
• Oracle SQL Management
• Oracle Generate Data Define Language

Oracle Sql Developer

• Oracle Sql Developer Kurulumu
• Oracle First New Connection
• Oracle Create Table – 1
• Oracle Table Column Insert , Drop
• Oracle Tables Actions
• Oracle New View , Delete
• Oracle Genel Tanımlar (Procedure,Trigger,Packages,Sequnts)
• Oracle New User Creating
• Oracle Database Export (User Schema)
• Oracle Database Copy (User Schema)
• Oracle Database Diff

Oracle SQL

• Oracle Select Statement
• Oracle Select - Where Keyword
• Oracle Select - OrderBy Keyword
• Oracle Like Keyword
• Oracle RowNum Keyword
• Oracle Sum-Avg Keyword
• Oracle MAX-MIN Keyword
• Oracle New Table SQL Script
• Oracle Drop Table SQL
• Oracle Update Table Schemas
• Oracle Deleted Table Row
• Oracle Upper Case - Lower Case
• Oracle Substr Fonksiyonu
• Oracle Length Fonksiyonu
• Oracle Replace Fonksiyonu
• Oracle Nvl - Round . Snippets Kullanımı
• Oracle Case Yapısı
• Oracle Views
• Oracle Inner - Left - Right Outer Joins

Oracle PL – SQL

• Giriş
• Oracle Pl-Sql Variables
• Oracle Pl-Sql Statements (Into Clause)
• Oracle PL - SQL TO_CHAR (sys.dual)
• Oracle PL - SQL Control Structure
• Oracle PL - SQL Loop - En Loop (Exit , Exit When)
• Oracle PL - SQL Labels Loop - End Loop
• Oracle PL - SQL While Statements
• Oracle PL - SQL For Döngüsü
• Oracle PL - SQL Goto Yapısı Labels
• Oracle PL - SQL Types Record
• Oracle PL - SQL Type Oluşturma Ve Nested Tables
• Oracle PL - SQL Records
• Oracle PL - SQL Sequents
• Oracle PL - SQL Cursor
• Oracle PL - SQL Rollback – Commit
• Oracle PL - SQL SubPrograms
• Oracle PL - SQL Error Handling
• Oracle PL - SQL Stored Procedure
• Oracle PL - SQL Function
• Oracle PL - SQL Packages

Connection

• C# Ile Oracle Instancesine Bağlanmak

C# İle Sequent Yardımıyla Insert Into

• C# Ile Sequent Yardımıyla Insert Into
• C# Ile Stored Procedure Çağırma
• OracleClient Part – 1
• OracleClient Part – 2
• Oracle Data Provider