Video Tutorials :

SQL Server Database Administration (SQL DBA) (Updated 2 2020)

      Author: voska89   |   17 February 2020   |   comments: 0


SQL Server Database Administration (SQL DBA) (Updated 2 2020)
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


Learn SQL Server database administration (SQL DBA) from beginning

What you'll learn
SQL Server Database Administration - SQL DBA.
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-Time 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













Home        |        Register        |        Rules        |        Statistics        |        Sitemap        |        RSS        |        Contact Us
DISCLAIMER
None of the files shown here are hosted or transmitted by this server. The links are provided solely by this site's users. The administrator of this site (downturk.eu) cannot be held responsible for what its users post, or any other actions of its users. You may not use this site to distribute or download any material when you do not have the legal rights to do so. It is your own responsibility to adhere to these terms.

Copyright © 2019 DownTurk. All rights reserved.