ARCHITECTURE

• SQL server architecture
• Protocols
• Storage structure
• Database Architecture
• Transactional Architecture
• Memory Architecture

INSTALLATION

• Requirements
• 2005 Installation
• Steps 2008 installation steps
• 2012 installation steps

ENHANCEMENTS FROM 2008
CONFIGURATION SETTINGS

• Memory setting
• Processor
• Connections
• Database Settings
• System Databases
• Creating user databases
• Database Options

BACKUPS

• Recovery Models
• Backup Types
• Backup Strategy’s
• Backup destination
• Backup Options
• Enhancements
• Permissions and History

RESTORATIONS

• Types of Restorations
• Restoration Options
• SQL SERVER DBA
• Restorations
• Recovery Process
• Recovery Options

AUTOMATION

• Creating Jobs
• Schedules
• Viewing
• Job History

SECURITY

• Types of Logins
• Authentication
• Creating Logins
• Server Roles
• Database Roles
• Encryption
• Schema
• Creating new role
• Digital Certificate
• Orphaned Users

MIGRATION

• Situations
• Steps in Migrations
• Migrating System Databases
• Migrating to other

RDBMS
UPGRADATION

• Types of Up gradation
• Planning for up gradation
• Upgrade Advisor

HIGH AVAILABILITY

• LOGSHIPPING
• Configuring log shipping
• Failover Process
• Database Mirroring
• Steps in Mirroring
• Types of Mirroring
• Configuring Mirroring
• Failover Steps

REPLICATION

• Types of Replication
• Configuring Replication

CLUSTERING

• Concepts of clustering
• Types of Clustering
• Requirements
• Configuring clustering

PERFORMANCE TUNING

• Locks
• Isolations levels
• Blocking
• Deadlocks
• Performance Monitor
• Profiler
• Execution plans
• Indexes
• DBCC And DMV’s

Support services

We know how hard it can be to find and keep a job when there are so many other things to worry about. Our support team is here to help break down the barriers which are blocking your road to employment.

If you are a Working Chance candidate, please don’t hesitate to ask for advice or support on any issues which are affecting your chances of finding a job.
For further information, please email careers@www.btmgusa.com and our Support and Training Manager will get in touch with you.

Job Preparation

• Assistance with learning job seeking skills.
• Resume creation.
• Master application completion.
• Dressing for success.
• Job interview preparation.

Job Development

• Assistance with completing applications online or in person.
• Job development online, on foot, networking events, job fairs and established employer relationships to locate available positions in your job goal.
• Job leads and information on attending hiring events.
• Follow-ups on applications placed to request interviews.