|
Exchange Server
IIS4 Training
SQL Server
TCP/IP Training
Windows NT
Windows 2000
Windows 2000 Server
A+ Certification
MCSE Certification
MOUS Certification
A+ Training
Access 2000
Excel 2000
Excel 2000 Expert
Word 2000
Word 2000 Expert
PowerPoint
Office 2000
Office 97
Cisco CCNA
Cisco CCDA
Oracle 8i
E-Commerce
Novel
Lotus Notes
Visual Basic
Java
HTML
Visual InterDev
PowerBuilder
FOCUS
UNIX
Sybase
PhotoShop
S.A.S.
QuickBooks
MS Works
Estate Planning
Interview Skils
Investing
Resumess Writing
Home Business
Management
|
This course is for database administrators who want to learn how to administer SQL Server 7.0, or who are preparing for the MCSE exam 70-028:
After completing these courses, the user should be able to:
- Assess whether to use Microsoft Windows NT or Microsoft SQL Server accounts
- Decide whether to use the Windows NT group structure for installation
- Assess whether to map Windows NT groups directly into a database or use logins
- Choose which NT accounts will be used to run services
- Plan an n-tier application security strategy and determine whether to use application roles or other mid-tier security mechanisms such as Microsoft Transaction Server
- Plan the security requirements for linked databases
- Plan the physical placement of files, including data files and log files
- Plan the use of filegroups
- Plan for growth over time
- Plan the physical hardware system
- Assess the server's communication requirements
- Choose the appropriate backup and restore strategies
- Assess whether to use a standby
- Assess whether to use clustering
- Plan an upgrade from a previous version
- Plan the migration of data from other data sources
- Determine hardware and software requirements for migration
- Use the Upgrade Wizard
- Use the Import Wizard
- Design an appropriate replication model
- Choose a replication type
- Select an appropriate subscription model and type
- Evaluate data type requirements
- Install the prerequisites
- Install Database component
- Choose an appropriate character set, Unicode collation sequence, and sort order
- Install network libraries and protocols
- Install the services and the appropriate startup options
- Install and configure client software on client machines
- Perform an unattended installation and uninstallation
- Prepare for upgrading a system
- Use the Upgrade Wizard to upgrade operations
- Validate and verify the upgrade of the system
- Register with a network
- Installing and configuring SQL Mail, and configuring the default ANSI settings
- Install and configure the Full-Text Search service, including enabling Full-Text Search on specific columns and tables, and creating and managing indexes to support Full-Text Search
- Assign access through Windows NT accounts, logins, and built-in administrator logins
- Assign database access to Windows NT accounts, login accounts, the Guest account, and the DBO user account
- Manage login IDs and database User IDs
- Grant to database users and roles the appropriate permissions on database objects and statements
- Audit server and database activity
- Create and manage databases
- Create data files, filegroups, and transaction log files
- Specify growth characteristics
- Manage database size
- Set database options
- Document and script a database
- Set up a database maintenance plan
- Delete a database
- Load data using the INSERT statement
- Load data using the SELECT INTO statement
- Load data using the BCP Utility
- Load data using the Data Transformation Services (DTS)
- Load data using the BULK INSERT command
- Back up system databases and user databases
- Restore system databases and user databases
- Diagnose and resolve problems with upgrading from SQL Server 6.x
- Use the Client Configuration utility to diagnose and resolve client connectivity problems
- Diagnose and resolve problems regarding databases and database objects
|
