你好，菜鳥DBA大蝦， 請教你一個如何做Oracle/SQL Server DBA的問題

請問，你的it skill set 都有哪些？我剛學了SQL,一點Unix/linux, MySql,PL/SQL， 準備再學點crystal report and SQL server， 請幫忙看一下這個training list, if it is sufficient to cover all the points one Oracle/SQL Server DBA need to know ? 我不知道是否值得花三個月的時間和金錢去學

Take a look at the detailed curriculum.

**Week 1 - SetFocus Fundamentals**

* Introduction to Database Management System
* The Relational Model
* Data Modeling
* Normalization
* Data Integrity
* Advanced Database Objects
* Codd's Rules
* Introduction to DBA Concepts
* Basic XML
* Validating XML
* Windows Administration Basics

**Week 2 - Writing Queries using MS SQL Server 2008 T-SQL**

* Getting Started with Databases and Transact-SQL in SQL Server 2008
* Querying and Filtering Data
* Grouping and Summarizing Data
* Joining Data from Multiple Tables
* Working with Subqueries
* Modifying Data in Tables
* Querying Metadata, XML, and Full-Text Indexes
* Using Programming Objects for Data Retrieval
* Using Advanced Querying Techniques

**Week 3 - Implementing a Microsoft SQL Server 2008 Database **

* Create databases and database files
* Create data types and tables
* Creating and Tuning Indexes
* Implementing Data Integrity by Using Constraints and Triggers
* Using XML
* Implementing Views
* Implementing Stored Procedures
* Implementing Functions
* Implementing Managed Code in the Database
* Managing Transactions and Locks
* Using Service Broker

**Week 4 - SetFocus - Customized SQL Programming Project**

**Week 5 - Advanced SQL Querying and Programming**

* SQL 2005 new features workshop
* SQL 2008 new features workshop
* Hierarchies and recursive querying
* Working with dates
* Concurrency and locking
* Query performance tuning
* Database security and encryption
* Spatial data

**Week 6 - Maintaining a Microsoft SQL Server 2008 Database **

* Installing and Configuring SQL Server
* Managing Databases and Files
* Disaster Recovery
* Managing Security
* Transferring Data
* Automating Administrative Tasks
* Implementing Replication
* Maintaining High Availability
* Monitoring SQL Server
* Troubleshooting and Performance Tuning

**Week 7 - SetFocus - Customized SQL Server 2008 Admin Project**

**Week 8 - Implementing and Maintaining MS SQL Server 2008 Integration Services**

* Introduction to SQL Server 2008 Integration Services
* Developing Integration Services Solutions
* Implementing Control Flow
* Implementing Data Flow
* Implementing Logging
* Debugging and Error Handling
* Implementing Checkpoints and Transactions
* Configuring and Deploying Packages
* Managing and Securing Packages

**Week 9 - Implementing and Maintaining MS SQL Server 2008 Reporting Services**

* Introduction to Microsoft SQL Server Reporting Services
* Authoring Basic Reports
* Enhancing Basic Reports
* Manipulating Data Sets
* Using Report Models
* Publishing and Executing Reports
* Using Subions to Distribute Reports
* Administering Reporting Services
* Programming Reporting Services

**Week 10 - SetFocus - Customized SSIS & SSRS Project**

**Week 11 - Microsoft SharePoint 2007 for Administrators and Project**

* Planning
* Installing
* Configuring the server
* Preparing
* Roll-out
* Providing support
* Managing the server
* Configuring external access

**Weeks 12 & 13 - SetFocus - Customized Final Project**

所有跟帖： 

• 回複：你好，菜鳥DBA大蝦， 請教你一個如何做Oracle/SQL Server DBA的問題 -非典型小菜鳥- ♂ (92 bytes) () 10/28/2009 postreply 11:08:42

• 菜鳥DBA大蝦， 你說的對，我的問題你沒有全回答， 明天 -我邊走邊問- ♀ (10 bytes) () 10/28/2009 postreply 11:49:24

• 回複：你好，菜鳥DBA大蝦， 請教你一個如何做Oracle/SQL Server DBA的問題 -非典型小菜鳥- ♂ (628 bytes) () 10/28/2009 postreply 13:25:19

• 謝謝菜鳥DBA大蝦，我要 在我還沒有變老之前爭取學到您的水平 -我邊走邊問- ♀ (132 bytes) () 10/29/2009 postreply 10:09:14