Administering a Microsoft SQL Server 2000 Database

Document Sample
Administering a Microsoft SQL Server 2000 Database Powered By Docstoc
					                                                 Administering a Microsoft
                                                 SQL Server 2000 Database
                                                 At the end of the course the delegate will be able to complete the following:

                                                 SQL Server Overview                                       Determine when and how to use filegroups to
                                                                                                            optimise a database.
COMPUTER TRAINING                                   What Is SQL Server                                    Optimise a database by using filegroups with
                                                    SQL Server Integration                                 hardware-based RAID.
 The key to a better future                         SQL Server Databases                                  Estimate the amount of space that a database
                                                    SQL Server Security                                    requires.
                                                    Working with SQL Server
                                                    Lab: SQL Server Overview
                                                                                                        Managing Security
                                                 Skills:                                                
      SQL SERVER                                    Describe SQL Server 2000 and its supported         
                                                                                                            Implementing an Authentication Mode
                                                                                                            Assigning Logins to Users and Roles
                                                     operating system platforms.                           Assigning Permissions to Users and Roles
     Course No. 2072                                Describe SQL Server architecture.                     Managing Security Within SQL Server
                                                    Describe SQL Server databases.                        Managing Application Security
                                                    Describe SQL Server security.                      
              5 Days                                Describe SQL Server querying, implementation,
                                                                                                            Managing SQL Server Security in the
                                                     administration, and data warehousing                  Lab: Managing Security
                                                     activities, as well as client application design      Lab: Managing Permissions
Target Audience:
                                                     options.                                              Lab: Managing Application Security
This course provides students with the
                                                 Planning to Install SQL Server                         Skills:
knowledge and skills required to install,
                                                    Hardware Installation Considerations
                                                                                                           Implement Windows Authentication Mode
configure, administer, and troubleshoot the                                                                 and Mixed Authentication Mode.
client-server database management system            SQL Server 2000 Editions                              Assign login accounts to database user
of Microsoft SQL Server 2000.                       Software Installation Considerations                   accounts and roles.
                                                    Methods of Installing SQL Server                      Assign permissions to user accounts and roles.
Pre-requisites:                                     Verifying the Installation                            Manage security within SQL Server.
Before attending this course, students              Configuring SQL Server Enterprise Manager             Manage security with views and stored
should have the following pre-requisites:           Troubleshooting                                        procedures.
 Experience using the Microsoft Windows            Lab: Installing SQL Server                            Create and use application roles to manage
  2000 operating system or attendance on
                                                 Skills:                                                    application security.
  courses 2151, Microsoft Windows 2000
  Network and Operating System Essentials
                                                    Determine hardware requirements for SQL               Manage SQL Server security in the enterprise
  and 2152, Implementing Microsoft                   Server 2000 and the SQL Server management              environment.
  Windows 2000 Professional and Server.              tools.
 An understanding of basic relational              Describe the various SQL Server Editions.          Performing Administrative
                                                    Describe the different types of licensing.
  database concepts or attendance on
  1609, Designing Data Services and Data            Determine software installation options that       Tasks
  Models.                                            are appropriate for your environment.                 Configuration Tasks
 Knowledge of basic Transact-SQL syntax            Describe various methods of installing an             Routine SQL Server Administrative Tasks
  or attendance on 2071, Querying                    instance SQL Server and install it by using SQL       Automating Routine Maintenance Tasks
  Microsoft SQL Server 2000 with Transact-           Server Setup.                                         Creating Alerts
  SQL.                                              Verify the installation of SQL Server.                Troubleshooting SQL Server Automation
 Familiarity with the role of the database         Configure SQL Server Enterprise Manager.              Automating Multiserver Jobs
  administrator.                                    Troubleshoot the installation.                        Lab: Configuring SQL Server
                                                                                                           Lab: Creating Jobs and Operators
Purpose:                                         Managing Database Files                                   Lab: Creating Alerts
At the end of the course, students will be          Introduction to Data Structures                    Skills:
able to describe SQL Server architecture,           Creating Databases                                    Perform common SQL Server configuration
plan for a SQL Server installation, manage          Managing Databases                                     tasks.
files and databases, including determining
                                                    Placing Database Files and Logs                       Describe how to upgrade SQL Server
resource requirements, choose a login
security method, configure, plan and
                                                    Optimising the Database by Using Hardware-             version 6.5 and SQL Server 7.0 to SQL
                                                     based RAID                                             Server 2000.
implement database permissions, and
                                                    Optimising the Database by Using Filegroups           Describe routine database administration
describe how to secure SQL Server in an
                                                    Optimising the Database by Using Filegroups            tasks.
