Linux System Engineer: Database Servers Using MariaDB

Focused View

Grant McWilliams

47:51

156 View

01 - Introduction

01 - Database server administration with MariaDB.mp4

00:40

02 - What you will need.mp4

01:01

02 - 1. Understanding Databases

01 - How databases work.mp4

02:54

02 - What is MariaDB.mp4

01:31

03 - 2. Introduction to MariaDB

01 - Install MariaDB.mp4

02:03

02 - MariaDB commands.mp4

01:24

03 - MariaDB configuration files.mp4

02:20

04 - MariaDB logs.mp4

02:59

05 - MariaDB and SELinux.mp4

02:58

04 - 3. The MySQL Shell

01 - Using the MySQL shell.mp4

02:43

02 - Subcommands to manage databases.mp4

01:51

03 - Subcommands to manage tables.mp4

02:04

05 - 4. Using Databases

01 - Create a database with tables.mp4

04:37

02 - Query a database.mp4

03:01

03 - Renaming tables and updating records.mp4

02:29

06 - 5. Administering Databases

01 - Set the root database password.mp4

02:08

02 - Recover the MariaDB root password.mp4

02:47

03 - Secure a MariaDB server.mp4

01:27

04 - Perform logical database backups.mp4

04:05

05 - Restore logical database backups.mp4

02:17

07 - Conclusion

01 - Next steps.mp4

00:32

Description

Study to pass the Red Hat Certified Engineer (RHCE) exam—the benchmark certification for Red Hat Enterprise Linux. This installment of the RHCE Cert Prep series covers database configuration and management with MariaDB. Instructor Grant McWilliams begins by reviewing database basics, walking through a MariaDB server install, and noting differences between MySQL and MariaDB. Then he demonstrates some SQL commands for creating databases and tables, and how to query the data held within them. Next, he explains how to set and recover the database root user's password and secure your database server installation. Finally, he shows how to create and restore logical MariaDB backups of databases and tables.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

Linux

Linux Administration

Grant McWilliams

Instructor's Courses

Grant McWilliams is a computer consultant, public speaker, technical writer, professor and software developer specializing in Linux and Open Source. He's been a college professor for 20 years teaching at Bellevue College, Shoreline Community College and Edmonds Community College. He's also provided custom training and curriculum for Boeing, Panasonic, Thales and many other fortune 500 corporations. His training focuses entirely on open source and Linux technologies. His consulting company - Sound Linux Training and Consulting has been in business for 26 years in various forms and specializes in creating custom solutions using open source technologies. These have included Linux based in-flight entertainment systems, massively scaled Xen hypervisor near-embedded platforms as well as cloud, virtual and physical security scanning and penetration testing appliances. His public speaking engagements include Linuxcon (New Orleans 2013), Xen User Summit (NYC 2014) and LinuxFest Northwest (Bellingham WA 2004-2011). His technical writing/editing achievements have included writing documentation and manpages for Citrix Xenserver via the Xenapi Admin Project and technical editor for No Starch Press on the book Wicked Cool Shell Scripts. Specialties: Cloud Computing, Virtualization, Xen Cloud Platform/Xenserver, Linux, BASH, Saltstack, SELinux, PHP, Python, System Design, Technical writing, curriculum creation, Instructor Led Training

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.