Paths

MySQL

Authors: Pinal Dave, Jon Flanders

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.... Read more

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

by Jon Flanders

Oct 11, 2013 / 3h 2m

3h 2m

Start Course
Description

Structured Query Language (SQL) is a special purpose language for interacting with relational databases. In this course, Introduction to SQL (Update), you will learn the basics of Structured Query Language. First, you will learn how to query data and shape results. Next, you will focus on creating and modifying data in your tables. Finally, you will touch on how actually modify the tables themselves. By the end of this course, you'll understand the basics of how to create and use a relational database.

Table of contents
  1. Course Overview1m
  2. Introduction11m
  3. Understanding Basic SQL Syntax13m
  4. Querying Data with the SELECT Statement25m
  5. Filtering Results with the WHERE Clause36m
  6. Shaping Results with ORDER BY and GROUP BY27m
  7. Matching Different Data Tables with JOINs18m
  8. Adding, Changing, and Removing Data20m
  9. Creating Database Tables28m

MySQL Fundamentals

by Pinal Dave

Apr 29, 2013 / 2h 37m

2h 37m

Start Course
Description

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack. This course covers the fundamentals of MySQL, including how to install MySQL as well as write basic data retrieval and data modification queries.

Table of contents
  1. Introduction2m
  2. Installations and GUI Tools13m
  3. Fundamentals of RDBMS and Database Designs16m
  4. Introduction MYSQL Workbench31m
  5. Data Retrieval Techniques1h 11m
  6. Data Modification Techniques20m
  7. Summary and Resources1m

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

by Pinal Dave

Jul 9, 2013 / 2h 43m

2h 43m

Start Course
Description

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack. In this course, which is part 2 of the Fundamentals of MySQL series, we explore more advanced topics such as stored procedures & user-defined functions, subqueries & joins, views and events & triggers.

Table of contents
  1. Introduction2m
  2. Joins, Unions and Subqueries1h 3m
  3. MySQL Functions36m
  4. MySQL Views19m
  5. Stored Procedures and Stored Functions25m
  6. Triggers and Events13m
  7. Summary and Resources2m

MySQL Workbench Guided Tour

by Pinal Dave

Jan 23, 2014 / 1h 52m

1h 52m

Start Course
Description

A detailed exploration of MySQL Workbench, a unified visual tool for data modeling, SQL development, and comprehensive administration tools for MySQL. This course will guide you through maximizing the power of MySQL Workbench and getting productive quickly with MySQL.

Table of contents
  1. Introduction2m
  2. MySQL Administration35m
  3. MySQL Development31m
  4. Data Modeling23m
  5. MySQL Workbench Preferences14m
  6. MySQL Workbench Shortcuts4m

MySQL Backup and Recovery Fundamentals

by Pinal Dave

May 24, 2014 / 1h 15m

1h 15m

Start Course
Description

Data is very important to any application and business. It is very important that every business plan for data safety. Database backup strategies are often discussed after the disaster has already happened. In this introductory course we will explore a few of the basic backup strategies every business should implement for data safely. We will explore how we can recover our server quickly after any unfriendly incident to our MySQL database.

Table of contents
  1. Introduction4m
  2. Backup With mysqldump22m
  3. Restore With mysql11m
  4. Data Export and Import With Workbench17m
  5. Frequently Asked Questions19m

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

by Pinal Dave

Aug 26, 2013 / 1h 39m

1h 39m

Start Course
Description

Performance is one of the most essential aspects of any application. Everyone wants their server to perform optimally and at the best efficiency. Indexes are the silver bullets for Performance. In this course we will gain an understanding of the basics of Indexes and further explore practical tips and tricks for performance tuning.

Table of contents
  1. MySQL Indexing for Performance1m
  2. Types of Indexes29m
  3. Indexing Strategies for High Performance55m
  4. Index Maintenance11m
  5. Checklists2m

MySQL Query Optimization and Performance Tuning

by Pinal Dave

Dec 30, 2013 / 1h 50m

1h 50m

Start Course
Description

Performance is one of the most essential aspects of any application. Everyone wants their server to perform optimally and at the best efficiency. In this course we will understand the basics of query optimization and look at practical tips and tricks for performance tuning.

Table of contents
  1. Introduction1m
  2. Optimizing Data Access12m
  3. Understanding MySQL Query Optimization26m
  4. Performance Optimization by Practical Query Tuning1h 6m
  5. Best Practices3m

phpMyAdmin Fundamentals

by Pinal Dave

Jun 20, 2014 / 1h 41m

1h 41m

Start Course
Description

phpMyAdmin is a free and open source tool written in PHP for the administration of MySQL via a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields, and rows as well as executing SQL statements or managing users and permissions. This course will guide you through maximizing the power of phpMyAdmin to get productive quickly with MySQL.

Table of contents
  1. phpMyAdmin Introduction3m
  2. phpMyAdmin Installation and Configuration16m
  3. Database Operations23m
  4. Table Operations43m
  5. Home Screen Settings11m
  6. Summary and Resources2m

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

Pre-requisites

This path targets beginners who may have no programming experience, or some experience with programming outside of databases and SQL.

Register for FREE. Get your Pluralsight IQ.

You’ll get unlimited access to adaptive skill assessments that help you validate your skills in as little as 5 minutes, and you'll get to see the Pluralsight platform first-hand.

Offer Code *
Email * First name * Last name *
Company
Title
Phone
Country *

* Required field

Opt in for the latest promotions and events. You may unsubscribe at any time. Privacy Policy

By activating this benefit, you agree to abide by Pluralsight's terms of use and privacy policy.

I agree, activate benefit