|
Course Outline For:
Microsoft SQL Server 2000 Admin
Start learning Microsoft SQL Server 2000 Admin right away, Free!
Click on the highlighted lesson links below to view the lessons immediately. You will require Quicktime. If you have any problems
viewing the lessons, click here A Few Words About SQL Server Overview General Database Information More lessons below ...
Would you like to continue? You can have instant access to the rest of this training for just $30.00
|
General Administrative Responsibilities  Real World Administration Designing/Building Databases Data Maintenance/Transfer Backup/Restore of Data Security Hardware Requirements Minimum Hardware Requirements Hardware Compatibility Optimizing Hardware for SQL Server Installing SQL Server 2000 SQL Server 2000 Editions Licensing Multiple Instances Choosing a Security Mode Collation and Sort Selection Network Libraries Installation Methods Upgrading to SQL Server 2000 Default Databases Installation Troubleshooting an Installation SQL Server Security Security Overview Authentication Modes Roles Assigning Permissions Application Roles System Services SQL Services SQL Services Issues System Databases System Databases Sample Databases Data Storage How SQL Stores Data Fillfactor File and Log Location/Management Administrative Tools Overview of Admin Tools Exam Considerations Enterprise Manager Microsoft Management Console Opening & Customizing the Enterprise Mgr Using the Enterprise Manager Query Analyzer Opening and Exploring the QA Issuing Queries Using the QA Query Analyzer Features Graphical Query Plan Transact-SQL Select Statement Using a Select Statement Basic Syntax Select Options Important Select Considerations Transact-SQL Insert Statement Using an Insert Statement Basic Syntax Insert Options/Considerations Transact-SQL Update Statement Using the Update Statement Basic Syntax/Options Important Update Considerations Transact-SQL Delete Statement Using the Delete Statement Basic Syntax/Important Considerations Creating a Database Using the Create Database Statement Database Properties and Options Database Creation Considerations Managing File Growth Shrinking Database Files Sizing the Database Importance of Good Design Transaction Logs How Transaction Logs Work What Transactions Look Like Location / Location / Location Advantages of Using Transaction Logs Transaction Log Options Filegroups What Are Filegroups? Advantages of Filegroups Disadvantages of Filegroups Microsofts Recommendation on Filegroups RAID & SQL RAID Basics SQL and RAID SQL Profiler What SQL Profiler Does Opening SQL Profiler Using SQL Profiler Operators What are Operators? Creating an Operator Considerations When Using Operators Jobs Automating SQL Server Mail Enabling SQL Server 2000 Creating a New Job Scheduling a Job Job Notifications Starting/Stopping a Job Multi Server Jobs Viewing Job History Alerts What are Alerts Performance Alerts User Defined Alerts Disabling Alerts Considerations When Using Alerts Linked Servers Using SQL In a Distributed Environment Referring to SQL Server Objects Setting Up a Linked Server Relationship Database Backups Backup Strategy Database Recovery Models SQL Server Backup Who When and Where System Databases User Databases Performing a Backup Using Multiple Devices SQL Backup Statement Tape Backup Backup Types Transaction Log Backups File and Filegroup Backups Full Backup Strategy Differential Backup Strategy Backup Review Restoring Data SQL Server Recovery Process Preparing to Restore a Database The SQL Restore Statement Restore Options Restoring Transaction Logs Restoring System Databases Bottom Line on Restoring Data Maintaining High Availability Determining Requirements Clustering Standby Servers Log Shipping Data Transformation Services Importing and Exporting Data SQL Data Transport Tools DTS Overview Creating a DTS Package More DTS Package Functionality Defining Transformation Tasks Creating Using DTS in Various Ways Monitoring SQL Server 2000 Performance Issues Monitoring and Tuning Basics Improving Performance Common Monitoring Tasks and Tools What To Monitor Locks Replication Basics Dealing With Distributed Data SQL Server Replication SQL Server Replication Types SQL Server Replication Models Replication Agents Web Based Data Applications SQL Server Replication Notes Course Wrap-Up Value of SQL Server knowledge Microsofts MCDBA Certification | 
Learn Microsoft SQL Server 2000 Admin
