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.


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
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
L12::Intro Data Selection	MS Visual C#	ASP.NET

Completed Databases in Lessons

Lesson 25	Fun Department Store
Lesson 27	College Park Auto-Repair
Lesson 28	Computer Training Center
Lessons 29 & 37	Monson University
Lesson 30	Information Technology Journal
Lesson 34	Bethesda Car Rental
Lesson 35	Lambda Square Apartments
Lessons 38, 39, & 40	Lambda Properties Management
Lesson 41 & 42	Kolo Bank
Lesson 43	Whatts A Loan

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
SUSER_NAME