MySQL | Path
Год выпуска: 2020
Производитель: Pluralsight
Сайт производителя://app.pluralsight.com/paths/skills/mysql
Автор: Jon Flanders / Pinal Dave
Продолжительность: ~17h
Тип раздаваемого материала: Видеоурок
Язык: Английский
Описание:
MySQL is a DBMS, or database management system. It is developed, supported and distributed by Oracle, but since it is open-source it is freely available to anyone under the GPL. MySQL databases are relational, meaning that the data is split up between tables. MySQL is very fast and lightweight so you can run it alongside your other applications on a desktop or laptop. It can also be scaled up to take advantage of all the CPU power and memory available on a dedicated machine. MySQL is constantly being updated and developed to include a wide array of useful and rich functions. This path will guide you through the basics of SQL and introduce MySQL relational databases, and by the end you'll be confident in creating and administering your very own database.
What you will learn:
Basics of SQL
MySQL server administration
Backup and recovery of MySQL database
InnoDB and MyISAM Storage Engines
Security
Performance monitoring
MySQL Enterprise
MySQL Workbench
Prerequisites:
This path targets beginners who may have no programming experience, or some experience with programming outside of databases and SQL.
Related Topics:
[Pluralsight] Querying Data with SQL in MariaDB | Path [2022, ENG]
[Pluralsight] Querying Data with SQL from PostgreSQL | Path [2020, ENG]
[Pluralsight] Querying and Modifying Data in MongoDB | Path [2020, ENG]
Содержание
Beginner
These courses will show you how to install MySQL software and perform basic setup of MySQL DBMS. You will also be introduced to basic queries in SQL/MySQL.
Introduction to SQL (Jon Flanders, 2017)
MySQL Fundamentals (Pinal Dave, 2020)
Intermediate
This section will take you through more complex queries in MySQL and cover some of your backup/recovery options. You'll finish of with a brief overview of MySQL Workbench installation and navigation.
MySQL Fundamentals Part 2 (Pinal Dave, 2020)
MySQL Workbench Guided Tour (Pinal Dave, 2014)
MySQL Backup and Recovery Fundamentals (Pinal Dave, 2014)
Advanced
The advanced courses you see here will solidify your confidence in MySQL database administration by showing you how to optimize performance and queries for your databases.
MySQL Indexing for Performance (Pinal Dave, 2013)
MySQL Query Optimization and Performance Tuning (Pinal Dave, 2013)
phpMyAdmin Fundamentals (Pinal Dave, 2014)
Файлы примеров: присутствуют
Субтитры: присутствуют
Формат видео: MP4
Видео: H.264/AVC, 1280x720/1024x768, 16:9, 15fps, 97.9 kb/s
Аудио: AAC, 44.1 kHz, 116 kbit/s, 2 channels
Скриншоты
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
