Sunday, September 21, 2008

Topical Table of 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


zippy1981 said...

I await entries in the Philosophy and Dogma segment. I especially await the discussions in the comment section of that.

Unknown said...

I just wanted to let you know how much I appreciate the work that your doing here. Great Job, and keep it up!

KenDowns said...

ben a: Thanks much!

Anonymous said...

Just want to add a note of thanks for this series. Your series is quite interesting and information.

Michael, still a datbase newb after five years

KenDowns said...

Michael P, I'm glad you find it useful!

Angela said...

Does anyone know how to append a unique document to a record. For example, scanned letters attached to different individuals.

KenDowns said...

Angela: the big debate is whether you should store the document itself in a "blob" field or on the filesystem. I fall into the filesystem crowd myself.

Your question might mean two things: How to design the tables, or how to program file uploads. Which is it?

Vertigo1 said...

I think this blog is a testamant to your excellent knowledge, your good character to share such a practical, easy to understand recounts of your experiences. Excellent work and please keep it up!


Javy said...

Good afternoon,

I am a post grad student seeking help with conducting an interview. I have no access to a DB programmer where I work and therfore I am looking for a volunteer to answer some questions regarging Mobile technologies and
Optimization Techniques.

As you all know with the use of cell phones to connect to a global world via the Internet, data continue to become more available, and thus, database designs have become more complex.

Therefore, there is a requirement to examine various function and checkpoints coding schemes. Having said that I hearby have some questions specifically for database programmers so I can gain an understanding of the coding schemes and connectivity rules for both stationary and mobile databases.

I would like to show the similarities and differences between stationary and mobile database designs, however, I do not know where to beging searching for these.

Here are my Proposed interview questions.

1. What type of DB did you program (stationary and/or mobile)?

2. If you built both types then would you comment on the similarities or differences that you found?

3. What coding scheme have you used in designing your DB?

4. Did you use connectivity rules? If so what were they? And why did you choose these and how did you utilized them?

5. Were there any rules that you would recommend using that you did not include in your DB?

6. With respect to connectivity rules again did you have any problems as a result of inefficient connectivity?

I appreciate your assistance. If you think of other questions please let me know.

Javy Medina

Mohamed Shajid said...

Thanks for your post bro. Make My Own Ebook

Mando said...

Hi there,I enjoy reading through your article post, I wanted to write a little comment to support you and wish you a good continuationAll the best for all your blogging efforts.

| armando manabu
| manabu mikami
| tkr dua
| mando manabu

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 )

Zencode said...

Nice Content
Cloud solutions provider
Custom application development company
Enterprise application development
Best mobile app development services
Ecommerce App Development Company