We use cookies to offer you a better experience and to analyse how visitors use our site, you may consent to our cookies by continuing to use our site, or you may view more information and choose to reject cookies by clicking here. Thank you

Contact us online or call us on 0191 377 8377

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields

PDF
Course SQL Server System Administration Fundamentals
  • Course Duration3 Days
  • Course Options
    Bespoke
    Bespoke
    Bespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.
    Private
    Private
    Flexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.

Overview
This 3 day course is intended for delegates who need to learn the essential skills necessary to maintain a Microsoft SQL Server system infrastructure. Being concise and hands-on, it is aimed at quickly getting delegates familiar with the Microsoft SQL Server administration concepts, tools and utilities. This course is an abridged version of the full 5 day “Microsoft SQL Server System Administration” course. The installation of SQL Server, covered in the first module of the course, is optional and can be omitted to free up time for other topics if desired.

Attendees will gain insight into the infrastructure and architecture of SQL Server, enabling individuals to fully understand the product with which they are dealing. Configuration of server instances and databases is given full treatment, as are database transaction logs, and the creation and maintenance of indexes. Concise treatment is given to managing SQL Server security, including both at the server and database level. The focus then shifts to examining how best to move and protect data, such as when importing or exporting it between heterogeneous data sources, backing it up to external media, and restoring data from a backup. Many tasks involved in the day to day administration of a SQL Server instance can be performed automatically, making an administrators life potentially simpler, and such is the subject matter in the module dealing with SQL Server Automation. The final part of the course looks at monitoring and troubleshooting SQL Server performance and related issues.
Prerequisites
    • Delegates should be familiar with working in a Microsoft Windows Server operating system environment. Delegates should also have an understanding of the fundamental design of relational databases including, but not restricted to, the purpose of primary and foreign keys, entity relationships, and data normalization. A working knowledge of the SQL language (such as might be gained from attending the 2 day “SQL Server Introduction to Querying” course) will also be assumed.
Objectives
    • Upon successful completion of this course, delegates will be able to:

      • Configure a SQL Server Instance
      • Create, Configure and Manage Databases
      • Implement and Manage Indexes
      • Understand and Implement SQL Server Security
      • Understand Data Transfer Utilities
      • Backup and Restore Databases
      • Automate Tasks in SQL Server
      • Monitor and Troubleshoot SQL Server
      • Understand SQL Server Transactions and Locking
Course Content
    • Install and Configure a SQL Server Instance
      Overview of SQL Server
      Preparing for an Installation (optional)
      Installing SQL Server (optional)
      Configuring Instance-Level Settings
    • Configuring and Managing Databases
      Creating and Managing Files and Filegroups
      Configuring Databases
      Managing Log Files
    • Creating and Managing Indexes
      SQL Server Index Architecture
      Creating and Modifying Indexes
      Managing Index Fragmentation
      Understanding and Managing Statistics
    • SQL Server Security Managing
      Logins and Server Roles Managing
      Users and Database Roles
      Assigning and Managing Permissions Using Schemas
    • Transferring Data
      Overview of Copying and Exporting Data
      Using BCP to Import and Export Data
      BULK INSERT
      OPENROWSET(BULK)
      SELECT INTO
      Using the SQL Server Import and Export Wizard
      Introducing SQL Server Integration Services (SSIS)
    • Backups and Recovery
      Understanding Database Recovery Models
      Understanding Backup Types
      Backup Options
      Backup to URL
      Encrypted Backups
      Performing Database and Log Backups
      Backing Up System Databases
      Viewing Backup History
      Restoring Database and Log Backups
      Restoring System Databases
    • SQL Server Automation
      Overview of SQL Server Automation
      The SQL Server Agent Service
      Configuring Credentials and Proxy Accounts
      Implementing Jobs
      Implementing Operators and Notifications
      Implementing Alerts
      Maintenance Plans
    • Monitoring and Troubleshooting SQL Server
      Introduction to Monitoring SQL Server
      Using DMVs and DMFs
      Activity Monitor
      Performance Monitor
      SQL Server Profiler
      Introduction to Extended Events
      Diagnosing Common Issues
    • Transactions and Locking
      Understanding Transactions
      Understanding SQL Server Lock Management
      Diagnosing Concurrency Issues

 

Course Dates Please contact us to discuss dates for this course, thank you

IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk

Printed: 16 Sep 19

 

 

 

Contact us

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields