This posting will be updated each week to contain a complete table of contents for the Database Skills series.
Superseded
This table of contents has been superseded by our new Comprehensive Table of Contents. The new table includes slots for future topics. Please update your bookmarks.
Subseries 1: Table Design Basics
The first group of posts introduces the must-know terms and techniques for table design.
- Introduction
- Primary Keys
- Foreign Keys
- First Normal Form
- Second Normal Form
- Third Normal Form and Calculated Values
- Of Tables and Constraints
Subseries 2: Table Design Patterns
The second subseries details commonly occurring patterns in table design, how to recognize them and when to use them.
There is a complete List of Table Design Patterns. The rest of the entries are:
- A Sane Approach To Choosing Primary Keys
- Different Foreign Keys for Different Primary Keys
- Cross Reference Validation Pattern
- Limited Transaction Pattern
- False Patterns and the Reverse Foreign Key
- The Primary Key That Wasn't: Impermanent Primary Keys
- Resolutions (Also listed in Queries below)
- Denormalization Patterns
- History Tables
- Sequencing Dependencies
- Secure Password Resets
Subseries 3: Development Tools and Procedures
- The Framework And The Database
- Table Structure Changes
- Bad Requirements and Iterative Database Development
Subseries 4: Queries
- Introduction To Queries
- The JOIN is the Cornerstone of Powerful Queries
- How SQL UNION Affects Table Design
- GROUP BY, HAVING, SUM, AVG and COUNT(*)
- Joins Part Two, The Many Forms of JOIN
- Resolutions (Also listed in Table Designs Above)
Subseries 5: System Architecture
- Minimize Code, Maximize Data
- Using a Data Dictionary
- Why I Do Not Use ORM
- The Wonderful Awful Browser
6 comments:
I'm trying to keep up, I think your articles are great, they are helping me learn the big picture.
Do you have a zip file of your commands that I could do rather than the code being interspersed within the blog?
Maybe you could provide a link.
Thx!
Anonymous: at present I have no combined code file because the examples are fairly independent. Each example is meant to teach only one topic, so they do not necessarily fit together as a whole. This is why a source file would not be useful.
Yesterday I was looking at http://www.andromeda-project.org/ and today it's content changed drastically, it seems that the site was hacked !
Or have you changed it for some reason !
Thanks for your attention !
Mediator: thanks for the heads-up. The site was moved to a new server yesterday afternoon and the virtual host setting was fouled up. I went in and fixed it. Thanks again for letting me know.
I've just installed Andromeda and all went well but now I have the login screen but the database is empty and there are no users on the database table users.
How it's supposed to start using Andromeda ?
Command line, inserting users through pgadmin3 ?
Also I've tryed send an email with this to andromeda@secdat.com but it's rejected, probably still a problem with the setup of your new hosting.
Mediador: I am glad you are trying out Andromeda, and I'd like to help. Community support is available on the sourceforge mailing lists at https://lists.sourceforge.net/lists/listinfo/andro-general
Generally I look at stuff there in the afternoon (US Eastern Time).
Post a Comment