DATABASE INTRODUCTION AND TUTORIALS

SQL TUTORIALS AND ONLINE TUTORS

Learning SQL is not as difficult as it sounds. Especially, as there exist interactive online tutorials who forgive you any mistake.

• SQL Tutorial & Interpreter w/ Live Practice Database (An interactive tutorial!)

• Introduction to Structured Query Language (A nice tutorial for beginners)

• SQL Basics for a Data Processing Environment (Tutorial with some code samples..)

• SQL Terms and Concepts (Detailed: The Data Model, Tables, Columns & Occurrences, Foreign Keys, Indexes, Data Dictionary, Null Values!)

• Using the Group By Clause ("..While most developers are familiar with the basic SQL syntax for constructing SELECT statements, many folks have rarely, if ever, used one of the more powerful clauses of the SELECT statement: Group By. I think the reason of this lack of use of this clause is two-fold.." - Tutorial)

• SQL Statements Tutorial (A nice, quick overview)

• A Practical SQL Tutorial (Tutorial)

• The Case for the Surrogate Key (Tutorial)

• The great primary-key debate ("..By definition, a relational database must contain normalized tables, and to be properly normalized, a table must contain a primary key..")

• and more....

DATABASE NORMALIZATION TUTORIALS

Correct database management cannot be mastered without understanding the database normalization process. Below are some very good tutorials teaching exactly this:

• Database Normalization (Tutorial, 3/00)

• Database Normalization: Definitions (Detailed)

• Normalization (1st and 2nd Norms)

• Data Normalization - A Primer (Introduction)

• Database normalization (Sample cases to do the Exercise)

• Determining Database Tables and Relationships (Tutorial)

• Database-Management Principles And Applications - Overview of Normalization (Detailed, with samples)

• Database-Management Principles And Applications - Overview of Normalization (Detailed, with samples)

• Normalization Is a Nice Theory ("..Designing a normalized database structure is the first step when building a database that is meant to last. Normalization is a simple, commonsense, process that leads to flexible, efficient, maintainable database structures. We'll examine the major principles

• Database Design and Performance

• Database Normalization (Second and Third Normal Forms)

• SQL Reference and Example Site

• and more...

DATABASE NORMALIZATION TUTORIALS

Nothing can teach database normalization as well as own exercises. Here are some samples and the results

• Normalization Exercise (Sample of the normalization process for a purchase order)

• Normalization Exercise (Manufacturing)

• Normalization Example ("...Process of RDBMS, Relational Database Management System..")

• and more...

Step1: Fill out the form below and click "Request Letter Now!". Subscribe optionally to our free Internet LinkAdvisor Journal. Very recommend to keep you up-to-date
Step2: An autoresponder email with the current topic and contents of this letter will be sent to you immediately!