Description
SQL language is one of the most sought-after features of today’s popular professions. In Indeed’s 2022 report, SQL comes first with 45% of the data-related features sought, followed by Python and other platforms.
However, SQL is the lingua franca of all databases and has few commands, so it is an easy language to learn.
In this course, participants will learn the skills required to maintain Microsoft SQL Server databases, focusing on data storage, backup, restore, importing and exporting data, security, database maintenance, and SQL Server Agent.
About Education
The objectives of this training:
- Database management tasks and tools
- Installing and configuring SQL Server
- Configure SQL Server databases and storage
- Backup strategy planning and implementation
- Restoring databases from backups
- Import and export data
- Monitoring SQL Server
- Monitor SQL Server activities
- Managing SQL Server security
- Control data access and encrypt data
- Running database maintenance jobs without interruption
- Automate SQL Server maintenance with SQL Server Agent jobs
- Configure database email, alerts and notifications
The envisaged content of this training:
- Introduction to SQL Server Database Administration
Database Management Overview
Introduction to SQL Server Platform
Database Management Tools and Techniques
- Installing and Configuring SQL Server
Planning a SQL Server Installation
Installing SQL Server and Post-Installation Configuration
- Working with Databases and Storage
Introduction to Data Storage with SQL Server
Managing Storage for System Databases and User Databases
Move Database Files
Configure the Buffer Pool Extension
- Planning and Implementing a Backup Strategy
SQL Server Recovery Models
Planning a Backup Strategy
Backup Databases and Transaction Logs
Backup Options and Backup Reliability
- Restoring SQL Server Databases
Restore Process and Restoring Databases
Advanced Restore Scenarios
Instant Rescue
- Import and Export Data
Data Transfer
Import and Export Table Data
Copy or Move a Database
- Monitoring SQL Server
Introduction to Monitoring SQL Server
Dynamic Management Views and Functions
Performance display
- Monitor SQL Server Activity
Monitor SQL Server Workload Activity and Use Traces
- Managing SQL Server Security
Introduction to SQL Server Security
Managing Server-Level Security and Database-Level Custodians
Manage Database Permissions
- Controlling Data Access and Encrypting Data
Controlling Data Access in SQL Server
SQL Server Auditing Implementation
Encrypting Databases
- Performing Ongoing Database Maintenance
Ensuring Database Integrity
Protecting Directories
Automating Routine Database Maintenance
- Automating SQL Server Administration
Implementing and Managing SQL Server Agent Jobs
Managing Workstep Security Contexts
Manage Work on Multiple Servers
- Monitor SQL Server Using Alerts and Notifications
Monitoring SQL Server Errors
Configure Database Mail
Configure Operators, Alerts and Notifications
Participants at the end of the training;
- Will be able to query data from a database on SQL Server and write SQL sentences required for reports.
- They will learn to use the functions and procedures needed on the TSQL side.
Who Should Receive the Training?
This course is suitable for people who want to write queries, perform development, prepare reports and design high-performance databases on Microsoft SQL Server.
Plan this training institutionally!
This training can be planned in different durations and content specific to your organization. Please contact us for detailed rich content and planning to realize your training objectives.
