Course Outline
Introduction to SQL Server Management Studio (SSMS)
- Overview of SQL Server editions and components
- Interface and key features of SSMS
- Advantages of utilizing SSMS for database management
Installation and Configuration
- System requirements for SQL Server and SSMS
- Procedure for installing SQL Server and SSMS
- Configuration steps following installation
- Establishing connections to SQL Server instances
Database Architecture and Storage
- Concepts of SQL Server databases and instances
- Internal architecture of SQL Server databases
- Filegroups and data file structures
Creating and Managing Databases
- Database creation processes in SSMS
- Managing database properties
- Attaching and detaching databases
Security Management
- Foundations of SQL Server security
- Administration of logins and users
- Role assignment and permission management
- Application of security best practices
Backup and Restore
- The significance of backup and restore operations
- Backup types: full, differential, and transaction log
- Executing backups through SSMS
- Restoring databases from backup files
Database Maintenance Plans
- The necessity of regular database maintenance
- Developing and scheduling maintenance plans
- Monitoring and troubleshooting maintenance activities
Monitoring and Performance Tuning
- Tracking SQL Server performance metrics
- Identifying and resolving performance bottlenecks
- Index management and optimization techniques
- Utilizing SQL Server Profiler and extended events
Automating Tasks with SQL Server Agent
- Overview of SQL Server Agent
- Job creation and management
- Scheduling jobs and configuring alerts
- Monitoring the status of SQL Server Agent jobs
High Availability and Disaster Recovery
- Survey of high availability options
- Implementation of database mirroring
- Configuration of Log Shipping
- Introduction to AlwaysOn availability groups
Upgrading and Migrating SQL Server
- Strategies for planning SQL Server upgrades
- Comparing in-place versus side-by-side upgrades
- Transferring databases to new instances
- Tasks to be performed after migration
Summary and Next Steps
Requirements
- Fundamental understanding of databases
- Familiarity with SQL syntax and querying
Target Audience
- Database Administrators (DBAs)
- Software Developers
- IT Professionals
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
