Courses Offered :
Testing Tools      PeopleSoft      Oracle Technologies      SQL DBA / MSBI      DBA/App’s      Data Warehousing      Android / iPhone      OBIEE, Data Stage      SOA Testing      Main Frames      DBA Technologies      SAS      Database / ETL Testing      SAP All Modules      SOA Testing      Micro Soft Technologies      JAVA      

SQLSERVER DBA

  • DBMS
  • RDBMS
  • Data Models
  • Introduction to SQL SERVER
  • History of SQL SERVER
  • Software And Hardware Requirements
  • IP Configuration, Domain Creation
  • Client-Server Architecture
  • IIS Configuration
  • Installation Process
  • Services, Checks after installation
  • Architecture of SQL SERVER 2005
  • Server startup process
  • Tools in SQL SERVER 2005
  • Management Studio(SSMS)
  • BI Tools(BIDS)
  • Configuration Tools
  • Performance Tools(Profiler)
  • Enabling Remote Connections
  • TCP/IP
  • Named Pipes
  • Changing Port numbers
  • Authentications
  • Windows Authentications
  • SQL Server Authentications
  • Securities
  • Logins
  • Users
  • Roles
  • Password Management
  • Database Assignment
  • Privileges
  • Schema
    • Databases

      • System Databases
      • User Databases
      • Database Designing
      • Creating Database
      • Altering Database
      • Files And File Groups
      • Data Files
      • Log Files
      • Primary File Group
      • Memory Architecture
      • Data Pages
      • Header and Description
      • Extents
      • Transactions in SQL SERVER
      • Commit
      • Rollback
      • Buffer
      • Checkpoint
      • Recovery Models
      • Full
      • Bulk Logged
      • Simple
      • Non Logged Operations
      • Compatibility
      • 2005
      • 2000
      • 7.0
      • Backups and Planning
      • Full
      • Differential
      • Transaction Log
      • Files and File Groups
      • Temporary
      • Jobs and Schedules
      • Back up Device
      • Append and Over write

        • Restorations
        • Complete restoration
        • Point in Time restoration
        • Restoration Options
        • OLTP and OLAP
        • Import and Export
        • SSIS
        • Migrations
        • SSIS Vs DTS Packages
        • Transformations
        • Up gradation
        • Replication
        • Publisher
        • Publication
        • Subscriber
        • Subscription
        • Distributor
        • Agents
        • Snap Shot Publication
        • Transactional Publication
        • Merge Publication
        • Replication monitor
        • Log Shipping
        • Primary Servers
        • Secondary Servers
        • Monitoring Servers
        • Jobs and Schedules
        • Blocking of Jobs
        • High Availability
        • Mirroring
        • Principle Server
        • Mirror Server
        • Witness Server
        • Mirror_Error
        • Stand by Server

          • SQL SERVER AGENT
          • Jobs
          • Schedules
          • Alerts
          • Operators
          • Error Logs
          • Database Mail
          • Maintenance Plan
          • Through SSMS
          • Through SSIS
          • Overview of Clustering
          • Performance Tuning
          • PERFMON
          • SQL LITESPEED
          • SQL DIAGNOSTIC MANAGER
          • LOG READER
          • DBCC
          • SYSTEM STORED PROCEDURES
          • REGULAR, WEEKLY AND MONTHLY ACTIVITIES
          • TROUBLE SHOOTING
          • INTERVIEW STUFF

Copyright © 2012, Jampani Technologies. All rights reserved.