Relational Database Design Fundamentals
Learn to design and model optimal relational databases, covering all normal forms and industry best practices in this comprehensive 5-week course.
Learn to design and model optimal relational databases, covering all normal forms and industry best practices in this comprehensive 5-week course.
This intermediate-level course provides comprehensive training in relational database design principles and modeling techniques. Students learn to create effective physical and logical models, develop Entity Relationship Diagrams (ERD), and implement Schema Diagrams using industry-standard tools. The course covers all forms of database normalization (Normal Forms 1-5 plus BCNF) to ensure optimal database design conforming to best practices. Emphasis is placed on practical application of concepts through hands-on exercises in database modeling and design.
Instructors:
-1746721442565.webp&w=3840&q=75)
English
English
Powered by
What you'll learn
Create physical and logical database models effectively
Develop comprehensive Entity Relationship Diagrams
Design normalized databases using industry best practices
Implement databases conforming to all normal forms through BCNF
Skills you'll gain
This course includes:
PreRecorded video
Graded assignments, Exams
Access on Mobile, Tablet, Desktop
Limited Access access
Shareable certificate
Closed caption
Get a Completion Certificate
Share your certificate with prospective employers and your professional network on LinkedIn.
Created by
Provided by
Top companies offer this course to their employees
Top companies provide this course to enhance their employees' skills, ensuring they excel in handling complex projects and drive organizational success.
There are 4 modules in this course
The course provides comprehensive coverage of relational database design principles and best practices. Students learn to distinguish between physical and logical models, create detailed Entity Relationship Diagrams, develop Schema Diagrams, and implement databases in various normal forms. The curriculum emphasizes practical application of database normalization concepts from basic to advanced levels, ensuring students can design efficient and maintainable database systems.
Physical and Logical Models
Module 1
Entity Relationship Diagrams
Module 2
Schema Diagrams
Module 3
Database Normalization
Module 4
Fee Structure
Instructors
-1746721442565.webp&w=256&q=75)
6 Courses
Distinguished Leadership in Information Systems and Cybersecurity Education
Dr. C. Augusto Casas serves as a Senior Lecturer in the Online MS program at the University of Maryland Baltimore County (UMBC), bringing over two decades of higher education teaching experience in information systems and computer science. His career uniquely combines academic excellence with extensive industry experience, having worked on Supervisory Control and Data Acquisition (SCADA) systems for major oil and power utility companies across the Americas, the Middle East, and Southeast Asia. At UMBC, a designated Center for Academic Excellence in Cybersecurity, he specializes in cloud security and teaches courses focused on Amazon Web Services (AWS) and secure system deployment. His academic credentials include a PhD in Information Systems from Nova Southeastern University, with research focus in computational finance, and an MBA from the University of Connecticut. As a Certified Financial Planner (CFP®), he also brings expertise in financial technology (FinTech) to his teaching. His student-centered teaching philosophy emphasizes active learning techniques and effective online teaching methods, particularly in cybersecurity education where he helps prepare qualified professionals to address the increasing challenges of cyberattacks facing organizations globally.
3 Courses
Distinguished Leadership in Information Systems and Software Engineering
Dr. Michael Brown serves as a Professor of Practice in the Department of Information Systems at the University of Maryland Baltimore County (UMBC), bringing over two decades of industry experience to academia. His career began at Sun Microsystems as a Java Engineer before founding Valhalla Data Systems, which secured contracts with major government agencies. His professional journey includes significant work at the NASA/WVU Software Research Laboratory and technical management positions in business process automation at federal law enforcement agencies. As an educator, he has demonstrated exceptional teaching abilities across 14 universities over 20 years, earning the distinction of being the only person to receive two Effective Practice Awards from the Online Learning Consortium. His research focuses on artificial intelligence and software engineering, with over 30 published research papers. Dr. Brown's academic credentials include a PhD in Computer Science from Nova Southeastern University, along with both a Master's and Bachelor's degree in Computer Science and Mathematics from Shippensburg University. He is currently recognized as a Senior Member in both IEEE and ACM, and his contributions to academia were further acknowledged with a Fulbright grant in 2019, which led to research at General Tadeusz Kosciuszko Land Forces Military University in Wroclaw, Poland.
Testimonials
Testimonials and success stories are a testament to the quality of this program and its impact on your career and learning journey. Be the first to help others make an informed decision by sharing your review of the course.
Frequently asked questions
Below are some of the most commonly asked questions about this course. We aim to provide clear and concise answers to help you better understand the course content, structure, and any other relevant information. If you have any additional questions or if your question is not listed here, please don't hesitate to reach out to our support team for further assistance.