Microsoft SQL Server 2008

Microsoft SQL Server is a computer application used to create desktop, enterprise, and web-based database systems. 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.
Microsoft SQL Server 2008
1:   Introduction to MS SQL Server
2.   Starting Microsoft SQL Server
3:   Introduction to Databases
4:   SQL Operations
5:   Variables and Data Types
6:   SQL Expressions
7:   Introduction to Functions
8:  A Review of Built-In Functions
9:  The Tables of a Database
10: The Records of a Database
11: Introduction to Data Analysis
12: Details on Data Analysis
13: Operations on Data Analysis
14: Relationships and Data Integrity
15: Data Joins
16: Views
17: Stored Procedures
18: Indexes
     

SQL Expressions/Examples
Databases Tables Columns Functions
CREATE DATABASE CREATE TABLE Adding a Column CREATE FUNCTION
DROP DATABASE DROP TABLE Renaming a Column DROP FUNCTION
Renaming Deleting a Column
DEFAULT
SQL Operations
Records
Creating a Record
Updating a Record
Deleting a Record

SQL Keywords
BEGIN...END CASE DECLARE ELSE FALSE DEFAULT
IF INDEX INSERT IS NOT NULL
PRINT SELECT THEN TRUE UNIQUE
WHEN WHILE
Built-In Functions
ABS ASCII CAST CEILING CHAR COS
CONVERT DATEADD DATEDIFF DEGREES EXP FLOOR
GETDATE LEFT LEN LOG LOG10 POWER
PI RADIANS REPLACE RIGHT SIN TAN
SIGN LOWER SQRT
Topics
Simple Data Binding: C# | MS Visual C++/CLI | MS Visual C# | MS VB | ASP.NET
Using a Parameterized Query: MS Visual C++/CLI | MS Visual C# | ASP.NET
Time Sheet: MS Visual C++/CLI | MS Visual C# | ASP.NET
Combo Box Data Binding
Example Database Mirror Site
Altair Real Estate
Yugo National Bank
Georgetown Cleaning Services Links
 
Previous Web Site Version (MS SQL Server 2005)
Previous version of this web site (For Microsoft SQL Server 2000)

Published on Thursday 02 October 2008 09:20
   
 
 
FunctionX Press Microsoft Access C++ Managed C++ Delphi C# HTML MySQL .NET VBScript Win32
Windows VBA For MS Access Visual C++ Microsoft Word Object Pascal Oracle Microsoft Excel MS PowerPoint JavaScript Visual Basic 6
Copyright © 2008-2009 FunctionX, Inc.
Last Update: Friday, 10 April 2009 08:08