Topic that will get covered in Ms SQL DBA course

Course content

SQL server architecture

• Memory Architecture
• Physical Architecture
• Transaction Log architecture

SQL server installation and upgrade

• Installation and upgrade
• SQL server Licencing

SQL server security

• Password policy
• Server, Database and application roles
• Sql server audits
• contained database
• policy base management

SQL server backup and restore

• Sql server Recovery Model
• Back and restore
• scenario based

SQL server High Availability

• Log shipping
• replication
• clustering
• mirroring
• always ON
• HA scenarios

SQL server performance tuning

• Indexes
• Statics
• Performance monitoring tools
• SQL server profiler
• Activity monitoring
• Performance tuning scenarios

Comment and follow for more detail....