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

20-week online Microsoft SQL Server 2000 Course

You will learn:

What is SQL Server 2000
Documentation Conventions
What's New in Microsoft SQL Server 2000
SQL Server 2000: Editions and Components
Setting up Windows Services Accounts
Main Server Components
Multiple Instances of SQL Server
Basic installation of SQL Server 2000
More advanced issues when installing SQL Server
Performing an Unattended Installation
Change the Service Accounts
Database files
Using SQL Server Service Manager and the Enterprise Manager
Using SQLServerAgent Service
Create a database Using the Wizard Table Design
Fields Properties other than Name, data type and length
The Primary Key
Data Entry
SQL (Structured Query Language) and T-SQL
Query Analyzer
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 2000 Administration
SQL Server Groups and Registrations
Modifying Server Registrations in Enterprise Manager
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
View a SQL Server login or Windows user or group
Change the default database of a login
Remove a SQL Server login
Deny login access to a Windows user or group
View the 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
Start SQL Server at Command Prompt
Import and Export Data
Using DTS Import/Export Wizard
Export a database to a text file
bulk copy command-line utility, bcp.exe
Implementing Jobs
Deterministic and Nondeterministic Functions
Rowset Functions
Using OpenXML
Aggregate Functions
Scalar functions
Using DATEADD
Using YEAR
Using ASCII
Using @@LANGUAGE
Database Backups
To restore the Database
Understand how ASP works
Access and manipulate SQL Server databases using ASP
Understand how VB works
Data Access using the ADO Data control
Understanding OLE DB
Using the ADO Data Control
ConnectionString Property
RecordSource Property
Binding a control
DataSource and DataField Properties
Build VB applications to access and manipulate SQL Server databases
Displaying Data from SQL Server using ASP.NET
Brief introduction to ASP.NET
Accessing Data with ADO.NET
Central Components of ADO.NET
Core Objects making up a .NET data provider
Data Binding
Structure of a vb.net Program
Database Access using ADO.NET and VB.NET

Cost: $US295 (US 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 (Ecourse) starting date:

Our next online course starting date is Monday 19 November 2012

Enquires or Enrolment:

Email: courses@expert.com.hk
or
Phone: + 61 3 9700 6260 (9am-5pm Australian Eastern time Monday to Friday)