We may earn an affiliate commission when you visit our partners.
Course image
Pluralsight logo

MySQL

Pinal Dave and 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. 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.

Read more

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'll 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
  • Enroll now

    Share

    Help others find this collection page by sharing it with your friends and followers:

    What's inside

    Six courses

    Introduction to SQL

    (3 hours)
    The vast majority of applications that use data are backed by a good relational database system. This course will help to establish a base to those who want to begin learning Structured Query Language (SQL), a special purpose language for interacting with relational databases.

    MySQL Fundamentals

    (2 hours)
    MySQL, a core component of LAMP, is a widely used database for web applications. This course introduces MySQL fundamentals, including installation, data retrieval, and modification queries.

    MySQL Fundamentals Part 2

    (2 hours)
    Part 2 of the MySQL Fundamentals series, covering stored procedures, user-defined functions, triggers, subqueries, joins, views, events, and more.

    MySQL Indexing for Performance

    (1 hours)
    MySQL course focusing on Indexing Strategies for High Performance Database Performance is one of the most essential aspects of any application. Indexes are the silver bullets for Performance.

    MySQL Query Optimization and Performance Tuning

    (1 hours)
    This course focuses on query optimization and performance tuning of MySQL. Performance is one of the most essential aspects of any application.

    phpMyAdmin Fundamentals

    (1 hours)
    phpMyAdmin is a free and open source tool for MySQL administration.

    Save this collection

    Save MySQL to your list so you can find it easily later:
    Save
    Our mission

    OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

    Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

    Find this site helpful? Tell a friend about us.

    Affiliate disclosure

    We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

    Your purchases help us maintain our catalog and keep our servers humming without ads.

    Thank you for supporting OpenCourser.

    © 2016 - 2024 OpenCourser