SQL Server Training: SQL Server Administration


Course Delivery

Live Instructor-Led Training

Course Description

The course SQL Server Administration (SharePoint Training) covers database administration from A to Z on SQL Server. The training explores the installation & configuration of SQL Server as well as the design & creation of SQL Server data & log files using files & filegroups. The course also discusses data import & export, backup & recovery, SQL Server security, and SQL Server performance tuning & monitoring. The training concludes with a detailed discussion of indexes, index types & data storage optimization.

Course Dates and Pricing


Nov 19 - 22, 2024$3,750.00Jan 21 - 24, 2025$3,750.00Feb 18 - 21, 2025$3,750.00Mar 18 - 21, 2025$3,750.00Apr 22 - 25, 2025$3,750.00May 20 - 23, 2025$3,750.00Jun 17 - 20, 2025$3,750.00Jul 22 - 25, 2025$3,750.00

Course Outline

Introduction to SQL Server and its Toolset

Overview of SQL Server Services
SQL Server Services and Features
Working with SQL Server Tools
Designing the Environment: Creating Accounts and Configuring the Firewall
About Virtualizing SQL Server
Configuring Services in an Enterprise Environment
Configuring Protocols: Server and Client
Configuring DCOM Components for Enterprise Applications
Configuring SQL Server Browser
Modifying the Operating System for Performance
Installing SQL Server 2016
Tweaking SQL Server Memory
Configuring TempDB

Working with Databases

About SQL Server Databases. Files and Filegroups
Planning for Space Usage
Creating Databases with TSQL
Creating Files and Filegroups
Attaching and Detaching Database Files
About Database Settings
Retrieving Key Database Information using TSQL

Backup and Recovery

About SQL Server Recovery Models
About Full, Transactional and Incremental Backups
Delving Deeper into Transaction Logging
Planning a SQL Server Backup Strategy
Performing a Backup using TSQL
About Backup Options
Performing a Recovery using TSQL
About Recovery Options
Performing a Point in Time Recovery
Backup Strategies for System Databases

Importing and Exporting Data

Overview of Import/Export Tools
Importing/Exporting Data using Graphical Tools
Importing/Exporting Data using TSQL
Importing/Exporting Data using Integration Services

SQL Server Security

Understanding SQL Server Security Modes
Understanding SQL Server Logins, Users and Roles
Creating SQL Server Logins
Working with Server Roles
Working with Users and Database Roles
Creating Database Roles
Security and Stored Procedure Execution
Troubleshooting Data Access Issues

SQL Server Event Management and Auditing

Enabling SQL Server Auditing
Auditing Data Access in SQL Server
Managing Auditing
Configuring SQL Server Agent
Creating and Scheduling Jobs and Alerts
Creating Operators and Notifications
Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance

Working with indexes

Understanding the Anatomy of CRUD Operations
Understanding Page Internals
Understanding Indexes, Index Types and Table Storage
About Fragmentation and Data Storage
Creating Clustered Indexes
Creating Non-Clustered Indexes
Rebuilding Indexes
Managing Fragmentation
Tuning TSQL Statements

Tracing Access to SQL Server

Capturing Activity using SQL Server Profiler
Improving Performance with the Database Engine Tuning Advisor
Working with Tracing Options
Monitoring Activity
Capturing and Managing Performance Data
Analyzing Collected Performance Data

Troubleshooting Common SQL Server Issues

Complete SQL Server Troubleshooting Lab

Course Locations

  • Ottawa

  • Montreal

  • Toronto

Related SQL Server Training

SQL Server Training: Mastering Always-On Technologies

The course Mastering Always-On Technologies (SQL Server Training) allows database professionals to design, implement and monitor a robust database infrastructure that can serve clients 24/7. The training introduces the concepts of always on infrastructure design with SQL Server and discusses the full implementation & maintenance of the design with SQL Server. The course includes topology design, installation & configuration in a SQL Server Always-On context. Training course titled SQL Server Training: Mastering Always-On Technologies that will allow you to hone your professional skills.

Nov 26 - 29, 2024$3,000.00Jan 28 - 31, 2025$3,750.00Feb 25 - 28, 2025$3,750.00Mar 25 - 28, 2025$3,750.00Apr 29 - May 2, 2025$3,750.00May 27 - 30, 2025$3,750.00Jun 24 - 27, 2025$3,750.00Jul 29 - Aug 1, 2025$3,750.00

SQL Server Training: Performance Tuning & Optimization

