Two-day Microsoft SQL Server 2000 Course

MS SQL Server is a relational database management and analysis system for e-commerce and data storage and manipulation.

Day 1:

• 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

Day 2:

• 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

Date: Thursday 16 September and Friday 17 September 2010

Cost: $660 (Australian dollars) including morning tea, lunch, afternoon tea, notes and lots of hands on exercises

Time: 9 am - 5pm

Place: 600 Collins Street or at a place close to the Monash freeway about 25 minutes drive from Melbourne city in Australia

Enquiries or Enrolment:

Email: melbourne@expert.com.hk

We also offer on-site training courses at your place anywhere in Australia, email to us for details: melbourne@expert.com.hk