Property & Construction
 Service & Business
 Shopping Paradise
 Travel Agent
Search WWW   
Powered By   
Visitor Guide :

you are here: home Hilight in Phuket

SIPA Ѵͺѡٵ Microsoft SQL 2005

SIPA Ң絨Ѵͺѡٵ Microsoft SQL 2005 ҧѹ 12 22 ѹҤ 2549 16.00 20.00 40 . ͧͺ 2 SIPA Ң




Course: Writing Queries Using Microsoft SQL Server 2005 Transact.
Purpose: The purpose of this course is to provide participants with the technical skills required to write basic Transact-SQL queries for Microsoft SQL 2005.
Course Outline
1.Getting Started with Database and Transact-SQL
2.Performing Basic Queries
3.Grouping and Summarizing Data
4.Joining Data from Multiple Tables
5.Working with Sub queries
6.Modifying data
7.Querying Full-Text Indexes and XML Data
8.Using Programming Object for Data Retrieval.
9.Advanced Queries Techniques.

Course: Implementing a Microsoft SQL Server 2005 Database
Purpose : The purpose of this course is provide a universal core skill of SQL Server, creating and implementing data storage objects such as databases, data types and tables; constraints, indexes and programming object such as UDFs, UDT, Triggers and stored procedures using Transact-SQL or through the CLR.
Course Outline
1.Creating databases and Database Files.
2.Creating Data Types and Tables.
3.Using XML.
4.Creating and Tuning Indexes.
5.Implementing Data Integrity.
6.Creating Views.
7.Creating Stored Procedures and Functions.
8.Implementing Managed Code in the Database.
9.Using Service Broker

Course: Maintaining a Microsoft SQL Server 2005 Database
Purpose : The purpose of this course is provide a universal core set of skills associated with SQL Server such as installing and configuring SQL Server , creating and maintaining database backups ,user account, permission, tasks, and bulk data operations.
Course Outline:
1.Installing and Configuring SQL Server 2005
2.Managing Databases and Database files
3.Managing Security.
4.Disaster Recovery.
5.Monitoring SQL Server 2005
6.Transferring Data
7.Automating Administrative Tasks.
8.Maintaining High Availability
9.Introduction to Replication.


     More Hilight

26 - 04 - 2013
絨Ѵ˭Фԧѵʵ෾ѵ ع
20 - 05 - 2010
絨Ѵ ͹ Phuket Fun Fly ҹҪҵԔ á
04 - 01 - 2010
ȺŹ ԭǪ ҹѹ觪ҵ Шӻ 2553 ѹ 9 ѹҤ 2553 ǹآҾ ѧǧ ٹǪоҹԹ 08.30 .繵
19 - 12 - 2009
ŹԸͧ絨ШѴҹѧä駷 4 ѹҷԵ 27 ѹҤ 2552 ҧЫ
18 - 03 - 2009
ȡ 19-28 չҤ
    Home | About Us | Contact Us | Advertise with Us | Order Form | Our Partner | Site Map
    Copyright © 1998-2006. Express Data Company. All rights reserved.
Express Data 
Phuket Today