|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/complete-mysql-training-for-data-analysis-on-linux/
课程评论：没有评论
课程名称：完整的MySQL数据库管理员课程 课程概述： MySQL服务器是全球最受欢迎且免费的数据库之一，作为IT的核心，它用于存储所有重要数据和信息。MySQL是一个关系型数据库管理系统（RDBMS），由Oracle开发、支持和分发，但因其开源特性，任何人均可免费使用。MySQL数据库以表的形式存储数据，具有速度快、占用资源少的特点，能在桌面或笔记本电脑上与其他应用程序并行运行，并能通过专用设备充分利用CPU和内存资源。若您希望成为SQL数据库管理的专家，这门课程将为您提供所需的全部技能。 课程大纲： - 第一部分：数据库基础 - RDBMS的定义 - SQL简介 - 前5大RDBMS - MySQL服务器介绍及不同版本 - 第二部分：MySQL服务器先决条件 - 实验设计 - 虚拟化概念 - 下载和安装VMWare Workstation Player和Oracle VirtualBox - 创建虚拟机及Linux服务器安装与管理 - 第三部分：Linux中的重要知识 - Linux导航命令 - root用户及目录列表 - 文件和目录创建、权限管理和密码更改 - 用户账号管理、进程监控和系统更新 - 第四部分：MySQL和云计算 - MySQL安装与配置 - MySQL Workbench的安装与样本数据恢复 - 第五部分：数据和数据库基础 - 数据存储与MySQL中的数据保存 - 表、列、行及各种键的定义 - 事务及ACID特性 - 数据库规范化及创建数据库 - 第六部分：SQL语句及类型 - DML、DDL、DCL和TCL语句示例 - 第七部分：表的创建与选择语句 - 各类连接（JOIN）及子查询 - 数据导入导出、存储过程及视图、索引等概念 - 第八部分：MySQL架构概述 - MySQL程序及配置文件管理 - 第九部分：MySQL备份 - 备份类型、加密、还原测试及相关工具的使用 - 第十部分：MySQL安全性 - 用户创建和权限控制 - 第十一部分：MySQL性能监控 - 查询日志、配置优化及性能调优提示 - 第十二部分：MySQL复制 - 复制方法、同步类型及设置演示 该课程全面涵盖MySQL数据库管理所需的知识与技能，适合希望深入学习数据库管理的人员。
MySQL Server continues to be one of the world's most popular, FREE and top databases. Database is a heart of IT which is needed to stored all critical data and information. MySQL is a DBMS, or database management system. It is developed, supported and distributed by Oracle, but since it is open-source it is freely available to anyone. MySQL databases are relational, meaning that the data is split up between tables. MySQL is very fast and lightweight so you can run it alongside your other applications on a desktop or laptop. It can also be scaled up to take advantage of all the CPU power and memory available on a dedicated machineIf you want to become an expert in SQL database administration then this is the course for YOU.This training course will provide you all the necessary skills you need to be a successful database administrator.Here is the course outline:Course SyllabusSection 1:Introduction to DatabaseRDBMSWhat is SQL?Top 5 RDBMSIntroduction to MySQL ServerDifferent editions of MySQLSection 2:MySQL Server pre-requisiteLab designWhat is virtualization?Download and Install VMWare Workstation PlayerOptional - Download and Install Oracle VirtualBoxCreate a Virtual MachineDownload and Install Linux ServerVirtual Machine ManagementSection 3:Important things to remember in LinuxLinux navigation commandsWhat is root?Directory listing attributesLinux command syntaxCreating files and directories and its permissionsChanging passwordHelp commandsAdding text to filesPipes ()File maintenance commandsFile display commandsLinux file editorUser account management and sudo accessProcess monitor commandsCrontabLinux network files and commandsSecure copy (SCP)System updates and repos (rpm and yum).Section 4:Forks of MySQL and Cloud ComputingMySQL installationDownload, Install and Configure MySQLInstall MySQL WorkbenchDownload and restore sample Sakila DBQuizSection 5:What is Data and Database and RDBMS?How is data stored?How is data saved in MySQL (Linux)MySQL Storage engine and TypesWhat is a Table, COLUMN and ROW ?What is a Key?What is Primary Key, Foreign Key, Unique Key etc.What is a Transaction and ACID properties?Database Normalization AND its different formsCreate your first Database, Table and Populate table with dataQuizSection 6:SQL Statement and TypesDML Statement with examplesDDL Statements with examplesDCL Statements with examplesTCL Statements with examplesQuizSection 7:Create TABLE(s) and Temp Table(s)SELECT Statement in detailOperators, Expressions and ConditionsWHERE Clause, ORDER BY, HAVING BY, GROUP BY ClauseSelect from two tables - JOINS and different Types of JOINSWhat is a Sub Query?INSERT, UPDATE, and DELETE statementsLoad data from a CSV file to MySQL and vice versaStored procedureWhat is view, function, trigger and indexClustered, non-clustered Indexes and Index Design considerationsINDEX Cardinality, Table Fragmentation, USE INDEX, FORCE INDEX and LABQuizSection 8:MySQL Architecture OverviewMySQL Programs and invocationSpecifying Program Options and Option FilesHow to edit the configuration file (.cnf)Options scopeWhat options are in affect?QuizSection 9:MySQL Backups, why we need backup, RTO and RPOType of Backups in MySQL, offsite storage, encryption and restore testingBinary logsThe mysqldump utilityRestore of database using mysql and WorkbenchTable level Backup and RestorePoint In Time Recovery in MySQLXtraBackup Utility by Percona, Functionality and InstallationFull Backup and Restore using Percona XtraBackupLab for mysqldump and Backups using MySQL WorkbenchIncremental Backup and Restore using Percona XtraBackupSchedule backups (cronjobs)QuizSection 10:Understanding MySQL SecurityRoot User in MySQLCREATE USER and ALTER USER StatementCreate New User (MySQL Workbench)MySQL Privileges , Privileges Control and Some important Privileges in MySQLGRANT Statement , WITH GRANT Option and Granting Privileges to MySQL UserGRANT Tables and Checking PrivilegesREVOKE Statement and Revoking PrivilegesDROP USER StatementRoles in MySQLQuizSection 11:MySQL Server Performance Monitoring BasicsThe General Query LogThe Slow Query LogThe Error LogOptimizing configuration for MySQL performanceDB Engine StatusQuery Optimization TIPS, EXPLAIN Statement and Execution PlansQuery Optimization DemoQuizSection 12:MySQL Replication and its AdvantagesMySQL Replication MethodsSynchronization TypesReplication FormatsMySQL Replication Setup DemoQuiz
