Database Structures and Management with MySQL
Develop a working knowledge of the MySQL DBMS, including creating, querying, and manipulating data; building and normalizing relational databases; using joins, unions, keys, views, subqueries, functions, and stored procedures over 4 modules.
What you'll learn
- Develop a working knowledge of the MySQL database management system (DBMS)
- Create, query, and manipulate data in relational databases using SQL
- Use joins, unions, primary and foreign keys, and views to work with related data
- Apply functions, subqueries, and stored procedures and complete a database normalization project
Skills you'll gain
- 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
- Complete a database normalization project
- Update databases using REPLACE, ALTER TABLE, COPY TABLE, and constraints
- Work with subqueries and complex comparison operators
- Create and use views (virtual tables) in MySQL
- Use numeric, string, date, comparison, and control flow functions in MySQL
- Create and work with MySQL stored procedures
Prerequisites
- • No prior web development experience required
- • Basic internet navigation skills
- • Eagerness to get started with coding
Who this course is for
- → Learners seeking foundational data management and SQL skills
- → Aspiring database engineers pursuing the Meta Database Engineer Professional Certificate
- → Beginners without prior web development experience who want to start coding
Provider
Coursera
Related Courses
System Design for Beginners
A free beginner-friendly video course from freeCodeCamp, listed on Class Central, introducing core concepts and practices of system design for software engineers and developers.
Introduction to Python Training
Learn to rapidly develop feature-rich applications in Python using built-in statements, functions, collections, object-oriented features, data accessors, and library modules in this 3-day instructor-led course.
Introduction to Python
Learn Python like a pro from day one—code in a professional IDE with guided setup, instant feedback, and short, focused lessons that build job‑ready Python fundamentals for data science, automation, and software development.
JavaScript Certification
This course teaches core JavaScript programming concepts including variables, functions, objects, arrays, and control flow. You also learn DOM manipulation, event handling, asynchronous and functional programming, and accessibility best practices, culminating in projects and a certification exam.
IT Systems Design and Analysis
Prepare to design, analyze, and evaluate IT systems using data flow diagrams, ERDs, UML, and feasibility analysis. Learn to assess existing systems, identify inefficiencies, compare solution alternatives, and deliver a digital transformation strategy through a hands-on final project.
Programming with JavaScript
Learn the basics of web development with JavaScript, including variables, data types, functions, objects, arrays, DOM manipulation, modern JS features, and writing unit tests with Jest over 5 modules.