Training Course

SQL Server System Administration Fundamentals

PDF
3 Days

Course Overview

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.

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 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.

  • Private Courses

    Flexible dates, location and content. All prices exclude VAT.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Ask 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
Following this training what are you going to do differently "Use my training to improve my reports and save time"

R.B. GSK, Excel Level 2

"This course will help me produce information more quickly and efficiently"

W.D. James Jones Sons Ltd, Excel Level 2

Following this training what are you going to do differently "Think about how I engage with my customers and build relationships "

J.A. Cirrus Environmental Soultions Ltd, Customer Care

What were the most useful aspects of the course "Personality profiling knowing how to understand and respond to others"

R.R. Welwyn Components Ltd, Stepping up to Management

"Great facilities and really helpful trainer"

V.P. MGL, Microsoft Power BI Desktop

Which part of the course did you find particularly valuable "The practical approach of trying every aspect whether I had already done it before or I was trying it for the first time. It was a safe space to make mistakes and a very encouraging environment. "

S.A. Fujifilm Diosynth Biotechnologies, 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 other courses would you like to attend "Would strongly recommend this to fellow colleagues in my current company"

J.C. Tekmar, Microsoft Project Essentials

 

Private Courses

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:5/17/2025 10:15:58 PM