Discover Classes. Earn 10% Rewards.

SQL Server Database Administration is unfortunately unavailable

Thankfully we have 1 other All Software Class for you to choose from. Check our top choice below or see all classes for more options.

Lightroom Classic in a Day

Capital Photography Center See all classes by this school @ 1201 K St NW, Washington, DC

Get faster and more confident in Lightroom Classic using its most powerful organizing and editing tools. Build a complete digital workflow covering importing, organizing, and precise color, tone, detail, and retouching adjustments. Practice masking, black-and-white conversions, noise reduction, sharpening, and clean exports.

(25) All levels 16 and older
$159
Attend
+1590 pts
Gift it!
See all All Software classes Washington, D.C.

SQL Server Database Administration

  • Intermediate
  • 18 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • 13650 Dulles Technology Dr, Herndon, VA
  • 30 hours over 4 sessions

Start Dates (0) $2,990/person

No upcoming dates are currently available.

Book a Private Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

Class Description

Description

Help protect your organization by using the knowledge gained in this course to correctly manage business databases. With this training, you learn the essential skills for administering SQL Server databases, and gain extensive experience using SQL Server tools to perform real-world administrative tasks with SQL Server Management Studio and Transact-SQL.


SQL Server Database Administration Course Benefits

  • 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


SQL Server Database Administration Course Outline

Important SQL Server Database Administration Course Information

Prerequisites

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


Audience Profile

This course is helpful to those who are new to SQL Server administration and who will be responsible for administering SQL Server. A basic understanding of SQL Server or experience at the level of Microsoft SQL Server Training Course is required.


Exam Information

Optional Learning Tree exam is available at the end of class.


SQL Server Database Administration Course Outline

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
  • sqlcmd
  • PowerShell

Constructing and Managing Databases

Inspecting storage structures

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

Designing file groups

Upgrading and moving databases

  • Maximizing storage utilization
  • Placing tables on file groups

  1. Choosing between upgrade and migration
  2. Detaching and attaching databases


Controlling database space

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

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

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

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

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

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

Refund Policy

If a customer would like to cancel or transfer their course, they must notify Coursehorse prior to 3 weeks before the start date of the course or within seven days of registration. On-Demand Courses cannot be cancelled once purchased and are not eligible for refund.

  • If a customer transfers to another course prior to 3 weeks before the start date or within seven days of registration of the course in which originally enrolled, 100% of any prepaid course tuition will be applied toward the course tuition for the subsequent course.
  • If a customer needs to cancel an enrollment 3 weeks prior to the start of the class or within seven days of registration, we will refund 95% of any prepaid course tuition for that enrollment.
  • If a customer does need to transfer or cancel a course within 3 weeks of the start date of the course or after seven days from the date of registration, a fee equal to 50% of the price of the course will be assessed for any standard attendances.

Attendances associated with a Learning Tree program will be assessed a $500 fee. Training Passports, Training Vouchers and Pay-As-You-Learn Vouchers cannot be used after their expiration dates, and a course cancellation or transfer by the customer will not extend a Training Passport, Training Voucher Pack or Pay-As-You-Learn Voucher Pack expiration date.

In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 29900 points. Earn 10% back in reward points!

Learning Tree International

Learning Tree International is a leading provider of IT and management training to businesses and government organizations worldwide. They offer a wide range of courses, personalized services, and implementation workshops to enhance the knowledge and skills of over 2.4 million IT professionals.

View school profile
Learning Tree International
Vetted by CourseHorse

A verified Washington, D.C. educator.

Loading...