Tuesday 24 February 2015

SQL Administrator Training In Bangalore

FabGreen is a Training institute and software development company located in Bangalore. We provide quality IT training either at our training center or at client premises. We provide training in SharePoint, BizTalk, QTP, Selenium, and SQL. All our courses are taught by experienced trainers who have extensive field knowledge with the topics they teach. FabGreen provide services to wide range of customers like for the working professional, job seeking candidates, corporate & to the students. We provide effective and efficient customer service, answering your queries promptly and being as helpful as possible in assisting you to choose the right course.

Course Features:
  • Sample Live Projects are provided
  • Lab Facility 14/7
  • Interview guidance - Questions and Sample Resumes
  • Technical guidance and support after the course completion
  • Course Materials Provide
  • Flexible training - Individual and Batch

FabGreen Technologies
#6/5, 2nd cross, 
VP road, Madiwala,
Bangalore - 560068
Phone: 8971120505 / 8971120606
Email: info@fabgreentech.com
Website: sqltraining.in
Company Website: Fabgreentech.com
Land Marks: 1. Opp to Total Mall
Land Marks: 2. Near Anjaneya Statue

Course Content:

v  SQL Server 2012 Architecture
·         SQL Server 2012 ecosystem
·         New important Features in 2012
·         SQL Server architecture
·         Editions of SQL Server
v  Installing SQL Server 2012 Best Practices
·         Planning the system
·         Installing SQL Server
·         Installing analysis services
·         Installing PowerPivot for SharePoint
·         Burning the system
·         Post-install configuration
·         Uninstalling SQL Server
·         Troubleshooting a failed install
v  Upgrading SQL Server 2012 Best Practices
·         Why upgrade to SQL Server 2012
·         Upgrading the SQL Server 2012
·         Pre-upgrade steps and tools
·         Backward compatibility
·         SQL Server component considerations
·         Post-upgrade checks
v  Managing and Troubleshooting the Database Engine
·         Configuration and administration tools
·         Troubleshooting tools
·         Management studio
·         Monitoring processes in T-SQL
·         Multiserver management
·         Trace flags
·         Getting help from support
v  Automating SQL Server
·         Maintenance plans
·         Automating SQL Server with SQL Server Agent
·         SQL Server Agent security
·         Configuring SQL Server Agent
·         Database mail
·         Multiserver administration
v  Service Broker in SQL Server 2012
·         Asynchronous messaging
·         Configuring SQL Server service broker
·         Using SQL Server service broker
v  SQL Server CLR Integration
·         Introduction to the CLR
·         Creating CLR assemblies
·         Securing CLR
·         Performance monitoring
v  Securing the Database Instance
·         Authentication types
·         Authorizing securables
·         Row level security
v  Change Management
·         Creating solutions and projects
·         Policy-based management
·         DDL trigger syntax
·         Trigger views
·         Scripting overview
·         Creating change scripts
·         Data-tier applications
v  Configuring the Server for Optimal Performance
·         What every DBA needs to know about performance
·         What the developer DBA needs to know about performance
·         What the production DBA needs to know about performance
·         CPU
·         Memory
·         I/O
v  Optimizing SQL Server 2012
·         Application optimization
·         The silent killer: I/O problems
·         Table and index partitioning
·         Data compression
·         CPU considerations
·         Memory considerations and enhancements
·         Resource governor
v  Monitoring Your SQL Server
·         The goal of monitoring
·         Choosing the appropriate monitoring tools
·         Performance monitor
·         Monitoring events
·         Monitoring with dynamic management views and functions
·         Monitoring logs
·         Management data warehouse
·         SQL Server standard reports
·         System center management pack
·         SQL Server best practice analyzer
·         System center advisor
v  Performance Tuning T-SQL
·         Physical query processing part 1: compilation and recompilation
·         Physical query processing part 2: execution
v  Indexing Your Database
·         Noteworthy index-related features in SQL Server
·         Partitioned tables and indexes
·         Index maintenance
·         Improving query performance with indexes
·         Database tuning advisor
·         Too many indexes?
v  Replication
·         Replication overview
·         Replication models
·         Implementing replication
·         Peer-to-peer replication
·         Scripting replication
·         Monitoring replication
v  Clustering SQL Server 2012
·         Clustering and your organization
·         Clustering: the big picture
·         Upgrading SQL Server clustering
·         Getting prepared for clustering
·         Clustering Windows Server 2008
·         Clustering Microsoft distributed transaction coordinator
·         Clustering SQL Server 2012
·         Managing and monitoring the cluster
·         Troubleshooting cluster problems
v  Backup and Recovery
·         Types of failure
·         Making plans
·         Overview of backup and restore
·         Preparing for recovery
·         Developing and executing a backup plan
·         Managing backups
·         Backup and restore performance
·         Performing recovery
·         Archiving data
v  SQL Server 2012 Log Shipping
·         Log shipping deployment deployment scenarios
·         Log shipping architecture
·         Log shipping process
·         System requirements
·         Deploying log shipping
·         Monitoring and troubleshooting
·         Managing changing roles
·         Database backup plan
·         Integrating log shipping with other high-availabilty solutions
·         Removing log shipping
·         Log shipping performance
·         Upgrading to SQL Server 2012 log shipping
v  Database Mirroring
·         Overview of database mirroring
·         Operating modes of database mirroring
·         Database mirroring in action
·         Database mirroring and SQL Server 2012 editions
·         Database mirroring catalogue views
·         Database mirroring role change
·         Database availability scenarios
·         Monitoring database mirroring
·         Troubleshooting database mirroring
·         Preparing the mirror server for failover
·         Mirroring multiple databases
·         Database Mirroring and other high-availabilty solutions
·         Mirroring event listener setup
·         Database snapshots

v  Conclusion