وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Advanced MySQL Database Administration

سرفصل های دوره

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.


01 - Introduction
  • 01 - Course structure and outline
  • 02 - Introducing the course project
  • 03 - Setting expectations

  • 02 - 1. Prerequisite Skills
  • 01 - Prerequisite skills review

  • 03 - 2. MySQL Intro and Setup
  • 01 - MySQL installation overview
  • 02 - Mac download Community Server
  • 03 - Mac download MySQL Workbench
  • 04 - PC Download Community Server plus Workbench
  • 05 - Connecting Workbench to the server
  • 06 - MySQL Workbench interface
  • 07 - Preparing Workbench

  • 04 - 3. Importing Data Files to the Database
  • 01 - Overview of create, insert, and delete
  • 02 - Review Creating a schema
  • 03 - Review Creating a table
  • 04 - Review Inserting records into a table
  • 05 - Review Deleting records
  • 06 - Importing data from a file
  • 07 - Challenge Importing order item data
  • 08 - Solution Importing order item data
  • 09 - Challenge Importing refund data
  • 10 - Solution Importing refund data
  • 11 - Challenge Deleting records
  • 12 - Solution Deleting records
  • 13 - Challenge Import remaining 2012 data
  • 14 - Solution Import remaining 2012 data
  • 15 - Bonus Load data

  • 05 - 4. Altering, Updating, and Mapping Keys
  • 01 - Overview of alter, update, and key relationships
  • 02 - Review Altering tables
  • 03 - Review Updating records
  • 04 - Review Table relationships and cardinality
  • 05 - Challenge Introducing a new product
  • 06 - Solution Introducing a new product
  • 07 - Challenge Adding a product to order items
  • 08 - Solution Adding a product to order items
  • 09 - Challenge Updating product data in order items
  • 10 - Solution Updating product data in order items
  • 11 - Challenge Primary key to foreign key mapping
  • 12 - Solution Primary key to foreign key mapping
  • 13 - Challenge Import 2013 Q1 data
  • 14 - Solution Import 2013 Q1 data

  • 06 - 5. Replication, Backup, and Recovery
  • 01 - Replication
  • 02 - Backup and recovery
  • 03 - Challenge Backup and recovery
  • 04 - Solution Backup and recovery

  • 07 - 6. Mid-Course Project
  • 01 - Challenge Mid-course project
  • 02 - Solution Mid-course project

  • 08 - 7. Trigger Automation
  • 01 - Review Triggers basics
  • 02 - Triggers deep dive
  • 03 - Challenge Creating and updating orders
  • 04 - Solution Creating and updating orders
  • 05 - Challenge Triggers
  • 06 - Solution Triggers
  • 07 - Challenge Testing your trigger system
  • 08 - Solution Testing your trigger system

  • 09 - 8. Creating Views
  • 01 - Views
  • 02 - Challenge Creating website sessions
  • 03 - Solution Creating website sessions
  • 04 - Challenge Creating views
  • 05 - Solution Creating views

  • 10 - 9. The EER Diagram Editor
  • 01 - Review The EER diagram editor
  • 02 - Reverse engineering EER diagrams
  • 03 - Challenge The EER diagram editor
  • 04 - Solution The EER diagram editor

  • 11 - 10. Stored Procedures and Scheduled Events
  • 01 - Stored procedures
  • 02 - Scheduled events
  • 03 - Challenge Stored procedures
  • 04 - Solution Stored procedures

  • 12 - 11. Automating Data from Website Activity
  • 01 - Writing data from website activity
  • 02 - Challenge Writing data from website activity
  • 03 - Solution Writing data from website activity
  • 04 - Challenge Importing website pageview data
  • 05 - Solution Importing website pageview data

  • 13 - 12. Security
  • 01 - Security threats
  • 02 - Security best practices
  • 03 - Challenge Database security
  • 04 - Solution Database security

  • 14 - 13. Final Project
  • 01 - Challenge Final project
  • 02 - Solution Final project
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    شناسه: 42635
    حجم: 1135 مگابایت
    مدت زمان: 472 دقیقه
    تاریخ انتشار: ۱۵ اردیبهشت ۱۴۰۴
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید