會員登錄
軟體搜尋
您的位置： 網站首頁 >> 專業知識教學 >> 電腦教學認證 >> 商品詳情
商品詳情
|
商品編號：CB0405-2 碟片數量：2片 銷售價格：400 瀏覽次數：35836 
【轉載TXT文檔】 |
您可能也喜歡：
DVD7924--Lynda com Designing a Newsletter Hands-On Workshop 英文正式版(教學：設計一個Newsletter實踐操作訓練) (dvd1片裝)
DVD7917--K Alliance Designing a Windows Server 2008 Applications Platform Infrastructure 英文正式版(教學：設計一個Windows Server 2008 應用平臺架構) (dvd1片裝)
DVD11806--Lynda com Designing a CD Cover Hands-On Workshop for CS5 英文正式版(教學)
TIC2633--PLURALSIGHT GETTING STARTED WITH JENKINS CONTINUOUS INTEGRATION 視頻教學 英文教學版
TIC2695--LYNDA JAVASCRIPT FOR WEB DESIGNERS 視頻教學 英文教學版
商品描述
Keystone SQL 2000 Implementing and Design Level 5 and 6 (2片裝)
軟體簡介:
Keystone SQL 2000 Implementing and Design Level 5 and 6 (2片裝)(微軟 SQL 2000 資料庫設計實作教學 Level 5及6)
Keystone 公司: 微軟 SQL 2000 資料庫設計實作教學 Level 5及6。
市價:新台幣 38000元。
This course teaches you to administer and troubleshoot information systems
that incorporate the SQL Server?2000 Enterprise Edition.
Learn how to install and configure a SQL 2000 Server, create SQL 2000
databases, manage, monitor and troubleshoot SQL 2000 databases, extract
and transform data and manage and monitor SQL 2000 security. Available
on 11 videos or 11 CDs, the entire course prepares you for Exams 70-228
and 70-229.
Implementing SQL Server 2000 Level 5 (2 hrs 2 min)
1.0 Transaction Processing (20 mins)
1.1 What is a Transaction?
1.2 Nesting Transactions
1.3 Transactions in Triggers
1.4 Trying out Transactions
1.5 Deadlocks
2.0 Data Transfer (26 mins)
2.1 Services Available
2.2 BCP
2.3 BULK INSERT
2.4 DTS
3.0 Full Text Search (28 mins)
3.1 What is Full Text Search?
3.2 Setting up Full Text Search
3.3 Performing a Full Text Search
3.4 Full Text System Procedures
3.5 FTS Enhancements in SQL 2000
4.0 Optimization (33 mins)
4.1 Optimizing your Server
4.2 Database design
4.3 Query Optimization
4.4 Index Usage
4.5 Statistics & Index Analyzer
4.6 SQL Server Profiler
4.7 Performance Monitor
5.0 System Databases & Tables (15 mins)
5.1 System Databases
5.2 System Tables
Implementing SQL Server 2000 Level 6 (1 hr 50 mins)
1.0 Using XML Extensions (61 mins)
1.1 Creating a Virtual Root
1.2 Using a Virtual Root
1.3 Returning Element Based XML
1.4 Passing Parameters
1.5 Multiple Result Sets
1.6 Using Stored Procedures
1.7 Inserting Data using XML
1.8 Joining Tables
1.9 Retrieving Data from VB
2.0 Application Development (49 mins)
2.1 OLE DB, ODBC and ADO
2.2 Using ADO
Keystone.SQL.2000.Implementing.and.Design.Level.5-6
軟體簡介:
Keystone SQL 2000 Implementing and Design Level 5 and 6 (2片裝)(微軟 SQL 2000 資料庫設計實作教學 Level 5及6)
Keystone 公司: 微軟 SQL 2000 資料庫設計實作教學 Level 5及6。
市價:新台幣 38000元。
This course teaches you to administer and troubleshoot information systems
that incorporate the SQL Server?2000 Enterprise Edition.
Learn how to install and configure a SQL 2000 Server, create SQL 2000
databases, manage, monitor and troubleshoot SQL 2000 databases, extract
and transform data and manage and monitor SQL 2000 security. Available
on 11 videos or 11 CDs, the entire course prepares you for Exams 70-228
and 70-229.
Implementing SQL Server 2000 Level 5 (2 hrs 2 min)
1.0 Transaction Processing (20 mins)
1.1 What is a Transaction?
1.2 Nesting Transactions
1.3 Transactions in Triggers
1.4 Trying out Transactions
1.5 Deadlocks
2.0 Data Transfer (26 mins)
2.1 Services Available
2.2 BCP
2.3 BULK INSERT
2.4 DTS
3.0 Full Text Search (28 mins)
3.1 What is Full Text Search?
3.2 Setting up Full Text Search
3.3 Performing a Full Text Search
3.4 Full Text System Procedures
3.5 FTS Enhancements in SQL 2000
4.0 Optimization (33 mins)
4.1 Optimizing your Server
4.2 Database design
4.3 Query Optimization
4.4 Index Usage
4.5 Statistics & Index Analyzer
4.6 SQL Server Profiler
4.7 Performance Monitor
5.0 System Databases & Tables (15 mins)
5.1 System Databases
5.2 System Tables
Implementing SQL Server 2000 Level 6 (1 hr 50 mins)
1.0 Using XML Extensions (61 mins)
1.1 Creating a Virtual Root
1.2 Using a Virtual Root
1.3 Returning Element Based XML
1.4 Passing Parameters
1.5 Multiple Result Sets
1.6 Using Stored Procedures
1.7 Inserting Data using XML
1.8 Joining Tables
1.9 Retrieving Data from VB
2.0 Application Development (49 mins)
2.1 OLE DB, ODBC and ADO
2.2 Using ADO
Keystone.SQL.2000.Implementing.and.Design.Level.5-6