Two-day Microsoft SQL Server 2005 Course

You will learn:

Day 1:

• Installing SQL Server 2005
• Starting and stopping SQL Server 2005
• 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 2005 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

Day 2:

• 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 2005 using ASP.NET
• Building applications using VB.NET to manipulate SQL Server 2005 database

Date: Monday 4 October and Tuesday 5 October 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