Master MySQL: Advanced Database Administration Pro
Focused View
7:51:27
01 - Course structure and outline.mp4
01:51
02 - Introducing the course project.mp4
02:08
03 - Setting expectations.mp4
03:06
01 - Prerequisite skills review.mp4
03:06
01 - MySQL installation overview.mp4
01:45
02 - Mac download Community Server.mp4
04:53
03 - Mac download MySQL Workbench.mp4
02:50
04 - PC Download Community Server plus Workbench.mp4
07:39
05 - Connecting Workbench to the server.mp4
02:11
06 - MySQL Workbench interface.mp4
10:42
07 - Preparing Workbench.mp4
04:41
01 - Overview of create, insert, and delete.mp4
01:48
02 - Review Creating a schema.mp4
03:24
03 - Review Creating a table.mp4
07:07
04 - Review Inserting records into a table.mp4
10:19
05 - Review Deleting records.mp4
10:40
06 - Importing data from a file.mp4
10:21
07 - Challenge Importing order item data.mp4
01:11
08 - Solution Importing order item data.mp4
10:56
09 - Challenge Importing refund data.mp4
01:32
10 - Solution Importing refund data.mp4
05:01
11 - Challenge Deleting records.mp4
01:36
12 - Solution Deleting records.mp4
04:40
13 - Challenge Import remaining 2012 data.mp4
00:45
14 - Solution Import remaining 2012 data.mp4
05:37
15 - Bonus Load data.mp4
04:44
01 - Overview of alter, update, and key relationships.mp4
01:29
02 - Review Altering tables.mp4
05:24
03 - Review Updating records.mp4
07:55
04 - Review Table relationships and cardinality.mp4
04:55
05 - Challenge Introducing a new product.mp4
01:08
06 - Solution Introducing a new product.mp4
04:18
07 - Challenge Adding a product to order items.mp4
00:55
08 - Solution Adding a product to order items.mp4
01:45
09 - Challenge Updating product data in order items.mp4
01:19
10 - Solution Updating product data in order items.mp4
02:20
11 - Challenge Primary key to foreign key mapping.mp4
01:17
12 - Solution Primary key to foreign key mapping.mp4
04:17
13 - Challenge Import 2013 Q1 data.mp4
00:37
14 - Solution Import 2013 Q1 data.mp4
03:28
01 - Replication.mp4
11:29
02 - Backup and recovery.mp4
09:38
03 - Challenge Backup and recovery.mp4
01:11
04 - Solution Backup and recovery.mp4
04:00
01 - Challenge Mid-course project.mp4
02:09
02 - Solution Mid-course project.mp4
20:02
01 - Review Triggers basics.mp4
08:37
02 - Triggers deep dive.mp4
34:17
03 - Challenge Creating and updating orders.mp4
02:07
04 - Solution Creating and updating orders.mp4
06:35
05 - Challenge Triggers.mp4
02:19
06 - Solution Triggers.mp4
05:10
07 - Challenge Testing your trigger system.mp4
02:09
08 - Solution Testing your trigger system.mp4
04:04
01 - Views.mp4
10:00
02 - Challenge Creating website sessions.mp4
01:04
03 - Solution Creating website sessions.mp4
08:12
04 - Challenge Creating views.mp4
00:52
05 - Solution Creating views.mp4
05:00
01 - Review The EER diagram editor.mp4
19:58
02 - Reverse engineering EER diagrams.mp4
09:12
03 - Challenge The EER diagram editor.mp4
01:10
04 - Solution The EER diagram editor.mp4
05:25
01 - Stored procedures.mp4
20:50
02 - Scheduled events.mp4
09:32
03 - Challenge Stored procedures.mp4
01:46
04 - Solution Stored procedures.mp4
12:40
01 - Writing data from website activity.mp4
10:18
02 - Challenge Writing data from website activity.mp4
00:42
03 - Solution Writing data from website activity.mp4
02:50
04 - Challenge Importing website pageview data.mp4
00:37
05 - Solution Importing website pageview data.mp4
05:29
01 - Security threats.mp4
10:19
02 - Security best practices.mp4
07:56
03 - Challenge Database security.mp4
01:10
04 - Solution Database security.mp4
02:59
01 - Challenge Final project.mp4
02:40
02 - Solution Final project.mp4
41:19
More details
Course Overview
Take your MySQL skills to the next level with this advanced course covering database administration, replication, automation, and security. Learn through hands-on projects as you build and manage a complete database system from the ground up.
What You'll Learn
- Advanced DBA concepts including replication, backup, and recovery
- Automation using stored procedures, triggers, and scheduled events
- Database security best practices and threat mitigation
Who This Is For
- Database administrators looking to advance their MySQL skills
- BI professionals needing deeper database management capabilities
- Analysts transitioning into database administration roles
Key Benefits
- Hands-on learning through real-world database projects
- Master automation to save time on repetitive tasks
- Gain skills to ensure data security and disaster recovery
Curriculum Highlights
- MySQL setup and data import techniques
- Advanced table operations and key relationships
- Replication, backup, and recovery strategies
Focused display
Category
- language english
- Training sessions 78
- duration 7:51:27
- English subtitles has
- Release Date 2025/06/02
