(Click Category to List Courses)

37 - IT-D Information Technology - Databases and Related Technologies


IT-D 221 - Administering a SQL Database Infrastructure

Code Start Date Duration Venue Fees
IT-D 221 12 December 2020 5 Days Istanbul $ 3950 Registration Form Link
IT-D 221 02 January 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 221 27 February 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 221 27 March 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 221 24 April 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 221 22 May 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 221 19 June 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 221 14 August 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 221 11 September 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 221 09 October 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 221 06 November 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 221 04 December 2021 5 Days Istanbul $ 3950 Registration Form Link
DOWNLOAD PDF

 

Course Description

In this course, professionals who administer and maintain SQL Server databases and who develop applications that deliver content from SQL Server databases will gain 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. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

Course Objectives

  • Authenticate and authorize users
  • Assign server and database roles
  • Protect data with encryption and auditing
  • Describe recovery models and backup strategies
  • Backup SQL Server databases
  • Configure security for the SQL Server agent
  • Managing SQL Server using PowerShell
  • Monitor a SQL Server infrastructure
  • Troubleshoot a SQL Server infrastructure

Who Should Attend?

  • Managers
  • IT professionals
  • Engineers involved in data storage operations
  • Anyone who deals directly or indirectly with data

Course Details/Schedule

Day 1

  • SQL Server Components
  • Installing SQL Server
  • SQL Server Security
  • Authenticating connections to SQL Server
  • Authorizing logins to connect to databases
  • Authorization across servers 
  • Assigning Server and Database Roles
  • Working with server roles and fixed database roles
  • Assigning User-Defined Database Roles
  • Authorizing Users to Access Resources
  • Authorizing user access to objects and to execute code
  • Configuring permissions at the schema level

Day 2

  • Database Maintenane 
  • Protecting Data with Encryption and Auditing
  • Implementing and managing SQL Server audit
  • Protecting data with encryption
  • Recovery Models and Backup Strategies
  • SQL Server transaction login
  • Planning a backup strategy
  • Backup of SQL Server Databases
  • Managing database backups
  • Working with backup options

Day 3

  • Restoring SQL Server 2016 Databases
  • Point-in-time recovery
  • Performing a Piecemeal Restore
  • Automating SQL Server Management
  • Working with SQL Server agent
  • Managing SQL Server agent jobs
  • Configuring Security for SQL Server Agent
  • Configuring credentials
  • Configuring proxy accounts

Day 4

  • Monitoring SQL Server with Alerts and Notifications
  • Configuring database mail
  • Operators, alerts and notifications
  • Alerts in Azure SQL database
  • Introduction to Managing SQL Server by using PowerShell
  • Configure SQL Server using PowerShell
  • Administer and Maintain SQL Server using PowerShell
  • Managing Azure SQL Server databases using PowerShell
  • Tracing Access to SQL Server with Extended events
  • Extended Events Core Concepts

Day 5

  • Monitoring SQL Server
  • Capturing and managing performance data
  • Analyzing collected performance data
  • SQL Server utility
  • Troubleshooting SQL Server
  • Cluster (SQL Server AlwaysOn)
  • Resolving service related issues, login and connectivity issues
  • Importing and Exporting Data
  • Transferring data to/from SQL Server
  • Using BCP and BULK INSERT to import data
  • Deploying and upgrading data-tier applications