enterprise network, perform and automate
administrative tasks and create custom               with Hardware-based RAID                               Automate routine maintenance tasks by
administrative tools, implement a backup            Capacity Planning                                      creating and scheduling jobs.
strategy, restore databases, monitor and            Performance Considerations                            Create alerts and operators.
optimise SQL Server performance, migrate            Lab: Managing Database Files                          Troubleshoot automated jobs, alerts, or
data into databases, describe how to             Skills:                                                    notifications.
replicate data, maintain the high-availability      Describe how SQL Server stores data and               Automate administrative jobs in a multiserver
of SQL Server.                                       handles transactions.                                  environment.
                                                    Create a database, including specifying options
                                                     during and after database creation.
                                                    Grow, shrink, or delete a database.
                                                    Determine the placement of database files and
                                                     transaction logs for performance and fault
                                                    Optimise a database by using hardware-based
Backing Up Databases                                  Maintaining High Availability
   Preventing Data Loss                                 Introduction to Availability
   Setting and Changing a Database Recovery             Increasing Availability Using Failover Clustering
    Model                                                Standby Servers and Log Shipping
   SQL Server Backup                                    Lab: Automating the Maintenance of a Standby
   When to Back Up Databases                             Server
   Performing Backups                                Skills:
   Types of Backup Methods                              Determine availability requirements and
   Planning a Backup Strategy                            strategies for a Microsoft Windows Server
   Performance Considerations                            System environment.
   Backing Up Databases                                 Use SQL Server failover clustering.
Skills:                                                  Configure a standby server and use log shipping
   Create backup files and backup sets.                  to maintain its integrity.
   Back up user and system databases by using
    Transact-SQL and SQL Server Enterprise            Introducing Replication
    Manager.                                             Introduction to Distributed Data
   Back up databases that are created on multiple       Introduction to SQL Server Replication
    files and filegroups.                                SQL Server Replication Agents                          F1 COMPUTER
   Apply the appropriate backup options to each of      SQL Server Replication Types
    the different SQL Server 2000 backup methods.        Physical Replication Models                          TRAINING SERVICES
   Use the BACKUP LOG statement to back up and          Lab: Implementing Replication
    clear transaction logs.
   Design an appropriate backup strategy.
                                                         Describe the various methods to distribute data            THE KEY TO A
Restoring Databases                                       in SQL Server 2000.                                       BETTER FUTURE
                                                         Explain the publisher-subscriber metaphor,
   SQL Server Recovery Process                           including articles, publications, and
   Preparing to Restore a Database                       subscriptions.
   Restoring Backups                                    Describe SQL Server replication agents.
                                                                                                                for further information…
    Restoring Databases from Different Backup            Explain the SQL Server replication types.
    Restoring Damaged System Databases
                                                         Describe the physical replication models.                 call us on
   Lab: Restoring Databases
Skills:                                                                                                         0800 169 1890
   Describe the SQL Server recovery process.
   Verify backups and perform specific tasks that

    enable the restore process.
    Use the RESTORE statement to get information
                                                                                                                   F1 COMPUTING
    about a backup file before you restore a                                                                        SYSTEMS LTD
    database, file, or transaction log.                                                                                3 Kelso Place
   Restore backups from different backup types and                                                                  Upper Bristol Road
    use the appropriate options.
   Restore damaged system databases.                                                                                 BATH BA1 3AU

Monitoring SQL Server for                                                                                           Fax: 01225 444728
   Why Monitor SQL Server                                                                             
   Performance Monitoring and Tuning
   Tools for Monitoring SQL Server
   Common Monitoring and Tuning Tasks                                                                 
   Lab: Monitoring SQL Server
   Describe the reasons why monitoring SQL
    Server 2000 is important.                                                                                  LONDON BATH OR ONSITE
   Develop a performance monitoring and tuning
   Describe the tools available for monitoring SQL
   Perform common monitoring and tuning tasks by
    using counters and appropriate tools.

Transferring Data
    Introduction to Transferring Data
   Tools for Importing and Exporting Data in SQL
   Introduction to DTS
   Transforming Data with DTS
   Lab: Transferring Data                                                                                    For the latest available price,
Skills:                                                                                                       please see the course page on
   Describe the rationale for, and the process of,                                                    ,
    importing, exporting, and transforming data.
   Describe the tools for importing and exporting
                                                                                                                  or call 01225 336096.
    data in SQL Server 2000.
   Transform data by using Data Transformation
    Services (DTS).                                                                                           Maximum of 6 people on each
   Create and edit a DTS package by using the DTS                                                            course at F1’s training facilities
    Import and DTS Export Wizards.
                                                                                                                   in London and Bath

Shared By: