Microsoft SQL Server Database Development
Microsoft SQL Server Database Development

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 2012 to create and manage databases.

 
 
 
Lessons Summary
 

Databases

Tables

Views

CREATE DATABASE CREATE TABLE CREATE VIEW
DROP DATABASE DROP TABLE ALTER VIEW
Selecting 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
Change Type WITH GRANT  
Identity Column REVOKE Permission  
Deleting a Column  
Renaming a Column  

Schemas

Creating a Schema    

Records Operations

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

Graphical Lessons

L05::Intro to Data Entry

MS Visual C# ASP.NET

L11::Intro Data Selection

MS Visual C# ASP.NET

L23: Deleting a Record

   
  

Completed Databases in Lessons

Lesson 21

Fun Department Store

Lesson 27

Colleg Park Auto-Repair

Lesson 28

Computer Training Center

Lessons 29 & 37

Monson University

Lesson 30

Information Technology Journal

Lesson 34

Bethesda Car Rental

Lesson 31

Lambda Square Apartments

Lessons 38, 39, & 40

Lambda Properties Management

Lesson 41 & 42

Kolo Bank

Lesson 43

Whatts A Loan - C# Version

  
Sky Drive
FROM SkyDrive 01/25/2013
MODIFIED AT HOME
MAISON L06022013
Boulot V22022013

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 CAST
CEILING CHAR CONCAT
CONVERT DB_ID DB_NAME
EXP FLOOR FORMAT
HOST_NAME LEN LEFT
LOWER OBJECT_ID PARSE
POWER REPLACE RIGHT
SIGN SQRT SUSER_ID
 

     

Copyright © 2000-2016, FunctionX