Relational Database Design Bootcamp

Descripción

Master the fundamentals of relational database design in this hands-on, project-based bootcamp. Learn to build efficient, scalable databases using database relationships, normalization, ER diagrams, and best practices. Perfect for beginners and aspiring data professionals. Enroll today to boost your data skills! This course takes a project based approach to learning database design. We begin from scratch and each section builds knowledge of different aspects of database design. Each section has a mini-project to solidify the concepts learnt. Finally we tie this all together in a final project where we apply everything we have learned in the course to design a database for a music streaming application. This course concentrates on database design concepts for relational databases. We will not be writing or learning any SQL queries in this bootcamp. We will be using VS Code to design and create conceptual models and Entity-Relationship Diagrams. Installation and setup videos for VS Code are included in the course, as well as a quick user guide for VS Code. Relational database design skills remain highly relevant in 2025 for several key reasons: • Ubiquity of Structured Data Despite the rise of NoSQL and other data storage paradigms, most business-critical data is still structured and fits well into relational models — think customer records, financial transactions, inventories, etc. Relational databases (RDBMSs) like PostgreSQL, MySQL, and Microsoft SQL Server continue to power thousands of enterprise systems. • Foundations for Other Technologies Relational design concepts like normalization, keys, and constraints form the core foundation for understanding data modeling in general, even in modern hybrid systems or when working with ORM tools in application development. • Longevity and Interoperability Relational databases are decades-old yet still dominant. Knowing how to design them means you can work across legacy systems, modern microservices, and even cloud-native environments — a critical skill in environments where systems need to interoperate. • Demand in the Job Market In 2025, companies continue to list relational database skills (SQL, schema design, normalization) as core requirements for software engineers, data analysts, and data engineers. The demand hasn't disappeared — it’s simply evolved. Relational database design is a timeless skill. In 2025, it's not just about writing SQL — it's about understanding how to model data effectively, optimize performance, ensure data quality, and future-proof systems in increasingly hybrid tech environments. In this bootcamp you will learn everything you need to design efficient and reliable relational databases. By the end of this course you will understand: • Relational databases and table structure. • Why good database design is important and the steps to database design. • Data modeling using conceptual models and entity-relationship diagrams. • The different types of database relationships and how they are implemented. • Key relational database concepts such as data integrity, data reliability and data redundancy. • The different data types, keys, constraints and indexes used in relational databases. • Database normalization and why databases should conform to at least third normal form. • A final project where you will bring all of this together to design a relational database for a music streaming service. No prior knowledge of databases, SQL or coding is needed to take this course as we begin from scratch. Enroll today to boost your data skills!

Lo que aprenderás

• Design a relational database from scratch.
• Understand and implement database relationships.
• Learn what database normalization is and why we need it for good database design.
• Master more advanced database concepts such as indexes and views.
• Data modeling for structured data.
• Understand how to improve data integrity and data reliability.

Requisitos

• No prior knowledge of databases or SQL is needed.