IIRF Online > Office Productivity > Oracle > Database Administration > SQL Database Administration: Advanced MySQL Workbench
SQL Database Administration: Advanced MySQL Workbench by Udemy
Learn advanced SQL for database administration (DBA) & analytics, and practice building SQL databases w/ real projects!
Course Highlights
- 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
Skills you will learn!
Curriculum
5 Topics
Course Structure & Outline
READ ME: Important Notes for New Students
DOWNLOAD: Course Resources
Introducing The Course Project
Setting Expectations
2 Topics
Prerequisite Skills Review
Prerequisite Skills
7 Topics
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
16 Topics
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
15 Topics
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
5 Topics
Replication
Backup & Recovery
ASSIGNMENT: Backup & Recovery
SOLUTION: Backup & Recovery
Replication Backup & Recovery
2 Topics
ASSIGNMENT: Mid-Course Project
SOLUTION: Mid-Course Project
9 Topics
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
6 Topics
Views
ASSIGNMENT: Creating Website Sessions
SOLUTION: Creating Website Sessions
ASSIGNMENT: Creating Views
SOLUTION: Creating Views
Creating Views
5 Topics
REVIEW: The EER Diagram Editor
Reverse Engineering EER Diagrams
ASSIGNMENT: The EER Diagram Editor
SOLUTION: The EER Diagram Editor
The EER Diagram Editor
5 Topics
Stored Procedures
Scheduled Events
ASSIGNMENT: Stored Procedures
SOLUTION: Stored Procedures
Stored Procedures & Scheduled Events
6 Topics
Writing Data from Website Activity
ASSIGNMENT: Writing Data from Website Activity
SOLUTION: Writing Data from Website Activity
ASSIGNMENT: Importing Website Pageview Data
SOLUTION: Importing Website Pageview Data
Automating Data from Website Activity
5 Topics
Security Threats
Security Best Practices
ASSIGNMENT: Database Security
SOLUTION: Database Security
Security
2 Topics
ASSIGNMENT: Final Course Project
SOLUTION: Final Course Project
1 Topic
BONUS LESSON
SQL Database Administration: Advanced MySQL Workbench
Related Database Administration Courses
.webp)
Thank You!
Your review has been submitted successfully.