Microsoft SQL allows you to manage data on demand, whether it is stored or retrieved. You will be able to retrieve information from all your data (relational, non-relational, structured and unstructured), and thus build a complete picture of your organization.
Duration
5 days
Schedule
9h to 16h
Regular fee
$2,395
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$2,155
Objectives of the training
To provide the knowledge and skills required to install, configure and administer MS SQL ServerTargeted audience
Developers, database administrators, network specialists and Web specialists.Prerequisite
Experience with basic MS SQL syntax (Course BD102).Trainers
Course architecture
- Overview and architecture of Microsoft MS SQL Server
- The tasks of a DBA
- Planning the installation of MS SQL Server
- SQL Server administration tools
- Migration to MS SQL Server 2019 and compatibility level management
- Configuration and optimization of SQL Server 2019
- SQL in virtualization mode
- What's new in performance optimization
- What's new with tempdb
- Data files and logs (MDF, NDF and LDF)
- Optimized Memory Tables and Partitioning
- System and user database overview and configuration
- Database backup and restore strategy
- Storage optimization with backup compression
- Access, security, permissions and certificate management
- Use of Dynamic Data Masking
- Execution and automation of administrative and scheduled tasks
- Management and optimization of indexes and statistics + Index columnstore
- Implementation of maintenance plans with best practices
- Profiler and eXtended Events (XEvents) to track usage
- Query Store and SQL server audit
- Management and configuration of alerts and database mail
- Performance and activity monitoring and optimization
- Implementation of replication
- Maintaining high availability with AlwaysOn
- Overview of an integration project (SSIS)
- The tasks of a DBA
- Planning the installation of MS SQL Server
- SQL Server administration tools
- Migration to MS SQL Server 2019 and compatibility level management
- Configuration and optimization of SQL Server 2019
- SQL in virtualization mode
- What's new in performance optimization
- What's new with tempdb
- Data files and logs (MDF, NDF and LDF)
- Optimized Memory Tables and Partitioning
- System and user database overview and configuration
- Database backup and restore strategy
- Storage optimization with backup compression
- Access, security, permissions and certificate management
- Use of Dynamic Data Masking
- Execution and automation of administrative and scheduled tasks
- Management and optimization of indexes and statistics + Index columnstore
- Implementation of maintenance plans with best practices
- Profiler and eXtended Events (XEvents) to track usage
- Query Store and SQL server audit
- Management and configuration of alerts and database mail
- Performance and activity monitoring and optimization
- Implementation of replication
- Maintaining high availability with AlwaysOn
- Overview of an integration project (SSIS)
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quoteDuration
5 days
Schedule
9h to 16h
Regular fee
$2,395
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$2,155
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote