Learn more about SQL Server tools

mssqltips logo
giveaway
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Database Development Tutorial



By:

Overview

Many databases are initially developed by professionals not deeply experienced in database development. In a lot of instances, an application engineer is drafted with the task of designing a table or database due to the lack of an available database resource. Unfortunately, sometimes working outside one's area of expertise can sometimes lead to making technical decisions that are later discovered to be less than optimal.

Explanation

The goal of this tutorial is to help non-database and database professionals alike recognize sound development practices and to recognize practices and techniques that could lead to future technical headaches.

With this goal in mind, the following topics will be examined:

  • Logical Design
  • Defining Data Types and Sizes
  • Defining a Primary Key
  • Defining a Clustered Index
  • Defining Constraints
  • Choosing Non-Clustered Indexes
  • Prepared Queries and Stored Procedures
  • Querying in Sets
  • Preventing Index Nullification
  • Temporary Tables and Table Variables
  • Working With Triggers





More SQL Server Solutions











Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


SQL tips:

*Enter Code refresh code     



Learn more about SQL Server tools