Back to the SSX Home Page.

This Page will help you get started by providing Tutorials at the three levels of Beginner, Intermediate and Advanced.

 1) Beginners
The aim at this point is to establish an understanding of the basic principles in the context of a specific Model.

Topics covered will include :-
Using a database schema to jumpstart building an application or Website 
Fundamentals of database schemas 

1.1 Choose the most interesting Data Model from the hundreds available
1.2 Go through the Tutorial for the specific Model you have chosen
1.3 Make sure that understand the basic principles, including :-
- Primary Keys, Foreign Keys, Tables and Views, Many-to-Many Relationships and Inheritance.

2) Intermediate
Topic covered will include :-
Customizing a database schema to meet your needs 

The aim at this point is to get you comfortable with 'mixing and matching' tables from different Models,
to produce something tailored to meet your specific requirements.
Use the Search facility to look for Models that contain specific Entities of Interest.
I will update the Entities in the search from my recent work on creating Top Ten Models in Themes with lists of Entities in each Model.

3) Advanced
Topics covered will include :-
Using Database Diagrams in SQL Server Express 
Building your own schemas 

The aim at this point is to make sure you understand the general principles in modelling any real-world situation.
Go through this Tutorial based on Generic Modelling and make sure you understand the principles.

Mark - here's an idea aimed at making everyone a Database Designer !
The Future : Database Design on Demand
- Build on the Search Facility
- Provide a drop-down list of Tables
- Let User choose his own selection of Tables of Interest.
- Use SQL Server Express DB Diagrammer to display tailored Diagrams with selected Tables
- Use a new 'Intelligent Diagrammer' to validate Model.
- User can take away and/or print his tailored Database Diagram.