http://www.expert.com.hk/australia/online-courses/index.htm

Home	Dreamweaver	VB.NET	XML	C#	VBScript	ASP	eMarketing
Contact	ColdFusion	ASP.NET	JSP	JScript	Fireworks	SQL	Advanced Java
How it works	ActionScript	Intro Java	Perl	Flash	HTML	PHP	Adv JavaScript

20-week Online Microsoft SQL Server 2008 Course

You will learn:

Installing SQL Server 2008
Starting and stopping SQL Server 2008
Using SQL Server Management Studio
Database files
Create a database
Fields Properties other than Name, data type and length
The Primary Key
Data Entry
SQL (Structured Query Language) and T-SQL
T-SQL Comments
Data Analysis
Create Database and tables using T-SQL
ALTER DATABASE using TSQL
Using Multiple Databases
Create a new database using Query Analyzer
Creating a Table Using the SQL Query Analyzer
Data Entry with Query Analyzer using T-SQL
Import an Access Database
Adjacent Data entry
Random Data Entry
Commonly used T-SQL Queries
Data Type Syntax
Using the various T-SQL statements
T-SQL Update
Using GROUP BY and HAVING
Working with more than one table
Using Joins
Data Import
Delete Database
SQL Server 2008 Administration
Adding SQL Server Registrations
Define Stored Procedures
Creating and Run a Stored Procedure
Delete Stored Procedure
Input Records with a stored procedure
To view Records in a table using Query Analyser
Define stored procedure with input parameters
Calling Stored Procedures
Create a Trigger using Enterprise Manager
Test the Trigger that you have just created
UPDATE Trigger
DELETE trigger
Extended stored procedures
Some Useful Extended Stored Procedures
Using Views
Built-in functions
User-defined functions and Types of user-defined functions
Create login(no password or default database)
Create a login ID and default database
Grant a user rights to a database
Roles
Change the default database of a login
Remove a SQL Server login
Roles defined in the current database
Rremove a user account from a database role
Remove a SQL Server role
View a database user
Allow access by granting permissions
Import and Export Data
Implementing Jobs
Attach databases
Database Backups
Restore Databases
Displaying and Manipulating Data from SQL Server 2008 using ASP.NET
Building applications using VB.NET to manipulate SQL Server 2008 database

Cost: $595 (Australian dollars) including course notes and lots of examples and exercises. You will have your own instructor whom you can ask as many questions as possible by email. You have the option of completing the course between 8 to 20 weeks.

Next online course starting date:

Our next online course starting date is Monday 12 November 2012

Enquires or Enrolment:

Email: melbourne@expert.com.hk
or
Phone: (03) 9700 6260