Out of all the tech subjects I have lectured on, databases or relational database systems have always been a subject with a “steep learning curve”. Students tend to find it challenging, and it just takes much more effort to learn 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
Requirements
No Prior experience needed but would be advantageous
[TutsNode.net] - Practical Database Design Blog Schema/10 - Stage 8 Expanding the Database Design/38 - Project Requirement Capture User Actions.mp4
80.1 MB
[TutsNode.net] - Practical Database Design Blog Schema/10 - Stage 8 Expanding the Database Design/39 - Project Requirement Alert to Any Objectionable Material by Flagging.mp4
76 MB
[TutsNode.net] - Practical Database Design Blog Schema/10 - Stage 8 Expanding the Database Design/40 - Project Requirement Custom Post Attributes.mp4
32.3 MB
[TutsNode.net] - Practical Database Design Blog Schema/10 - Stage 8 Expanding the Database Design/41 - Project Requirement Post Comments.mp4
75 MB
[TutsNode.net] - Practical Database Design Blog Schema/10 - Stage 8 Expanding the Database Design/42 - Project Requirement Post Ratings.mp4
30.3 MB
[TutsNode.net] - Practical Database Design Blog Schema/2 - Relational Database Underpinning Knowledge/3 - Key Terminology Databases RDBMS and the Data Lifecycle.mp4
34.3 MB
[TutsNode.net] - Practical Database Design Blog Schema/2 - Relational Database Underpinning Knowledge/4 - Key Terminology Entity and Tables.mp4
8.3 MB
[TutsNode.net] - Practical Database Design Blog Schema/2 - Relational Database Underpinning Knowledge/5 - Key Terminology Attributes and Fields.mp4
[TutsNode.net] - Practical Database Design Blog Schema/3 - Stage 1 Project Initiation/7 - Project Introduction Designing a Blog Database.mp4
20.6 MB
[TutsNode.net] - Practical Database Design Blog Schema/4 - Stage 2 Establishing Entities and Attributes/10 - Project Approach 1 Formulate the Preliminary Entity List.mp4
146.9 MB
[TutsNode.net] - Practical Database Design Blog Schema/4 - Stage 2 Establishing Entities and Attributes/11 - Project Lucid Chart.mp4
23 MB
[TutsNode.net] - Practical Database Design Blog Schema/4 - Stage 2 Establishing Entities and Attributes/12 - Project Approach 1 Associate Attributes with Entities.mp4
59.4 MB
[TutsNode.net] - Practical Database Design Blog Schema/4 - Stage 2 Establishing Entities and Attributes/13 - Project Approach 2 Identifying Entities from a List of Attributes.mp4
38.4 MB
[TutsNode.net] - Practical Database Design Blog Schema/4 - Stage 2 Establishing Entities and Attributes/14 - Illustrating a Database Design Entity Relationship Diagram ERD.mp4
31.8 MB
[TutsNode.net] - Practical Database Design Blog Schema/4 - Stage 2 Establishing Entities and Attributes/15 - Table and Field Naming Convention 19.mp4
46.9 MB
[TutsNode.net] - Practical Database Design Blog Schema/4 - Stage 2 Establishing Entities and Attributes/8 - Introducing the Entities.mp4
24.5 MB
[TutsNode.net] - Practical Database Design Blog Schema/4 - Stage 2 Establishing Entities and Attributes/9 - Identifying Significant Entities.mp4
23.1 MB
[TutsNode.net] - Practical Database Design Blog Schema/5 - Stage 3 Refining the Table Structures/16 - Normalisation and 1NF.mp4
28.1 MB
[TutsNode.net] - Practical Database Design Blog Schema/5 - Stage 3 Refining the Table Structures/17 - Multivalued Fields.mp4
23.7 MB
[TutsNode.net] - Practical Database Design Blog Schema/5 - Stage 3 Refining the Table Structures/18 - Project Identify and Resolve Multivalued Fields.mp4
28.6 MB
[TutsNode.net] - Practical Database Design Blog Schema/5 - Stage 3 Refining the Table Structures/19 - Multipart composite Fields.mp4
19.5 MB
[TutsNode.net] - Practical Database Design Blog Schema/5 - Stage 3 Refining the Table Structures/20 - Project Identify and Resolve Multipart Fields.mp4