Course
Administering Microsoft SQL Server
Course Duration
5 Days
This five-day instructor-led course provides students who wish to administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.
Private Courses
This course is available as a private event. A private event can be held at one of our venues, your location, or somewhere else if you prefer.
Prerequisites
-
- In addition to their professional experience, delegates who attend this training should already have the following technical knowledge:
Essential:
Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of Transact-SQL or have attended Querying SQL Databases using T-SQL
Nice to have:
Working knowledge of relational databases.
Some experience with database design.
- In addition to their professional experience, delegates who attend this training should already have the following technical knowledge:
Objectives
-
- Design and implement SQL Instances
- Authenticate and authorize users
- Assign server and database roles
- Authorize users to access resources
- Protect data with encryption and auditing
- Describe recovery models and backup strategies
- Backup SQL Server databases
- Restore SQL Server databases
- Automate database management
- Configure security for the SQL Server agent
- Manage alerts and notifications
- Manage on-going SQL Database maintenance
- Securing SQL data
Target Audience
-
- The primary audience for this course is individuals who will administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
Course Content
-
SQL OverviewThis module introduces the main terms used within the administration of SQL Server instances and discusses the requirements of SQL architecture such as which services are available, and which security options are available.
Introduction to the SQL Server Platform
Overview of SQL Server Architecture
-
SQL Server InstallationThis module is aimed at installing a SQL instance (default or named), selecting the services required and reviewing installation options. The lessons covered include the considerations for installation, configuration of the tempdb, defaults for database files location, and other SQL instance options, unattended installs using the GUI or command line and upgrading SQL Server instances.
Considerations for Installing SQL Server
tempdb Files
Installing SQL Server
Automating Installation
Upgrading SQL Server
-
Working with SQL DatabasesThis module looks at the tasks that could be undertaken by administrators working with databases both set up and maintaining.
Introduction to Data Storage with SQL Server
Managing Storage for System Databases
Managing Storage for User Databases
Moving and Copying Database Files
SQL Server Transaction logs
Ensuring database integrity
Maintaining indexes
-
Backup and Restore SQL DatabasesThis module covers all aspects for backup and restore using SQL Server.
Backup Types
Managing Database Backups
Advanced Database Options
Understanding the Restore Process
Restoring Databases
Advanced Restore Scenarios
Point-in-time Recovery
-
SQL Server AuthenticationThis module covers the setup and maintenance of logins and users and connections at the both the instance and database levels. Often SQL queries will be cover multiple instance and database, linked servers are covered.
Authenticating Connections to SQL Server
Authorizing Logins to Connect to Databases
Authorization Across Servers
Partially Contained Databases
-
Server and Database RolesThis module covers the creation and maintenance of roles at the server and database level.
Working with Server Roles
Working with Fixed Database Roles
User-Defined Database Roles
-
Database Object SecurityThis module covers security for objects at the database level such as tables, view, stored procedures, and functions. This topic is usually a collaboration between the administrators and developers.
Authorizing User Access to Objects
Authorizing Users to Execute Code
Configuring Permissions at the Schema Level
-
Data SecurityThis module builds on the object level security of the previous module to protect the security of data from the protection of data within the objects.
Protecting at row and column levels
Column level permissions
Row-level security
Dynamic data masking
Auditing data changes
Auditing with Triggers
Auditing with Temporal Tables
Managing SQL Server Audit
Introduction to SQL Server Audit
Defining a Server Audit
Creating Server and database Audit Specifications
Audit-Related Dynamic Management Views and System Views
Custom Audit Events
Protecting Data with Encryption
Transparent Data Encryption
Moving Encrypted Databases
Introduction to Always Encrypted
Adding encryption keys
Implementing always encrypted
-
Automating SQL Server managementThis module covers the automation of administration with the SQL Server instance using database mail, jobs, alerts and operators.
Automating SQL Server Management
Understanding SQL Server Agent Security
Overview of Security in SQL Server Agent
SQL Server Agent Roles
Assigning Security Contexts to SQL Server Agent Job Steps
Overview of database mail
Managing Credentials
Managing Proxy Accounts
Configuring Jobs
Configuring Operators
Configuring Alerts
Configuring multi-server jobs
You can choose your learning path and delivery style. Courses are delivered at one of our training venues throughout the UK. Small class sizes. Course materials included. Flexible course content. Expert trainers and tried & tested training methods. 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.
- Virtual Training
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:5/3/2024 12:05:25 AM
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:5/3/2024 12:05:25 AM