SQL Server DBA Training

Viswa Online Trainings is one of the world’s leading online IT training providers. We deliver a comprehensive catalog of courses and online training for freshers and working professionals to help them achieve their career goals and experience our best services.

4627 Reviews
5/5

Duration :  30 Days

About Course

Dell Boomi understands the need for a quality training curriculum along with real-time implementation exposure as it forms the very essence of your future career in Boomi Certification. Our well-structured online training course in Dell Boomi Training extensively covers all the core aspects of classes with an emphasis on live scenarios. Access to expert trainers and instructor-led training sessions ensures that you can easily clear your doubts and get the exact guidance that is expected from Dell Boomi Online Training sessions.

Upcoming Live Online Classes

 
10-SEP-2022 TO 05-DEC-2022

 08:00 AM

 
10-SEP-2022 TO 05-DEC-2022

 08:00 AM

Can't Find Your Convenient Batch?

SQL Server DBA Training Course Syllabus

  • SQL Server DBA 2019 Installation
  • Server Components and Purpose
  • New features of SQL Server 2019
  • Service Accounts, Purpose, and Usage
  • Authentication Modes & Logins
  • Instance Configuration Options
  • Management Studio (SSMS) Tool Usage
  • Troubleshooting the failed Instance
  • Establishing Downtime For Maintenance
  • Service Packs and Patch/hotfix Activities
  • Pre Database Maintenance Activities
  • Post Database Maintenance Activities
  • Steps for doing the Side-by-Side Migration
  • Migration with Backup and Restore Method
  • Migration of the Logins and Fixing Orphan users
  • Merits/Demerits of the side by Side Migration
  • Import and Export utility
  • Scripts for copying the tables with data
  • Configuration of the Network Protocols
  • Dedicated Administrator Connection(DAC) configuration
  • What is RAID Levels and choosing the Best suited for All DBs
  • Database Configurations
  • Attaching and detaching SQL Server DBA
  • What is TempDB
  • Corruption of TempDB
  • How to troubleshoot and avoid common tempdb issues
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
  • Starting and Stopping the SQL Server Services
  • Configuration Manager
  • Net commands
  • Command Prompts and SQL CMD
  • Starting the Dbs in Single-user Mode
  • What is a database and a database management system (DBMS)
  • ACID Properties
  • The Life Cycle of a Query
  • The Relational and Storage Engines
  • Recovery
  • Difference between Checkpoint and LazyWriter
  • Types of System Dbs
  • Startup Parameters
  • Licencing of SQL Server DBA
  • Pages & Types of Pages
  • Extents and Types of Extents
  • Managing Extents
  • Data Files: Purpose and Storage
  • Filegroups: Purpose and Usage
  • Log files: Purpose and Audits
  • Shrinking the log files
  • File growth and MAXSIZE Options
  • Scripting Database Structures
  • Security
  • Security Architecture
  • Fixing the Server Roles
  • Creating Logins
  • Fixed Database Roles
  • Database Users
  • SQL Server Agent and Monitoring the Agent logs
  • Troubleshooting the Jobs with help of Logs and Event Logs
  • Steps for creation of Jobs with different steps.
  • Job Activity Monitor and History Deletes
  • Database Maintenance Plans.
  • DB Maintenance Strategies & Schedules
  • Monitoring tools used for SQL Server Monitoring
  • Log file Viewer and Maintenace of Log File Viewer
  • Activity Monitor
  • Database reports
  • Monitoring Processes in T-SQL
  • sp_who and sp_who2
  • sys.dm_exec_connections
  • Backups with T-SQL Scripts
  • Backups Concept and Mechanism
  • Data Backups – Syntax and Types
  • Log Backup Mechanism and Use
  • COMPRESSION, CHECKSUM, and STATS
  • Scheduling Backups & Strategies
  • FILELISTONLY and VERIFYONLY Options
  • COPY_ONLY Backups and Importance
  • Compatibility, Recovery Model Options
  • Working with Recovery Models & Backups
  • Point-In-Time Restores & Recovery
  • Overwrite Options for DB Restores
  • Log Shiping
  • Log Shipping Overview
  • Configuration of the Log Shipping
  • Deploy Log Shiping
  • DB Mirroring Architecture & Use
  • Mirroring Configuration Scenarios
  • Backups & Restores for Mirrors
  • Architecture
  • Availability Group Replicas and Roles
  • Availability Modes
  • Types of Failover Supported
  • Allowing Read-Only Access to Secondary Replicas
  • Availability Group Example
  • Configure a New Availability Group
  • Configure an Existing Availability Group
  • AlwaysOn Group Dashboard
  • Understanding SQL Clustering Need
  • SQL Server Clustering Architecture
  • Windows Server Installation Options
  • SQL Server Cluster Installation (VM)
  • Add Nodes to SQL Server Cluster
  • Replication Overview
  • Replication Components
  • Replication Types
  • Implementing Replication
  • Implementing Transactional
  • Replication Monitor
  • Understanding the Memory
  • Windows and Memory
  • Physical Memory
  • SQL Server Memory
  • Understanding Wait Statistics
  • Locks a currency
  • Lock Types
  • Blocking and how to monitor the blocking
  • DMVs for monitoring the blocking
  • Table and Index Architecture
  • Cluster and Non-Cluster indexes
  • What is Heap
  • Cluster index structure
  • Index fragmentation
  • DMVs for checking the indexes
  • Common Causes of High CPU Usage
  • Outdated statistics
  • I/O
  • Disks
  • Performance counters for Disk I/Os

Course Details

  • Live Instructor Based Training
  • Real-Time Oracle Certified Trainer
  • 1 Yr. Membership to Multiple Batches
  • Live Recorded Videos Access
  • Latest Instance Access for 5 Months
  • Study Material Provided
  • Sample Resumes & Preparation
  • Interview Questions with Ans

CHOOSE YOUR OWN COMFORTABLE LEARNING EXPERIENCE

Corporate Training

  • Learn As A Full Day Schedule With Discussions, Exercises,
  • Practical Use Cases
  • Design Your Own Syllabus Based
Popular

Self-Paced Learning

  • Complete set of live-online training sessions recorded videos.
  • Learn technology at your own pace.
  • Get access for lifetime.
Popular

Live Virtual Training

  • Schedule your sessions at your comfortable timings.
  • Instructor-led training, Real-time projects
  • Certification Guidance.
Popular

Happy Students Reviews

Dami
Dami@dami
Read More
The trainer who taught me was very good. The total journey went great. He used to teach me from the beginner level to the advanced…
Surekha
Surekha@Surekha
Read More
The training experience and throughout the duration of course was excellent.I took SAP ABAP couse here which has covered all the topics from beginner to…
Vikram Kumar
Vikram Kumar@Vikram_Kumar
Read More
Best training in Java Script and Angular JS. Recording classes are very good. Focused on every concept with practical approach. This institute gives best training…
Yaswanth
Yaswanth@Yaswanth
Read More
Trainer was good in understanding the requirements and trained the topics with relevant examples for a better understanding. The training was interactive and content was…
Abey
Abey@Abey
Read More
Nice institute with very good facilities for trainer and trainee. Highly recommend it for SAP S4 Hana Basis training. Rajendra Prasad is very helpful and…
Abdhul Mohammad
Abdhul Mohammad@Abdhul_Mohammad
Read More
I had a good experience with VISWA Technologies My trainer was Pradeep sir, he is a good trainer. I completed python course successfully with deep…
Previous
Next

More Courses You Might Like

Dell Boomi

AWS Course

Oracle

Linux

Quick Links