Advanced MySQL Database Administration

Focused View

Maven Analytics and John Pauler

7:51:27

0 View

01 - Introduction

01 - Course structure and outline.mp4

01:51

02 - Introducing the course project.mp4

02:08

03 - Setting expectations.mp4

03:06

02 - 1. Prerequisite Skills

01 - Prerequisite skills review.mp4

03:06

03 - 2. MySQL Intro and Setup

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

04 - 3. Importing Data Files to the Database

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

05 - 4. Altering, Updating, and Mapping Keys

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

06 - 5. Replication, Backup, and Recovery

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

07 - 6. Mid-Course Project

01 - Challenge Mid-course project.mp4

02:09

02 - Solution Mid-course project.mp4

20:02

08 - 7. Trigger Automation

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

09 - 8. Creating Views

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

10 - 9. The EER Diagram Editor

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

11 - 10. Stored Procedures and Scheduled Events

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

12 - 11. Automating Data from Website Activity

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

13 - 12. Security

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

14 - 13. Final Project

01 - Challenge Final project.mp4

02:40

02 - Solution Final project.mp4

41:19

Description

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.

Note: This course was created by John Pauler and Maven Analytics. We are pleased to host this training in our library.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

Maven Analytics and John Pauler

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.