{"id":82,"date":"2018-08-29T14:32:13","date_gmt":"2018-08-29T14:32:13","guid":{"rendered":"https:\/\/mpzsoftware.com\/?page_id=82"},"modified":"2018-08-29T14:32:29","modified_gmt":"2018-08-29T14:32:29","slug":"mysql-for-database-administrators","status":"publish","type":"page","link":"https:\/\/mpzsoftware.com\/?page_id=82","title":{"rendered":"MySQL For Database Administrators"},"content":{"rendered":"

MySQL For Database Administrators<\/b><\/h1>\n

 <\/p>\n

Course Objectives<\/span><\/h2>\n
    \n
  • MySQL Database Architecture <\/span><\/li>\n
  • MySQL Database Administration Essentials<\/span><\/li>\n<\/ul>\n

    Prerequisites<\/span><\/h2>\n
      \n
    • General IT technical knowledge<\/span><\/li>\n
    • Understanding of RDBMS concepts<\/span><\/li>\n
    • Previous RDBMS Database Administration Experiance (Oracle, MS SQL Server, etc.)<\/span><\/li>\n<\/ul>\n

      Course Outline<\/span><\/h2>\n
        \n
      • Introduction to MySQL<\/span>\n
          \n
        • Why MySQL?<\/span><\/li>\n
        • Brief History of MySQL<\/span><\/li>\n<\/ul>\n<\/li>\n
        • MySQL Installation <\/span>\n
            \n
          • MySQL Software Installation Methods<\/span><\/li>\n
          • Hardware and Software Prerequisites<\/span><\/li>\n
          • User Accounts and Environment Variables<\/span><\/li>\n<\/ul>\n<\/li>\n
          • MySQL Server Basics <\/span>\n
              \n
            • MySQL Server Configuration and Defaults<\/span><\/li>\n
            • MySQL Server System and Status Variables<\/span><\/li>\n
            • MySQL Server SQL Modes<\/span><\/li>\n<\/ul>\n<\/li>\n
            • MySQL CLI<\/span>\n
                \n
              • mysql<\/span><\/li>\n
              • mysqladmin<\/span><\/li>\n
              • mysqlcheck<\/span><\/li>\n
              • mysqlshow<\/span><\/li>\n
              • mysqldump<\/span><\/li>\n
              • mysqlimport<\/span><\/li>\n<\/ul>\n<\/li>\n
              • MySQL Server Logs<\/span>\n
                  \n
                • MySQL Error Log<\/span><\/li>\n
                • MySQL General Query Log<\/span><\/li>\n
                • MySQL Slow Query Log<\/span><\/li>\n
                • MySQL DDL Log<\/span><\/li>\n
                • MySQL Binary Log<\/span><\/li>\n
                • MySQL Server Log Maintenance and Rotation<\/span><\/li>\n<\/ul>\n<\/li>\n
                • MySQL Data Dictionary<\/span>\n
                    \n
                  • Understanding Metadata<\/span><\/li>\n
                  • INFORMATION_SCHEMA<\/span><\/li>\n<\/ul>\n<\/li>\n
                  • MySQL Server Security<\/span>\n
                      \n
                    • MySQL General Security Issues<\/span><\/li>\n
                    • MySQL User Account Management<\/span><\/li>\n
                    • MySQL Access Privileges<\/span><\/li>\n
                    • MySQL Connection Encryption<\/span><\/li>\n<\/ul>\n<\/li>\n
                    • MySQL Server Backup and Recovery<\/span>\n
                        \n
                      • MySQL Backup and Recovery Methods<\/span><\/li>\n
                      • MySQL Backup and Recovery Strategies<\/span><\/li>\n
                      • Introducing Point-in-time recovery<\/span><\/li>\n<\/ul>\n<\/li>\n
                      • MySQL Storage Engines <\/span>\n
                          \n
                        • InnoDB Storage Engine<\/span><\/li>\n
                        • MyISAM Storage Engine<\/span><\/li>\n
                        • MEMORY Storage Engine<\/span><\/li>\n
                        • ARCHIVE Storage Engine<\/span><\/li>\n
                        • NDB Storage Engine (MySQL Cluster)<\/span><\/li>\n
                        • Other Storage Engines<\/span><\/li>\n<\/ul>\n<\/li>\n
                        • MySQL Table Partitioning<\/span>\n
                            \n
                          • MySQL Table Partitioning Overview<\/span><\/li>\n
                          • MySQL Partition Types<\/span><\/li>\n
                          • MySQL Partition Management<\/span><\/li>\n
                          • MySQL Partition Pruning<\/span><\/li>\n
                          • MySQL Partitioning Restrictions<\/span><\/li>\n<\/ul>\n<\/li>\n
                          • MySQL Procedural Programming<\/span>\n
                              \n
                            • MySQL Stored Procedures<\/span><\/li>\n
                            • MySQL Functions<\/span><\/li>\n
                            • MySQL Triggers<\/span><\/li>\n
                            • MySQL Event Scheduler<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                               <\/p>\n","protected":false},"excerpt":{"rendered":"

                              MySQL For Database Administrators   Course Objectives MySQL Database Architecture MySQL Database Administration Essentials Prerequisites General IT technical knowledge Understanding of RDBMS concepts Previous RDBMS Database Administration Experiance (Oracle, MS SQL Server, etc.) Course Outline Introduction to MySQL Why MySQL? Brief History of MySQL MySQL Installation MySQL Software Installation Methods Hardware and Software Prerequisites User […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":37,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-82","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/mpzsoftware.com\/index.php?rest_route=\/wp\/v2\/pages\/82","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mpzsoftware.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/mpzsoftware.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/mpzsoftware.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mpzsoftware.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=82"}],"version-history":[{"count":1,"href":"https:\/\/mpzsoftware.com\/index.php?rest_route=\/wp\/v2\/pages\/82\/revisions"}],"predecessor-version":[{"id":83,"href":"https:\/\/mpzsoftware.com\/index.php?rest_route=\/wp\/v2\/pages\/82\/revisions\/83"}],"up":[{"embeddable":true,"href":"https:\/\/mpzsoftware.com\/index.php?rest_route=\/wp\/v2\/pages\/37"}],"wp:attachment":[{"href":"https:\/\/mpzsoftware.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=82"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}