IIRF Online > Office Productivity > Oracle > Database Administration > MySQL Database Administration: Beginner SQL Database Design
MySQL Database Administration: Beginner SQL Database Design by Udemy
Learn SQL for data analysis, relational database management & administration w/ MySQL Workbench (SQL DBA for beginners!)
Course Highlights
- Write SQL queries and use the MySQL Workbench UI to create databases and tables
- Learn how to alter tables by adding and removing columns
- Connect data between tables by creating primary and foreign key relationships
- Assign user roles and permissions to database users, just like a real DBA
- Solve practical hands-on assignments and real-world business use cases
- Master unique tips, tools and case studies that you won't find anywhere else
- Understand common Relational Database Management Systems (RDBMS)
- Get LIFETIME access to resource files, quizzes, assignments, and expert support
Skills you will learn!
Curriculum
5 Topics
Introduction
READ ME: Important Notes for New Students
DOWNLOAD: Course Resources
Introducing The Course Project
Setting Expectations
4 Topics
Introduction to SQL
Relational Databases
Relational Database Management Systems
QUIZ: SQL & Relational Database Overview
7 Topics
MySQL Installation Overview
Mac Download - MySQL Community Server
Mac Download - MySQL Workbench
PC Download - MySQL Community Server & MySQL Workbench
Connecting Workbench To The Server
MySQL Workbench Interface
Creating Initial Schemas
15 Topics
Creating A Schema Using The UI
Creating A Schema Using SQL Code
Creating A Table Using The UI
Creating A Table With A SQL Query
MySQL Data Types
Assignment: Creating Your Own Schema And Tables
Solution: Creating Your Own Schema And Tables
Adding and Removing Columns In The Editor
Adding And Removing Columns With SQL Code
Assignment: Adding And Removing Columns
Solution: Adding And Removing Columns
Dropping Schemas And Tables
Assignment: Dropping Schemas And Tables
Solution: Dropping Schemas And Tables
QUIZ: Creating and Altering Schemas & Tables
9 Topics
Inserting Records Into A Table
Updating Data Records
Assignment: Inserting And Updating Records
Solution: Inserting And Updating Records
Deleting Specific Records
Deleting All Records With Truncate
Assignment: Deleting Records
Solution: Deleting Records
QUIZ: Inserting Updating and Deleting Records
12 Topics
Primary Keys and Foreign Keys
Primary Keys and Foreign Keys Demo
Assignment: Table Relationships
Solution: Table Relationships
Database Normalization
Database Normalization Demo
Assignment: Normalization
Solution: Normalization
The EER Diagram Editor
Assignment: EER Diagram Editor
Solution: EER Diagram Editor
QUIZ: Database Design
2 Topics
Assignment: Mid Course Project
Solution: Mid Course Project
12 Topics
Creating An Index
The Unique Constraint
The Non Null Constraint
Assignment: Indexes And Constraints
Solution: Indexes And Constraints
Stored Procedures
Assignment: Stored Procedures
Solution: Stored Procedures
Triggers
Assignment: Triggers
Solution: Triggers
QUIZ: Advanced Concepts
7 Topics
Server Management
Assignment: Server Management
Solution: Server Management
Managing Users And Permissions
Assignment: Managing Users And Permissions
Solution: Managing Users And Permissions
QUIZ: Server & User Management
2 Topics
Assignment: Final Course Project
Solution: Final Course Project
2 Topics
Resources & Next Steps
BONUS LESSON
MySQL Database Administration: Beginner SQL Database Design
Related Database Administration Courses
.webp)
Thank You!
Your review has been submitted successfully.