Microsoft SQL Server 2005 Self-Study Training Tutorial

1. SQL Server 2005 Installation
2. Starting up SQL Server 2005 servers 
-        Registration and connecting the server
-        Pause and stop the server
3. SQL Server Management Studio  
-        Basic function of Server Management Studio
-        Change Window layout
-        Writing Transact-SQL code
-        Using template, programs and projects
-        Enhance efficiency by using HELP
4. Database management
-       Design users database
-       Create user database
-       Set up user database
-       Detach and attach user databases
-       Online and offline user database
-       Compress user database and file
-       Delete an unused database
-       Export SQL script directly from SQL Server 2005 (new feature)
5. Management of Data Tables 
-       Design user tables 
-       Create user tables  
-       Edit user tables
-       Delete user Table
-       INSERT statements
-       UPDATE statements
-       DELETE statements
6. Transact-SQL Data Queries
-       Understanding Common Query Language
-       Using a WHERE conditions Query
-       Using ORDER BY command in a query  
-       GROUP BY queries     
-       HAVING command in a query
-       INTO Command
-       JOIN query
-       Nested query  
7.  Index Management
-        Basic knowledge of Index  
-        How to create an index
-        How to check index information
-        How to alter an index 
-        How to delete an index  
8. Views, Statistics and Synonyms  
-        How to create views
-        How to maintain statistical Information of a database
-        How to create Synonyms  
9. Stored Procedure and Trigger Management
-        Stored Procedure
-        Triggers and Trigger Management  
10. Data Integrity  
-        Overview of Data Integrity
-        How to create and manage constraints
-        How to create and manage Rules
-        How to create and manage defaults
11. Security and License  
-        SQL Server 2005 security mechanism
-        Login and User Account Management
-        Role Management
-        Permission Management  
12. Backup and Recovery    
-        Complete Database Backup and Recovery
-        “Integral + Logs” Database Backup and Recovery
-        “Integral + Difference + Logs“ Database Backup and Recovery  
-        Database Recovery from Backup Files

Appendix: SQL Database Theory and Definition

Total training time:     ~  30 hours

System Requirements:

• Pentium 133 MHz or higher
• 32MB RAM
• 10MB free disk space
• 24X CD-ROM

Brand New in shrinkwrapped DVD case

Payment Method/Terms:

• Visa, Mastercard, Discover, Paypal
• Please add $4.95 s/h in U.S.A. $5.95 to Canada. $7.95 to Western Europe, Japan and Australia. Insurance is included.
• 30 day warranty for defective media.
• We will ship your item(s) within 24 hours of payment (excluding weekends). We will send you an item shipped email to notify you.
• Payment is due within 10 days of auction completion.
• By bidding, you will entering into a contract to purchase this item. We humbly request that you bid only if you are certain you wish to purchase this item. 
• End of Auction: We will email the winning bidder within 24 hours after the auction ends, excluding weekends. We will provide you with complete payment and contact information. If you do not receive our email, please check any spam folders you have in place. Our email is definitely being sent. Also, please make sure your Ebay registered email address is valid.