Training objectives
- Understand the SQL Server design
- Install & configure instances
- Create & configure databases
- Maintaining databases: maintenance plan, re-indexing, SQL agent jobs & alerts, troubleshooting, high availability basics
Topics
- Server requirements and best practice
- Installation with the wizard and using script
- Firewall & services configuration
- Instance configuration
- Database creation with the wizard and by script
- Database security: roles & logins
- Databases objects: table, view, trigger, function, stored procedures, etc.
- Maintenance plan: backup, history cleanup, integrity test, reorganize and rebuild indexes
- Using the SQL agent
Method
- Presentation with countless practical exercises and trainings
- Case studies, live demos, discussions
- Networking during coffee break, lunch, and apéro on last day (included in price, except for on-site workshop courses)
Target groups
- Database administrators (DBA) as well as network, system, and application administrators responsible for or supporting SQL Server databases
Related trainings & events
- dbi InSite Workshop SQL Server Performance Tuning
Language & documentation
- Workshop training normally held in English; French or German possible instead as course languages
- Documentation: content details, scripts, case study solutions as PDF file (in English)