YoVDO

MySQL Database Course for Beginners

Offered By: Simon Sez IT via YouTube

Tags

MySQL Courses Database Design Courses Database Administration Courses Normalization Courses

Course Description

Overview

Dive into a comprehensive 3.5-hour MySQL training course designed for beginners. Learn to install MySQL, design and administer databases, create tables with constraints, understand normalization, explore data types, and grasp ACID principles. Master user creation, access control, database backup, and performance monitoring. Delve into indexing, query optimization, and advanced topics like locks and isolation levels. Gain practical skills through demos and hands-on exercises, preparing you for real-world database administration tasks.

Syllabus

- Simon Sez IT Intro
- Course Outline and Intro to MySQL and Database
- MySQL Architecture and Installation of MySQL
- Installation Demo - Part 1
- Installation Demo - Part 2
- Database Design
- MySQL Workbench Download
- Database Table and Constraints
- Database Designing and Normalization - Part 1
- Database Designing and Normalization - Part 2
- Storage and Data Types
- Data Types Demo
- ACID and Transactions
- Locks, Deadlocks, Isolation Levels and Logging
- Isolation Levels and Locking Demo
- Locking Mechanism Demo and MySQL ACID Support
- Responsibilities of a Database Administrator
- Creating a User and Limiting Access to a Database; Basic Table Maintainance Function
- Protecting your Database; How to Perform Database Backup
- Performance Monitoring
- InnoDB Indexing and Clustered vs. Unclustered Index
- Query and Where Clause
- Impact of Indexing on Database Performance
- Performance Optimization


Taught by

Simon Sez IT

Related Courses

Statistics for Genomic Data Science
Johns Hopkins University via Coursera
Fundamentals of database systems
Indian Institute of Technology Kanpur via Swayam
Database Systems Concepts and Design
Georgia Institute of Technology via edX
Introduction to Data Modeling
Microsoft via edX
Введение в базы данных
St. Petersburg State Polytechnic University via Stepik