Database Lesson #4 of 8 - Data Modeling and the ER Model - - vimore.org

Database Lesson #4 of 8 - Data Modeling and the ER Model

Database Lesson #4 of 8 - Data Modeling and the ER Model

YouTube

Dr. Soper gives a lecture on data modeling and the entity-relationship (ER) model. Topics include the components of ER models, depicting entities, attributes, relationships, and cardinalities in ER models, one-to-one, one-to-many, and many-to-many relationships, strong and weak entities, identifying and non-identifying relationships, supertypes and subtypes, and recursive relationships in data models.



Database Lesson #5 of 8 - Database Design

Dr. Soper gives a lecture on database design. Topics include transforming ER data models into physical database designs, denormalization, implementing one-to-on

YouTube

Database Lesson #3 of 8 - The Structured Query Language (SQL)

Dr. Soper gives a lecture on using the structured query language (SQL) to work with databases. Topics include CREATE, ALTER, and DROP statements, SELECT, INSERT

YouTube

Database Lesson #6 of 8 - Database Administration

Dr. Soper gives a lecture on database administration. Topics covered include concurrent access / concurrency control, database security, database backup and rec

YouTube

Video 3: Supertype/subtype Hierarchies

Supertype/subtype hierarchies alllow you to model attributes common to some entities, but also model their differences as well. The approach allows you to diff

YouTube

How to Draw a Data Flow Diagram

This KnowledgeKnugget™ is an overview of Data Flow Diagrams. If you want to learn step by step how to create Data Flow Diagrams (DFDs), Context-level DFDs, and

YouTube

Normalisation 1NF: Understanding and applying First Normal Form

Hopefully the definitive video tutorial for First Normal Form, complete worked example using a spreadsheet. I use this type of spreadhseet with my students when

YouTube

Database Fundamentals

Learn about the fundamentals of databases. What are entities, attributes, relationships, primary keys, and foreign keys? This video covers the basics.

YouTube

Types of Numbers

Dr. Soper provides an overview of the various types of numbers. Topics covered include natural numbers, zero, negative integers, integer and non-integer numbers

YouTube

Database - Database CARDINALITY [ with examples ]

Database - Database CARDINALITY [ with examples ]

YouTube

Database Lesson #7 of 8 - Database Indexes

Dr. Soper gives a lecture on database indexes. Topics covered include index concepts, linear vs. binary search strategies, estimating index storage space requir

YouTube

What is an ER diagram? How to make an ERD? What are ERD symbols?

ER diagrams illustrate the logical structure of databases. An ER diagram is a means of visualizing how the information a system produces is related. There are f

YouTube

Database Lesson #1 of 8 - Introduction to Databases

Dr. Soper gives an introductory lecture on database technologies. Topics covered include the reasons for using a database, the components of a database system,

YouTube

What is Dimensional Modeling

Description – Dimensional modeling is set of guidelines to design database table structure for easier and faster data retrieval. It is widely accepted techniqu

YouTube

Erwin Data Modeler Tutorial | Erwin Training

Erwin Data Modeler Tutorial http://kerneltraining.com/all-courses/ Oracle Apps Technical R12 Database Tutorial http://kerneltraining.com/all-courses/ Thanks f

YouTube

Conceptual Data Modeling Explained

This video explains conceptual data modeling. We'll explore the purpose of concepual data modeling and then show how to create crow's foot entity-relationship d

YouTube

Entity Relationship Diagram (ERD) Tutorial - Part 1

Learn how to create an Entity Relationship Diagram in this tutorial. We provide a basic overview of ERDs and then gives step-by-step training on how to make an

YouTube

Database Lesson #2 of 8 - The Relational Model

Dr. Soper gives a lecture on the relational model and its role in the database world. Topics include relations, primary keys, composite keys, foreign keys, norm

YouTube

Barry's Tutorial on understanding a Database Schema

A 15 minute version of this Tutorial is available on the Microsoft Web Site at this page :- http://msdn2.microsoft.com/en-gb/express/bb403186.aspx and is al

YouTube