Overview

SQL Server Database Administration Part-1 covers all necessary topics to enter as a DBA. This course covers the administration basics including the following concepts.This course is the startup course to become SQL Server Database Administrator. You can opt for Part-2 to become complete SQL Server DBA. In Part-2 I will discuss all high availability concepts including Log Shipping, Database Mirroring, Always On, Replication, Clustering and Performance Tuning concepts along with troubleshooting common issues.Introduction to SQL ServerApplication ArchitectureDBA - Roles and ResponsibilitiesIntroduction to SQL ServerIntroduction to SQLSQL Server ToolsSQL Server ServicesHow to Start/Stop ServicesSQL Server InstancesDefault and Named InstancesInstance SummaryInstallation Pre-RequisitesSQL Server InstallationInstalling using Configuration FileWorking with ConfigurationsVerifying Installation using summary.txt fileConfiguring Data and Log File LocationsConfiguring ErrorLogsUsing Trace FlagsConfiguring Backup Folder PathsPatching SQL ServerHow to rollback the patchesConfiguring MemoryConfiguring CPUConfiguring Remote ConnectionsBasic Query Life Cycle StagesConfiguring DACWorking with Databases both System and User DefinedSystem DatabasesMoving master, msdb and TempDB databasesDatabase ArchitectureLog File Architecture- VLFs, Blocks, LSNData File Architecture - Extents, PagesPage ArchitectureTypes of PagesDatabase StatesDatabase Suspect Mode scenariosErrors 17207, 17204Rebuilding master databaseTroubleshooting common database issuesWorking with Transaction Log file and its common issuesWorking with Security FeaturesUsers, Permissions and Role managementServer RolesDatabase RolesOrphan users, how to resolve orphan usersCreating users with passwords from SQL Server 2012EncryptionsRecovery ModelsCheckpointsTypes of CheckpointsBackups and RestoresDifferent Types of BackupsFull, Differential, T.Log backupsFile, Filegroup BackupsCopy-only backupsBackup CompressionRestoring databasesDatabase Recovery StatesHow to take tail log backupchecksum and SQL Server Backupschecksum and restorescommon backup and restore issues

Skills

Reviews