logo
SQL Server Database Administration (SQL DBA) (Updated 2/2020)
Разное | Автор: LeeAndro | Добавлено: 17-02-2020, 06:38 | Просмотров (14) | Комментариев (0) | Жалоба |
SQL Server Database Administration (SQL DBA) (Updated 2/2020)
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 1.44 GB
Genre: eLearning Video | Duration: 27 lectures (3 hours, 50 mins) | Language: English

SQL Server Database Administration - SQL DBA.


What you'll learn

Basic Powershell

SQL DBA Interview Q & A

SQL Database backup & Restore

Replication, Log shipping, AlwaysOn and clustering

Requirements

No, it is starting from Basic to Advance

Description

SQL Server Database Administrator course, normally in the IT sector we called as SQL DBA. This course includes basic tutorial for Azure SQL Database as well.

My course will cover all the below topics/modules. (Course is not completed, in progress. )

Module 1: Introduction to Database Administration

· Database Administration Roles and Responsibilities.

· Introduction to the SQL Server Platform

· Database Management Tools and Techniques

Module 2: Installing and Configuring SQL Server 2017 and 2019

· Installation of SQL Server 2019 using GUI

· Installation of SQL Server 2017 using Configuration file- kind of automation.

· Post-Installation Configuration

Module 3: Databases and Storage

· Introduction to Data Storage with SQL Server

· Managing Storage for System Databases

· Managing Storage for User Databases

· Moving Database Files

· Configuring the Buffer Pool Extension

Module 4: Backup

· SQL Server Recovery Models

· Planning a Backup Strategy

· Backing up Databases and Transaction Logs

Module 5: Restoring

· Restore Process

· Restoring Databases

· Advanced Restore Scenarios

· Working with Point-in- Recovery

Module 6: Importing and Exporting Data

· Introduction to Transferring Data

· Importing and Exporting Table Data

· Copying or Moving a Database

Module 7: Trace flags

· Tracing SQL Server Workload Activity

· Using Traces

Module 8: SQL Server Security

· Introduction to SQL Server Security

· Managing Server-Level Security

· Managing Database-Level Principals

· Managing Database Permissions

Module 9: Database Maintenance

· Ensuring Database Integrity

· Maintaining Indexes

· Automating Routine Database Maintenance

Module 10: Monitoring SQL

· Monitoring SQL Server Errors

· Configuring Database Mail

· Configuring Operators, Alerts, and Notifications

Module 11: SQL Server high availability and disaster recovery

Lessons:

· Log shipping

· Replication

· SQL Cluster

· AlwaysOn availability Group

Module 12: Azure SQL Database

Module 13: Interview

Who this course is for:

Anyone who wants to start their career as SQL/ Azure SQL DBA including Powershell



DOWNLOAD
uploadgig


rapidgator


nitroflare
Уважаемый посетитель, Вы зашли на сайт как незарегистрированный пользователь. Мы рекомендуем Вам зарегистрироваться либо войти на сайт под своим именем.
  • 0
Похожие новости:
Информация
Посетители, находящиеся в группе Гости, не могут оставлять комментарии к данной публикации.
Панель управления
Навигация
На сайте
Пользователей Юзеры (0)
Гостей Гости (17)
guestguestguestguestguestguestguestguestguestguestguestguestguestguestguestguestguest
Роботов Боты (2)
crawl Botbot
Всего Всего на сайте (19)
Популярное
Не попавшее на главную
Архивы сайта