MICROSOFT SQL SERVER DBA Online Training | MICROSOFT SQL SERVER DBA Online Course | Free demo on MICROSOFT SQL SERVER DBA
India:+91 (0)8885575549, 040-42627705 | USA: +1 973-619-0109 | UK: +44 207-993-2319 Santosh@acutesoft.com
Select Page

MICROSOFT SQL SERVER DBA

SQL SERVER DBA ONLINE TRAINING

SQL SERVER DBA ONLINE TRAINING IN INDIA, USA & UK

SQL SERVER DBA ONLINE TRAINING IN CANADA

SQL SERVER DBA ONLINE TRAINING IN AUSTRALIA

SQL SERVER DBA ONLINE TRAINING

SQL SERVER DBA COURSE CURRICULUM

Download [PDF]

  • Overview of the SQL server
      Architecture of sql server
      The major versions and editions, upgrades from sql
      Installing SQL server and client components
      Pre-requisites, system configuration check
      installing selected components
      High availability using Clustering
  • SQL server clustering concept
      Security / User role management
      Authentication modes, user and roles management
      Object management
      Creating, managing and maintaining databases
      Tables / indexes / views / stored procedures
      User defined functions
      Monitoring activity
      Monitoring the tasks, audits, sql profiler
      Backup and restore
      Taking different types of backups and restoring
      Backup and restore compression
      Implementing Disaster recovery
  • Configuring log shipping
      Automation of tasks, alerts
      Notifications using sql server agent
      Creating, managing, maintaining jobs, alerts
      Notifications through mails
      Implementing Replication
      Configuring various methods of replications
      New Features of SQL
      Features that are indulged from old version SQL
      Resource Governor, Activity Monitor, Intellisense
      Auditing, Plug-in model for SSMS
      Central Management Servers
      Sql Server Analysis Services (SSAS)
      Creating Measurements, dimension, cubes
      BIDS or MSVS
      Importing the cubes in SSAS, processing cubes
      Editing cubes, managing cubes
      Sql Server Reporting Services (SSRS)
      Installing, Configuring and maintaining SSRS
      Sql Server integration Services (SSIS)
      Exporting and importing SSIS packages  Clarifications and discussions

SQL SERVER DBA

The Data Base Administrator (DBA) is responsible for providing technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies, and providing Information Technology with a long-term perspective on the relationship of database technology to the business opportunities facing the company. It is extremely important to the company that on-line processing database systems offer the highest reliability and performance possible. The DBA is challenged to work with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives. Trains and develops technical support and applications staff to better utilize on-line processing databases environment. Provides and designs tools to assist in the management of the database and transaction processing environment. Works to provide a working model of our transaction processing environment for capacity assessment and planning.

Develops a methodology for the ongoing assessment of database performance and the identification of problem areas. Develops a security scheme for the database environment, as well as assisting in disaster recovery if necessary. Provides leadership during the development and enhancement of production applications including working with applications, technical support and operations during the design, development and implementation of applications. Work with the transaction processing area to develop both the physical and the logical database administration functions and assists in the development of our processing database and computing environments. Work with others in IT to build the logical database area and provide technical guidance during all phases of the development process. Work with vendors in evaluating and implementing new technologies.

Microsoft SQL Server Administration (DBA) Services

  • MS SQL Database Designing
  • MS SQL Store Procedure Development/li>
  • MS SQL Trouble-shooting and Query Optimization/li>
  • Database Performance Scalability and Indexing/li>
  • Database Back-up, Monitoring, Memory Check, Administration and Maintenance Services/li>
  • Database Business Intelligence Services/li>
  • Database Integration Services/li>
  • Database Support Services/li>
  • Database Security and User Management Services/li>
  • MS SQL DB Tracking/li>
  • Replication- Data Synchronization among multiple servers/li>
  • Database QA/Testing Services/li>

DEMOS VIDEOS

UPCOMING DEMOS

For updated Schedules please contact
calls