Type to search LearningTree.com

Do you mean "{{response.correctedQuery}}" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.

 

SQL Server Training









Preferred method of contact?

SQL Server Database Administration

COURSE TYPE

Practitioner

Course Number

2108

Duration

4 Days

Enroll

About This Course: SQL Server offers a sophisticated platform for enterprise data management. Organizations rely on database administrators who know how to manage their mission-critical databases correctly. This course targets those who are new to database administration and offers the essential skills you need to administer SQL Server.

You Will Learn How To

  • Administer SQL Server 2012 and 2014 with SQL Server Management Studio and Transact-SQL
  • 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

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
  • Dedicated Administrator Connection
  • Constructing and Managing Databases

Inspecting storage structures

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

Designing file groups

  • Maximizing storage utilization
  • Placing tables on file groups

Upgrading and moving databases

  • 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 mismapped 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
Show complete outline
Show Less

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

Oct 4 - 7 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Oct 11 - 14 AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware

Nov 22 - 25 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Nov 29 - Dec 2 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jan 3 - 6 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jan 24 - 27 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jan 31 - Feb 3 AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware

Feb 7 - 10 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Feb 14 - 17 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Mar 7 - 10 AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware

May 9 - 12 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

May 16 - 19 AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware

May 23 - 26 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jun 6 - 9 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jun 20 - 23 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jun 26 - 29 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jul 25 - 28 AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware

Aug 1 - 4 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Aug 15 - 18 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Guaranteed to Run

Show all dates
Show fewer dates

Bring this Course to Your Organization and Train Your Entire Team
For more information, call 1-888-843-8733 or click here

Tuition

Standard

$2990

Government

$2659

Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

Free Course Exam
You can take your course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."

Prev
Next

Questions

Call 1-888-843-8733 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm


FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results.
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)
  • Make progress toward one or more Learning Tree Specialist & Expert Certifications (if applicable)

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

Earn 23 Credits from NASBA

This course qualifies for 23 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...

“The course content was very relevant to my job and taught me SQL Server skills I will apply immediately. The instructor gave us actual, real-world examples—he kept us busy without overwhelming us.”

- S. Kijek, Management Analyst
U.S. Department of Veterans Affairs

Prev
Next