Home
Courses
SQL Server Database Administration

SQL Server Database Administration

Course 2108

Duration: 4 days
Labs: Yes
Language: English
23 NASBA CPE Credits (live, in-class training only)
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

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
  - 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,140

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

Apr 14 - 17 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
May 6 - 9 11:00 AM - 6:30 PM EDT

Aurora, CO or Virtual
May 20 - 23 9:00 AM - 4:30 PM EDT

Herndon, VA or Virtual
Jun 3 - 6 12:00 PM - 7:30 PM EDT

San Francisco or Virtual
Jun 24 - 27 9:00 AM - 4:30 PM EDT

New York or Virtual
Jul 22 - 25 10:00 AM - 5:30 PM EDT

Austin or 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

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

Apr 14 - 17 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
May 6 - 9 11:00 AM - 6:30 PM EDT

Aurora, CO or Virtual
May 20 - 23 9:00 AM - 4:30 PM EDT

Herndon, VA or Virtual
Jun 3 - 6 12:00 PM - 7:30 PM EDT

San Francisco or Virtual
Jun 24 - 27 9:00 AM - 4:30 PM EDT

New York or Virtual
Jul 22 - 25 10:00 AM - 5:30 PM EDT

Austin or 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

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?

Customize Your Team Training Experience

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

* Required Fields

Preferred method of contact:

Phone

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

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.

SQL Server Database Administration

SQL Server Database Administration Delivery Methods

SQL Server Database Administration Course Benefits

SQL Server Database Administration Course Outline

Important SQL Server Database Administration Course Information

Prerequisites

Audience Profile

Exam Information

SQL Server Database Administration Course Outline

Getting Started with SQL Server

Constructing and Managing Databases

Controlling database space

Handling Server and Database Security

Granting and Revoking Permissions

Backup and Recovery

Streamlining Tasks with Jobs, Alerts and Database Mail

Database Maintenance and Monitoring

SQL Server Database Administration FAQs

I was planning to take Microsoft Course 20764: Administering a SQL Database Infrastructure, can I take this course instead?

What version of Microsoft SQL Server is used in this course?

I am currently a developer looking to move into an administrator role, is this the right course for me?

Related Courses