Welcome To Eazygurus

SQL DBA

Course Name        :   SQL DBA Microsoft Technology
Duration                 :  35 hrs

STUDENTS ENROLLED

    • DBMS
    • RDBMS
    • Introduction to SQL SERVER
    • Software And Hardware Requirements
    • Client-Server Architecture
    • SQL SERVER Installation
      • Requirements
      • 2008 Installation Steps
    • Services & Checks after installation
    • Features of SQLSERVER 2008 & 2012
    • Server startup process
    • Tools in SQL SERVER 2008
      • Management Studio(SSMS)
    • BI Tools(BIDS)
      • Configuration Tools
      • Performance Tools(Profiler)
    • Architecture
      • SQL SERVER Architecture
      • Protocols
      • Storage Structures
      • Database Architecture
    • Configuration Settings
      • Memory Settings
      • Processor
      • Connections
      • Database Settings
    • Transactions in SQL SERVER
      • Commit
      • Rollback
      • Buffer
      • Checkpoint
    • Databases
      • System Databases
      • User Databases
      • Creating Database
      • Altering Database
      • Data Files
      • Log Files
      • File Groups
    • Security
      • Windows Authentications
      • SQL Server Authentications
      • Logins and Users
      • Roles
      • Schema
      • Orphaned Users
    • Recovery Models
      • Full
      • Bulk Logged
      • Simple
      • Non Logged Operations
    • Backups and Planning
      • Full
      • Differential
      • Transaction Log
      • Files and File Groups
      • Compressed backups
      • Mirrored Backups
      • Split Backup
      • Jobs and Schedules
      • Back up Device
      • Append and Over write
      • Permissions and Settings
      • Enhancements
    • Restore
      • Complete restoration
      • Point in Time restoration
      • Restore Modes
      • Recover Process
    • Migrations
      • Steps in Migration
      • Migrating System databases
      • Migration to other RDBMS
      • SSIS , Package creation & Issues
    • Database Upgrade
      • Types
      • Planning for Upgrade
      • Upgrade Advisor
    • Replication
      • Publisher
      • Publication
      • Subscriber
      • Subscription
      • Distributor
      • Agents
      • Snap Shot Publication
      • Transactional Publication
      • Merge Publication
      • Replication monitor
      • Jobs
      • Latency Issues
    • Log Shipping
      • Configuring Log shipping
      • Monitoring logshipping
      • Failover Process
      • Issues
    • Mirroring
      • Principle Server
      • Mirror Server
      • Witness Server
      • Quorum
      • High Availability
      • High Protection
      • High performance
      • Synchronization
      • Disaster Recovery
      • Monitoring & Issues
    • CLUSTERING
      • Types
      • Configuring Clustering
      • Monitoring Clustering
      • Issues
    • SQL SERVER AGENT
      • Jobs
      • Schedules
      • Alerts
      • Operators
      • Error Logs
    • Database Mail Configuration
    • Maintenance Plan
      • Through SSMS
      • Through SSIS
    • PERFORMANCE TUNING
      • Isolation levels
      • ACID Properties
      • Normalization
      • Blocking
      • Dead Locks
      • Indexes
      • DBCC and DMV
      • Stored procedures
      • Performance Monitor
      • Profiler & Counters
      • Tuning Adviser
    • TROUBLE SHOOTING
      • Tempdb Full Issues
      • Log file Full Issues
      • Suspect Mode Issues
      • Page Corruption Issues
      • Tail Log Backup
      • Moving system databases
      • Moving User databases
      • Rebuild Matser Database
      • Orphaned Users
      • Connection Issues
      • SQLSERVER Service Issues
      • LONG Running Slow Queries
      • Index Fragmentation Issues
      • SP_RECOMPILE SP’S
      • Tickets, SLA
    • SSRS Configuration & Issues
    • SQL Browser
    • REGULAR, WEEKLY AND MONTHLY ACTIVITIES

    Key Benefits:

    • Exposure to real time scenarios.
    • Job oriented training program.
    • Training in an enterprise highly focused in recruitment.
    • Resume Preparation and Interview Tips
    • Q & A
    • Mock Interview.

    Course Curriculum

    Course Reviews

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 2 weeks, 4 days

    Advanced Course Search

    Total It Training Portal © Eazygurus. All rights reserved.