Microsoft SQL Server Administration – 2019
$299.00
Learn to install, back up, secure, monitor and maintain Microsoft SQL Server 2019 databases. For new and aspiring DBAs, with 6 hours 24 minutes of video across 41 lessons.
- Login details sent straight after payment
- Self-paced. Study on any device
- StemBoss Certificate of Completion
- 14-day refund promise
Secure checkout. Pay by card, Apple Pay or Google Pay.
Microsoft SQL Server Administration 2019 teaches you how to install, run and look after SQL Server 2019 databases day to day. It is for new database administrators, IT staff taking on database work and developers who want to understand the server side. The course runs for 6 hours 24 minutes across 41 videos, with 75 practice questions.
What you will learn
- Install and configure SQL Server 2019
- Manage storage for system and user databases, and move database files
- Choose a recovery model and plan a backup strategy
- Back up and restore databases and transaction logs with SSMS and T-SQL
- Import, export, copy and move data and databases
- Monitor the server with dynamic management views, server reports, Performance Monitor and Extended Events
- Tune workloads with the Database Tuning Advisor
- Manage server-level and database-level security, including row-level security and contained databases
- Audit data access and set up Transparent Data Encryption
- Check database integrity, maintain indexes and automate routine jobs
Course outline
- Installation: introduction and installing SQL Server.
- Data Storage: storage for system and user databases, and moving files.
- Data Recovery: recovery models, backup planning, backup and restore with SSMS and T-SQL, advanced restores and moving data.
- Monitoring: DMVs, server reports, Performance Monitor, tracing, Extended Events and the Tuning Advisor.
- Security: server and database security, row-level security, contained databases, auditing and Transparent Data Encryption.
- Maintenance: integrity checks, index upkeep, automation and error monitoring.
Who this course is for
- New and aspiring database administrators
- IT staff moving into database administration
- Developers who want to understand how databases are run
- Data analysts who want to know what happens behind the data
- Students and graduates aiming for database roles
Before you start
It helps to know what a database is and to have written some basic SQL. If you are new to T-SQL, a querying course first will make the backup, restore and security lessons easier to follow. A test install of SQL Server lets you practise safely.
Jobs this course supports
- SQL Server Database Administrator
- Database Developer
- Data Engineer
- Business Intelligence Analyst
- Data Analyst
| Skill level | Intermediate |
|---|---|
| Duration | 6 Hours 24 Minutes |
| Videos | 41 Course Videos |
| Questions | 75 Test Questions |
| Prerequisites | Basic database and SQL knowledge is helpful. |
| Best for | Database administrators, IT staff moving into DBA work, developers, data analysts, students |
| Topics covered | Installation, data storage, recovery models, backup and restore, monitoring, server and database security, encryption and auditing, maintenance and automation |
| Format | Online video lessons, self-paced |
| Language | English |
| Closed captions | Yes |
| Certificate | StemBoss Certificate of Completion |
What is inside this course
6 modules and 41 lessons. Here is the full outline.
Module 1: Installation2 lessons
- SQL Admin Intro
- Installation
Module 2: Data Storage4 lessons
- Introduction to Data Storage with SQL Server
- Managing Storage for System Databases
- Managing Storage for User Databases
- Moving Database Files
Module 3: Data Recover13 lessons
- Intro to Data Recovery
- Understanding SQL Server Recovery Models
- Planning a Backup Strategy
- Backing up Databases and Transaction Logs
- Using SSMS For Backup
- Understanding the Restore Process
- How to Restore a Database
- Using SSMS For Restore
- T-SQL Backup and Restore
- Advanced Restore Scenarios
- Introduction to Transferring Data
- Importing and Exporting Table Data
- Copying or Moving a Database
Module 4: Monitoring7 lessons
- Introduction to Monitoring SQL Server
- Dynamic Management Views and Functions
- Server Reports
- System Performance Monitor
- Tracing SQL Server Workload Activity
- Extended Events
- Database Tuning Advisor
Module 5: Security8 lessons
- Introduction to SQL Server Security
- Managing Server-Level Security
- Managing Database-Level Security
- Row Level Security (RLS) Using Policies
- Database Security Tools
- Contained Database
- Auditing Data Access in SQL Server
- Implementing Transparent Data Encryption
Module 6: Maintenance7 lessons
- Introduction to Maintenance
- Ensuring Database Integrity
- Maintaining Indexes
- Automating Routine Database Maintenance
- Automating SQL Server Management
- Monitoring SQL Server Errors
- Configuring Database Mai
Your learning path
Where Microsoft SQL Server Administration - 2019 fits. Build your skills one step at a time.
Frequently asked questions
What does a SQL Server DBA do?
A database administrator installs SQL Server, keeps data backed up, controls who can see it, watches performance and runs regular maintenance. This course covers each of those tasks.
Does the course cover backup and restore?
Yes. The data recovery module covers recovery models, backup planning, backing up databases and logs, and restoring with both SSMS and T-SQL.
Which security features are included?
You learn server and database security, row-level security, contained databases, auditing data access and Transparent Data Encryption.
How do I monitor SQL Server performance?
The monitoring module uses dynamic management views, server reports, Performance Monitor, Extended Events and the Database Tuning Advisor.
Should I learn querying before this course?
It helps. Basic T-SQL makes the backup, restore and maintenance lessons easier, so many learners take a querying course first.
Do I get a certificate?
Yes. You get a StemBoss Certificate of Completion when you finish the course.
Can I get a refund?
Yes, within 14 days if you have completed less than 20% of the course. See our refund policy for details. Read the refund policy.
