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.

1

Introduction to SQL

by Jon Flanders

Oct 11, 2013 / 3h 2m

Beginner • 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 Overview
    1m 30s
  2. Introduction
    11m 36s
  3. Understanding Basic SQL Syntax
    13m 1s
  4. Querying Data with the SELECT Statement
    25m 28s
  5. Filtering Results with the WHERE Clause
    36m 17s
  6. Shaping Results with ORDER BY and GROUP BY
    27m 8s
  7. Matching Different Data Tables with JOINs
    18m 58s
  8. Adding, Changing, and Removing Data
    20m 33s
  9. Creating Database Tables
    28m 12s
2

MySQL Fundamentals

by Pinal Dave

Apr 29, 2013 / 2h 37m

Intermediate • 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. Introduction
    2m 12s
  2. Installations and GUI Tools
    13m 51s
  3. Fundamentals of RDBMS and Database Designs
    16m 13s
  4. Introduction MYSQL Workbench
    31m 51s
  5. Data Retrieval Techniques
    1h 11m 13s
  6. Data Modification Techniques
    20m 41s
  7. Summary and Resources
    1m 31s

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.

3

MySQL Fundamentals Part 2

by Pinal Dave

Jul 9, 2013 / 2h 43m

Intermediate • 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. Introduction
    2m 9s
  2. Joins, Unions and Subqueries
    1h 3m 56s
  3. MySQL Functions
    36m 55s
  4. MySQL Views
    19m 19s
  5. Stored Procedures and Stored Functions
    25m 23s
  6. Triggers and Events
    13m 41s
  7. Summary and Resources
    2m 18s
4

MySQL Workbench Guided Tour

by Pinal Dave

Jan 23, 2014 / 1h 52m

Intermediate • 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. Introduction
    2m 25s
  2. MySQL Administration
    35m 31s
  3. MySQL Development
    31m 57s
  4. Data Modeling
    23m 56s
  5. MySQL Workbench Preferences
    14m 39s
  6. MySQL Workbench Shortcuts
    4m 29s
5

MySQL Backup and Recovery Fundamentals

by Pinal Dave

May 24, 2014 / 1h 15m

Intermediate • 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. Introduction
    4m 7s
  2. Backup With mysqldump
    22m 12s
  3. Restore With mysql
    11m 15s
  4. Data Export and Import With Workbench
    17m 49s
  5. Frequently Asked Questions
    19m 46s

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.

6

MySQL Indexing for Performance

by Pinal Dave

Aug 26, 2013 / 1h 39m

Intermediate • 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 Performance
    1m 35s
  2. Types of Indexes
    29m
  3. Indexing Strategies for High Performance
    55m 12s
  4. Index Maintenance
    11m 10s
  5. Checklists
    2m 39s
7

MySQL Query Optimization and Performance Tuning

by Pinal Dave

Dec 30, 2013 / 1h 50m

Intermediate • 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. Introduction
    1m 59s
  2. Optimizing Data Access
    12m 28s
  3. Understanding MySQL Query Optimization
    26m 7s
  4. Performance Optimization by Practical Query Tuning
    1h 6m 22s
  5. Best Practices
    3m 50s
8

phpMyAdmin Fundamentals

by Pinal Dave

Jun 20, 2014 / 1h 41m

Intermediate • 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 Introduction
    3m 37s
  2. phpMyAdmin Installation and Configuration
    16m 55s
  3. Database Operations
    23m 30s
  4. Table Operations
    43m 1s
  5. Home Screen Settings
    11m 25s
  6. Summary and Resources
    2m 34s

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.