Practical Database Design – Blog Schema

Practical Database Design – Blog Schema, available at $44.99, has an average rating of 4.35, with 42 lectures, based on 33 reviews, and has 282 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginners, Developers, Students, and Enthusiasts new to relational database design It is particularly useful for Beginners, Developers, Students, and Enthusiasts new to relational database design.

Enroll now: Practical Database Design – Blog Schema

Summary

Title: Practical Database Design – Blog Schema

Price: $44.99

Average Rating: 4.35

Number of Lectures: 42

Number of Published Lectures: 42

Number of Curriculum Items: 42

Number of Published Curriculum Objects: 42

Original Price: $19.99

Quality Status: approved

Status: Live

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

Who Should Attend

Beginners, Developers, Students, and Enthusiasts new to relational database design

Target Audiences

Beginners, Developers, Students, and Enthusiasts new to relational database design

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Course Resources

Chapter 2: Relational Database Underpinning Knowledge

Lecture 1: Key Terminology: Databases, RDBMS, and the Data Lifecycle

Lecture 2: Key Terminology: Entity and Tables

Lecture 3: Key Terminology: Attributes and Fields

Lecture 4: Database Design Objectives

Chapter 3: Stage 1: Project Initiation

Lecture 1: Project Introduction: Designing a Blog Database

Chapter 4: Stage 2: Establishing Entities and Attributes

Lecture 1: Introducing the Entities

Lecture 2: Identifying Significant Entities

Lecture 3: Project: Approach 1 – Formulate the Preliminary Entity List

Lecture 4: Project: Lucid Chart

Lecture 5: Project: Approach 1 – Associate Attributes with Entities

Lecture 6: Project: Approach 2 – Identifying Entities from a List of Attributes

Lecture 7: Illustrating a Database Design – Entity Relationship Diagram (ERD)

Lecture 8: Table and Field Naming Convention [19]

Chapter 5: Stage 3: Refining the Table Structures

Lecture 1: Normalisation and 1NF

Lecture 2: Multivalued Fields

Lecture 3: Project: Identify and Resolve Multivalued Fields

Lecture 4: Multipart (composite) Fields

Lecture 5: Project: Identify and Resolve Multipart Fields

Chapter 6: Stage 4: Establishing Keys

Lecture 1: Table Keys

Lecture 2: Candidate Key

Lecture 3: Primary Key

Lecture 4: Project: Establishing Table Keys

Chapter 7: Stage 5: Dependency

Lecture 1: Dependency

Lecture 2: Normalization Second Normal Form (2NF)

Lecture 3: Partial Key Dependencies

Lecture 4: Project: Identify and Resolve Partial Key Dependencies

Chapter 8: Stage 6: Establishing Table Relationships

Lecture 1: Table Relationships

Lecture 2: Identifying Table Relationships

Lecture 3: One-to-Many

Lecture 4: Many-to-Many

Lecture 5: One-to-One

Lecture 6: Project: Establishing Table Relationships

Chapter 9: Stage 7: Normalization 3NF

Lecture 1: Normalization Third Normal Form (3NF)

Lecture 2: Transitive Dependency

Lecture 3: Project: Identity and Resolving Transitive Dependencies

Chapter 10: Stage 8: Expanding the Database Design

Lecture 1: Project Requirement: Capture User Actions

Lecture 2: Project Requirement: Alert to Any Objectionable Material by Flagging

Lecture 3: Project Requirement: Custom Post Attributes

Lecture 4: Project Requirement: Post Comments

Lecture 5: Project Requirement: Post Ratings

Instructors

Very Academy
Technical Education

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 5 votes
4 stars: 6 votes
5 stars: 21 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu