最 低 价：￥45.00
| Stephen Giles (MCSE, MCDBA, MCT, CTT) is a Microsoft Certified Trainer from Toronto, Canada. He has spent the last three years teaching, writing about, and working with SQL Server and Oracle. When not submerged in databases, he spends his time trying to keep up with his daughter Olivia. Glen Martin (MCSE, MCDBA, CCNA, MCT) is a Microsoft Certified Trainer from Ottawa, Canada. In addition to SQL Server, he also delivers training on many of th.. << 查看详细 |
| contents 1 installing sql server 2000 installing sql server questions failover clustering questions default collation questions number of instances questions file location questions service account questions performing a custom upgrade to sql server 2000 questions upgrading to sql server 2000 from sql server 6.5 questions upgrading to sql server 2000 from sql server 7.0 questions .lab question quick answer key in-depth answers lab answer 2 configuring sql server 2000 creating a linked server questions configuring sql mail and sql agent mail questions configuring network libraries questions troubleshooting failed installations questions lab question quick answer key in-depth answers lab answer 3 creating sql 2000 databases creating and altering databases questions setting database options questions adding/configuring filegroups questions expanding and shrinking databases questions sizing and placing the transaction log questions configuring database options for performance questions attaching and detaching databases questions lab question quick answer key in-depth answers lab answer 4 creating and managing database objects creating and managing basic database objects creating and managing constraints questions creating and managing indexes questions creating and managing stored procedures questions creating and managing triggers questions creating and managing views questions lab question quick answer key in--depth answers lab answer 5 managing, monitoring, and troubleshooting sql server 2000 databases optimizing database performance questions optimizing data storage questions managing database schema questions lab question quick answer key in-depth answers lab answer 6 backing up, restoring, and recovering sql 2000 databases recovering system state questions backing up user databases questions backing up system databases questions restoring user databases questions restoring system databases questions configuring, maintaining, and troubleshooting log shipping questions performing integrity checks questions troubleshooting transactions and locking questions lab question quick answer key in-depth answers lab answer 7 extracting and transforming data with sql server 2000 using xml support questions importing and exporting data with data transformation services questions developing and managing dts packages questions managing linked servers questions converting data types questions configuring, maintaining, and troubleshooting replication services questions lab question quick answer key in-depth answers lab answer 8 managing and monitoring sql server 2000 security configuring security modes questions creating and managing logons questions creating and managing database user accounts questions adding and removing users from fixed roles questions creating roles to manage database security questions setting permissions in a database questions enforcing and managing security by using stored procedures, triggers, view, and user-defined functions questions managing security auditing questions lab question quick answer key in-depth answers lab answer 9 managing sql server 2000 automation creating, managing, and troubleshooting sql server agent jobs questions configuring alerts using sql server agent questions creating and using user-defined fount messages questions configuring operators questions lab question quick answer key in-depth answers lab answer 10 managing, monitoring, and troubleshooting sql server 2000 optimizing hardware resources questions monitoring hardware using system monitor questions resolving system bottlenecks by using system monitor questions optimizing and troubleshooting sql server system activity using the profiler questions lab question quick answer key in-depth answers lab answer practice exam questions answers glossary |
内容加载中，请稍后...
商品评论（0条）