Course Outline
Introduction to SQL Server Management Studio (SSMS)
- Overview of SQL Server editions and core components
- Exploration of the SSMS interface and key features
- Advantages of leveraging SSMS for database management
Installation and Configuration
- System requirements for both SQL Server and SSMS
- Step-by-step installation of SQL Server and SSMS
- Post-installation configuration steps
- Establishing connections to SQL Server instances
Database Architecture and Storage
- Conceptual understanding of SQL Server databases and instances
- Insights into SQL Server database architecture
- Management of filegroups and data files
Creating and Managing Databases
- Database creation processes within SSMS
- Administration of database properties
- Procedures for attaching and detaching databases
Security Management
- Foundations of SQL Server security
- Administration of logins and user accounts
- Assignment of roles and permission sets
- Application of security best practices
Backup and Restore
- The critical role of backup and restore operations
- Types of backups: full, differential, and transaction log
- Executing backups via SSMS
- Restoring databases from existing backups
Database Maintenance Plans
- The importance of consistent database maintenance
- Development and scheduling of maintenance plans
- Monitoring and troubleshooting maintenance activities
Monitoring and Performance Tuning
- Techniques for monitoring SQL Server performance
- Identification of performance bottlenecks
- Index management and optimization strategies
- Utilization of SQL Server Profiler and extended events
Automating Tasks with SQL Server Agent
- Introduction to SQL Server Agent capabilities
- Creation and management of automated jobs
- Scheduling of jobs and alert configurations
- Oversight of SQL Server Agent job execution
High Availability and Disaster Recovery
- Overview of high availability solutions
- Implementation of database mirroring
- Configuration of Log Shipping
- Introduction to AlwaysOn availability groups
Upgrading and Migrating SQL Server
- Strategic planning for SQL Server upgrades
- Comparison of in-place versus side-by-side upgrade paths
- Database migration to new instances
- Execution of post-migration tasks
Summary and Next Steps
Requirements
- Fundamental understanding of database concepts
- Proficiency in SQL syntax and query construction
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
