J. S., Framestore CFC
B. M., London Internet Exchange
Microsoft SQL Server training course contents
Introduction to SQL Server administration
Database administration, SQL Server platform, database management tools and techniques. Lab: SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server.
Installing and configuring SQL Server 2014
Planning SQL Server installation, installing SQL Server 2014, post-installation configuration. Lab: installing SQL Server.
Working with databases and storage
Data storage with SQL Server, managing storage for system databases, managing storage for user databases, moving database files, configuring the buffer pool extension. Lab: Configuring tempdb storage, creating databases, attaching a database.
SQL Server recovery models, backup strategies, backing up databases and transaction logs, backup options, ensuring backup reliability Lab: Backing up database, database differential, and transaction log backups, partial backup.
Restoring SQL Server 2014 databases
The restore process, restoring databases, advanced restore scenarios, point-in-time recovery. Lab: restoring databases.
Importing and exporting data
Transferring data, importing and exporting table data, copying or moving a database. Lab: import and export wizard, bcp utility, BULK INSERT statement, OPENROWSET function.
Monitoring SQL Server 2014
Monitoring SQL Server, dynamic management views and functions, performance monitor. Lab: Baseline metrics, monitoring a workload.
Tracing SQL Server activity
Tracing workload activity, using traces. Lab: Capturing a trace in SQL Server profiler, generating tuning recommendations.
Managing SQL Server security
SQL Server security, server-level security, database-level principals, database permissions. Lab: SQL Server security. Testing access.
Auditing data access and encrypting data
Auditing data access in SQL Server, SQL Server audit, encrypting databases. Lab: auditing data access and encrypting data.
Performing ongoing database maintenance
Database integrity, maintaining indexes, automate maintenance. Lab: DBCC CHECKDB.
Automating SQL Server 2014 management
Automating SQL Server management, SQL Server agent jobs, job step security contexts, managing jobs on multiple servers. Lab: Creating a job, scheduling a job, configuring job step security contexts
Alerts and notifications
Monitoring SQL Server errors, configuring database mail, configuring operators, alerts, and notifications. Lab: monitoring SQL Server by using alerts and notifications.
Why Choose Us
SNT trainers score an average of over 90% on the three main areas of:
- Ability to teach
- Technical knowledge
- Answering questions
We limit our maximum class size to 8 delegates; often we have less than this. This ensures optimal interactivity between delegates and instructor.
"Excellent course. The small class size was a great benefit…" M.B. IBM
We write our own courses; courseware does not just consist of slides and our slides are diagrams not bullet point text. A typical chapter provides clearly defined objectives with a chapter overview, slides with text underneath, a quiz at the end to check the learning of the students. Hands on exercises are at the end and are used to reinforce the theory.