Course Outline
Introduction to SQL Server Management Studio (SSMS)
- Overview of SQL Server editions and components.
- Interface and features of SSMS.
- Benefits of using SSMS for database management.
Installation and Configuration
- System requirements for SQL Server and SSMS.
- Installing SQL Server and SSMS.
- Post-installation configuration.
- Connecting to SQL Server instances.
Database Architecture and Storage
- Understanding SQL Server database and instances.
- SQL Server database architecture.
- Filegroups and data files.
Creating and Managing Databases
- Creating databases using SSMS.
- Managing database properties.
- Attaching and detaching databases.
Security Management
- Introduction to SQL server security.
- Managing logins and users.
- Assigning roles and permissions.
- Implementing security best practices.
Backup and Restore
- Importance of backup and restore.
- Types of backups: full, differential, transaction log.
- Performing backups using SSMS.
- Restoring databases from backups.
Database Maintenance Plans
- Importance of regular database maintenance.
- Creating and scheduling maintenance plans.
- Monitoring and troubleshooting maintenance plans.
Monitoring and Performance Tuning
- Monitoring SQL Server performance.
- Identifying performance bottlenecks.
- Index Management and optimization.
- Using SQL Server profiler and extended events.
Automating Tasks with SQL Server Agent
- Introduction to SQL Server agent.
- Creating and managing jobs.
- Scheduling jobs and alerts.
- Monitoring SQL Server agent jobs.
High Availability and Disaster Recovery
- Overview of high availability options.
- Implementing database mirroring.
- Configuring Log Shipping.
- Introduction to AlwaysOn availability groups.
Upgrading and Migrating SQL Server
- Planning for SQL Server upgrades.
- In-place vs. side-by-side upgrades.
- Migrating databases to new instances.
- Post-Migration tasks.
Summary and Next Steps
Requirements
- Fundamental knowledge of databases.
- Understanding of SQL syntax and queries.
Audience
- Database administrators (DBAs).
- Developers.
- IT professionals.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 4800 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (4)
data was personalised to our organisations
Vincent Long - ASSMANG PTY LTD
Course - T-SQL Fundamentals with SQL Server Training Course
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The instructor brought his A game again as he superbly took my staff through the customized training with expert timing, knowledge, support, and rapport with my staff.
James - Shawnee Mission School District
Course - Administering in Microsoft SQL Server
The lecture about cte
