Data - SQL Server
SQL Server is a relational database management system developed by Microsoft, used to store, manage, and analyze data.
Flexible 100% online training
Start your new career at any time! Available part-time? No problem, study at your own pace.
Professional projects
You will develop your professional skills by working on concrete projects inspired by business reality. No problem, study at your own pace.
Personalized support
Benefit from weekly mentoring sessions with a business expert.
Earn certificates and diplomas
Earning certificates and degrees can enhance your career, broaden your horizons, and provide you with increased personal satisfaction.
SQL Server Training Objectives
Operational objective:
Know how to implement the best high availability and disaster recovery strategy with SQL Server (from version 2012 to 2019).
Educational objectives:
At the end of this SQL Server High Availability training you will have acquired the necessary knowledge and skills:
- Understand the principles of high availability solutions offered in SQL Server
- Know the prerequisites and essential conditions for setting up a failover cluster or Always On availability groups
- Install SQL Server Instances in Failover Cluster
- Configure AlwaysOn Availability Groups
- Implement a log shipping solution
- Identify the benefits and limitations of other availability solutions offered in SQL Server
Who is this training for?
Audience: This SQL Server High Availability training is primarily aimed at database administrators, operations managers, as well as system administrators and engineers.
Prerequisites:
To follow this SQL Server High Availability course, it is necessary to know and practice SQL Server administration.
A pedagogy based on practice
- Acquire essential skills by validating professional projects.
- Progress with the help of a professional expert.
- Gain real know-how as well as a portfolio to demonstrate it.
SQL Server 2016 initiation course content:
Introduction to Databases
Introduction to Relational Databases
Other database types
Data analysis
Database language
Data Modeling with SQL Server 2016
Data modeling
ANSI/SPARC Database Model
Entity Relationship Model
Standardization
Why normalize data?
Conditions of standardization
The different levels of standardization
Denormalization
Relation
Schema Mapping
Referential integrity
Performance of SQL Server 2016 databases
Indexing
Query Performance
Competitive access
SQL Server 2016 Database Objects
The tables
The views
Stored Procedures
Other database objects
Individual and privileged supervision.
- Benefit from weekly individual sessions with an expert mentor in the field
- quickly in your projects thanks to its excellence in sharing its know-how
The Empire Training community
- Count on a close-knit community of students ready to help you 24/7.
Online pre-registration
Please fill out the form
Please fill out the form
How does an Empire Training course work?
From the chosen training to their entry into their new career, our students recount each stage of their experience and the support they received.