The course Performance Tuning & Optimization (SQL Server Training) explores SQL Server performance. The training includes a general discussion of SQL Server architecture & configuration as it related to tuning activities. The course covers clustered & non-clustered indexes, SQL execution plans, join strategies & data storage considerations. Further, the training includes a discussion of the relative performance characteristics of stored procedures, joins, sub-queries, correlated sub-queries, covering indexes & more in a SQL Server environment. Training course titled SQL Server Training: Performance Tuning & Optimization that will allow you to hone your professional skills.

Nov 19 - 22, 2024$3,750.00Jan 21 - 24, 2025$3,750.00Feb 18 - 21, 2025$3,750.00Mar 18 - 21, 2025$3,750.00Apr 22 - 25, 2025$3,750.00May 20 - 23, 2025$3,750.00Jun 17 - 20, 2025$3,750.00Jul 22 - 25, 2025$3,750.00

SQL Server Training: The Complete TSQL Programming Course

The course The Complete TSQL Programming Course (SQL Server Training) covers every aspect of the TSQL development language. Beginning with database basics like creating databases and tables, we proceed to a thorough investigation of the TSQL language. We discuss variable declaration, conditional and looping expressions and the use of native SQL functions. You learn advanced topics such as string and date time manipulation, the use of NULL values in tables and scripts and the use of stored procedures and BLOB data. This is a busy and rewarding week. Training course titled SQL Server Training: The Complete TSQL Programming Course that will allow you to hone your professional skills.

Nov 19 - 22, 2024$3,750.00Jan 21 - 24, 2025$3,750.00Feb 18 - 21, 2025$3,750.00Mar 18 - 21, 2025$3,750.00Apr 22 - 25, 2025$3,750.00May 20 - 23, 2025$3,750.00Jun 17 - 20, 2025$3,750.00Jul 22 - 25, 2025$3,750.00

Oracle Training: Replication, Clustering & High Availability

The course Replication, Clustering & High Availability (Oracle Training) is an exploration of clustering & high availability with MySQL. The training includes clustering basic concepts and discusses the hardware, topology & software requirements of a clustered MySQL implementation. The course covers MySQL cluster design, installation, configuration & implementation. This MySQL course also includes a full discussion on MySQL cluster monitoring, troubleshooting & optimization. Training course titled Oracle Training: Replication, Clustering & High Availability that will allow you to hone your professional skills.

Nov 26 - 29, 2024$3,350.00Jan 28 - 31, 2025$3,750.00Feb 25 - 28, 2025$3,750.00Mar 25 - 28, 2025$3,750.00Apr 29 - May 2, 2025$3,750.00May 27 - 30, 2025$3,750.00Jun 24 - 27, 2025$3,750.00Jul 29 - Aug 1, 2025$3,750.00

SQL Server Training: Database Querying

The course Database Querying (SQL Server Training) covers every aspect of the SQL language. The training begins with a detailed discussion of creating databases & tables. The course studies every element of the SQL language with SQL Server. The training includes SQL data manipulation & modification statements, string & date time manipulation and the use of NULL values in SQL Server tables and TSQL scripts. The course also discusses advanced joins, filtering & sorting & aggregate data calculations with TSQL on SQL Server. Training course titled SQL Server Training: Database Querying that will allow you to hone your professional skills.

Jan 6 - 7, 2025$1,500.00Feb 3 - 4, 2025$1,500.00Mar 3 - 4, 2025$1,500.00Apr 7 - 8, 2025$1,500.00May 5 - 6, 2025$1,500.00Jun 2 - 3, 2025$1,500.00Jul 7 - 8, 2025$1,500.00

SQL Server Training: Transforming Data with SSIS

The course Transforming Data with SSIS (SQL Server Training) covers the full range of SSIS concepts from the basics of data sources to advanced data flows and control flows. The course begins with a tour of Visual Studio .NET and its many windows, dialog boxes and features. From there, you learn to import data from delimited & positional files, to export data to external data sources and to implement simple error conditions. The training includes how to implement complex data transformation tasks and how to handle NULL values & encoding changes. The course also discusses data load operations that are common to SQL Server data warehouses that make use of a Star schema. Training course titled SQL Server Training: Transforming Data with SSIS that will allow you to hone your professional skills.

Nov 20 - 22, 2024$3,350.00Jan 22 - 24, 2025$3,350.00Feb 19 - 21, 2025$3,350.00Mar 19 - 21, 2025$3,350.00Apr 23 - 25, 2025$3,350.00May 21 - 23, 2025$3,350.00Jun 18 - 20, 2025$3,350.00Jul 23 - 25, 2025$3,350.00