SQL Server Database Administration

Our SQL Server Database Administration training course covers the following Modules:

Module 1: Getting Started with SQL Server

Setting up SQL Server

• Selecting installation options
• Installing a named instance

Leveraging essential tools

• SQL Server Management Studio
• Configuration Manager
• Transact-SQL
• PowerShell

Module 2: Constructing and Managing Databases

Inspecting storage structures

• Relating servers, databases and files
• Creating databases and transaction logs

Designing file groups

Upgrading and moving databases

• Maximising storage utilisation
• Placing tables on file groups
  • Choosing between upgrade and migration
  • Detaching and attaching databases

Module 3: Controlling Database Space

• Permitting automatic database growth
• Adding database files to expand databases

Module 4: Handling Server and Database Security

Implementing server security

• Comparing authentication modes
• Defining logins
• Creating user-defined server roles
• Enforcing password policy

Granting database access

• Contrasting users and logins
• Adding users
• Defining new roles
• Delegating privileges with predefined roles
• Repairing mis-mapped logins

Module 5: Granting and Revoking Permissions

Managing database-scoped privileges

• Permitting object creation
• Giving blanket permissions

Defining object-level permissions

• Limiting object access
• Meeting complex permission requirements with roles

Module 6: Backup and Recovery

Backing up databases

• Selecting a recovery model
• Investigating the transaction log
• Running full, log and differential backups

Restoring databases

• Performing a post-crash log backup
• Rebuilding the master database
• Recovering user and system databases

Module 7: Streamlining Tasks with Jobs, Alerts and Database Mail

Configuring SQL Server Agent

• Setting agent properties
• Implementing database mail

Defining jobs to handle routine tasks

• Creating alerts and operators
• Initiating multi-step jobs
• Associating alerts with jobs

Module 8: Database Maintenance and Monitoring

Handling fragmentation and database corruption

• Identifying and curing fragmentation
• Repairing database corruption

Building database maintenance plans

• Scheduling plan execution
• Notifying operators of success or failure

Resolving contention problems

• Identifying blocked processes
• Killing blockers

Our SQL Server Database Administration training course will benefit several individuals and organisations including but not limited to:

• Aspiring Database Administrators
• Database Developers
• System Administrators
• IT Professionals and Consultants
• Business Intelligence Professionals
• Small Business Owners and Entrepreneurs
• Students and Researchers
• Anyone working with SQL Server databases or interested in pursuing a career in database administration can benefit from learning SQL Server database administration skills.

 Our SQL Server Database Administration training course contains the following:

• 4-day instructor-led training course
• Earn 23 NASBA CPEs (live, in-class training only)
• One-on-one after-course instructor coaching
• End-of-course exam included
• Pre-reading
• Course Manual
• Quizzes
• Exercises

Our SQL Server Database Administration training course has the following prerequisites:

• Relational database experience
• Working knowledge of computers and a familiarity with Microsoft Windows
• SQL programming experience is helpful, but not required

There is no recommended reading for our SQL Server Database Administration training course.

SQL Server Database Administration Exam:

• Format: Multiple Choice
• Questions: 40
• Pass Mark: 70%

Attendees may enjoy our SQL Server Reporting Services training course.

Our four-day SQL Server Reporting Services training course will give you an in-depth skillset to leverage on-premises SQL Server Reporting Services (SSRS) for extracting business intelligence from enterprise data. Attain the knowledge and skills to produce compelling reports with enhanced visualisation features. This training course enables you to go beyond the limitations of legacy reporting to deliver and share information with others — when you want and how you want.

Our SQL Server Database Administration training course offers several benefits to individuals and organisations including but not limited to:

• Lucrative Career Opportunities: SQL Server is widely used in organisations, making SQL Server database administration skills in high demand.
• Database Management Proficiency: SQL Server database administration provides you with the knowledge and skills to effectively manage databases.
• Improved Problem-Solving Skills: Database administration involves troubleshooting and resolving issues that can arise in a database environment.
• Enhanced Database Performance: SQL Server database administration equips you with techniques for optimising database performance.
• Data Security and Compliance: SQL Server database administration focuses on implementing robust security measures to protect data from unauthorised access and ensure compliance with regulatory requirements.
• Business Continuity and Disaster Recovery: Learning SQL Server database administration enables you to implement and maintain high availability and disaster recovery solutions.
• Continuous Learning and Growth: The field of database administration is dynamic, with new features, technologies, and best practices evolving over time.