SQL Server DBA

SQL Server DBA

0 STUDENTS ENROLLED

    SQL Server DBA Course Content : 

    1.Introduction to Microsoft SQL Server

    • What is a Database?
    • Why to use database?
    • What is RDBMS?
    • Types of RDBMS
    • Advantages of SQL Server
    • Requirements and scope of SQL Server

    2.Roles and Responsibilities of DBA

    • What is Administration?
    • Roles of DBA
    • Licensing and Pricing of SQL Server

    3.System Design and Architecture

    • RAID Configuration
    • Capacity Planning
    • Installation
    • Upgrades and Backward Compatibility

    4.SQL Server Database Design

    • Logical and Physical architecture of database
    • Creating Database
    • Modifying structure of Database
    • Files and File Groups
    • Data Placement and Audit Placement

    5.SQL Server Objects

    • Data Types
    • Tables
    • Constraints
    • Views
    • Indexes and performance Considerations
    • Triggers
    • Stored Procedures
    • User Defined Functions
    • Cursors
    • Synonyms

    6.Transactions

    • ACID Properties
    • Commit Modes and Rollbacks
    • Savepoints
    • Transaction Locks and Locking Mechanism
    • Isolation Levels
    • Blocking and Deadlocks

    7.Database Snapshots

    • What is a DB Snapshot
    • Why we use Snapshots
    • How to design Snapshots
    • Advantages and disadvantages
    • Precautions when designing Snapshots

    8.SQL Server Partitions

    • Partitioning Fundamentals
    • Designing Partitions
    • Creating Partitions
    • Viewing Partition Information
    • Maintaining Partitions

    9.Backup Fundamentals

    • System Failures and need of Backups
    • Use of Transaction Log
    • Microsoft SQL Server Automatic Recovery
    • Recovery Models
    • Simple Recovery Model
    • Full Recovery Model
    • Bulk Logged Recovery Model
    • Types of Backups
    • Data (Full) Backups
    • Differential Backups
    • Log Backups
    • Copy-Only Backups
    • Full-Text Catalog Backups
    • Media Devices and Media Sets
    • Overview of Backup History Tables
    • Real world Backup Strategy

    10.Restoring Data

    • Restore and Recovery Concepts
    • Restoring Data from Backups
    • Complete, Differential and Log Restores
    • Point-In-Time Restores
    • File and File Group Restores
    • Page Restores
    • Piecemeal and Online Restores
    • Reverting to Database Snapshots

    11.Replication

    • Replication Fundamental
    • Use of Replication
    • Data Warehousing
    • Distributing and Consolidating Data
    • Offloading Report Processing
    • Replication Components
    • Types of Replication
    • Snapshot Replication
    • Transactional Replication
    • Merge Replication
    • Configuring Replication
    • Configure Distributor

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews

    N.A

    ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 1 month, 1 week

    Drop us a query

    Job Support

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies

    Disclaimer

    This web site or keentechnologies.com team is not associated with SAP AG or any other product. We are providing this service absolutely for Education and Training purpose only. We charge for the support services only, not for the actual SAP System access. All SAP Systems operate under INITIAL evaluation license. All trademarks mentioned on this web site belongs to their owners. We do not share or distribute ANY personal information we collect on this web site. For any additional information

    475-212-0075

    +91 9989754807

    trainings@keentechnologies.com


    ONLINE MEETING PARTNERS

    top
    COPYRIGHT © 2019 KEEN IT TECHNOLOGIES PVT.LTD, ALL RIGHTS RESERVED
    X