Learn The Core Principles Of ITIL® 4 With Our 3-Day ITIL® 4 Foundation Virtual Training Course! Start Your ITIL® 4 Certification Journey Today. Learn more

Please Note: You can book this course and hold it in credit until you have decided on a specific course date. Alternatively, please view our other course dates

Our SQL Server Database Administration training course will teach you to become proficient in the following:

  • Configure and manage SQL Server databases
  • Ensure SQL Server security with logins, roles, users, and permissions
  • Develop backup strategies and recover from disasters
  • Leverage SQL Server Agent to automate administrative tasks
  • Isolate and repair fragmentation and database corruption

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%
Proctored Exam
SQL Server Database Administration Certificate

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.

SQL Server Database Administration FAQS

The duration of our SQL Server Database Administration training course is four-days.

INFORMATION

SQL Server Database Administration Course Dates

Course date
Course Date

Course location
Location

Now only £2395 + VAT

Course date
Course Date

Course location
Location

Now only £2395 + VAT

Course date
Course Date

Course location
Location

Now only £2395 + VAT

Course date
Course Date

Course location
Location

Now only £2395 + VAT

Course date
Course Date

Course location
Location

Now only £2395 + VAT

Why Choose Us?

We Are Here To Help You Pass

All of our trainers have achieved exceptionally high delegate pass rates for accredited examinations for all our courses. We also offer complimentary pre and post-course support for any questions you may have.

We Are Flexible

We try and be as flexible as we can and accommodate your needs. We can swap delegates at any time with no charge. We can also create bespoke content should this be required.

We Are The Specialists

We specialise in IT Service and Project Management. All of our Trainers and Consultants have considerable years of hands-on experience in IT Service / Project Management, working across a wide number of industry sectors.

We Are Professionals

Our training, sales and admin staff are all professional, helpful, friendly and approachable. We believe in providing excellent customer service. You will always have a dedicated friendly Account Manager