|
|||
Data ModelingWelcome Welcome Prerequisites for this Course About this Course Where to Find Documentation Samples and Example Data Models Part pt. 1 Samples and Example Data Models Part pt. 2 A Relational Database Modeling Tool ERWin: Changing Physical Structure ERWin: Generating Scripts The History of Data Modeling What is a Data Model? Types of Data Models The Evolution of Data Modeling File Systems Hierarchical Databases Network Databases Relational Databases Object Databases Object-Relational Databases The History of the Relational Database Tools for Data Modeling Entity Relationship Diagrams Using ERWin Part pt. 1 Using ERWin Part pt. 2 Using ERWin Part pt. 3 Modeling in Microsoft Access The Parts of an Object Data Model Basic UML for Object Databases Building Class Structures Other UML Diagrams Introducing Data ModelingThe Relational Data ModelThe Object Data Model The Object-Relational Data Model Data Warehouse Data Modeling Client-Server Versus OLTP Databases Available Database Engines Relational Data ModelingWhat is Normalization?Normalization Made Simple Relational Terms and Jargon 1st Normal Form Demonstrating 1st Normal Form 2nd Normal Form Demonstrating 2nd Normal Form 3rd Normal Form Demonstrating 3rd Normal Form 4th and 5th Normal Forms Primary/Foreign Keys/Referential Integrity The Traditional Relational Database Model Surrogate Keys and the Relational Model Denormalization pt. 1 Denormalization pt. 2 Object Data ModelingThe Object-Relational Database ModelRelational Versus Object Models What is the Object Data Model? What is a Class? Again - a Class and an Object What is an Attribute? What is a Method? The Simplicity of Objects What is Inheritance? What is Multiple Inheritance? Some Specifics of the Object Data Model Data Warehouse Data ModelingThe Origin of Data WarehousesWhy the Relational Model Fails The Dimensional Data Model Part pt. 1 The Dimensional Data Model Part pt. 2 Star Schemas and Snowflake Schemas Data Warehouse Model Design Basics Getting Data from a DatabaseWhat is Structured Query Language (SQL)?The Roots of SQL Queries Changing Data Changing Metadata What is ODQL? Tuning a Relational Data ModelNormalization Versus DenormalizatrionReferential Integrity Part pt. 1 Referential Integrity Part pt. 2 Alternate Keys What is an Index? Indexing Considerations Too Many Indexes Composite Indexing Which Columns to Index? Index Types Match Indexes to SQL Code Types of Indexing in Detail pt. 1 Types of Indexing in Detail pt. 2 Where Index Types Apply Undoing Normalization What to Look For? Undoing Normal Forms Some Good and Bad Tricks Part pt. 1 Some Good and Bad Tricks Part pt. 2 Tuning a Data Warehouse Data ModelDenormalizationStar Versus Snowflake Schemas Dimensional Hierarchies Specialized Data Warehouse Toys Other TricksRAID Arrays and StripingStandby Databases Replication Clustering Wrapping it UpSome Available Database EnginesThe Future: Relational or Object? What You Have Learned CreditsAbout the Author |