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.