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

Up and Running with MySQL

Jeff Iannucci

MySQL is one of the most popular database management systems in the world due to its low cost and ease of use. This course will teach you how to install and use free tools to connect to MySQL databases and query data.

Read more

MySQL is one of the most popular database management systems in the world due to its low cost and ease of use. This course will teach you how to install and use free tools to connect to MySQL databases and query data.

Data is one of the most vital resources modern organizations possess, and many of the world's leading companies rely on MySQL to store their business-critical data. In this course, Up and Running with MySQL, you'll learn how to install and use free tools to access data in a MySQL database, regardless of your previous experience using databases. First, you'll explore the reasons for choosing MySQL, as well as gain a basic understanding of the terms associated with relational databases. Next, you'll discover how to install and use the tools to access data in a MySQL database. Finally, you'll see how to perform SQL queries of data. When you're finished with this course, you'll have the skills and knowledge of MySQL and its associated tools to connect to a MySQL database and query the vital data you need.

Enroll now

What's inside

Syllabus

Course Overview
Introducing MySQL
Working with MySQL Tools
Querying Data in MySQL
Read more

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Provides a foundation for learners with no prior experience in databases
Focuses on MySQL, one of the most popular and widely used database management systems
Builds practical skills in connecting to MySQL databases and querying data

Save this course

Save Up and Running with MySQL to your list so you can find it easily later:
Save

Activities

Coming soon We're preparing activities for Up and Running with MySQL. These are activities you can do either before, during, or after a course.

Career center

Learners who complete Up and Running with MySQL will develop knowledge and skills that may be useful to these careers:
Web Developer
Web Developers design, create, and maintain websites. A firm understanding of databases is necessary to work with content management systems. Many websites use MySQL databases. Up and Running with MySQL teaches you how to install and use free tools to connect to MySQL databases and query data, which is valuable to aspiring Web Developers.
Data Analyst
Data Analysts scrutinize an organization's data to extract meaningful insights that can drive better decision-making. SQL is the standard language for querying databases. Up and Running with MySQL teaches you how to perform SQL queries of data. This is a valuable skill for aspiring Data Analysts.
Database Administrator
A Database Administrator, often abbreviated DBA, is responsible for overseeing the entire operational lifecycle of an organization's databases. Up and Running with MySQL teaches you how to connect to databases, query data, and understand the terms associated with relational databases. This course may be useful to those who wish to gain a foundational understanding of databases and SQL, which is a skill essential to the success of any DBA.
Technical Writer
Technical Writers are responsible for translating complex technical information into user-friendly content. Up and Running with MySQL teaches you the terms associated with relational databases, as well as how to use tools to access data in a MySQL database. This can be a valuable course for those interested in becoming Technical Writers who wish to write about database-related topics.
Software Developer
Software Developers design, create, and maintain software applications. A foundational understanding of databases is helpful for Software Developers who may need to work with data.
Business Analyst
Business Analysts analyze how an organization is performing to come up with ways to improve efficiency. A foundational understanding of databases is helpful for Business Analysts who wish to analyze data and recommend solutions to problems.
Information Technology Specialist
Information Technology Specialists maintain and enhance an organization's IT system. A basic understanding of databases is helpful for those in this role.
Project Manager
Project Managers oversee projects from planning through completion. Larger IT projects may require a Project Manager with experience in database management.
Operations Manager
Operations Managers oversee the operation of a business. Understanding databases can be helpful for managers of IT operations.
Customer Relationship Manager
Customer Relationship Managers manage an organization's relationships with its customers. Up and Running with MySQL may be useful for those in this role who wish to analyze customer data.
Marketing Manager
Marketing Managers develop strategies to market an organization's products or services. Up and Running with MySQL may be useful for understanding the data used by Marketing departments to drive marketing decisions.
Sales Manager
Sales Managers oversee the sales operations of an organization. Up and Running with MySQL may be useful for those in this role who wish to analyze sales data.
Business Development Manager
Business Development Managers seek new clients for an organization's products or services. For BDM's who target companies with a need for database management, Up and Running with MySQL may be useful for understanding client pain points and needs.
Financial Manager
Financial Managers oversee the financial operations of an organization. Up and Running with MySQL may be useful for those in this role who wish to analyze financial data.
Human Resources Manager
Human Resources Managers oversee the human resources functions of an organization. Up and Running with MySQL may be useful for those in this role who wish to analyze data to make hiring or retention decisions.

Reading list

We've selected 12 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Up and Running with MySQL.
Contains many detailed examples and sample code. It provides a comprehensive overview of MySQL and is especially useful for learning SQL.
Provides a very comprehensive overview of MySQL. It is published by MySQL AB, making it a good resource for finding official and up-to-date documentation about MySQL's features.
Focuses primarily on data querying using MySQL. It's a useful resource for those who are already familiar with databases and SQL, but it may be too advanced for those who are learning either for the first time. The book also includes some information on setting up a MySQL database, and using data visualization tools with MySQL.
Provides advanced techniques for optimizing MySQL performance. It is especially useful for database administrators and developers who need to improve the performance of their MySQL databases.
Good starting point for new learners of SQL. It covers all of the basics of SQL, including advanced topics such as joins, nested queries, triggers, and stored procedures.
Helpful introduction to MySQL. It covers not just data querying, but also introduces some of the fundamentals of relational databases and database management systems. This book good starting spot for beginners who have no experience with databases, but those who have more experience may want to consult additional resources.
Provides a detailed guide to advanced SQL programming techniques. It is especially useful for experienced SQL developers who need to learn how to write more efficient and effective SQL queries.
Provides a comprehensive guide to using MySQL and MariaDB. It is especially useful for beginners who need to learn the basics of MySQL and MariaDB.
Provides a comprehensive guide to using MySQL with PHP. It is especially useful for web developers who need to create dynamic web pages that interact with MySQL databases.

Share

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

Similar courses

Here are nine courses similar to Up and Running with MySQL.
Managing MySQL Databases and Stored Procedures
Most relevant
MySQL: The Ultimate MySQL Course
Most relevant
The Complete MySQL Developer Course
Most relevant
SQL for Data Analysis: Beginner MySQL Business...
Most relevant
Relational Database Basics
Most relevant
Preparing a Production Hadoop Cluster with Cloudera:...
Most relevant
Database Clients
Most relevant
SQL - The Complete Developer's Guide (MySQL, PostgreSQL)
Most relevant
Introduction to Databases
Most relevant
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