FunctionX | FunctionX Press | Microsoft Access | VBA Access | C# | Microsoft Visual C# | Microsoft Visual Basic | Microsoft Excel | VBA Excel
  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
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 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 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    
 
 
  FunctionX Press Microsoft Access Microsoft Excel MS SQL Server 2008 Oracle C++ XML Microsoft Word  
  Windows VBA For MS Access VBA Excel MS SQL Server 2005 MySQL .NET Visual C++ MFC VBScript Win32  
  HTML C# MS Visual C# Object Pascal Delphi Microsoft PowerPoint JavaScript Networking  
  Copyright © 2000-2013, FunctionX