Training Course

SQL Server System Administration Fundamentals

PDF
3 Days
This 3 day course is intended for students who need to learn the essential skills necessary to maintain a Microsoft SQL Server 2016 or 2017 system infrastructure. Being concise and hands-on, it is aimed at quickly getting students familiar with the Microsoft SQL Server administration concepts, tools and utilities. 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.

The course focuses on managing a single on-premise SQL Server Database instance and does not delve into more advanced enterprise features such as high availability and replication. Neither do we consider cloud-based solutions in this course. That said, for delegates looking to get a strong grounding in SQL Server architecture and administration, perhaps before advancing on to more advanced features, this is an ideal course upon which to build.

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.

Private Training

Flexible dates, location and content. All prices exclude VAT.

Course 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 good working knowledge of the SQL language will also be assumed.

Course Objectives

    • Upon successful completion of this course, delegates will be able to:

      • Configure a SQL Server 2016 or 2017 Instance
      • Create, Configure and Manage Databases
      • Understand SQL Server Internal Storage Mechanisms
      • 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

SQL Server System Administration Fundamentals Course Content

  • Install and Configure a SQL Server Instance

    Overview of SQL Server 2016 and 2017
    Installing SQL Server (optional)
    Configuring Instance-Level Settings

  • Configuring and Managing Databases

    Creating and Managing Database Files and Filegroups
    Configuring Databases
    System Databases
    TempDB Database Considerations
    Managing Log Files

  • SQL Server Internals

    How SQL Server Stores and Manages Data Internally
    Examining Internal Storage Mechanisms

  • Creating and Managing Indexes

    SQL Server Index Architecture
    Clustered v Non-Clustered Indexes
    Creating and Modifying Indexes
    Missing and Unused Indexes
    Understanding and 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 Indirect Checkpoints
    Understanding Backup Types
    Backup Options
    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
    Introduction to Extended Events
    Diagnosing Common Issues

 

Private Training

Flexible dates, location and content. All prices exclude VAT.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Have a Question?
    Keep me up to date with offers and news
    By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
  • SQL Server System Administration Fundamentals 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 course content, flexible training date(s), flexible location(s), variable course 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.
    Virtual
    Virtual
    These courses can be attended from anywhere.
  • Virtual Training

Course Reviews
Any other comments or recommendations "Trainer was good at delivering the info and being helpful"

R.S. ENGIE Fabricom, Excel Level 1

"I will feel more confident in general using Excel, I will be able to present data in a better way and will also feel more confident setting up my own worksheets in Excel."

D.K. Egger, Excel Level 2

Following this training what are you going to do differently "Apply this knowledge to our SEO strategy. Reduce the file sizes of images and use the tools to help report it."

L.C. Visit County Durham, Search Engine Optimisation Introduction

"Everything was clearly explained and useful"

R.F. Wetherby Shade Card Co, Excel Level 2

Which part of the course did you find particularly valuable "The whole course was great, really helpful. Nothing was too much to ask Moira."

H.S. Department for International Trade, Adobe In Design Level 1

What were the most useful aspects of the course "I felt learning about the pathfinder tool and default options the most useful aspect for me. This will save me a lot of time!"

H.Y. CMP Products British Engines, Adobe InDesign Level 1

"All was useful and very well explained"

L.O. Labour Party, Excel Level 2

"I found all of the course valuable as what I learned was all information I didn't know before."

D.S. , Word Advanced Features

 

Private Training

Flexible dates, location and content. All prices exclude VAT.

 

Please contact us to discuss your SQL Server System Administration Fundamentals course, we have many solutions available to ensure you receive the best training possible.
Your SQL Server course can be delivered online or in-person.  You can choose your learning path and delivery style.  Learn in-person or online with our virtual classrooms.  Your course can be delivered online, at your office or at one of our training venues, it's your choice. Small course sizes. Course materials included. Flexible SQL Server System Administration Fundamentals course content. Expert trainers and tried & tested training methods. Many course materials available online using your personal training account.  You can master SQL Server, please contact us to book a place or request a quote for your SQL Server System Administration Fundamentals course.
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/27/2025 4:46:01 PM