• views: 140
• date: 3 November 2024
• posted by: AD-TEAM

MySQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst and BI professional should have in the arsenal. In this course, take your database DBA skills to the next level and expand into advanced concepts like replication, backup, recovery, and security, along with automation tools like stored procedures, triggers, and scheduled events.

Instructor John Pauler starts by introducing the course structure, installing MySQL Community and Workbench, and reviewing key database administration (DBA) tasks. Learn about creating and editing schemas and tables, inserting and deleting records, and reviewing the key principles of normalized databases.

John then covers advanced DBA concepts like replication, backup and recovery, and how to leverage automation via stored procedures, triggers, and scheduled events.

Throughout the course, you'll be playing the role of lead DBA for a new firm, building out an entire database and populating tables from the ground up, just like you would in the real world.

More Info




   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.