get app

    SQL Server DBA Training and Certification

    BY
    Mindmajix Technologies

    Brochure Enquire
    Mode

    Online

    Fees

    ₹ 8000 10000

    Quick Facts

    particular details
    Medium of instructions English
    Mode of learning Self study, Virtual Classroom
    Mode of Delivery Video and Text Based
    Frequency of Classes Weekdays, Weekends

    Course and certificate fees

    Fees information
    ₹ 8,000  ₹10,000
    certificate availability

    Yes

    certificate providing authority

    Mindmajix Technologies

    The syllabus

    Starting with SQL Server 2022

    • Responsibilities of Database Administrator
    • Types of DBA’s
    • History of SQL Server – Versions
    • What’s new in SQL Server 2022 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 2022 
      • 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 do 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

    Practice Test & Interview Questions

    Instructors

    Mr Uday
    Instructor
    Mindmajix Technologies

    Articles

    Popular Articles

    Top 12 Certification Courses Offered by IIT Bombay Top 12 Certification Courses Offered by IIT Bombay Updated On 06 Dec, 2024
    The Scope of Artificial Intelligence in India The Scope of Artificial Intelligence in India Updated On 04 Dec, 2024
    150+ UGC Approved Online Degree Courses by Top Universities 150+ UGC Approved Online Degree Courses by Top ... Updated On 29 Nov, 2024
    Top 10 Online Healthcare and Hospital Management Courses Top 10 Online Healthcare and Hospital Managemen... Updated On 19 Nov, 2024
    Top 10 Indian Universities Offering Online Degrees Top 10 Indian Universities Offering Online Degrees Updated On 02 Nov, 2024
    Top 16 IIT Madras Online Degree, Diploma, and Certification Courses Top 16 IIT Madras Online Degree, Diploma, and C... Updated On 11 Oct, 2024
    UGC Guidelines to Pursue Online Courses UGC Guidelines to Pursue Online Courses Updated On 13 Mar, 2024
    Reasons to Enroll for an Online Content Writing Course Reasons to Enroll for an Online Content Writing... Updated On 29 Feb, 2024
    Top 10 Online Animation Certificate Courses for a Better Career Top 10 Online Animation Certificate Courses for... Updated On 27 Feb, 2024
    Best Programming Languages to Learn in 2024 Best Programming Languages to Learn in 2024 Updated On 13 Feb, 2024

    Latest Articles

    Top Online Courses for Jobs With High Salaries in India Updated On 07 Nov, 2024
    Top Trending DBMS Project Ideas for Beginners Updated On 15 Jul, 2024
    Top 50 MongoDB Interview Questions And Answers Updated On 16 Apr, 2024
    Top 50 DBMS Interview Questions To Prepare Updated On 15 Apr, 2024
    15 Online Database Administration Courses to Pursue Right Now Updated On 28 Feb, 2024
    Information Retrieval Systems: Types, Components & Functionality Explained Updated On 08 Feb, 2024
    DBMS vs. RDBMS: What Are the Differences Between DBMS and RDBMS Updated On 25 Sep, 2023
    Database And Database Management: Types And Functions Updated On 25 May, 2022
    7 Types of Keys in DBMS - A Glossary of Database Terms Updated On 17 Feb, 2022
    20 Online MongoDB Certifications to Become a Database Designer Updated On 18 Sep, 2021
    15+ Online Database Courses to Opt For Updated On 08 Sep, 2021

    Trending Courses

    Digital Marketing Courses Fashion Design Courses Data Science Courses Interior Design Courses Graphic Designing Courses Cyber Security Courses Nursing Courses Tally Courses Data Analysis Courses Web Designing Courses Artificial Intelligence Courses Ethical Hacking Courses Free Digital Marketing Courses And certifications Free Artificial Intelligence Courses And Certifications Free Data Analysis Courses And Certifications Free Cyber Security Courses And Certifications Free Data Science Courses And Certifications Free Cloud Computing Courses And Certifications Free Python Courses And Certifications Free Fashion And Textiles Courses And Certifications Free Graphic Designing Courses And Certifications Free Web Designing Courses And Certifications

    Popular Courses

    General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Programming Courses Cyber Security Courses Data Science Courses Law Courses Digital Marketing Courses Leadership Courses Explore all courses

    Popular Platforms

    upGrad Courses Udemy Courses Edx Courses Swayam Courses Coursera Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses NPTEL Courses IIT Kharagpur Courses Emeritus Courses IIT Kanpur Courses Explore all platforms

    Learn more about the Courses

    10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management
    Providers
    Close

    Download the Careers360 App on your Android phone

    Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

    Careers360 App
    150M+ Students
    30,000+ Colleges
    500+ Exams
    1500+ E-books