Bizi tercih ettiğiniz için teşekkür ederiz. Ekip üyelerimiz en kısa sürede sizlerle iletişime geçecektir.
Rezervasyonunuzu gönderdiğiniz için teşekkür ederiz! Ekibimizden bir yetkili kısa süre içinde sizinle iletişime geçecektir.
Eğitim İçeriği
Introduction to Database Migration
- Why migrate from proprietary to open source
- Oracle/SQL Server vs PostgreSQL architecture comparison
- Common migration challenges and success factors
- Overview of migration methodologies
Pre-Migration Assessment and Planning
- Database inventory and dependency analysis
- Schema complexity evaluation
- Application compatibility assessment
- Creating a migration roadmap and timeline
Schema Migration Strategies
- Converting Oracle data types to PostgreSQL
- Translating SQL Server data types
- Table structure conversion
- Index and constraint mapping
Object Migration: Stored Procedures and Functions
- PL/SQL to PL/pgSQL conversion
- T-SQL translation techniques
- Built-in function equivalents
- Package and procedure restructuring
Data Migration Tools and Techniques
- Using pg_dump and pg_restore
- Oracle FDW for data migration
- SQL Server integration services
- Handling large data volumes efficiently
Application Code Migration
- JDBC and ODBC driver differences
- Connection string modifications
- SQL dialect differences in application code
- Handling proprietary features
Testing and Validation
- Data integrity verification
- Functional testing strategies
- Performance benchmarking
- Parallel running and cutover planning
Post-Migration Optimization
- Query performance tuning in PostgreSQL
- Configuration adjustments for migrated workloads
- Monitoring setup and alerting
- Ongoing maintenance considerations
Troubleshooting Common Migration Issues
- Case study: Oracle migration challenges
- Case study: SQL Server migration challenges
- Rollback strategies
- Lessons learned and best practices
Hands-On Migration Workshop
- Guided migration of a sample schema
- Data extraction and loading exercises
- Code conversion practice
- Validation and verification exercises
Kurs İçin Gerekli Önbilgiler
- Basic understanding of relational databases
- Experience with SQL
- Familiarity with database administration concepts
Audience
- Database Administrators
- Application Developers
- IT Architects
14 Saatler
Danışanlarımızın Yorumları (2)
Sağlanan eğitim araçları.
- UNIFI
Eğitim - NoSQL Database with Microsoft Azure Cosmos DB
Yapay Zeka Çevirisi
Onun yöntemlerini çok bilgilendirici buldum
Adnan - Computerbits
Eğitim - Oracle SQL Language
Yapay Zeka Çevirisi
