This SQL Server Administration course is designed for the practicing Microsoft SQL Server professional. It is also appropriate for anyone interested in learning SQL Server database administration. This includes SQL Server developers, SQL Server DBAs and any computer professional who needs to understand the architecture and fundamental administration of a SQL Server database.

Learn the essential skills a SQL Server Database Administrator requires to keep the database running smoothly

Who this course is for:
•    Aspiring DBA
•    Aspiring Data Analyst
•    Aspiring SQL developers
•    Data warehouse professionals

Course covers:
•    SQL SERVER – OVERVIEW
•    SQL SERVER – EDITIONS
•    SQL SERVER – INSTALLATION
•    SQL SERVER – ARCHITECTURE
•    SQL SERVER – MANAGEMENT STUDIO
•    SQL SERVER – LOGIN DATABASE
•    SQL SERVER – CREATE DATABASE
•    SQL SERVER – SELECT DATABASE
•    SQL SERVER – DROP DATABASE
•    SQL SERVER – CREATING BACKUPS
•    SQL SERVER – RESTORING DATABASES
•    SQL SERVER – CREATE USERS
•    SQL SERVER – ASSIGN PERMISSIONS
•    SQL SERVER – MONITOR DATABASE
•    SQL SERVER – SERVICE
•    SQL SERVER – HA TECHNOLOGIES
•    SQL SERVER – REPORTING SERVICES
•    SQL SERVER – EXECUTION PLANS
•    SQL SERVER – INTEGRATION SERVICES
•    SQL SERVER – ANALYSIS SERVICES