SETC Training844-434-7382
 Find a Course: 
 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

SQL Server Training


Trainer was well prepared. Course was very interesting.
Comment from Shared Services canada

1. Title

  • SQL Server Administration: The Complete Course (SQLADCP, 4 days)
    View PDF

2. Course Pre-requisites

  • Previous SQL Server experience

3. Target Audience

  • IT professionals who want to learn how to administer a production SQL Server environment

4. Dates and Pricing


Apr 4 to Apr 7, 2017$2,775.00/person
Sep 5 to Sep 8, 2017$2,775.00/person
Nov 6 to Nov 9, 2017$2,775.00/person

5. Outline

Module 1: Introduction to SQL Server and its Toolset

Topic 1: Overview of SQL Server Services

Topic 2: SQL Server Services and Features

Topic 3: Working with SQL Server Tools

Topic 4: Designing the Environment: Creating Accounts and Configuring the Firewall

Topic 5: About Virtualizing SQL Server

Topic 6: Configuring Services in an Enterprise Environment

Topic 7: Configuring Protocols: Server and Client

Topic 8: Configuring DCOM Components for Enterprise Applications

Topic 9: Configuring SQL Server Browser

Topic 10: Modifying the Operating System for Performance

Topic 11: Installing SQL Server 2016

Topic 12: Tweaking SQL Server Memory

Topic 13: Configuring TempDB

Module 2: Working with Databases

Topic 1: About SQL Server Databases. Files and Filegroups

Topic 2: Planning for Space Usage

Topic 3: Creating Databases with TSQL

Topic 4: Creating Files and Filegroups

Topic 5: Attaching and Detaching Database Files

Topic 6: About Database Settings

Topic 7: Retrieving Key Database Information using TSQL

Module 3: Backup and Recovery

Topic 1: About SQL Server Recovery Models

Topic 2: About Full, Transactional and Incremental Backups

Topic 3: Delving Deeper into Transaction Logging

Topic 4: Planning a SQL Server Backup Strategy

Topic 5: Performing a Backup using TSQL

Topic 6: About Backup Options

Topic 7: Performing a Recovery using TSQL

Topic 8: About Recovery Options

Topic 9: Performing a Point in Time Recovery

Topic 10: Backup Strategies for System Databases

Module 4: Importing and Exporting Data

Topic 1: Overview of Import/Export Tools

Topic 2: Importing/Exporting Data using Graphical Tools

Topic 3: Importing/Exporting Data using TSQL

Topic 4: Importing/Exporting Data using Integration Services

Module 5: SQL Server Security

Topic 1: Understanding SQL Server Security Modes

Topic 2: Understanding SQL Server Logins, Users and Roles

Topic 3: Creating SQL Server Logins

Topic 4: Working with Server Roles

Topic 5: Working with Users and Database Roles

Topic 6: Creating Database Roles

Topic 7: Security and Stored Procedure Execution

Topic 8: Troubleshooting Data Access Issues

Module 6: SQL Server Event Management and Auditing

Topic 1: Enabling SQL Server Auditing

Topic 2: Auditing Data Access in SQL Server

Topic 3: Managing Auditing

Topic 4: Configuring SQL Server Agent

Topic 5: Creating and Scheduling Jobs and Alerts

Topic 6: Creating Operators and Notifications

Topic 7: Ensuring Database Integrity

Topic 8: Maintaining Indexes

Topic 9: Automating Routine Database Maintenance

Module 7: Working with indexes

Topic 1: Understanding the Anatomy of CRUD Operations

Topic 2: Understanding Page Internals

Topic 3: Understanding Indexes, Index Types and Table Storage

Topic 4: About Fragmentation and Data Storage

Topic 5: Creating Clustered Indexes

Topic 6: Creating Non-Clustered Indexes

Topic 7: Rebuilding Indexes

Topic 8: Managing Fragmentation

Topic 9: Tuning TSQL Statements

Module 8: Tracing Access to SQL Server

Topic 1: Capturing Activity using SQL Server Profiler

Topic 2: Improving Performance with the Database Engine Tuning Advisor

Topic 3: Working with Tracing Options

Topic 4: Monitoring Activity

Topic 5: Capturing and Managing Performance Data

Topic 6: Analyzing Collected Performance Data

Module 9: Troubleshooting Common SQL Server Issues

Topic 1: Complete SQL Server Troubleshooting Lab

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette