Server-Side Development Tutorials | ITGeared.com

gearlogo

Client-Side Development

Server-Side Development

Computers & Networking

SQL

Introduction to SQL

Install SQL Server

SQL SELECT Statement

SQL INSERT INTO Statement

SQL DELETE Statement

SQL UPDATE Statement

SQL Order By Keyword

SQL Where Clause

SQL AND/OR Operators

SQL LIKE Operator and Wildcards

SQL IN Operator

SQL Between Operator

Assigning an Alias to Columns and Tables

Joining Tables and Views

SQL UNION Operator

SQL SELECT INTO

SQL AVG Function

SQL COUNT Function

SQL MIN Function

SQL MAX Function

SQL SUM Function

SQL UPPER, UCASE Function

SQL LOWER, LCASE Function

SQL LEN Function

SQL ISNULL, NVL, and IFNULL Function

SQL ROUND Function

SQL Date Functions Overview

Date Formatting

SQL GETDATE Function

SQL DATEPART Function

SQL DATEADD Function

SQL DATEDIFF Function

MySQL NOW Function

MySQL CURDATE Function

MySQL CURTIME Function

MySQL DATE Function

MySQL EXTRACT Function

MySQL DATE_ADD Function

MySQL DATE_SUB Function

MySQL DATEDIFF Function

MySQL DATE_FORMAT Function

SQL DROP Statement

SQL TRUNCATE Table Statement

SQL CREATE DATABASE Statement

SQL CREATE TABLE Statement

SQL CREATE VIEW Statement

SQL ALTER Statement

Stored Procedures

Stored Procedure Parameters

SQL IF…ELSE Statement

Sending Email Using CDOSYS

Returning Data From a Stored Procedure

Querying Active Directory from SQL

Leveraging Temporary and Variable Tables in SQL

ASP

Introduction to Active Server Pages (ASP)

Server Side Scripting with ASP

Running ASP on a Web Server

Basic Syntax for ASP

Declaring Variables in ASP

Working with Operators in ASP

Adding Comments in ASP Code

ASP Special Characters

ASP Conditional Statements

ASP Functions and Subroutines

ASP Looping Statements

Using the #include Directive in ASP

ASP Session Object

ASP Application Object

ASP Response Object

Redirect Methods Using ASP

Managing Caching Options with ASP

ASP Request Object

ASP QueryString Collection

ASP Form Collection

ASP ServerVariables Collection

ASP Cookies Collection

ASP Server Object

Using a DLL in your ASP Application

Formatting the Date in ASP

Sending Email Using CDOSYS in ASP

ASP FileSystem Object

ASP TextStream Object

ASP File Object

ASP Folder Object

ASP Drive Object

ASP Database Access Using ADO

ADO

Introduction to ADO

ADO Connection Object

ADO Recordset Object

ADO Command Object

What is ADOVBS.inc

ADO Querying a Database

ADO Displaying Data in a Table

ADO GetString Method

ADO Inserting Records in a Database

ADO Updating Records in a Database

ADO Deleting Records in a Database

ADO Capturing Errors

ASP.NET

Introduction to ASP.NET

Creating a Basic ASP.NET Page

ASP.NET HTML Server Controls

ASP.NET Web Server Controls

ASP.NET Web Forms

Using Server-side Comments in ASP.NET

Create an RSS Feed for your Website

Create a Sitemap XML File for your Website

Did you find the page informational and useful? Share it using one of your favorite social sites.