Mastering Microsoft SQL Server Management Studio; A Step-by-Step Guide to Database Administration and Management
MSRP:
Was:
Now:
(Inc. Tax)
MSRP:
Was:
Now:
USD215.43
(You save)
SKU:
UPC:
When you get access:
Course access is prepared after purchase and delivered via email
How you learn:
Self-paced • Lifetime updates
Your guarantee:
30-day money-back guarantee — no questions asked
Who trusts this:
Trusted by professionals in 160+ countries
Toolkit Included:
Includes a practical, ready-to-use toolkit with implementation templates, worksheets, checklists, and decision-support materials so you can apply what you learn immediately - no additional setup required.
Mastering Microsoft SQL Server Management Studio: A Step-by-Step Guide to Database Administration and Management
Mastering Microsoft SQL Server Management Studio: A Step-by-Step Guide to Database Administration and Management
This comprehensive course is designed to help you master the skills needed to administer and manage databases using Microsoft SQL Server Management Studio. Upon completion, you will receive a certificate issued by The Art of Service. This course is:
Interactive and engaging, with hands-on projects and bite-sized lessons
Comprehensive, covering all aspects of database administration and management
Personalized, allowing you to learn at your own pace
Up-to-date, with the latest information on Microsoft SQL Server Management Studio
Practical, with real-world applications and examples
High-quality, with expert instructors and high-quality content
Certified, with a certificate issued upon completion
Flexible, with lifetime access and mobile-accessible learning
Community-driven, with a community of learners and instructors
Actionable, with insights and skills you can apply immediately
Course Outline
Chapter 1: Introduction to Microsoft SQL Server Management Studio
Topic 1.1: Overview of Microsoft SQL Server Management Studio
What is Microsoft SQL Server Management Studio?
History and evolution of Microsoft SQL Server Management Studio
Key features and benefits of Microsoft SQL Server Management Studio
Topic 1.2: Installing and Configuring Microsoft SQL Server Management Studio
System requirements for Microsoft SQL Server Management Studio
Installing Microsoft SQL Server Management Studio
Configuring Microsoft SQL Server Management Studio
Chapter 2: Database Administration
Topic 2.1: Creating and Managing Databases
Creating a new database
Managing database properties
Creating and managing database objects
Topic 2.2: Security and Access Control
Understanding SQL Server security
Creating and managing logins and users
Assigning permissions and roles
Topic 2.3: Backup and Recovery
Understanding backup and recovery concepts
Creating and managing backups
Restoring databases
Chapter 3: Database Management
Topic 3.1: Performance Monitoring and Tuning
Understanding performance monitoring concepts
Using SQL Server Profiler
Using Database Tuning Advisor
Topic 3.2: Indexing and Optimization
Understanding indexing concepts
Creating and managing indexes
Optimizing queries
Topic 3.3: Troubleshooting and Maintenance
Understanding troubleshooting concepts
Using SQL Server error logs
Performing routine maintenance tasks
Chapter 4: Advanced Topics
Topic 4.1: High Availability and Disaster Recovery
Understanding high availability concepts
Configuring failover clustering
Configuring Always On Availability Groups
Topic 4.2: Business Intelligence and Data Warehousing
Understanding business intelligence concepts
Using SQL Server Analysis Services
Using SQL Server Reporting Services
Topic 4.3: Cloud Computing and Azure
Understanding cloud computing concepts
Using Azure SQL Database
Using Azure SQL Data Warehouse
Chapter 5: Case Studies and Real-World Applications
