{"id":153,"date":"2024-05-28T11:03:00","date_gmt":"2024-05-28T11:03:00","guid":{"rendered":"https:\/\/stradata.com.tr\/en\/?page_id=153"},"modified":"2024-09-30T12:40:09","modified_gmt":"2024-09-30T12:40:09","slug":"egitim","status":"publish","type":"page","link":"https:\/\/stradata.com.tr\/en\/?page_id=153","title":{"rendered":"TRAINING CATALOGUE"},"content":{"rendered":"\n
\n
\n
\n
\"\"<\/figure>\n\n\n\n

Oracle Database Administration<\/h3>\n\n\n\n
    \n
  • Database Configuration and Management<\/li>\n\n\n\n
  • Database Objects<\/li>\n\n\n\n
  • SQL and PL\/SQL<\/li>\n\n\n\n
  • Network and Connection Management<\/li>\n\n\n\n
  • Monitoring and Management Tools<\/li>\n\n\n\n
  • Data Backup and Restore<\/li>\n\n\n\n
  • Performance Tuning<\/li>\n\n\n\n
  • Security Management<\/li>\n\n\n\n
  • Data Migration and Migration<\/li>\n\n\n\n
  • High Availability and Disaster Recovery<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n
    \n
    \n
    \"\"<\/figure>\n\n\n\n

    Oracle Database Backup & Recovery<\/h3>\n\n\n\n
      \n
    • Backup Strategies<\/li>\n\n\n\n
    • Physical Backup Techniques<\/li>\n\n\n\n
    • Logical Backup Techniques<\/li>\n\n\n\n
    • Using RMAN (Recovery Manager)<\/li>\n\n\n\n
    • Data Recovery Scenarios<\/li>\n\n\n\n
    • Restore and Recovery with RMAN<\/li>\n\n\n\n
    • Point-in-Time Recovery (PITR)<\/li>\n\n\n\n
    • Flashback Technologies<\/li>\n\n\n\n
    • Backup and Recovery Performance<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n
      \n
      \n
      \"\"<\/figure>\n\n\n\n

      Oracle Database Patch & Upgrade<\/h3>\n\n\n\n
        \n
      • Patch and Upgrade Terminology<\/li>\n\n\n\n
      • Patch Management<\/li>\n\n\n\n
      • Oracle Patch Types and Categories<\/li>\n\n\n\n
      • Patch Application Processes<\/li>\n\n\n\n
      • Oracle Database Upgrade Planning<\/li>\n\n\n\n
      • Pre-Upgrade Preparations<\/li>\n\n\n\n
      • Upgrade Methodologies<\/li>\n\n\n\n
      • Oracle Database Upgrade Tools<\/li>\n\n\n\n
      • Post-Upgrade Checks and Tests<\/li>\n\n\n\n
      • Rollback Strategies<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n
        \n
        \n
        \n
        \"\"<\/figure>\n\n\n\n

        Oracle RAC, ASM & Grid Infrastructure<\/h3>\n\n\n\n
          \n
        • Grid Infrastructure Components<\/li>\n\n\n\n
        • Oracle ASM Architecture<\/li>\n\n\n\n
        • Grid Infrastructure & ASM Installation and Configuration<\/li>\n\n\n\n
        • Oracle RAC Architecture<\/li>\n\n\n\n
        • Oracle RAC Installation and Configuration<\/li>\n\n\n\n
        • Clusterware Management and Monitoring<\/li>\n\n\n\n
        • RAC and ASM Performance Tuning<\/li>\n\n\n\n
        • RAC and ASM Security Management<\/li>\n\n\n\n
        • Error Diagnosis and Resolution<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n
          \n
          \n
          \"\"<\/figure>\n\n\n\n

          Oracle Data Guard Administration<\/h3>\n\n\n\n
            \n
          • Oracle Data Guard Architecture<\/li>\n\n\n\n
          • Data Guard Installation and Configuration<\/li>\n\n\n\n
          • Physical and Logical Standby<\/li>\n\n\n\n
          • Data Guard Broker Usage<\/li>\n\n\n\n
          • Data Synchronization and Replication<\/li>\n\n\n\n
          • Switchover and Failover Processes<\/li>\n\n\n\n
          • Data Protection Modes<\/li>\n\n\n\n
          • Performance Tuning and Optimization<\/li>\n\n\n\n
          • Data Guard Monitoring and Management<\/li>\n\n\n\n
          • Disaster Recovery Scenarios and Planning<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n
            \n
            \n
            \"\"<\/figure>\n\n\n\n

            Oracle Exadata Administration<\/h3>\n\n\n\n
              \n
            • Oracle Exadata Architecture<\/li>\n\n\n\n
            • Exadata Hardware and Software Components<\/li>\n\n\n\n
            • Exadata Installation and Configuration<\/li>\n\n\n\n
            • Storage Cell Management<\/li>\n\n\n\n
            • Smart Scan and Smart Flash Cache<\/li>\n\n\n\n
            • Image and Firmware Updates<\/li>\n\n\n\n
            • Performance Optimization<\/li>\n\n\n\n
            • Exadata Management Tools and Techniques<\/li>\n\n\n\n
            • Exadata Security Management<\/li>\n\n\n\n
            • Backup and Restore Strategies<\/li>\n\n\n\n
            • High Availability and Disaster Recovery<\/li>\n\n\n\n
            • Exadata Fault Diagnosis and Resolution<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n
              \n
              \n
              \n
              \"\"<\/figure>\n\n\n\n

              Oracle Database PL\/SQL Programming<\/h3>\n\n\n\n
                \n
              • PL\/SQL Programming Architecture<\/li>\n\n\n\n
              • Data Types and Variables<\/li>\n\n\n\n
              • Control Structures<\/li>\n\n\n\n
              • Loops and Conditional Statements<\/li>\n\n\n\n
              • Subprograms: Procedures and Functions<\/li>\n\n\n\n
              • PL\/SQL Packages<\/li>\n\n\n\n
              • Error Handling and Exceptions<\/li>\n\n\n\n
              • PL\/SQL Triggers<\/li>\n\n\n\n
              • Dynamic SQL and PL\/SQL<\/li>\n\n\n\n
              • Performance Tuning and Optimization<\/li>\n\n\n\n
              • Security and Authorization<\/li>\n\n\n\n
              • Advanced Applications with PL\/SQL<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n
                \n
                \n
                \"\"<\/figure>\n\n\n\n

                Oracle Database Security<\/h3>\n\n\n\n
                  \n
                • Oracle Database Security Components<\/li>\n\n\n\n
                • User Management and Authorization<\/li>\n\n\n\n
                • Use and Management of Roles<\/li>\n\n\n\n
                • Database Object Security<\/li>\n\n\n\n
                • Encryption Methods<\/li>\n\n\n\n
                • Data Masking Techniques<\/li>\n\n\n\n
                • Database Auditing and Monitoring<\/li>\n\n\n\n
                • Virtual Private Database (VPD) Usage<\/li>\n\n\n\n
                • Database Vault Usage<\/li>\n\n\n\n
                • Transparent Data Encryption (TDE)<\/li>\n\n\n\n
                • Oracle Label Security (OLS)<\/li>\n\n\n\n
                • Firewall Configuration<\/li>\n\n\n\n
                • Security Policies and Practices<\/li>\n\n\n\n
                • Security Audits and Reporting<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n
                  \n
                  \n
                  \"\"<\/figure>\n\n\n\n

                  Oracle Database Performance Tuning<\/h3>\n\n\n\n
                    \n
                  • Database Performance Monitoring and Measurement Tools<\/li>\n\n\n\n
                  • Indexing Strategies and Optimization<\/li>\n\n\n\n
                  • Database Statistics and Statistics Collection<\/li>\n\n\n\n
                  • Memory Management and Optimization<\/li>\n\n\n\n
                  • Disk I\/O Management and Optimization<\/li>\n\n\n\n
                  • Database Parameter Settings and Configuration Improvements<\/li>\n\n\n\n
                  • Parallel Processes and Performance Impacts<\/li>\n\n\n\n
                  • Cache Management and Usage<\/li>\n\n\n\n
                  • Diagnostic Packages and Performance Troubleshooting<\/li>\n\n\n\n
                  • Real Application Testing and Performance Validation<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n
                    \n
                    \n
                    \n
                    \"\"<\/figure>\n\n\n\n

                    Linux System Administration for DBA<\/h3>\n\n\n\n
                      \n
                    • Linux Operating System Fundamentals<\/li>\n\n\n\n
                    • Basic Linux Command Line (CLI) Usage<\/li>\n\n\n\n
                    • File and Directory Management<\/li>\n\n\n\n
                    • User and Group Management<\/li>\n\n\n\n
                    • System Logs (Logs) and Monitoring Tools<\/li>\n\n\n\n
                    • Basic Network Management and Settings<\/li>\n\n\n\n
                    • Disk Management and File Systems<\/li>\n\n\n\n
                    • Package Management and Software Installation<\/li>\n\n\n\n
                    • Basic Security and Access Controls<\/li>\n\n\n\n
                    • System Performance Monitoring and Tuning<\/li>\n\n\n\n
                    • Basic Debugging and Troubleshooting<\/li>\n\n\n\n
                    • Automatic Jobs and Management (Cron)<\/li>\n\n\n\n
                    • Shell Scripting Fundamentals<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n
                      \n
                      \n
                      \"\"<\/figure>\n\n\n\n

                      SQL Programming<\/h3>\n\n\n\n
                        \n
                      • SQL Basics and Introduction<\/li>\n\n\n\n
                      • Data Query (SELECT)<\/li>\n\n\n\n
                      • Data Insertion (INSERT)<\/li>\n\n\n\n
                      • Data Update (UPDATE)<\/li>\n\n\n\n
                      • Data Deletion (DELETE)<\/li>\n\n\n\n
                      • Advanced SELECT Statements<\/li>\n\n\n\n
                      • Subqueries and Joins (JOIN)<\/li>\n\n\n\n
                      • GROUP BY, HAVING<\/li>\n\n\n\n
                      • Arrays (ARRAYS) and Usage<\/li>\n\n\n\n
                      • Data Types and Operators<\/li>\n\n\n\n
                      • SQL Functions and Procedures<\/li>\n\n\n\n
                      • Dynamic SQL and Parameters<\/li>\n\n\n\n
                      • Error Handling and Exceptions<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n
                        \n
                        \n
                        \"\"<\/figure>\n\n\n\n

                        SQL Performance Tuning<\/h3>\n\n\n\n
                          \n
                        • SQL Performance Optimization Fundamentals<\/li>\n\n\n\n
                        • Data Modeling and Normalization<\/li>\n\n\n\n
                        • Data Indexing and Optimization<\/li>\n\n\n\n
                        • Writing and Optimizing SQL Queries<\/li>\n\n\n\n
                        • Collecting and Using SQL Statistics<\/li>\n\n\n\n
                        • DML Performance Optimizations<\/li>\n\n\n\n
                        • JOIN Operators and Performance Impacts<\/li>\n\n\n\n
                        • Parallel Queries and Performance Optimizations<\/li>\n\n\n\n
                        • Database Monitoring Tools and Usage<\/li>\n\n\n\n
                        • SQL Plan Management and Optimization<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n
                          \n
                          \n
                          \n
                          \"\"<\/figure>\n\n\n\n

                          PostgreSQL Database Administration<\/h3>\n\n\n\n
                            \n
                          • Understanding PostgreSQL Architecture<\/li>\n\n\n\n
                          • PostgreSQL Database Installation and Configuration<\/li>\n\n\n\n
                          • Database Object Management (Tables, Indexes, Views)<\/li>\n\n\n\n
                          • Data Backup and Restore Operations<\/li>\n\n\n\n
                          • PostgreSQL Security Management (User Management, Access Controls)<\/li>\n\n\n\n
                          • Performance Tuning and Optimization<\/li>\n\n\n\n
                          • SQL and PL\/pgSQL Programming<\/li>\n\n\n\n
                          • High Availability and Disaster Recovery Strategies<\/li>\n\n\n\n
                          • PostgreSQL Monitoring and Management Tools<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n
                            \n
                            \n
                            \"\"<\/figure>\n\n\n\n

                            PostgreSQL Database Backup & Recovery<\/h3>\n\n\n\n
                              \n
                            • Backup Strategies<\/li>\n\n\n\n
                            • WAL Concept and Recovery<\/li>\n\n\n\n
                            • PostgreSQL Point-in-Time Recovery (PITR)<\/li>\n\n\n\n
                            • Using pg_dump and pg_dumpall<\/li>\n\n\n\n
                            • Backing up with pg_basebackup<\/li>\n\n\n\n
                            • Backing up with pg_backrest<\/li>\n\n\n\n
                            • Backing up with barman<\/li>\n\n\n\n
                            • Managing and Storing Backup Files<\/li>\n\n\n\n
                            • Planning and Automating Backup Strategies<\/li>\n\n\n\n
                            • Restore Scenarios and Applications<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n
                              \n
                              \n
                              \"\"<\/figure>\n\n\n\n

                              PostgreSQL Replication and High Availability<\/h3>\n\n\n\n
                                \n
                              • PostgreSQL Replication Basics<\/li>\n\n\n\n
                              • Streaming Replication and Asynchronous Replication<\/li>\n\n\n\n
                              • Standby Server Installation and Configuration<\/li>\n\n\n\n
                              • Data Flow Between Servers<\/li>\n\n\n\n
                              • Replication Slot Concept and Usage<\/li>\n\n\n\n
                              • Replication and Load Balancing<\/li>\n\n\n\n
                              • Point-in-Time Recovery (PITR) Applications<\/li>\n\n\n\n
                              • Patroni Installation and Configuration<\/li>\n\n\n\n
                              • Etcd Usage and Configuration<\/li>\n\n\n\n
                              • Patroni Error Scenarios and Solutions<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n
                                \n
                                \n
                                \n
                                \"\"<\/figure>\n\n\n\n

                                PostgreSQL Database Security<\/h3>\n\n\n\n
                                  \n
                                • User Management and Authorization<\/li>\n\n\n\n
                                • Data Encryption and Security<\/li>\n\n\n\n
                                • Database Access Controls (GRANT and REVOKE)<\/li>\n\n\n\n
                                • SSL\/TLS Certificates and Secure Connections<\/li>\n\n\n\n
                                • Audit and Log Management<\/li>\n\n\n\n
                                • PostgreSQL Extensions and Security<\/li>\n\n\n\n
                                • Debugging and Vulnerabilities<\/li>\n\n\n\n
                                • Database Firewall Applications<\/li>\n\n\n\n
                                • Data and Security Policies<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n
                                  \n
                                  \n
                                  \"\"<\/figure>\n\n\n\n

                                  PostgreSQL Database Performance Tuning<\/h3>\n\n\n\n
                                    \n
                                  • Database Statistics<\/li>\n\n\n\n
                                  • Writing and Optimizing SQL Queries<\/li>\n\n\n\n
                                  • Indexing Strategies and Optimizations<\/li>\n\n\n\n
                                  • Data Modeling and Normalization<\/li>\n\n\n\n
                                  • Disk I\/O Management and Optimization<\/li>\n\n\n\n
                                  • Memory Management and Caching<\/li>\n\n\n\n
                                  • Parallel Query Management and Performance Optimizations<\/li>\n\n\n\n
                                  • PostgreSQL Performance Monitoring Tools<\/li>\n\n\n\n
                                  • Using Logs and Diagnostic Data in Performance Management<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n
                                    <\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                                    Oracle Database Administration Oracle Database Backup & Recovery Oracle Database Patch & Upgrade Oracle RAC, ASM & Grid Infrastructure Oracle Data Guard Administration Oracle Exadata Administration Oracle Database PL\/SQL Programming Oracle Database Security Oracle Database Performance Tuning Linux System Administration for DBA SQL Programming SQL Performance Tuning PostgreSQL Database Administration PostgreSQL Database Backup & Recovery […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-153","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/stradata.com.tr\/en\/index.php?rest_route=\/wp\/v2\/pages\/153","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stradata.com.tr\/en\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/stradata.com.tr\/en\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/stradata.com.tr\/en\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/stradata.com.tr\/en\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=153"}],"version-history":[{"count":10,"href":"https:\/\/stradata.com.tr\/en\/index.php?rest_route=\/wp\/v2\/pages\/153\/revisions"}],"predecessor-version":[{"id":365,"href":"https:\/\/stradata.com.tr\/en\/index.php?rest_route=\/wp\/v2\/pages\/153\/revisions\/365"}],"wp:attachment":[{"href":"https:\/\/stradata.com.tr\/en\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}