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.