Module1: Starting with SQL Server br Responsibilities of Database Administrator br Types of DBAs br History of SQL Server br Editions of SQL Server br Tools of SQL Server br Differences between Standard and Enterprise editions br Instances types in SQL Server br Default Instance br Named Instance br SQL Server Services br Instance aware services br Instance unaware services br Module2: Installing SQL Server br Pre-requisites br Installation br Post Installation verification Session br Module3: Functioning of Databases br Database br Types of Database and Brief explanation br System Databases br User Database br Database Architecture br Pages br Extents br File groups br Database br Transaction Architecture br Creating Database br Modifying Database br Adding Files br Moving and renaming of Database files br Database modes br Real time Scenario br Module4: Security br Authentication Types in SQL Server br Types of Login br Windows Login br SQL Login br Creating Users and Logins br Server roles br Password policy br Understanding Database and Server Roles br Permissions br Working on access level issues br Orphan users Finding and Fixing br Important Queries br Module5: Database Backups and Restoration br Database Backups br Why we need backups br Types of Backup br Full Backup br Differential Backup br Transaction Log Backup br Copy-only, Mirrored, Split and Tail log Backups br Differences between backups br Backup Strategy br Understanding how the data moving from Log to Data File, CHECKPOINT br Monitoring the space usage of Log File and fixing br Checking the backup files VALID or CORRUPTED br Backup storage tables br Important Queries br Performing Restorations br Types of Restoration br Attach and Detach br Shrinking files br Module6: Recovery Models of Database br Types of Recovery Models br Full br Bulk Logged br Simple br Differences between Recovery Models br Setting Recovery Models according to the Scenarios with examples br Module7: Automation of SQL SERVER br Working with SQL SERVER Agent br Creating Jobs br Managing Jobs and Resolving i br www.magnifictraining.com - "Oracle scm purchasing Online Training" contact us:info@magnifictraining.com or +919052666559,9052666558 By Real Time Experts from Hyderabad, Bangalore,India,USA,Canada,UK, Australia,South Africa.