Save For Later

MySQL

Save For Later

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
  • Read More

    OpenCourser is an affiliate partner of Pluralsight and may earn a commission when you buy through our links.

    From Pluralsight
    Hours 17
    Instructors Jon Flanders, Pinal Dave
    Language English
    Subjects Programming IT & Networking Data Science

    Similar Courses

    Sorted by relevance

    Careers

    An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).

    Coordinator of Donor Stewardship & Database Management $53k

    AMOS Database Management Specialist $70k

    Database Management Manager $82k

    Database Management Librarian $84k

    Database Management Analyst $85k

    Database Management & Data Entry $91k

    Database Management / Administration Apprenticeship $92k

    Configuration Management Database Analyst $97k

    Materials Management IS Database Specialist $102k

    Technical Analyst - Database Management $108k

    Engineering Project Management Database Designer $119k

    Database Management Systems Programmer $121k

    Courses in this Paths

    Listed in the order in which they should be taken

    Starts Course Information

    On Demand

    Introduction to SQL

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

    Pluralsight

    Save

    On Demand

    MySQL Fundamentals

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

    Pluralsight

    Save

    On Demand

    MySQL Fundamentals Part 2

    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,...

    Pluralsight

    Save

    On Demand

    MySQL Workbench Guided Tour

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

    Pluralsight

    Save

    On Demand

    MySQL Backup and Recovery Fundamentals

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

    Pluralsight

    Save

    On Demand

    MySQL Indexing for Performance (You were viewing this course)

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

    Pluralsight

    Save

    On Demand

    MySQL Query Optimization and Performance Tuning

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

    Pluralsight

    Save

    On Demand

    phpMyAdmin Fundamentals

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

    Pluralsight

    Save

    Pluralsight

    From Pluralsight
    Hours 17
    Instructors Jon Flanders, Pinal Dave
    Language English
    Subjects Programming IT & Networking Data Science

    Careers

    An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).

    Coordinator of Donor Stewardship & Database Management $53k

    AMOS Database Management Specialist $70k

    Database Management Manager $82k

    Database Management Librarian $84k

    Database Management Analyst $85k

    Database Management & Data Entry $91k

    Database Management / Administration Apprenticeship $92k

    Configuration Management Database Analyst $97k

    Materials Management IS Database Specialist $102k

    Technical Analyst - Database Management $108k

    Engineering Project Management Database Designer $119k

    Database Management Systems Programmer $121k

    Similar Courses

    Sorted by relevance