Data Manipulation and Management using MYSQL Workbench
By the end of this project, you will be able to manage data efficiently in a specific database using MYSQL Workbench. You will be able to select data from tables from your database and use keywords in select statements such as LIMIT and Top. You will be able to update the data and filter them using where statements, and also apply conditions with different ways and keywords such as like, and, or, and between. Moreover, you will be able to apply the aggregate functions in your select statement and the grouping by, and finally, you will be able to join tables with each other using three differen
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
Analyze and Manage HR Databases Using MySQL
By the end of this course, learners will be able to design a structured HR database, write efficient SQL queries, analyze data using aggregations and joins, manage transactions, and import or export data using MySQL. This hands-on course guides learners through the complete lifecycle of building and working with an HR database, starting from database creation and table design to advanced querying and performance analysis. Learners gain practical experience by working on a realistic HR schema and an additional Music database, enabling them to apply SQL concepts across multiple real-world scena
All levels