1.Hafta (TANI�MA VE ORACLE TEKNOLOJ�LER�)
�
������ Tan��ma
������ Oracle Teknolojileri
������ Oracle 9i/10G/11G aras�ndaki temel farklar
������ Windows/Linux Platformu �zerinde Oracle Kurulumu
������ Enterprise Manager / Toad Kullan�m�
������ Oracle Server ve Instance
������ Oracle Fiziksel yap�s�
������ Memory Y�netimi
������ System Global Area (SGA) y�netimi
������ Shared Pool
������ Library Cache
������ Data Dictionary Cache
������ Database Buffer Cache
������ Redo Log Buffer Cache
������ Large Pool
������ Java Pool
�
���� 2.Hafta (ORACLE MEMORY KULLANIMI)
�
������ Program Global Area (PGA) y�netimi
������ Process Structure
������ User Process i�lemleri
������ Server Process i�lemleri
������ Background Processes i�lemleri
������ Database Writer (DBWn)
������ Log Writer (LGWR)
������ System Monitor (SMON)
������ Process Monitor (PMON)
������ Checkpoint (CKPT)
������ Archiver (ARCn)
������ Logical Structure i�lemleri
������ Database Administration Tools
������ Optimal Flexible Architecture (OFA) kavram�
������ Oracle Software ve File Lokasyonlar�
������ Database Y�netimi i�in Authentication Methodlar�
������ Using Password File Authentication
������ SQL* Plus
������ Initialization Parameter Files
������ SPFILE ve spfileSID.ora
������ Oracle Managed Files
������ Veritaban�n�n ba�lat�lmas�
������ ALTER DATABASE Comand
������ Restricted Modda Database’in ba�lat�lmas�
������ Read-Only Modda Database’in ba�lat�lmas�
������ Veritaban�n�n kapat�lmas�
������ Shutdown Opsiyonlar�
������ Uygulama
�
3.Hafta (ORACLE F�Z�KSEL M�MAR�S�)
�
������ Alert Log File yap�s�
������ Background / User Trace Files ve yap�lar�
������ Enabling / Disabling User Tracing
������ Database Y�netimi
������ ��letim Sistemi Parametreleri
������ Database Configuration Assistant(DBCA) kullan�m�
������ Veritaban� olu�turma standartlar�
������ Instance’�n ba�lat�lmas�
������ Database olu�turma y�ntemleri
������ Data Dictionary Parametreleri
������ Data Dictionary ve Dynamic Performance Views sorgulamalar�
������ Control File yap�s�
������ OMF ile Control File y�netimi
������ Redo Log File yap�lar�
������ Clearing, Relocating, ve Renaming Online Redo Log Files
������ OMF ile Online Redo Log Y�netimi
������ SYSTEM ve Non-SYSTEM Tablespace y�netimi
������ Locally Managed Tablespaces
������ Dictionary Managed Tablespaces
������ Tablespace Yap�lar�
������ Tablespace B�y�kl�kleri
������ OMF ile Tablespace Y�netimi
������ Uygulama
������ Extent Allocation ve Deallocation
������ Block Space Utilization Parametreleri
������ Automatic Segment-Space Y�netimi
������ Data Dictionary Viewlar�
������ Automatic Undo Management konfig�rasyonu
������ Temporary Tables olu�turma
������ Nonpartitioned Table organizasyonu
������ UNUSED opsiyon kullan�m�
�
4.Hafta (INDEX,CONSTRAINT YAPILARI VE KULLANICI Y�NET�M�))
�
������ Index yap�lar�
������ B-Tree ve Bitmap Index kar��la�t�rmalar�
������ Allocating ve Deallocating Index Space
������ Indexlerin yeniden olu�turulmas�
������ Constraints tipleri
������ Primary ve Unique Key bilgileri
������ EXCEPTIONS Table kavram�
������ Tablo olu�umunda constraint olu�turma
������ Uygulama
������ Profiller
������ Password Management olu�umu
������ Profile olu�turma
������ Profile y�netimi
������ Resource Limit ayarlar� ve Session Level
������ Database Resource Manager y�netimi
������ Yeni kullan�c� olu�turma
������ Tablespace �zerinde User Quota de�i�imi
������ System Privileges ayarlar�
������ Object Privileges kald�rma
������ Auditing Kategorileri
������ Database Audit opsiyonlar�
������ Role bazl� Audit
������ Enabling ve Disabling Roles
������ Password kullan�m� ve� Default Roller
������ Database Character Setleri ve National Character Set yap�s�
������ NLS Parameter kullan�m� ve� SQL Functions
������ NLS ayarlar�
������ Uygulama
�
5.Hafta (ORACLE NETWORK M�MAR�S�)
�
������ Oracle Network Teknolojileri
������ Basit ve Komplex Network: N-Tier
������ Oracle Net Services
������ Database Connectivity (IIOP ve http)
������ Oracle Net ve Firewalls
������ Client-Server Application Connection: No Middle-Tier
������ The Listener Process
������ Listener.ora File
������ Logging ve Tracing
������ Listener Control Utility (LSNRCTL)
������ LSNRCTL SET ve SHOW Modifiers
������ Host Naming Method
������ Oracle Net Configuration Assistant
������ Net Service Names ile konfig�rasyon
������ Host Name ve Listener Port
������ tnsnames.ora
������ sqlnet.ora
������ Server Configurations
������ Dedicated Server Processes
������ Oracle Shared Server
������ SGA ve PGA
������ Configuring Oracle Shared Server
������ CIRCUITS
������ SHARED_SERVER_SESSIONS
������ Data Dictionary Views
������ Backup / Recovery Prensipleri
������ Felaket Kategorileri
������ User Process Felaket ��z�m�
������ User Errors lar�n ��z�m�
������ Instance Felaketlerinin ��z�m�
������ Backup and Recovery Strategy geli�tirme
������ Operasyonel gereklilikler
������ Disaster Recovery Prensipleri
������ Large Pool
������ Database Buffer Cache, DBWn, ve Datafiles
������ Redo Log Buffer, LGWR, ve Redo Log Files
������ CKPT Process
������ ARCn Process ve Archived Log Files
������ Phases for Instance Recovery
������ Tuning the Duration of Instance ve Crash Recovery
������ Tuning the Phases of Instance Recovery
������ Fast-Start On-Demand Rollback
������ Monitoring Parallel Rollback
������ Redo Log History
�
��� 6.Hafta (ONLINE BACKUP,RMAN KULLANIMI)
�
������ Noarchivelog Mode
������ Archivelog Mode
������ Archiving Mode de�i�tirme
������ Additional Archive Processesleri ba�latma / durdurma
������ Enabling Automatic Archiving at Instance Startup
������ Manually Archiving Online Redo Log Files
������ LOG_ARCHIVE_DEST_n Options
������ Minimum Number of Local Destinations
������ File Name Format a��klamas�
������ Archive Log bilgilerini anlamak
������ Recovery Manager Gereksinimleri
������ RMAN Repository: Using the Control File
������ Manual Channel Allocation
������ Automatic Channel Allocation
������ Connecting Without a Recovery Catalog
������ RMAN Commands
������ RMAN Configuration Settings
������ Recovery Manager Packages
������ RMAN Usage Considerations
������ User-Managed Backup and Recovery
������ Backup Methods
������ Open Database Backup
������ Failure During Online Tablespace Backup
������ Manual Control File Backups
������ �
�
��� 7.Hafta (RMAN Y�NET�M YAPISI)
�
������ Verifying Backups Using the DBVERIFY Utility
������ DBVERIFY Command-Line Interface
������ Uygulama
������ Recovery Manager Backups(RMAN)
������ Backup Setleri
������ Backup Set karakteristikleri
������ Backup par�a b�y�kl�kleri
������ Multiplexed Backup Sets
������ Archived Redo Log File Backups
������ Datafile Backup Set Processing
������ Characteristics of an Image Copy
������ Database Klonlama
������ Incremental Backup farkl�l�klar�
������ RMAN Control File Autobackups
������ RMAN Dynamic Views
������ RMAN Backups kontrol�
������ Media Recovery
������ Archivelog ve Noarchivelog Modes
������ Recovery in Noarchivelog Mode
������ Complete Recovery in Archivelog Mode
������ User-Managed Recovery Procedures
������ Complete Recovery Methods
������ Complete Recovery of a Closed Database
������ Recovery of a Datafile Without a Backup
������ Loss of Control Files
������ Recovering Control Files
������ Uygulama
�
8.Hafta (SQL Server 2008’e Giri�)
�
������ Temel Kavramlar ve SQL Server 2008 Ara�lar�
������ SQL Server 2008 Bile�en ve Mimarisine Genel Bak��
������ SQL Server 'de yer alan yaz�l�m geli�tirme ara�lar�
������ SQL Server 2008 G�venlik Mimarisi
�
9.Hafta (Temel Transact SQL ve Veri Sorgulama)
�
������ Genel Olarak SQL-DDL-DML-DCL
T-SQL ile De�i�ken ve Kontrol Yap�lar�n� Kavramak
Genel Olarak Veri Sorgulama C�mlecikleri
Karakter ve Tarih ��lemleri
SQL Server 2008 Bile�en ve Mimarisine Genel Bak��
������ Alt Sorgular ve T�retilmi� Tablo
Tablolar� Birle�tirerek
Sorgulamak
Verileri Gruplamak ve �zetlemek
�leri Veri
Y�netimi(Birle�tirmeli
Veri Silme-Ekleme-G�ncelleme)
������ Stored Procedure'ler
View'ler ve Fonksiyonlar
Ortak Zamanl�l�k Kavram� ve Trigger'lar
������ DDL Yenilikleri (Yeni Veri Tipleri-Schema-Partitioning Table...)
������ DML Yenilikleri (APPLY-PIVOT-CTE-RANKING...)
������ Yap�sal Hata Yakalama-TRY-CATCH yap�s�n� kullanmak
������ XML Veri Tipi ile �lgili Yenilikler(FOR XML ve OPEN XML iyile�tirmeleri...)
�
10.Hafta (Servis Mimarisi)
�
������ Service Broker Mimarisi
������ Service Broker Kodlamak ve Kullanmak
������ Do�al HTTP Deste�i Mimarisi
������ Do�al HTTP Deste�ini Ayarlamak ve HTTP Endpoint'ler Kurgulamak
������ Notification Service Mimarisi
������ Notification Service Olu�turmak
������ SQL CLR Mimarisi
������ Dahili Veri Sa�lay�c� olarak ADO.NET
������ Y�netilebilir SQL Server ��eleri Programlamak
������ ADO.NET ile SQL Server 2005'e �stemci Eri�imi Programlamak
������ Windows ve ASP.NET Uygulamalar�nda Veri Ba�lamak
������ SQL Management'e Genel Bak��
11.Hafta (MySql Temelleri)
�
�
12.Hafta (MySql Performans Y�netimi)