Advanced SQL Database Administration with MySQL Workbench
5.0 /5- Offered byUDEMY
Advanced SQL Database Administration with MySQL Workbench at UDEMY Overview
Duration | 8 hours |
Total fee | ₹3,299 |
Mode of learning | Online |
Credential | Certificate |
Advanced SQL Database Administration with MySQL Workbench at UDEMY Highlights
- Certificate of completion
- 8 hours on-demand video
- 3 articles
- 6 downloadable resources
- Access on mobile and TV
- 30-Day Money-Back Guarantee
- Full Lifetime Access
Advanced SQL Database Administration with MySQL Workbench at UDEMY Course details
- For analysts or BI professionals looking to gain a deeper understanding of database management
- For DBAs who want to learn advanced database management & automation tools
- For anyone seeking to master one of the world's most popular database programming languages
- For students looking for a hands-on and project-based deep dive into database administration with MySQL
- Write SQL queries and use MySQL Workbench to create new databases from scratch
- Explore database security threats and practice techniques like replication, backup and recovery
- Leverage advanced automation tools like triggers, stored procedures, and scheduled events
- Create and modify EER diagrams to understand table structures and relationships
- Work through practical, real-world assignments and projects you won't find anywhere else
- Get LIFETIME access to resource files, quizzes, assignments, and expert support
- 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, learner will take your database administration skills to the next level, expanding into advanced concepts like replication, automation, and database security
- Throughout the course, learner will be playing the role of Lead Database Administrator for an e-commerce startup, and learn how to build and populate an entire database from the ground up using real-world projects and assignments
Advanced SQL Database Administration with MySQL Workbench at UDEMY Curriculum
Course Structure & Outline
READ ME: Important Notes for New Students
DOWNLOAD: Course Resources
Introducing The Course Project
Setting Expectations
Prerequisite Skills
Prerequisite Skills Review
Prerequisite Skills
MySQL Intro & Setup
MySQL Installation Overview
Mac Download - MySQL Community Server
Mac Download - MySQL Workbench
PC Download - Community Server & Workbench
Connecting Workbench to the Server
MySQL Workbench Interface
Preparing Workbench
Importing Data Files to the Database
Overview of Create, Insert & Delete
REVIEW: Creating a Schema
REVIEW: Creating a Table
REVIEW: Inserting Records into a Table
REVIEW: Deleting Records
Importing Data from a File
ASSIGNMENT: Importing Order Item Data
SOLUTION: Importing Order Item Data
ASSIGNMENT: Importing Refund Data
SOLUTION: Importing Refund Data
ASSIGNMENT: Deleting Records
SOLUTION: Deleting Records
ASSIGNMENT: Importing Remaining 2012 Data
SOLUTION: Importing Remaining 2012 Data
BONUS: Load Data
Importing Data Files to the Database
Altering, Updating & Mapping Keys
Overview of Alter, Update & Key Relationships
REVIEW: Altering Tables
REVIEW: Updating Records
REVIEW: Table Relationship & Cardinality
ASSIGNMENT: Introducing a New Product
SOLUTION: Introducing a New Product
ASSIGNMENT: Adding Product to Order Items
SOLUTION: Adding Product to Order Items
ASSIGNMENT: Updating Product Data in Order Items
SOLUTION: Updating Product Data in Order Items
ASSIGNMENT: Primary Key to Foreign Key Mapping
SOLUTION: Primary Key to Foreign Key Mapping
ASSIGNMENT: Importing 2013 Q1 Data
SOLUTION: Importing 2013 Q1 Data
Altering, Updating & Mapping Keys
Replication, Backup & Recovery
Replication
Backup & Recovery
ASSIGNMENT: Backup & Recovery
SOLUTION: Backup & Recovery
Replication, Backup & Recovery
Mid-Course Project
ASSIGNMENT: Mid-Course Project
SOLUTION: Mid-Course Project
Trigger Automation
REVIEW: Triggers Basics
Triggers Deep Dive
ASSIGNMENT: Creating & Updating Orders
SOLUTION: Creating & Updating Orders
ASSIGNMENT: Triggers
SOLUTION: Triggers
ASSIGNMENT: Testing Your Trigger System
SOLUTION: Testing Your Trigger System
Trigger Automation
Other courses offered by UDEMY
Advanced SQL Database Administration with MySQL Workbench at UDEMY Students Ratings & Reviews
1 Rating- 4-51
Student Forum
Anything you would want to ask experts?