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
- 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