Microsoft SQL Server Database Development
Microsoft SQL Server 2008

Microsoft SQL Server is a computer application used to create desktop, enterprise, and web-based database applications. It is used at different levels and with various goals. This web site provides lessons and topics on how to use Microsoft SQL Server 2008 to create and manage databases.

Table of Contents
 

Databases

Tables

Views
CREATE DATABASE CREATE TABLE CREATE VIEW
DROP DATABASE DROP TABLE ALTER VIEW
Renaming Renaming DROP VIEW
    Creating a Record

Columns

Users

Triggers
Create a Primary Key CREATE USER CREATE TRIGGER
Create Foreign Key GRANT Permission ALTER TRIGGER
Adding a Column DENY Permission DROP TRIGGER
Identity Column REVOKE Permission  
Deleting a Column WITH GRANT

Schemas
Renaming a Column   Creating a Schema

Records Operations
Creating a Record Default Value Allow/Disallow null
Updating a Record Expression Unique Values
Deleting a Record    

Index

Functions

Stored Procedures
CREATE INDEX CREATE FUNCTION CREATE PROCEDURE
DROP INDEX DROP FUNCTION ALTER PROCEDURE
DROP PROCEDURE

Topics
Simple Data Binding: ASP.NET
Using a Parameterized Query: ASP.NET
Time Sheet: ASP.NET
Resources for the Lessons

References
Example Database Altair Real Estate  
Ceil Inn Kolo Bank Lambda Square
Fun Department Store 1 | Fun Department Store 2 (With File Names)
Georgetown Dry Cleaning Services |  Red Oak High School
Monson University 1: Data Definition Language | Text
Monson University 1: Data Manipulation Language | Text
Exam 70-433: Microsoft SQL Server 2008, Database Development
Exam 70-433 Preparation: Multiple Choice Questions
An electronic book (ebook) version of these lessons is available for purchase
 

Graphical Applications Examples
Ceil Inn - Hotel    
College Park Auto Repair    
Lambda Square Apartments    

Published on Saturday 26 February 2011 09:50
   

Transact-SQL Keywords
ALL ALTER AND
AS ASC BETWEEN
BEGIN...END BY CASE
CATCH CHECK CLUSTERED
CONSTRAINT CREATE  
CROSS JOIN DECLARE DEFAULT
DELETE DISTINCT ELSE
EXECUTE FALSE FOREIGN KEY
FULL JOIN GRANT GROUP BY
HAVING IF IN
INDEX INNER JOIN INSERT
IS JOIN LEFT JOIN
LIKE LOGIN MERGE
NONCLUSTERED NOT NULL
OR ORDER BY OUTPUT
PRIMARY KEY PRINT REFERENCES
RETURNS RIGHT JOIN SCHEMA
SELECT THEN TOP
TRUE TRY UNION
UNIQUE UPDATE USE
USING WHEN  
WHERE WHILE WITH

Transact-SQL Built-In Functions
ABS ASCII CHAR
CAST CEILING CONVERT
EXP FLOOR LEFT
LEN LOWER POWER
REPLACE RIGHT SIGN

SQL and Transact-SQL Examples
ALL INSERT DATABASE
  DECLARE  
TOP    
  UNION USE
  . .

Classroom

This section is intended for those who are taking these lessons in a classroom
Lesson 01 Lesson 02 Lesson 03
Lesson 04 Lesson 05 Lesson 06
Lesson 07 Lesson 08 Lesson 09
Lesson 10 Lesson 11 Lesson 12
Lesson 36 . .
     
Copyright © 2011-2013, FunctionX, Inc. Contact
 
 
FunctionX Press Microsoft Access Microsoft SQL Server 2012 C++ Delphi C# HTML MySQL .NET VBScript Win32
Windows VBA For MS Access XML Visual C++ Object Pascal Oracle Microsoft Excel Microsoft PowerPoint JavaScript Networking
Copyright © 2000-2016, FunctionX, Inc.
Last Update: Monday, 18 April 2016 08:12