Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Master relational database design from fundamentals to advanced concepts in this comprehensive 5 hour 55 minute course covering an 8-week curriculum. Begin with SQL basics including tables, entities, keys, filtering, aggregation, and JOIN operations, then progress through the complete database design lifecycle from conceptualizing real-world problems to implementing robust database solutions. Explore entity-relationship modeling techniques including one-to-one, one-to-many, and many-to-many relationships, while distinguishing between strong and weak entities. Dive deep into database normalization through all normal forms from First Normal Form (1NF) to Boyce-Codd Normal Form (BCNF), understanding primary keys, atomic values, functional dependencies, and transitive dependencies. Learn critical data type selection including proper string types, floating-point considerations, and date/time handling to avoid costly mistakes. Understand various constraint types including primary keys, unique constraints, foreign key constraints with CASCADE options, NOT NULL, DEFAULT, and CHECK constraints. Examine security considerations through access control, hashing, and encryption techniques. Optimize database performance through indexing strategies comparing B-Tree and full-text indexes, and learn when denormalization is appropriate. Access supplementary materials including weekly schedules, quizzes, and hands-on assignments through the accompanying GitHub repository, with content based on the forthcoming Manning Publications book "Grokking Relational Database Design" by Dr. Qiang Hao and Dr. Michael Tsikerdekis.
