М20764C: Administration of SQL Server databases - course 60,990 rub. from Specialist, training 40 academic hours, date of May 15, 2023.
Miscellaneous / / December 06, 2023
Special purpose teacher, holder of prestigious international status Microsoft Certified Master. Graduate of Moscow State Technical University named after N.E. Bauman.
In his classes, Fedor Anatolyevich puts the principle at the forefront “Look to the root!” - it is important not only to study the operation of the mechanism, but also to understand why it works this way and not otherwise.
A generalist in the field of software design and development. He has many years of experience as a development team leader and chief architect. Specializes in enterprise application integration, web portal architecture development, data analysis systems, deployment and support Windows infrastructure.
The combination of engineering and natural science presentation styles allows students to convey the passion and creative approach of the teacher. Fedor Anatolyevich invariably receives the most enthusiastic reviews from his grateful graduates.
The first Microsoft Certified Trainer (MCT) in Russia!
Qualified Microsoft Authorized Training Instructor. One of the first in Russia and the CIS countries to receive the title of Microsoft systems engineer. He has invaluable practical experience as a Microsoft support engineer - the Microsoft Hotline service. Vladimir Anatolyevich taught the first group of Microsoft courses back in 1996, when he received MCT status. For 25 years, he has trained a huge number of qualified specialists who successfully work in a variety of organizations in Russia and other countries.
The competence of Vladimir Averin is evidenced by numerous certificates for the developed products.
Coaching qualifications:
Qualifications:
20 years of experience working with Microsoft technologies and products. Vladimir Anatolyevich constantly improves his qualifications and attends forums and conferences around the world. As a certified instructor, Vladimir Anatolyevich took part in major projects for training specialists from the largest organizations and enterprises of the Russian Federation.
The teacher has courses on the most “heavy” Microsoft server products.
Specializations:
Extensive teaching experience makes it possible for Vladimir Anatolyevich Averin to teach courses equally easily for both novice users and serious, highly qualified specialists. Satisfied listeners often speak of Vladimir Anatolyevich as a teacher who finds a common language with all his students, which helps them understand even difficult new material.
Leading teacher of the center for Microsoft Azure and network technologies Microsoft, has statuses MS: MCSA, MCSE, MCDBA and SCNP.
Microsoft Certified Trainer (MCT) with over 20 years of teaching experience. During his time as a teacher, he trained more than 4,000 specialists.
Alexander Vitalievich Candidate of Sciences, majoring in Cybernetics, author of professional articles on systems for processing, transmitting and protecting information, and automated control systems. Has more than 30 technical certifications (Microsoft, CompTIA, SCP, ITIL) and extensive experience in managing technical support for corporate customers.
Alexander Vitalievich worked for more than 14 years in the technical support service of Microsoft Corporation, of which more than 10 years led the group technical support for corporate customers, managing a team of more than 20 technical support managers and providing premium Premier support of more than 100 largest Russian corporations, including Magnit, Lenta, Russian Post, Kaspersky and etc. Alexander Vitalievich took an active part in the introduction of a new type of premium technical support (Microsoft Unified Support) in Russia in 2018-2020, focused on maximizing assistance in the implementation of cloud technologies in organizations.
During the classes, the teacher places the main emphasis on developing practical skills in students. In their reviews, graduates invariably note not only the information richness and structure of the material, but also the especially warm, friendly atmosphere, humor, and abundance of cases and stories from practice.
Module 1. SQL Server Security System (2 ac. h.)
- Authentication of connections to SQL Server
- Authorization of logins to access databases
- Authorization of linked servers
- Partially autonomous databases
- Laboratory work
Module 2. Using roles (3 ac. h.)
- Server roles
- Built-in database roles
- Creating roles in the database
- Laboratory work
Module 3. Restriction of access to resources (3 ac. h.)
- Authorization of users to access objects
- Authorization of users to execute code
- Setting permissions at the schema level
- Laboratory work
Module 4. Encryption and auditing (3 ac. h.)
- Data access audit options
- Built-in audit mechanism
- Audit management
- Data protection using encryption
- Laboratory work
Module 5. Recovery models and backup strategies (2 ac. h.)
- Backup strategies
- General information about the transaction log
- Planning a backup strategy
- Laboratory work
Module 6. Database backup (3 ac. h.)
- Backup databases and transaction logs
- Backup management
- Additional backup options
- Laboratory work
Module 7. Database recovery (3 ac. h.)
- Recovery process
- Database recovery
- Advanced recovery scripts
- Point in time recovery
- Laboratory work
Module 8. Automation of SQL server management (3 ac. h.)
- Automation of administrative tasks
- Working with SQL agent
- Job management
- Managing a group of servers
- Laboratory work
Module 9. Configuring security settings for the SQL agent (2 ac. h.)
- SQL agent protection mechanisms
- Setting up credentials
- Setting up proxy accounts
- Laboratory work
Module 10. Monitoring using warnings and notifications (3 ac. h.)
- Setting up Database Mail
- Bug tracking
- Setting up operators, alerts and notifications
- Alert mechanism in Azure SQL Database
- Laboratory work
Module 11. Using PowerShell (3 ac. h.)
- Introduction to Windows PowerShell
- Configuring SQL Server using PowerShell
- Administering SQL Server using PowerShell
- Manage Azure databases using PowerShell
- Laboratory work
Module 12. Tracing using extended events (2 ac. h.)
- Extended Events Concept
- Working with extended events
- Laboratory work
Module 13. Monitoring a SQL server (3 ac. h.)
- Activity monitoring
- Obtaining performance indicators
- Analysis of collected performance data
- SQL Server Utility Tool
- Laboratory work
Module 14. Resolution of typical problems (2 ac. h.)
- Methodology
- Typical problems related to the operation of the service
- Typical login problems
- Laboratory work
Module 15. Import and export of data (3 ac. h.)
- Move data from and to SQL Server
- Import and export of tabular data
- Using the BCP program and the BULK INSERT statement
- Deploying and updating data-tier applications
- Laboratory work
This course is designed for IT professionals involved in assessing, planning, deploying and operating Microsoft Office 365 services, including identities, dependencies, requirements, and support technologies. * *the course is taught in partnership with the ARMKYBERSEC Academy
4,2