
DBA Fundamentals - give yourself a solid SQL foundation!
Event Information
Description
This class is designed for New or Non-DBAs struggling with SQL admin tasks, and having to Google things daily. I will teach you SQL Server fundamentals so that you will have confidence in:
- What makes up a SQL Server
- How a database is structured
- How to install and what to look out for
- Finding what you need in Management Studio
- SQL Security Basics
- How to create and manage backups
- How to create a database
- Basic performance troubleshooting
- Picking a Disaster Recovery option for your environment
These are taught from a foundational standpoint, in simple to understand terms so that you can build on them with confidence. My teaching is heavy on interaction, with examples from years of experience/mistakes. There will be a mix of slides and demos. I'll skip many advanced features that are out of scope of a beginner class, as I don't want your head to explode! Join me for the day and you will walk out with a strong grasp of SQL Admin basics!