data modeling - relational data tutorial

Free Relational Database Tutorial
and Tips For Beginners!

Intro To Data Modeling - By Alex Glaros

Welcome to my online intro training class on how to design files for a relational database system. You can learn how to design files to accurately reflect almost any business problem. This is called modeling the data.

Here's the dilemma: Real world business problems can't be represented with simple lists of information.

Relational databases can accurately model all kinds of problems. But, using them is not intuitive, at least not at first!

I find it somehow comforting that the relational database idea is not some passing-fad theory but actually based on relational algebra. Its based on solid math concepts that make your information work for you in the most efficient manner possible. Relational databases will always be with us! But don't worry, there won't be any complicated math!

I've taught many people how to design data files and discovered that there's two ways people learn. By: (1) using rules or (2) intuition. Beginners with math blocks can learn intuitively just as fast or faster than skilled computer programmers!

Click here to continue


Data Modeling Essentials : Analysis, Design, and Innovation Data 
      Modeling Essentials : Analysis, Design, and Innovation An innovative "how-to" guide and design aid to data modeling. This book discusses the theory and practice of data modeling as a design activity, and shows the reader how to increase quality and stimulate creativity with new modeling approaches. The book is useful as both a basic learning tool, and a thought provoking guide to higher achievement in designing and executing data models.
Data Modeling for Information ProfessionalsData Modeling for Information Professionals Explains to members of a project team creating an information system, especially a computerized system, how to structure data. Discusses such aspects as what data models are, what makes them successful and fail, the components of an enterprise data model, domains, predicates, entities, classes, relationships, and attributes. The CD-ROM contains two full-function CASE repositories developed during the redesign of a travel tour company.
Search Now:
In Association with Amazon.com



Find all books and videos related to relational databases at Amazon!

Search Now:
In Association with Amazon.com

Lesson 1, 2, 3, 4

Database Design for Mere Mortals : A Hands-On Guide to Relational Database Design

Database Design for Mere Mortals : A Hands-On Guide to Relational Database Design

Relational Database Design for Mere Mortals explains the concepts of relational-database design in an easy-to-digest fashion that covers both the theoretical underpinnings and their practical implications. Hernandez covers all the basics--table and field structure, keys, relationships, business rules, and more--but always keeps his feet on the ground with advice for real-world implementations and a particularly strong section on analyzing your current database infrastructure.


Designing Relational Database Systems

Designing 
        Relational Database Systems

Designing Relational Database Systems has struck an attractive balance between the two extremes by providing enough theory to enable you to design your databases intelligently, while keeping in mind real-world business practices and the practical limitations of actual database management systems. Topics covered: The theory and practice of designing relational databases and their management systems. The author explains tables and their relationships, queries, business logic, database schema, and interface design.

E-mail