Overview
-
Get up to speed on installing and administering the world's most popular database, Microsoft SQL Server 2014.
Syllabus
-
Introduction
- Welcome
- What you should know before watching this course
- Using the exercise files
- Planning your installation: Part 1
- Planning your installation: Part 2
- Planning your installation: Part 3
- Installing SQL Server 2014: Part 1
- Installing SQL Server 2014: Part 2
- Using SQL Server Management Studio
- Downloading, installing, and using SQL Server Data Tools
- Exploring PowerShell for SQL Server
- Using the sqlcmd utility
- Introducing data storage
- Managing the system databases
- Managing the user databases
- Introducing maintenance plans
- Automating with SQL Server Agent
- Developing a backup plan
- Understanding recovery models
- Performing and managing backups
- Performing and managing recovery
- Using the SQL Server Import and Export Wizard
- Working with the bcp utility
- Using indexes to improve query performance
- Creating indexes
- Understanding execution plans
- Viewing execution plans
- Using the Database Engine Tuning Advisor
- Examining the Actvity Monitor
- Data collection and management data warehouse
- Using Performance Monitor
- Examining Extended Events
- View the Extended Events Wizard
- Exploring SQL Server security and roles
- Viewing server and database-level security
- Using database permissions
- Auditing data access
- Next steps
