This course provides students with the knowledge and
skills to maintain a Microsoft SQL Server database. The
course focuses on how to use SQL Server 2016
product features and tools related to maintaining a
database.
Note: This course is designed for customers
who are interested in learning SQL Server 2014 or SQL
Server 2016. It covers the new features in SQL Server
2016, but also the important capabilities across the
SQL Server data platform.
Individuals who work with SQL Server databases.
Individuals who develop applications that deliver content
from SQL Server databases.
Introduction to data communications & networking.
3 days
Database administration, SQL Server platform, database management tools and techniques.
Hands on SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server.
Data storage with SQL Server, managing storage for system databases, managing storage for user databases, moving database files, configuring the buffer pool extension.
Hands on Configuring tempdb storage, creating databases, attaching a database.
Transferring data, importing and exporting table data, copying or moving a database.
Hands on import and export wizard, bcp utility, BULK INSERT statement, OPENROWSET function.
Monitoring SQL Server, dynamic management views and functions, performance monitor.
Hands on Baseline metrics, monitoring a workload.
Tracing workload activity, using traces.
Hands on Capturing a trace in SQL Server profiler, generating tuning recommendations.
SQL Server security, server-level security, database-level principals, database permissions.
Hands on SQL Server security. Testing access.
"Able to customise course which was excellent."
"Good pace. Well tailored to fit the needs of the group."
This structured training course seeks to build upon workbook learning through the use of group exercises, dynamic discussion and individual tasks in order to deliver an engaging and interactive module that will ensure all candidates are able to transfer their new skills into the workplace.