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.
