filmov
tv
MySQL Database Course for Beginners: 3+ Hours of MySQL Training
Показать описание
Take a look at the full course from Simon Sez IT
In this MySQL training course for beginners, we cover the fundamental concepts you need as a MySQL administrator. We start off with installing MySQL for the first time before moving on to exploring how to design and administrate a MySQL database. We also discuss how to run a database backup, performance monitoring, and so much more!
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Simon Sez IT Intro
00:00:09 - Course Outline and Intro to MySQL and Database
00:10:20 - MySQL Architecture and Installation of MySQL
00:26:20 - Installation Demo - Part 1
00:29:55 - Installation Demo - Part 2
00:39:33 - Database Design
00:48:19 - MySQL Workbench Download
00:55:55 - Database Table and Constraints
01:05:34 - Database Designing and Normalization - Part 1
01:17:26 - Database Designing and Normalization - Part 2
01:25:36 - Storage and Data Types
01:31:06 - Data Types Demo
01:42:26 - ACID and Transactions
01:52:10 - Locks, Deadlocks, Isolation Levels and Logging
01:59:26 - Isolation Levels and Locking Demo
02:12:09 - Locking Mechanism Demo and MySQL ACID Support
02:18:32 - Responsibilities of a Database Administrator
02:22:18 - Creating a User and Limiting Access to a Database; Basic Table Maintenance Function
02:32:53 - Protecting your Database; How to Perform Database Backup
02:40:37 - Performance Monitoring
02:51:24 - InnoDB Indexing and Clustered vs. Unclustered Index
03:05:41 - Query and Where Clause
03:11:14 - Impact of Indexing on Database Performance
03:21:47 - Performance Optimization
🔥Check out our Long Training Courses playlist here
💻Watch more popular tutorials from Simon Sez IT:
✅Microsoft Office 2021 and Office 365 Training Tutorials
✅Excel 2021 Tutorials for Beginners playlist
✅Simon Sez IT Long Training Courses playlist
💬Stay in touch!
🔔Subscribe to our channel:
If you enjoyed the video, please give a "thumbs up" and subscribe to the channel 👍🏽 ;-)
In this MySQL training course for beginners, we cover the fundamental concepts you need as a MySQL administrator. We start off with installing MySQL for the first time before moving on to exploring how to design and administrate a MySQL database. We also discuss how to run a database backup, performance monitoring, and so much more!
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Simon Sez IT Intro
00:00:09 - Course Outline and Intro to MySQL and Database
00:10:20 - MySQL Architecture and Installation of MySQL
00:26:20 - Installation Demo - Part 1
00:29:55 - Installation Demo - Part 2
00:39:33 - Database Design
00:48:19 - MySQL Workbench Download
00:55:55 - Database Table and Constraints
01:05:34 - Database Designing and Normalization - Part 1
01:17:26 - Database Designing and Normalization - Part 2
01:25:36 - Storage and Data Types
01:31:06 - Data Types Demo
01:42:26 - ACID and Transactions
01:52:10 - Locks, Deadlocks, Isolation Levels and Logging
01:59:26 - Isolation Levels and Locking Demo
02:12:09 - Locking Mechanism Demo and MySQL ACID Support
02:18:32 - Responsibilities of a Database Administrator
02:22:18 - Creating a User and Limiting Access to a Database; Basic Table Maintenance Function
02:32:53 - Protecting your Database; How to Perform Database Backup
02:40:37 - Performance Monitoring
02:51:24 - InnoDB Indexing and Clustered vs. Unclustered Index
03:05:41 - Query and Where Clause
03:11:14 - Impact of Indexing on Database Performance
03:21:47 - Performance Optimization
🔥Check out our Long Training Courses playlist here
💻Watch more popular tutorials from Simon Sez IT:
✅Microsoft Office 2021 and Office 365 Training Tutorials
✅Excel 2021 Tutorials for Beginners playlist
✅Simon Sez IT Long Training Courses playlist
💬Stay in touch!
🔔Subscribe to our channel:
If you enjoyed the video, please give a "thumbs up" and subscribe to the channel 👍🏽 ;-)
4:20:39
SQL Tutorial - Full Database Course for Beginners
0:12:04
Installing MySQL and Creating Databases | MySQL for Beginners
1:59:31
MySQL Database - Full Course
0:17:17
MySQL - The Basics // Learn SQL in 23 Easy Steps
3:29:55
MySQL Database Course for Beginners: 3+ Hours of MySQL Training
3:10:19
SQL Tutorial for Beginners [Full Course]
3:00:00
MySQL Full Course for free 🐬
0:45:53
Introduction To MySQL | MySQL Workbench Tutorial | MySQL Basics For Beginners | Simplilearn
0:06:01
Master MYSQL Installation With These 3 Brilliant Hacks!
0:11:30
MySQL IN 10 MINUTES | Introduction to Databases, SQL, & MySQL
0:12:55
16 | Create a Database in MySQL PHP Tutorial | 2023 | Learn PHP Full Course for Beginners
9:52:57
MySQL Full Course 2023 | MySQL Tutorial For Beginners | SQL Full Course | SQL Training | Simplilearn
0:17:40
Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3
0:02:23
SQL Explained in 100 Seconds
2:05:58
MySQL Tutorial For Beginners | Introduction to MySQL | Learn MySQL | MySQL Training | Edureka
4:20:31
Learn MySQL In One Video - Course for Beginners
0:46:50
MySQL Tutorial | MySQL for Beginners | MySQL Training | Edureka
1:11:35
MySQL Crash Course | Learn SQL
3:16:14
SQL - Complete Course in 3 Hours | SQL One Shot using MySQL
3:27:38
MySQL Full Course for Beginners with Practical [FREE] | Learn MySQL in 3 Hours
0:09:53
MySQL Tutorial for Beginners - Part 7 - Database Table and Constraints
3:25:49
SQL Crash Course for Beginners 2022 (MySQL & PostgreSQL) - No prior knowledge required!
0:56:24
Learn SQL In 60 Minutes
0:49:16
MySQL Live - 1 | MySQL Tutorial For Beginners | Introduction to MySQL | MySQL Training | Edureka
Комментарии