Sql dba(ms sql dba) online course - Chennai

Monday, 6 March 2017

Item details

City: Chennai, Tamil Nadu
Offer type: Offer
Price: Rs 10,000

Contacts

Contact name rakesh
Phone 8667484273

Item description

responsibilites of sql-server DBA
I) INSTALLATION & CONFIGURATION
versions, editions, service packs for sql-server
server level, database level and user level configurations.
II) CREATING AND MANAGING OF DATABASES
types of sql-server databases
internal architechture
storage formats
managing the files of the databases
iii) SECURITY
LOGINS AND USERS
TYPE OS AUTHENTICATIONS
SERVER LEVEL, DATABASE LEVEL AND OBJECT LEVEL SERCUIRTY
GRANTING AND REVOKING OF PERMISSIONS
SCHEMAS, ENCRYPTION AND DECRYPTION.
IV) DISASTER RECOVERY
backup & restore plans
moving of databases
v) AUTOMATION
decreasing the work load
vi) HIGH AVAILABILITY
no down time.
log shipping
dbmirroring
replication
vii) performance tuning
better performance.
monitoring.