Module1: Starting with SQL Server Responsibilities of Database Administrator Types of DBAs History of SQL Server Editions of SQL Server Tools of SQL Server Differences between Standard and Enterprise editions Instances types in SQL Server Default Instance Named Instance SQL Server Services Instance aware services Instance unaware services Module2: Installing SQL Server Pre-requisites Installation Post Installation verification Session Module3: Functioning of Databases Database Types of Database and Brief explanation System Databases User Database Database Architecture Pages Extents File groups Database Transaction Architecture Creating Database Modifying Database Adding Files Moving and renaming of Database files Database modes Real time Scenario Module4: Security Authentication Types in SQL Server Types of Login Windows Login SQL Login Creating Users and Logins Server roles Password policy Understanding Database and Server Roles Permissions Working on access level issues Orphan users Finding and Fixing Important Queries Module5: Database Backups and Restoration Database Backups Why we need backups Types of Backup Full Backup Differential Backup Transaction Log Backup Copy-only, Mirrored, Split and Tail log Backups Differences between backups Backup Strategy Understanding how the data moving from Log to Data File, CHECKPOINT Monitoring the space usage of Log File and fixing Checking the backup files VALID or CORRUPTED Backup storage tables Important Queries Performing Restorations Types of Restoration Attach and Detach Shrinking files Module6: Recovery Models of Database Types of Recovery Models Full Bulk Logged Simple Differences between Recovery Models Setting Recovery Models according to the Scenarios with examples Module7: Automation of SQL SERVER Working with SQL SERVER Agent Creating Jobs Managing Jobs and Resolving i 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.
Be the first to comment