CA flag CA
888-843-8733
888-843-8733

SQL Server Database Administration

Course 2108

  • Duration: 4 days
  • Labs: Yes
  • Language: English
  • Level: Intermediate

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 Delivery Methods

  • Hands-On Instructor-Led Training

  • Learning Tree Exam

  • After Course Instructor Coaching

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

  • 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.

  • 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
      • Choosing between upgrade and migration
      • 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
Get This Course $3,450 $3,036 For Team Prices Call: 888-843-8733

  • 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

  • Pay later by invoice -OR- at the time of checkout by credit card

#2108
  • Jul 22 - 25 10:00 AM - 5:30 PM EDT
    Virtual
  • Aug 5 - 8 11:00 AM - 6:30 PM EDT
    Aurora, CO or Virtual
  • Sep 2 - 5 12:00 PM - 7:30 PM EDT
    Bellevue, WA or Virtual
  • Sep 9 - 12 9:00 AM - 4:30 PM EDT
    Ottawa or Virtual
  • Oct 7 - 10 9:00 AM - 4:30 PM EDT
    Herndon, VA or Virtual
  • Oct 28 - 31 11:00 AM - 6:30 PM EDT
    Aurora, CO or Virtual
  • Nov 4 - 7 9:00 AM - 4:30 PM EST
    New York or Virtual
  • Dec 2 - 5 12:00 PM - 7:30 PM EST
    San Francisco or Virtual
  • Dec 9 - 12 10:00 AM - 5:30 PM EST
    Austin or Virtual
  • Jan 27 - 30 9:00 AM - 4:30 PM EST
    Ottawa or Virtual
  • Feb 3 - 6 11:00 AM - 6:30 PM EST
    Aurora, CO or Virtual
  • Mar 10 - 13 9:00 AM - 4:30 PM EDT
    Herndon, VA or Virtual
  • Mar 17 - 20 12:00 PM - 7:30 PM EDT
    Bellevue, WA or Virtual

Scroll to view additional course dates

  • 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

  • Pay later by invoice -OR- at the time of checkout by credit card

#2108
  • Jul 22 - 25 10:00 AM - 5:30 PM EDT
    Virtual
  • Aug 5 - 8 11:00 AM - 6:30 PM EDT
    Aurora, CO or Virtual
  • Sep 2 - 5 12:00 PM - 7:30 PM EDT
    Bellevue, WA or Virtual
  • Sep 9 - 12 9:00 AM - 4:30 PM EDT
    Ottawa or Virtual
  • Oct 7 - 10 9:00 AM - 4:30 PM EDT
    Herndon, VA or Virtual
  • Oct 28 - 31 11:00 AM - 6:30 PM EDT
    Aurora, CO or Virtual
  • Nov 4 - 7 9:00 AM - 4:30 PM EST
    New York or Virtual
  • Dec 2 - 5 12:00 PM - 7:30 PM EST
    San Francisco or Virtual
  • Dec 9 - 12 10:00 AM - 5:30 PM EST
    Austin or Virtual
  • Jan 27 - 30 9:00 AM - 4:30 PM EST
    Ottawa or Virtual
  • Feb 3 - 6 11:00 AM - 6:30 PM EST
    Aurora, CO or Virtual
  • Mar 10 - 13 9:00 AM - 4:30 PM EDT
    Herndon, VA or Virtual
  • Mar 17 - 20 12:00 PM - 7:30 PM EDT
    Bellevue, WA or Virtual

Scroll to view additional course dates

  • Bring this or any training to your organization

  • Full - scale program development

  • Delivered when, where, and how you want it

  • Blended learning models

  • Tailored content

  • Expert team coaching

#2108
Questions about this course?
* Required Fields
Customize Your Team Training Experience

Fill out the form below or call 888-843-8733

* Required Fields
Preferred method of contact:

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Contact Us

SQL Server Database Administration FAQs

Yes! Microsoft retired the course, and certification, 20764. This course will get you the same knowledge you would have gained from the 20764 course.

Learning Tree uses Microsoft SQL Server 2019; however, this course is applicable to those using earlier versions of SQL Server.

Yes! This course is helpful to those who are new to SQL Server administration and who will be responsible for administering SQL Server.

Chat With Us