Backup and Restore | Stedmans SQL School

Autoplay
Autocomplete

Previous Lesson Complete and Continue

SQL Server Interview Questions for DBA's and Developers

Welcome

Welcome by Steve (3:26)
To get the most out of this course

Interview Questions

Steps involved in ugrade SQL Server to a new version. (8:29)
Managing multiple SQL Server instances (4:33)
Management Studio (SSMS) (4:39)
Creating a new database (6:58)
Recovery Models (5:43)
Backup and Restore (7:03)
Log Shipping (6:11)
System Databases (3:39)
Error Handling (3:30)
SQL Agent Jobs (5:50)
Index Fragmentation (7:24)
Transaction Log (6:07)
Webservice Calls (3:50)
Disaster Recovery (4:44)
Normalization (8:01)
Role and Configuration of TempDB
Configuration Manager (2:00)
Database Maintenance (4:30)
Database Mail
Database Snapshots (2:57)
Replication Types and Concepts (4:49)
JOIN Types (7:09)
Stored Procedures and Functions
What is Sharding? (4:27)

Performance Related Interview Questions

Profiler and Extended Events (1:42)
Query Optimization (3:59)
Performance, tools and technique
UNION vs UNION ALL (4:30)
Temp Tables and Table Variables
Concept of Indexes (11:37)
Partitioned Tables (5:01)
Updating Statistics (6:17)
Locking and Blocking (4:22)
Deadlocks (4:58)

Non-Technical Questions

Do you have any questions for me?
Tell me about a time something went really bad and how you fixed it?

Summary

Test your knowledge
The perfect socks for your interview (0:15)
Bonus for you!
Super Bonus (2:41)
Thank You!

Teach online with

Backup and Restore

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock