WPI Curriculum Module: Databases & SQL
Master Relational Database Design and SQL
The modern Internet processes a gigantic flood of data every day. What to do with all this data? A data management concept that has proven itself for decades has also taken web development by storm: the relational database model. Learn to design and manage efficient relational databases using MySQL and UML. This module covers essential database concepts, including normalization, indexing, and query optimization. You'll gain hands-on experience with SQL, the standard language for interacting with relational databases.
After completing this module, you'll be able to:
Design and implement relational databases:Â You will learn how to design efficient database structures using normalization techniques and create databases using MySQL.
Write SQL queries:Â You will be able to write SQL queries to retrieve, insert, update, and delete data from databases.
Optimize database performance:Â You will learn techniques to optimize database performance, such as indexing and query optimization.
Understand database concepts:Â You will gain a solid understanding of fundamental database concepts, including data modeling, normalization, and ACID properties.
This module consists of the following classes:
This class focuses on modern data management concepts, including relational databases, database migrations, indexing, sorting, relationships, and object-relational mapping. It provides hands-on experience with MySQL and UML to prepare you with the required base knowledge for successful data management with a focus on the development of web applications.Â
This module as a workload of approximately 78 hours. The workload includes the total amount of time that course participants have to successfully complete the course.
The workload is an average value calculated by the Web Professional Institute (WPI). The actual workload in a course offered by a training center may differ from the average value stated here depending on the delivery method of the course (e.g. online or face-to-face) and the target group.
The duration of the course depends on the weekly study time. You can use the slider to find out how long the course lasts.
This module is required for the following WPI Certifications:
Interested in learning more about these certifications? Click on the links above to find out how each one can benefit you.
Can't find the perfect fit yet? Explore our full range of certifications to discover new opportunities.