وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Becoming a Production MySQL DBA

سرفصل های دوره

An awesome journey towards world's most popular open source database to become a Production MySQL DBA.


1 - Introduction
  • 1 - Course Introduction
  • 2 - Why MySQL
  • 2 - mariadb enterprise open source database.zip
  • 2 - official website of mysql server.zip
  • 2 - percona the database performance experts.zip
  • 3 - Meet Bob The Future DBA
  • 4 - COURSE.zip
  • 4 - Download Course Slides.html

  • 2 - MySQL Server Installation
  • 5 - Installing MySQL Server Community Edition
  • 5 - mysql community edition installation.zip
  • 6 - Installing MariaDB Database Server
  • 6 - mariadb-installation.zip
  • 7 - Installing Percona Server for MySQL Server
  • 7 - percona mysql installation.zip
  • 7 - percona-installation.zip
  • 8 - Removing MySQL
  • 8 - remove mysql.zip
  • 9 - Installing Specific Version of MySQL
  • 9 - customized-installation.zip
  • 10 - Demo Installing Specific Version of MySQL
  • 10 - installing specific version of mysql.zip
  • 11 - Manually Download RPMs and Locally Install
  • 11 - manually download rpms.zip
  • 12 - Demo Manually Download RPMs and Locally Install
  • 13 - Performing MySQL Secure Installation
  • 14 - Demo Performing MySQL Secure Installation
  • 14 - mysqlsecureinstallation.zip
  • 15 - Linux Utilities
  • 16 - Demo Linux Utilities
  • 16 - linuxutilities.zip
  • 17 - Section Recap What Bob has learned so for

  • 3 - Exploring MySQL Server
  • 18 - MySQL Architecture
  • 19 - MySQL Installed File Locations
  • 20 - Demo MySQL Installed File Locations
  • 21 - MySQL Executable Programs
  • 22 - MySQL Service under SystemD
  • 23 - MySQL Shell Commands
  • 24 - Demo MySQL Shell Commands
  • 25 - MySQL Socket File
  • 26 - Demo MySQL Socket File
  • 27 - MySQL GLOBAL Variables
  • 28 - Demo Global Variables
  • 29 - MySQL SESSION Variables
  • 30 - Demo MySQL SESSION Variables
  • 31 - Getting System Variables Help
  • 31 - system variables.zip
  • 32 - MySQL SHOW Command
  • 33 - Demo MySQL SHOW Command
  • 34 - MySQL System Databases
  • 35 - Demo MySQL System Databases
  • 36 - MySQL Local vs Remote Connections
  • 37 - Demo MySQL Local vs Remote Connections
  • 38 - MySQL Shell
  • 38 - mysql shell.zip
  • 39 - Section Recap What Bob has learned

  • 4 - Basic MySQL Database Administration
  • 40 - Storing MySQL Authentication Credentials
  • 41 - Assignment Login to MySQL Without Credentials
  • 41 - mysqlconfigeditor.zip
  • 42 - mysqladmin MySQL Administration Program
  • 43 - Assignment Perform DBA tasks with mysqladmin
  • 43 - mysqladmin.zip
  • 44 - Executing SQL Files
  • 45 - Assignment Execute employeessql SQL File
  • 45 - execute sql file.zip
  • 46 - Importing data with mysqlimport
  • 47 - Assignment Import stafftxt file
  • 47 - mysqlimport.zip
  • 47 - staff.zip
  • 48 - Maintaining Integrity with mysqlcheck
  • 49 - Assignment Perform mysqlcheck on staff table
  • 49 - mysqlcheck.zip
  • 50 - Displaying useful Information with mysqlshow
  • 51 - Assignment Get Report on employees database and its tables
  • 51 - mysqlshow.zip
  • 52 - Time Zone Tables
  • 53 - Assignment Load Time Zone Tables into MySQL
  • 53 - timezone.zip
  • 54 - MySQL Example Databases
  • 55 - Assignment Download World Database
  • 55 - worlddb.zip
  • 56 - Listing Binary Logs Events with mysqlbinlog
  • 57 - Assignment Investigate When Database was dropped
  • 58 - Section Recap What Bob has learned

  • 5 - MySQL Storage Engines
  • 59 - Storage Engines
  • 59 - storage engines.zip
  • 60 - Exploring Storage Engines
  • 61 - FEDERATED Storage Engine
  • 62 - MEMORY Storage Engine
  • 63 - Assignment MEMORY Storage Engine
  • 63 - memory engine demo.zip
  • 64 - BLACKHOLE Storage Engine
  • 65 - Assignment BLACKHOLE Storage Engine
  • 66 - CSV Storage Engine
  • 67 - Assignment CSV Storage Engine
  • 68 - MyISAM Storage Engine
  • 69 - Assignment MyISAM Storage Engine
  • 70 - ARCHIVE Storage Engine
  • 71 - Assignment ARCHIVE Storage Engine
  • 72 - InnoDB Storage Engine
  • 73 - Assignment InnoDB Storage Engine
  • 74 - Checking Storage Engine Status
  • 75 - Switching Storage Engine
  • 76 - Installing New Storage Engine
  • 77 - Disabling Storage Engine
  • 78 - Section Recap What Bob has learned

  • 6 - MySQL User Administration
  • 79 - DBA Account
  • 80 - MySQL Permissions
  • 81 - WITH GRANT OPTION
  • 82 - Assignment Create DBA Account
  • 82 - createdbauser.zip
  • 83 - Connecting to MySQL
  • 83 - mysqlsh.zip
  • 84 - Exploring MySQL Workbench
  • 85 - Creating Regular MySQL Users
  • 86 - Grant Permissions
  • 87 - LockUnlock MySQL Account
  • 88 - mysqlnativepassword cachingsha2password auth plugins
  • 89 - MySQL Roles
  • 90 - Assignment MySQL Roles
  • 90 - mysql roles.zip
  • 91 - Section Recap What Bob has learned

  • 7 - MySQL Server Configuration
  • 92 - MySQL Default Configuration File
  • 92 - mycnf.zip
  • 93 - Assignment Locate Default Option File
  • 93 - mysql configuration.zip
  • 94 - MySQL OptionConfiguration File Syntax
  • 95 - Assignment ReWrite Default Option File
  • 96 - Variable or Option in Option File
  • 97 - Changing Default Option Files Location
  • 97 - mysql configuration.zip
  • 98 - Assignment Change Default Location of Option File
  • 99 - STRACE LSOF With MySQL
  • 100 - Demo STRACE LSOF
  • 100 - strace.zip
  • 101 - Option File Inclusions
  • 101 - modified-cnf-file.zip
  • 102 - Assignment Option File Inclusions
  • 103 - DATADIR MySQL Data Directory
  • 104 - Assignment Move DATA DIRECTORY
  • 104 - data directory.zip
  • 105 - Binary Log Files
  • 106 - Purging Binary Log Files
  • 107 - Assignment Disable Binary Logging
  • 107 - binary-logs-location.zip
  • 108 - Assignment Enable Binary Logging
  • 109 - Binary Logs Retention
  • 110 - MySQL Error Log File
  • 111 - Assignment Change MySQL Error Log File Location
  • 112 - Adjusting Timestamp of MySQL Error Log File
  • 113 - MySQL TEMP Directory
  • 114 - Assignment Change TMPDIR Location
  • 115 - Removing DoubleEntry for MySQL Error Log File
  • 116 - Section Recap What Bob has learned

  • 8 - InnoDB Storage Engine Configuration
  • 117 - InnoDB Storage Engine
  • 118 - InnoDB Architecture
  • 119 - InnoDB Buffer Pool
  • 120 - Demo InnoDB Buffer Pool
  • 121 - InnoDB Log Buffer
  • 122 - Assignment InnoDB Log Buffer
  • 123 - InnoDB Flush Method
  • 124 - ODIRECT OR ODIRECTNOFSYNC
  • 125 - Assignment Change InnoDB Flush Method
  • 126 - Doublewrite Buffer
  • 127 - Assignment Doublewrite Buffer
  • 128 - Flushing Logs at Transaction Commit
  • 129 - Assignment Setting value of innodbflushlogattrxcommit
  • 130 - InnoDB Redo Log Files
  • 131 - Assignment 1 InnoDB Redo Log Files
  • 131 - innodb redo log files.zip
  • 132 - Assignment 2 InnoDB Redo Log Files
  • 132 - innodb redo log files.zip
  • 133 - Assignment 3 InnoDB Redo Log Files
  • 133 - redo log files.zip
  • 134 - System Tablespace
  • 135 - Assignment System Tablespace
  • 135 - system tablespace.zip
  • 136 - Undo Tablespaces
  • 137 - Demo Undo Tablespaces
  • 137 - undo tablespaces.zip
  • 138 - Temporary Tablespaces
  • 139 - General Tablespaces
  • 140 - FilePerTable Tablespaces
  • 141 - Dedicated MySQL Server
  • 142 - Turning Dedicated Server ON
  • 143 - Overriding Dedicated Server Settings
  • 144 - Section Recap What Bob has learned

  • 9 - MySQL Backup Restore
  • 145 - MySQL Backups
  • 146 - PhysicalCold Backup
  • 147 - Assignment Perform PhysicalCold Backup
  • 148 - Assignment Restore From PhysicalCold Backup
  • 149 - Files needed for Cold Backup
  • 150 - Logical Backups
  • 151 - MySQLDUMP Backup Program
  • 152 - Assignment Take Backup with MySQLDUMP
  • 153 - Restoring from MySQLDUMP
  • 154 - MySQLPUMP Backup Program
  • 155 - Demo 1 MySQLPUMP
  • 156 - Demo 2 MySQLPUMP
  • 157 - Assignment Backing Up MySQL Accounts
  • 158 - Assignment Restore MySQL Account
  • 159 - Compressing MySQL Backups
  • 160 - Assignment Compress MySQL Backup
  • 161 - Assignment Restore MySQL Compressed Backup
  • 162 - Creating Consistent Data Dump
  • 163 - CREATE TABLE LIKE SQL Statement
  • 164 - MySQL Hot Backup
  • 165 - MySQL Hot Backup Tools
  • 166 - XtraBackup Hot Backup Tool
  • 166 - install xtrabackup.zip
  • 166 - xtrabackup.zip
  • 167 - Assignment Download Install XtraBackup
  • 168 - Assignment Backup with XtraBackup
  • 169 - Assignment XtraBackup Backup Files
  • 170 - Preparing Hot Backup Restore
  • 171 - Assignment Restore From Hot Backup
  • 171 - restore xtrabackup.zip
  • 172 - Section Recap What Bob has learned

  • 10 - MySQL Server Replication
  • 173 - Replication Concepts
  • 174 - Replication Methods
  • 175 - Replication Formats
  • 176 - Replication Formats Comparison
  • 177 - General Replication Setup Requirements
  • 178 - Primary Server
  • 179 - Assignment Configure Primary Server
  • 180 - Cleanup Options from Option File
  • 181 - Demo 1 Install MySQL On Replica Server
  • 182 - Demo 2 Install MySQL On Replication Server
  • 183 - Start MySQL on Replica
  • 184 - Hot Backup on Primary for Replication
  • 185 - Copy Hot Backup from Primary to Replica
  • 186 - Restore Hot Backup on Replica
  • 187 - Replica Server Configuration
  • 188 - Assignment Configure Replica
  • 189 - Configure Binary Log Position Based Replication
  • 190 - Assignment Configure Binary Log Replication
  • 191 - Set Report Host on Replica
  • 192 - SHOW REPLICA STATUS
  • 193 - Demo Replica IOTHREAD
  • 194 - Demo Replica SQLTHREAD
  • 195 - Demo Ignore Database
  • 196 - Demo Ignore Table
  • 197 - Cleanup Traditional Replication
  • 198 - Setting up GTID Replication
  • 198 - setting-up-gtid-replication.zip
  • 199 - GTID Replication Requirements
  • 200 - Prepare GTID Replication
  • 201 - Assignment Setup GTID Replication
  • 202 - Start Replica Until Command
  • 203 - Demo Start Replica with Until
  • 204 - Primary Replica Failover
  • 205 - Prepare Primary Replica Failover
  • 206 - Assignment Failover Primary to Replica
  • 207 - Assignment Configure Old Primary to Replica
  • 208 - Section Recap What Bob has learned

  • 11 - Upgrading MySQL Server
  • 209 - Types of MySQL Version Upgrades
  • 210 - Preparing for Minor Version Upgrade
  • 211 - Assignment Perform Minor Version Upgrade
  • 211 - mysql minor upgrade.zip
  • 212 - Demo Primary Replica Version Compatibility
  • 213 - Installing MySQL 57
  • 213 - install mysql 57.zip
  • 214 - Download World Example Database
  • 215 - mysqlcheck PreUpgrade Check
  • 216 - mysqlsh script PreUpgrade Check
  • 217 - Demo Perform MySQL Major Version Upgrade
  • 218 - Section Recap What Bob has learned

  • 12 - Docker and MySQL
  • 219 - Introduction
  • 220 - Install Docker
  • 220 - install docker.zip
  • 221 - Pull Inspect MySQL Docker Image
  • 221 - search mysql image.zip
  • 222 - Run MySQL as Container
  • 223 - MySQL Container Logs
  • 224 - MySQL Container Host
  • 225 - Removing MySQL Container
  • 226 - Exposing Port From Container to Host
  • 226 - exposing container port.zip
  • 227 - Create DBA User Bob
  • 228 - Remotely Login to MySQL Container
  • 229 - Demo Data Loss at Container Removal
  • 230 - Bind Volume For Data Persistence
  • 231 - Demo Persistant Volume
  • 232 - Section Recap What Bob has learned

  • 13 - DBA Tips Tricks Club
  • 233 - Welcome to the DBA Club
  • 234 - DBA Tip Customizing MySQL Prompt
  • 235 - Demo Customizing MySQL Prompt

  • 14 - Course Completion
  • 236 - Thank You Goodbye
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    شناسه: 5618
    حجم: 6189 مگابایت
    مدت زمان: 900 دقیقه
    تاریخ انتشار: 20 بهمن 1401
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید