Managing Big Data with MySQL
This course is an introduction to how to use relational databases in business analysis. You will learn how relational databases work, and how to use entity-relationship diagrams to display the structure of the data held within them. This knowledge will help you understand how data needs to be collected in business contexts, and help you identify features you want to consider if you are involved in implementing new data collection efforts. You will also learn how to execute the most useful query and table aggregation statements for business analysts, and practice using them with real databas
Skills you'll learn
We may earn a commission if you enroll through our links — it never affects the price you pay.
Similar courses
Full-Stack Development with Node, Express & Databases
This course features Coursera Coach! A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. This course will take you step-by-step through building a robust full-stack web application using Node.js, Express.js, and MySQL. You’ll begin by mastering HTTP requests in React, and learn to fetch and manage data with external APIs. The course emphasizes real-world development practices, offering hands-on experience through interactive lessons and assessments. The jou
All levels
Database Structures and Management with MySQL
Develop a working knowledge of the MySQL database management system (DBMS). Gain DBMS skills such as data creation, querying and manipulation. You’ll gain further experience with SQL statements, clauses and data types. By the end of this course, you’ll be able to: - Utilize the MySQL DBMS to build and modify relational databases with SQL - Add records to a MySQL database - Perform intricate queries on database records with filters and groupings - Create simple joins and unions within a database - Create relationships between tables using primary and foreign keys - Demonstrate the ab
All levels
Apache Spark: Design & Execute ETL Pipelines Hands-On
Build practical data engineering skills by learning how to design, develop, and execute end-to-end ETL (Extract, Transform, Load) pipelines using Apache Spark. In this hands-on course, you will begin by setting up a Spark development environment, installing and configuring PySpark, Hadoop, and MySQL, organizing ETL project structures, and exploring real-world datasets. As you progress, you will implement complete and incremental ETL workflows using Apache Spark. You'll integrate Spark with MySQL through JDBC, apply data transformation logic with Spark SQL, perform business-rule filtering, and
All levels
SQL Joins
In this 1-hour long project-based course, you will learn how to utilize MySQL joins in your queries. By the end of this project, you will create a number of examples that will develop your learning around joins in SQL. This course will enable you to take your beginner knowledge of SQL to the next level by enabling you to utilize joins. Thus, being able to develop more complex queries. This course will provide students with the knowledge behind different joins that are available in MySQL language such as inner join, outer join, and left join. This project will take students through a number of
All levels