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 )

Susan said...

Thanks for the nice blog. It was very useful for me. I'm happy I found this blog. Thank you for sharing with us,I too always learn something new from your post. Eminem is an American rapper and one of the most successful artists in hip-hop. As of 2020, Eminem net worth is now estimated to be $230 million.

aditya said...

Great to read article about berry update which i like reading about it.You have made an excellent effort in making this website which is appreciable. appvalley vip Sydney Brooke Simpson cotomovies streaming app

nirjonniyaz said...

토토사이트검증 토토 먹튀 검증 저희 먹튀커머스 는 2016년 5월 부터 지금까지 먹튀커머스 를 믿고 방문 해주시는 유저 분들을 위해 더이상 먹튀 없는 공정한 배팅 문화 를 만들기 위해서 항상 노력하고 유저분들에 소리에 귀를 기울리는 NO.1 먹튀검증 커뮤니티 입니다. 또한 먹튀커머스 에서는 무분별한 배팅사이트 들을 일방적으로 추천 하지 않고 철저한 검수 작업을 토대로 사전에 먹튀 사고가 발생 안되게끔 유저 분들 에게 추천하는 만큼 저희측에 등록 되어 있는 배팅사이트 내에서 혹여 먹튀가 발생 한다면 오로지 그책임은 저희 먹튀커머스 에 있음을 알려 드립니다. / 먹튀 검증

ed treatment tablets said...

This is very interesting, You are a very skilled blogger. I've joined your rss feed and look forward to seeking more of your excellent post. Also, I've shared your site in my social networks!

best ed pills said...

Every weekend i used to pay a visit this site, as i want enjoyment, as this this site conations really pleasant funny material too.

SeoMaster789 said...

In this article understand the most important thing, the item will give you a keyword rich link a great useful website page 먹튀검증

SeoMaster789 said...

이것은 매우 흥미 롭습니다. 먹튀검증

SeoMaster789 said...

Hello I really like your post and I think that it's curious. I would like to use it in my article. Is it possible? Of course, I will write a source 토토사이트

온라인포커 said...

The assignment submission period was over and I was nervous, 온라인포커 and I am very happy to see your post just in time and it was a great help. Thank you ! Leave your blog address below. Please visit me anytime.

GOGOLIVE said...

First of all, thank you for letting me see this information. I think this article can give me a lot of inspiration. I would appreciate 바둑이사이트 if you could post more good contents in the future.

ádccdvfvsd said...

Hello. I'm subscribed to your posts. You inspire me a lot.카지노사이트I am so grateful.

seomaster said...

The assignment submission period was over and I was nervous, 메이저놀이터 and I am very happy to see your post just in time and it was a great help. Thank you ! Leave your blog address below. Please visit me anytime.

sooji001 said...

I simply want to say I am just newbie to blogging and honestly savored your web page.

안전놀이터 said...

We are looking for a lot of data on this item. In the meantime, this is the perfect article I was looking for . Please post a lot about items related to 안전놀이터추천!!! I am waiting for your article. And when you are having difficulty writing articles, I think you can get a lot of help by visiting my .

aditya said...

Good post thanks for share information.
minecraft optifine

메이저놀이터 said...

you'll be able to dive head first into 메이저놀이터추천 this project and work quickly and things will still come out well.