Practical Database Design - Blog Schema

Database Theory and Practical Application

4.50 (26 reviews)
Udemy
platform
English
language
Databases
category
instructor
Practical Database Design - Blog Schema
256
students
5.5 hours
content
Jan 2023
last update
$44.99
regular price

What you will learn

Build a database design from a given set of requirements

Determine a set of prelimiary entities and attributes to start a database design

Normalise a database design into 1NF taking into consideration multivalued and miltipart fields

Establish table candidate and primary keys

Normalise a database design into 2NF taking into consideration partial key dependencies

Identify multiple types of table relationships and define relationships between tables

Normalise a database design into 3NF taking into consideration transitive dependencies

Develop database design solutions to common features of a blog application

Description

Databases or relational database systems have always been a subject with a "steep learning curve". Students tend to find it challenging, and learning takes much more effort than other subjects.

To my surprise, I am one of many people who have observed this trend. There is, in fact, a small niche of research papers written on this topic.

So why is it so challenging? When I think of how we might overcome some challenges when learning databases instantly, I think of one fact that remains true, which goes back to even when I started learning database systems. There needed to be more examples or actual database design in practice.

This course aims to help support anyone starting their journey into relational database systems by establishing underpinning skills and concepts of database and database design by working through practical scenario reasoning and providing the rationale to design decisions. Nothing beats experience in most subjects. That is amplified in the realms of relational database development. With the knowledge and experience gained in the course in hand, I hope that on completion of this course, it will provide the scaffolding, underpinning knowledge to support your endeavours in the world of relational database development.

Content

Introduction

Introduction
Course Resources

Relational Database Underpinning Knowledge

Key Terminology: Databases, RDBMS, and the Data Lifecycle
Key Terminology: Entity and Tables
Key Terminology: Attributes and Fields
Database Design Objectives

Stage 1: Project Initiation

Project Introduction: Designing a Blog Database

Stage 2: Establishing Entities and Attributes

Introducing the Entities
Identifying Significant Entities
Project: Approach 1 – Formulate the Preliminary Entity List
Project: Lucid Chart
Project: Approach 1 – Associate Attributes with Entities
Project: Approach 2 – Identifying Entities from a List of Attributes
Illustrating a Database Design – Entity Relationship Diagram (ERD)
Table and Field Naming Convention [19]

Stage 3: Refining the Table Structures

Normalisation and 1NF
Multivalued Fields
Project: Identify and Resolve Multivalued Fields
Multipart (composite) Fields
Project: Identify and Resolve Multipart Fields

Stage 4: Establishing Keys

Table Keys
Candidate Key
Primary Key
Project: Establishing Table Keys

Stage 5: Dependency

Dependency
Normalization Second Normal Form (2NF)
Partial Key Dependencies
Project: Identify and Resolve Partial Key Dependencies

Stage 6: Establishing Table Relationships

Table Relationships
Identifying Table Relationships
One-to-Many
Many-to-Many
One-to-One
Project: Establishing Table Relationships

Stage 7: Normalization 3NF

Normalization Third Normal Form (3NF)
Transitive Dependency
Project: Identity and Resolving Transitive Dependencies

Stage 8: Expanding the Database Design

Project Requirement: Capture User Actions
Project Requirement: Alert to Any Objectionable Material by Flagging
Project Requirement: Custom Post Attributes
Project Requirement: Post Comments
Project Requirement: Post Ratings

Reviews

Mikael
October 1, 2023
Really good course, loved it, Zander was sharing his thought process and different design approaches one could take.
Carlos
April 10, 2023
I took this course as a refresh. I have a Certificate of Relational Databases but never worked in a relational Database Environment. Boy, glad i did it! The course starts with a definition of what is a Database, the relational approach, different types of relational databases, etc. Then he starts to identify the entities(tables) using the functional requirements. This part alone is worth the price of the course. The function of each entity and the fields that they should contains alone with their type(numeric, text, etc.) After that comes the first normal formal, second normal form and third normal form, table relationships and so on. The explanations are clear and to the point but..... Relational Databases are not easy to swallow, so be prepared to read the transcripts 2 or 3 times. to really understand the concept. He even covers the ERD (Entity Relational Diagram). The course last 5.5 hours but it took me about 8 hours to complete the course because i have to go back and read the transcript or see the video again. I gave a rating of 4.5 because i was expecting a deeper explanation of the ERD diagrams, but maybe my expectations were too high. Excellent course, great content and a very knowledgeable tutor.
Kakon
March 13, 2023
He is an amazing tutor.I have been his fan since long now . I have been watching his tutorials from youtube for last 2-3 years now.

Charts

Price

Practical Database Design - Blog Schema - Price chart

Rating

Practical Database Design - Blog Schema - Ratings chart

Enrollment distribution

Practical Database Design - Blog Schema - Distribution chart

Related Topics

5102020
udemy ID
1/21/2023
course created date
2/4/2023
course indexed date
kokku
course submited by