Practical Database Design - Blog Schema

Focused View

Very Academy

5:32:47

111 View

1 - Introduction

1 - Introduction.mp4

05:20

2 - Course Resources.html

2 - Specification.docx

2 - Relational Database Underpinning Knowledge

3 - Key Terminology Databases RDBMS and the Data Lifecycle.mp4

11:00

4 - Key Terminology Entity and Tables.mp4

02:53

5 - Key Terminology Attributes and Fields.mp4

05:36

6 - Database Design Objectives.mp4

13:45

3 - Stage 1 Project Initiation

7 - Project Introduction Designing a Blog Database.mp4

02:30

4 - Stage 2 Establishing Entities and Attributes

8 - Introducing the Entities.mp4

07:18

9 - Identifying Significant Entities.mp4

08:12

10 - Project Approach 1 Formulate the Preliminary Entity List.mp4

16:51

11 - Project Lucid Chart.mp4

03:07

12 - Project Approach 1 Associate Attributes with Entities.mp4

09:45

13 - Project Approach 2 Identifying Entities from a List of Attributes.mp4

07:06

14 - Illustrating a Database Design Entity Relationship Diagram ERD.mp4

05:57

15 - Table and Field Naming Convention 19.mp4

12:54

5 - Stage 3 Refining the Table Structures

16 - Normalisation and 1NF.mp4

08:00

17 - Multivalued Fields.mp4

06:30

18 - Project Identify and Resolve Multivalued Fields.mp4

07:35

19 - Multipart composite Fields.mp4

05:54

20 - Project Identify and Resolve Multipart Fields.mp4

01:27

6 - Stage 4 Establishing Keys

21 - Table Keys.mp4

04:46

22 - Candidate Key.mp4

15:18

23 - Primary Key.mp4

04:47

24 - Project Establishing Table Keys.mp4

10:47

7 - Stage 5 Dependency

25 - Dependency.mp4

07:25

26 - Normalization Second Normal Form 2NF.mp4

04:02

27 - Partial Key Dependencies.mp4

06:22

28 - Project Identify and Resolve Partial Key Dependencies.mp4

02:40

8 - Stage 6 Establishing Table Relationships

29 - Table Relationships.mp4

04:45

30 - Identifying Table Relationships.mp4

17:27

31 - OnetoMany.mp4

13:29

32 - ManytoMany.mp4

07:08

33 - OnetoOne.mp4

06:16

34 - Project Establishing Table Relationships.mp4

13:38

9 - Stage 7 Normalization 3NF

35 - Normalization Third Normal Form 3NF.mp4

01:58

36 - Transitive Dependency.mp4

05:43

37 - Project Identity and Resolving Transitive Dependencies.mp4

07:02

10 - Stage 8 Expanding the Database Design

38 - Project Requirement Capture User Actions.mp4

17:45

39 - Project Requirement Alert to Any Objectionable Material by Flagging.mp4

14:25

40 - Project Requirement Custom Post Attributes.mp4

05:55

41 - Project Requirement Post Comments.mp4

14:25

42 - Project Requirement Post Ratings.mp4

05:04

Description

Database Theory and Practical Application

What You'll 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 is this for?

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

More details

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.
Who this course is for:
Beginners, Developers, Students, and Enthusiasts new to relational database design

User Reviews

Rating

average 0

Total votes0

Focused display

Database Design

Very Academy

Instructor's Courses

Very Academy is an online education provider that offers a vast and ever-growing catalogue of tutorials and courses. Very Academy's mission is to provide universally accessible, highest quality Computer Science and Technology education. By providing you with the most relevant, highest-quality learning experiences to support your learning, we hope to help foster students into global competent professionals in the field of Computer Science and Technology.We hope you enjoy our courses and hope to bring you much more in the future. Don't forget to check out the Very Academy YouTube channel for more helpful tutorials.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.