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 |
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
 
 
 

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, Fianga.com Contact