This is Anna's Blog

DBA University course outline

Overview

-Create Backups and Restore Databases, understanding the different recovery models

-Manage logins and server roles, and import and export data

-Implement and maintain indexes, and manage and configure databases, including compression and concurrency problems

-Manage SQL Server Agent and audit SQL Server instances -Collect and analyse troubleshooting data

-Plan and install SQL Server and related services, including implementing a migration strategy

  1. Backup And Restore How to generate T-SQL, Backing up and Restoring, Changing Recovery models, Different backup models, Point in Time recovery, Recover from a corrupted drive.

  2. Manage Logins And Server Roles Create login accounts, Manage access to the server, and secure SQL server, Create and maintain user-defined server roles, Create Database User Accounts, Fixed and User Database-Level Roles, Creating and Using Schemas, Creating access to server/database with least privilege, Protect objects from being modified

  3. Implement And Maintain Indexes Indexes, Fragmentation, Fill factor, Optimise indexes, Identify unused indexes, Statistics

  4. Import And Export Data, And Manage SQL Server Agent Transfer data, Bulk insert, Import and Export data, Jobs and alerts, RAISERROR, Adding operators

  5. Manage And Configure Databases Database configuration, Design multiple file groups, Manage file space with new filegroups, Partitioning, Managing a multi-TB database, Log file growth, DBCC, Contained databases and logins

  6. Compression And Concurrency Problems Page and Row Data Compression, Spare columns, Columnstore indexes, Blocking, live locking and deadlocking, Monitoring.

  7. Troubleshooting Data And Auditing SQL Server Instances SQL Server Profiler, XEvents (Extended Events), System Monitor, Bottlenecks, Server audits, Elevated privileges, Track who modified an object.

  8. Plan Installation And Installing SQL Server Choosing the right hardware, Scale-up versus scale-out, Windows-Level and Service Level Security, Default and named instances, Planning the installation of SQL Server, Testing connectivity, Configuring an O/S disk.

  9. Implementing A Migration Strategy And Installing Additional Server Restore versus detach/attach, Migrate security, systems and data from other sources, Full-text indexing, Security, Filestream and Filetable.

Source: http://filecats.co.uk/sql-server-database-administration-dba/