Monday, December 17, 2007

Database Skills: Complete Contents

This posting is updated whenever a new post goes up.

There is a also a Skills-oriented Table Of Contents. It is not as complete as this list, which lists all posts, but it is more centered on links as they relate to skills.

If you want some free analysis, why not submit your schema to the Database Programmer? If you are willing to discuss your issues with a bit of public exposure, I will provide free analysis, and everybody can benefit!

User-Submitted Analysis Topic: Email

The Application Stack

Table Design Basics: Keys, Normalization, Denormalization

The first group of posts introduces the must-know terms and techniques for table design.

It might be a good idea to start with The Relational Model.

Following up on the normal forms are some basic discussions of normalization and denormalization.

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:

SQL SELECT and Queries

Algorithms and Processes

Server-Side Code


Development Cycle


Data Dictionary

Many of these posts are listed elsewhere in this table of contents, but I wanted to have them altogether in one place as well.



The Browser


Anonymous said...

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.


KenDowns said...

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.

mingodad said...

Yesterday I was looking at 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 !

KenDowns said...

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.

mingodad said...

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 but it's rejected, probably still a problem with the setup of your new hosting.

KenDowns said...

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

Generally I look at stuff there in the afternoon (US Eastern Time).

Stress Management Training said...

Hey thanks a lot for sharing the stuff with us. It is really a worthy stuff for beginner like me. Thanks again for it.

Unknown said...

Take advantage of every opportunity to practice your communication skills so that when important occasions arise, you will have the gift, the style, the sharpness, the clarity, and the emotions to affect other people. See the link below for more info.


The Marketer said...

I enjoyed your blog Thanks for sharing such an informative post. We are also providing the best services click on below links to visit our website.

digital marketing company in nagercoil
digital marketing services in nagercoil
digital marketing agency in nagercoil
best marketing services in nagercoil
SEO company in nagercoil
SEO services in nagercoil
social media marketing in nagercoil
social media company in nagercoil
PPC services in nagercoil
digital marketing company in velachery
digital marketing company in velachery
digital marketing services in velachery
digital marketing agency in velachery
SEO company in velachery
SEO services in velachery
social media marketing in velachery
social media company in velachery
PPC services in velachery
online advertisement services in velachery
online advertisement services in nagercoil

web design company in nagercoil
web development company in nagercoil
website design company in nagercoil
website development company in nagercoil
web designing company in nagercoil
website designing company in nagercoil
best web design company in nagercoil
web design company in velachery
web development company in velachery
website design company in velachery
website development company in velachery
web designing company in velachery
website designing company in velachery
best web design company in velachery

Thanks for Sharing - ( Groarz branding solutions )