17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Complete MySQL DBA Training On Linux
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
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 machine
If 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 Syllabus
Section 1:
Introduction to Database RDBMS What is SQL? Top 5 RDBMS Introduction to MySQL Server Different editions of MySQL
Section 2:
MySQL Server pre-requisite Lab design What is virtualization? Download and Install VMWare Workstation Player Optional – Download and Install Oracle VirtualBox Create a Virtual Machine Download and Install Linux Server Virtual Machine Management
Section 3:
Important things to remember in Linux Linux navigation commands What is root? Directory listing attributes Linux command syntax Creating files and directories and its permissions Changing password Help commands Adding text to files Pipes (|) File maintenance commands File display commands Linux file editor User account management and sudo access Process monitor commands Crontab Linux network files and commands Secure copy (SCP) System updates and repos (rpm and yum).
Section 4:
Forks of MySQL and Cloud Computing MySQL installation Download, Install and Configure MySQL Install MySQL Workbench Download and restore sample Sakila DB Quiz
Section 5:
What is Data and Database and RDBMS? How is data stored? How is data saved in MySQL (Linux) MySQL Storage engine and Types What 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 forms Create your first Database, Table and Populate table with data Quiz
Section 6:
SQL Statement and Types DML Statement with examples DDL Statements with examples DCL Statements with examples TCL Statements with examples Quiz
Section 7:
Create TABLE(s) and Temp Table(s) SELECT Statement in detail Operators, Expressions and Conditions WHERE Clause, ORDER BY, HAVING BY, GROUP BY Clause Select from two tables – JOINS and different Types of JOINS What is a Sub Query? INSERT, UPDATE, and DELETE statements Load data from a CSV file to MySQL and vice versa Stored procedure What is view, function, trigger and index Clustered, non-clustered Indexes and Index Design considerations INDEX Cardinality, Table Fragmentation, USE INDEX, FORCE INDEX and LAB Quiz
Section 8:
MySQL Architecture Overview MySQL Programs and invocation Specifying Program Options and Option Files How to edit the configuration file (.cnf) Options scope What options are in affect? Quiz
Section 9:
MySQL Backups, why we need backup, RTO and RPO Type of Backups in MySQL, offsite storage, encryption and restore testing Binary logs The mysqldump utility Restore of database using mysql and Workbench Table level Backup and Restore Point In Time Recovery in MySQL XtraBackup Utility by Percona, Functionality and Installation Full Backup and Restore using Percona XtraBackup Lab for mysqldump and Backups using MySQL Workbench Incremental Backup and Restore using Percona XtraBackup Schedule backups (cronjobs) Quiz
Section 10:
Understanding MySQL Security Root User in MySQL CREATE USER and ALTER USER Statement Create New User (MySQL Workbench) MySQL Privileges , Privileges Control and Some important Privileges in MySQL GRANT Statement , WITH GRANT Option and Granting Privileges to MySQL User GRANT Tables and Checking Privileges REVOKE Statement and Revoking Privileges DROP USER Statement Roles in MySQL Quiz
Section 11:
MySQL Server Performance Monitoring Basics The General Query Log The Slow Query Log The Error Log Optimizing configuration for MySQL performance DB Engine Status Query Optimization TIPS, EXPLAIN Statement and Execution Plans Query Optimization Demo Quiz
Section 12:
MySQL Replication and its Advantages MySQL Replication Methods Synchronization Types Replication Formats MySQL Replication Setup Demo Quiz
Who this course is for:
Anyone who wants to start a career in SQL database administration Anyone who wants to have complete SQL database training to get a job in IT Anyone who wants to advance his/her career Anyone who wants to master the SQL command line skills College students IT professionals, teachers and instructors
Requirements
Positive attitude and desire to learn Passion to become SQL database administrator A PC or MAC with at least 4-8 GB of RAM
Last Updated 7/2022
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
.pad/0
18 B
.pad/1
52 B
TutsNode.com.txt
63 B
[TutsNode.net] - Complete MySQL DBA Training on Linux/1 - Introduction/2 - CourseSyllabusMySQL.pdf
117.3 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/1 - Introduction/6 - Top 5 RDBMS using SQL English.vtt
4 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/1 - Introduction/8 - Editions of MySQL Server English.vtt
2.8 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/10 - Users and Privileges Management/104 - Understanding MySQL Security English.vtt
21.3 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/10 - Users and Privileges Management/105 - Root User in MySQL English.vtt
11.1 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/10 - Users and Privileges Management/106 - CREATE USER and ALTER USER Statement English.vtt
29.7 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/10 - Users and Privileges Management/107 - Create New User MySQL Workbench English.vtt
5.9 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/10 - Users and Privileges Management/108 - MySQL Privileges Privileges Control and Some important Privileges in MySQL English.vtt
18.5 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/10 - Users and Privileges Management/109 - GRANT Statement WITH GRANT Option and Granting Privileges to MySQL User English.vtt
32 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/10 - Users and Privileges Management/110 - GRANT Tables and Checking Privileges English.vtt
16.6 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/10 - Users and Privileges Management/111 - REVOKE Statement and Revoking Privileges English.vtt
14.5 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/10 - Users and Privileges Management/112 - DROP USER Statement English.vtt
9.8 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/10 - Users and Privileges Management/113 - Roles in MySQL English.vtt
30.2 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/10 - Users and Privileges Management/7 - Quiz Users and Privileges Management.html
0 B
[TutsNode.net] - Complete MySQL DBA Training on Linux/11 - Monitoring MySQL Server/115 - MySQL Server Performance Monitoring Basics English.vtt
20 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/11 - Monitoring MySQL Server/116 - The General Query Log English.vtt
17.9 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/11 - Monitoring MySQL Server/117 - The Slow Query Log English.vtt
21.5 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/11 - Monitoring MySQL Server/118 - The Error Log English.vtt
10.4 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/11 - Monitoring MySQL Server/119 - Optimizing mycnf for MySQL performance English.vtt
28.3 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/11 - Monitoring MySQL Server/120 - InnoDB Engine Status English.vtt
11.4 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/11 - Monitoring MySQL Server/121 - Query Optimization TIPS EXPLAIN Statement and Execution Plans English.vtt
22.3 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/11 - Monitoring MySQL Server/122 - Query Optimization Demo English.vtt
12.5 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/12 - MySQL Replication/124 - MySQL Replication and Its Advantages English.vtt
14.1 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/12 - MySQL Replication/125 - MySQL Replication Methods Synchronization Types and Replication Formats English.vtt
18 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/12 - MySQL Replication/126 - MySQL Replication Setup Demo English.vtt
41 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/12 - MySQL Replication/127 - Congratulations English.vtt
8 B
[TutsNode.net] - Complete MySQL DBA Training on Linux/2 - Lab design and setup/11 - Lab design English.vtt
2 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/2 - Lab design and setup/16 - Download and Install Linux server English.vtt
11 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/2 - Lab design and setup/9 - Welcome to the lab design and setup English.vtt
8 B
[TutsNode.net] - Complete MySQL DBA Training on Linux/2 - Lab design and setup/9 - Welcome to the lab design and setup.mp4
277.3 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/3 - Linux Basics for a DB Administrator/19 - Important Things to Remember in Linux English.vtt
2.6 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/3 - Linux Basics for a DB Administrator/20 - Linux navigation commands cd pwd and ls English.vtt
11.5 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/3 - Linux Basics for a DB Administrator/21 - What is root English.vtt
2.4 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/3 - Linux Basics for a DB Administrator/22 - Directory Listing Attributes English.vtt
2.9 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/3 - Linux Basics for a DB Administrator/26 - Files and Directory Permissions chmod English.vtt
13 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/3 - Linux Basics for a DB Administrator/28 - Adding Text to Files English.vtt
12.2 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/3 - Linux Basics for a DB Administrator/30 - File Maintenance Commands cp rm mv mkdir rmdir English.vtt
13 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/3 - Linux Basics for a DB Administrator/32 - Linux File Editor vi English.vtt
14 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/3 - Linux Basics for a DB Administrator/33 - User Account Management useradd groupadd usermod userdel groupdel English.vtt
14 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/3 - Linux Basics for a DB Administrator/35 - Process monitor commands ps and top English.vtt
18.3 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/3 - Linux Basics for a DB Administrator/39 - System Updates and Repos rpm yum English.vtt
11.8 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/4 - Download Install and Configure MySQL/1 - Quiz Download Install and Configure MySQL.html
0 B
[TutsNode.net] - Complete MySQL DBA Training on Linux/4 - Download Install and Configure MySQL/40 - Weclome To Download Install and Configure MySQL Section English.vtt
1.7 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/4 - Download Install and Configure MySQL/41 - Brief History Forks of MySQL and Cloud Computing English.vtt
11.2 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/4 - Download Install and Configure MySQL/42 - MySQL installation steps prereq distribution versions etc English.vtt
22.3 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/4 - Download Install and Configure MySQL/43 - Download Install and Configure MySQL English.vtt
27.1 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/4 - Download Install and Configure MySQL/44 - Install MySQL Workbench English.vtt
35.2 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/4 - Download Install and Configure MySQL/44 - Install MySQL Workbench.mp4
269.5 MB
[TutsNode.net] - Complete MySQL DBA Training on Linux/4 - Download Install and Configure MySQL/45 - Download and restore sample Sakila DB English.vtt
17.1 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/5 - Database Fundamentals and Design/2 - Quiz Database Fundamentals and Design.html
0 B
[TutsNode.net] - Complete MySQL DBA Training on Linux/5 - Database Fundamentals and Design/46 - Welcome To Database Fundamentals and Design Section English.vtt
1.6 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/5 - Database Fundamentals and Design/51 - How is Data Saved in MySQL linux English.vtt
10 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/5 - Database Fundamentals and Design/52 - MySQL Storage engine and Types English.vtt
10.7 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/5 - Database Fundamentals and Design/55 - What is Primary Key Foreign Key Unique Key etc English.vtt
13.2 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/5 - Database Fundamentals and Design/56 - What is a Transaction and ACID properties English.vtt
15.1 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/5 - Database Fundamentals and Design/57 - Database Normalization AND Different forms of Database Normalization English.vtt
14.1 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/5 - Database Fundamentals and Design/58 - Create your first Database Table and Populate table with data English.vtt
21.8 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/6 - Introduction to SQL Commands/3 - Quiz Introduction to SQL Commands.html
0 B
[TutsNode.net] - Complete MySQL DBA Training on Linux/6 - Introduction to SQL Commands/64 - TCL Statement with examples English.vtt
13.3 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/7 - Query and Data Manipulation/4 - Quiz Query and Data Manipulation.html
0 B
[TutsNode.net] - Complete MySQL DBA Training on Linux/7 - Query and Data Manipulation/66 - Create TABLEs and Temp Tables English.vtt
38 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/7 - Query and Data Manipulation/66 - Create TABLEs and Temp Tables.mp4
288 MB
[TutsNode.net] - Complete MySQL DBA Training on Linux/7 - Query and Data Manipulation/69 - WHERE Clause ORDER BY Clause HAVING By Clause GROUP BY Clause English.vtt
26.1 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/7 - Query and Data Manipulation/71 - Different Types of JOINS English.vtt
24.2 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/7 - Query and Data Manipulation/72 - What is a Sub Query English.vtt
12.4 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/7 - Query and Data Manipulation/73 - INSERT Statement in detail English.vtt
14 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/7 - Query and Data Manipulation/74 - Load Data from a CSV file to MySQL English.vtt
19.1 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/7 - Query and Data Manipulation/76 - UPDATE Statement in detail English.vtt
20.7 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/7 - Query and Data Manipulation/77 - DELETE Statement in detail English.vtt
12.9 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/7 - Query and Data Manipulation/78 - What is a Stored Procedure English.vtt
28.4 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/7 - Query and Data Manipulation/79 - What Is a View English.vtt
11 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/7 - Query and Data Manipulation/80 - What is a Function English.vtt
20.2 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/7 - Query and Data Manipulation/81 - What is a Trigger English.vtt
22 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/7 - Query and Data Manipulation/82 - What is an INDEX English.vtt
10.1 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/7 - Query and Data Manipulation/83 - Clustered NonClustered Indexes and Index Design considerations English.vtt
14.8 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/7 - Query and Data Manipulation/84 - INDEX Cardinality Table Fragmentation USE INDEX FORCE INDEX and LAB English.vtt
37.4 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/7 - Query and Data Manipulation/84 - INDEX Cardinality Table Fragmentation USE INDEX FORCE INDEX and LAB.mp4
266.1 MB
[TutsNode.net] - Complete MySQL DBA Training on Linux/8 - MySQL Architecture and Option Files/5 - Quiz MySQL Architecture and Option Files.html
0 B
[TutsNode.net] - Complete MySQL DBA Training on Linux/8 - MySQL Architecture and Option Files/86 - MySQL Architecture Overview English.vtt
12.7 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/8 - MySQL Architecture and Option Files/87 - MySQL Programs and invocation Specifying Program Options and Option Files English.vtt
19.5 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/8 - MySQL Architecture and Option Files/88 - mycnf file and How to edit mycnf LAB English.vtt
11.4 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/8 - MySQL Architecture and Option Files/89 - Options Scope and What options are in affect English.vtt
10.3 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/9 - MySQL Backups and Recovery/100 - Lab for mysqldump and Backups using MySQL Workbench English.vtt
32.5 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/9 - MySQL Backups and Recovery/101 - Incremental Backup and Restore using Percona XtraBackup English.vtt
19 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/9 - MySQL Backups and Recovery/102 - Schedule backups cronjobs English.vtt
10.6 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/9 - MySQL Backups and Recovery/6 - Quiz MySQL Backups and Restore.html
0 B
[TutsNode.net] - Complete MySQL DBA Training on Linux/9 - MySQL Backups and Recovery/91 - MySQL Backups why we need backup RTO and RPO English.vtt
10.1 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/9 - MySQL Backups and Recovery/92 - Type of Backups in MySQL Offsite Storage Encryption and Restore Testing English.vtt
25.9 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/9 - MySQL Backups and Recovery/93 - Binary Logs English.vtt
18.7 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/9 - MySQL Backups and Recovery/94 - The mysqldump Utility English.vtt
17 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/9 - MySQL Backups and Recovery/95 - Restore of database using mysql and Workbench English.vtt
24.3 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/9 - MySQL Backups and Recovery/96 - Table level Backup and Restore English.vtt
21.1 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/9 - MySQL Backups and Recovery/97 - Point In Time Recovery in MySQL and Lab English.vtt
15.7 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/9 - MySQL Backups and Recovery/98 - XtraBackup Utility by Percona Functionality and Installation English.vtt
19 KB
[TutsNode.net] - Complete MySQL DBA Training on Linux/9 - MySQL Backups and Recovery/99 - Full Backup and Restore using Percona Xtrabackup English.vtt
