First time here? Take a quick tour of our comprehensive Online Training.
» Take Tour

See what people have been saying about us.
» Feedback

SQL DBA

 

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

 

 

Testimonials

Thank you for having this. I would not have had an extended education if there was not online learning..Rama Krishna
My online course was terrific! You really do get to know the other students. I talked to more people because it was a smaller class. There was a great sense of community.........Ravinder Reddy
Superb..........Subhash
...10 out of 10 stars.....Dipu Padey
...the best out there.....Santosh.M
I found online learning more convenient then the traditional classroom because I work full-time and getting to classroom across town in traffic is problematic.......Divya
...a very effective way to learn.....Rajesh
Have a testimonial about a ACEONLINEMENTORS services? If so, send us an e-mail at feedback@aceonlinementors.com with your testimonial and how you benefited from our training.......
more testimonials..