SQL DBA Online Training

About SQL DBA Online Training:

  • This SQL DBA Online Training from Real-time, Certified Trainers includes Basic to Advanced Database Administration activities : Capacity Planning, Query Tuning, Index Management, Database Maintenance, High Availability (HA), Disaster Recovery (DR), Query Store, In-Memory Tables, Database Repairs, Page Repairs, Jobs, Alerts, Resource Management, Security Management including Azure SQL DBA Activities like Azure Sync, Azure Server Failover, Azure Virtual Machines and Azure DB Migrations.
    Today we cannot imagine our life, our business without proper database. We always wish to analysis data and obtain report from data in order that they will manage their life and their organization in proper order. meaning that there’s highly demand of database. database isn’t only important for storing the info in proper order .Beside this there’s also numbers of application where it pays the large roles to perform efficiently. here are some point that he mention thereEasy access to data
  • Easy integration and reporting the data
  • Easy sharing of information.
  • Powerful analysis of information.
  • Massive Scale
  • Ready for future.

About Instructor

                               SQL DBA Online Training is provided by a real time consultant. The experience acquired by our trainer on SQL DBA, is promisingly helpful to the corporate trainee’s. Our instructors are experts in the implementation and support projects. ASTS always works on real time scenarios. It is extremely useful for the professionals to handle the projects easily in the IT industry.

Prerequisites:

  • Command-line program,
  • Relational database systems will be an added advantage

Terms And Conditions

  • We will Provide Supporting to resolve Student practical Issues.
  • We will provide server Access and 100% Lab Facility.
  • Resume Preparation.
  • Interview Questions & Answers.
  • We will conduct mock interviews. Student also gets 100% supporting before and after getting job.

SQL DBA Online Training Course Content:

Starting with SQL Server 2019

  • Responsibilities of Database Administrator
  • Types of DBA’s
  • History of SQL Server – Versions
  • What’s new in SQL Server 2019 for Administrators?
  • Editions of SQL Server
  • Differences between Enterprise and Standard Editions
  • Requirements
    • Hardware
    • Software
  • Instances  & its advantages
  • Types
    • Default Instance
    • Named Instances

Installing and Configuring

  • Installing SQL Server 2019
    • Pre –Installation Steps
    • Installations
    • Viewing the Installation process with Log files
    • Common issues
    • Adding or removing components
    • Installing Service Packs
  • Configuration
    • Configuration of Various Services
    • Startup Parameters
    • Configuring data files and log file paths
    • Memory Configuration
    • Remote Connections
    • Configuring network protocols, Ports
    • Configuring Services
    • Configuring default backup folder.

Working with Databases

  • Working with Databases
    • System Defined databases
    • Moving System Databases
    • Handling TempDB database
  • Database Architecture
    • Data Files
    • Log Files
    • Filegroups
    • Extents
    • Pages –Types
    • Page Architecture
    • Tracking Free Space
    • Log file full – How to troubleshoot.
  • Creating Databases
  • Adding files, Filegroups
  • SQL Server Architecture

Security in SQL Server 2019

  • Security Enhancements
  • Types of Authentications.
    • Windows Authentication
      • Creating logins from windows users and groups
      • Orphan logins
  • SQL Server Authentication
    • Creating SQL logins and testing logins
    • Setting Authentication Mode
    • Security Auditing
    • Understanding Server roles
    • Working with users
    • Resolving Orphan users
    • Understanding database roles
    • Understanding permissions
    • Major Issues

Backup and Restoration

  • Recovery Models Setting Recovery Model
    • Full
    • Bulk Logged
    • Simple
  • Database Backups
    • Why we need backups
  • Backup Types Copy-Only, Mirrored and Tail log backups
    • Full
    • Differential
    • Transaction Log
    • File or Filegroup
  • Backup Devices
  • Performing Restoration
  • Backup System Databases
  • Point-in-time Recovery
  • Viewing complete details of the backup process
  • Issues related to backups

Introduction to High Availability and Working with Log Shipping

  • Introduction to High Availability
  • Working with Log Shipping
    • Features
    • Jobs
    • Requirements to implement Log Shipping
    • Configuring Log Shipping
    • Monitoring Log Shipping
    • Manually performing Fail Over
    • Transferring Logins
    • Log Shipping tables and stored procedures
    • Handling Issues

Introduction to Always ON & Replication

  • Always-ON

    • HADR Internals & advantages
    • Setting up HADR
    • Adding a DB to the AG
    • Patching in Always on
    • Adding a Replica in AG
    • Setting up Listener & read-only Replicas in AG
    • Troubleshooting & maintenance
  • Replication

    • Replication and Advantages
    • Replication Entities
    • Replication Architecture
    • Replication Agents
    • Types of Replications
    • Configuring Replication
    • Snapshot Replication
    • Transactional Replication
    • Merge Replication
    • Peer to Peer replication
    • Managing Replication
    • Monitoring and Tuning Replication

Clustering SQL Server

  • Clustering SQL Server
  • Overview of Windows Clustering
  • Requirements
  • Installation and configuration of SQL Server Clustering
  • Applying Service packs and fixes
  • Moving groups
  • Adding node on a SQL Server Failover Cluster
  • Troubleshooting Cluster issues.

Automating Administrative Tasks

  • Maintenance Plans
  • Working with Database Mail Configuring
    • Mail Architecture
    • Configuring Profiles and Accounts
    • Sending Mails
  • Implementing Automation
    • Configuring SQL Server Agent
    • Creating Operators, Alerts, Jobs
    • Managing jobs and resolving errors
    • Monitoring Jobs
    • Auto alert when jobs are enabled, disabled or failed

Advanced Administration Concepts

  • Database indexes understanding
  • Checking index defragmentation & Maintenance
  • Database Health Check
  • Understanding SQL Server Profiler
  • Creating & Running Traces
  • Understanding Extended Events
  • Creating & configuring Extended Events
  • Monitoring Tools
    • System Monitor
    • SQL Server Profiler
    • Database Engine Tuning Advisor
    • Dynamic Management Views
    • SQL Server and Windows Error Logs
  • TroubleshootingLocks
    • Physical Server Performance
    • Connectivity to SQL Server
    • Database Performance
  • Dead Locks
  • Transaction Isolation Levels
  • Understanding Blocking
  • Terminating Processes
  • Using the DAC
  • Managing Databases

 

share this
Top ↑