Type to search LearningTree.co.uk

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

Sorry, no results were found for your query.

Please check your spelling and try your search again.

 

SQL Server Courses









Preferred method of contact?

SQL Server Database Administration

COURSE TYPE

Practitioner

Course Number

2108

Duration

4 Days

Enrol

About This Course: SQL Server offers a sophisticated platform for enterprise data management. Organisations 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

  • Maximising storage utilisation
  • 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 Enrolment: No advance payment required.
Tuition Fee due 30 days after your course.

11 - 14 Oct London/AnyWare Enrol Now

How would you like to attend?

Live, Online via Anyware
In-Class

10 - 13 Jan London/AnyWare Enrol Now

How would you like to attend?

Live, Online via Anyware
In-Class

4 - 7 Apr London/AnyWare Enrol Now

How would you like to attend?

Live, Online via Anyware
In-Class

27 - 30 Jun London/AnyWare Enrol Now

How would you like to attend?

Live, Online via Anyware
In-Class

26 - 29 Sep London/AnyWare Enrol Now

How would you like to attend?

Live, Online via Anyware
In-Class

AFTERNOON START: Attend these live courses online via Anyware scheduled 2 PM - 9:30 PM BST

4 - 7 Oct Herndon, VA/AnyWare Enrol Now

How would you like to attend?

Live, Online via Anyware
In-Class

29 Nov - 2 Dec New York/AnyWare Enrol Now

How would you like to attend?

Live, Online via Anyware
In-Class

14 - 17 Feb Rockville, MD/AnyWare Enrol Now

How would you like to attend?

Live, Online via Anyware
In-Class

9 - 12 May Rockville, MD/AnyWare Enrol Now

How would you like to attend?

Live, Online via Anyware
In-Class

23 - 26 May New York/AnyWare Enrol Now

How would you like to attend?

Live, Online via Anyware
In-Class

15 - 18 Aug New York/AnyWare Enrol 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 0800 282 353 or click here

Tuition Fee

Standard

£2095

Course Tuition Fee 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 0800 282 353 or click here »

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

Training Hours

Standard class hours:
9:00 a.m. - 4:30 p.m.

Last day class hours:
9:00 a.m. - 3:30 p.m.

Free Course Exam – Last Day:
3:30 p.m. - 4:30 p.m.

Each class day:
Informal discussion with instructor about your projects or areas of special interest
4:30 p.m. - 5:30 p.m.

AFTERNOON START class hours:
2:00 p.m. - 9:30 p.m.


Last day class hours:
2:00 p.m. - 8:30 p.m.


Free Course Exam – Last Day:
8:30 p.m. - 9:30 p.m.


Each class day:
Informal discussion with instructor about your projects or areas of special interest
9:30 p.m. - 10:30 p.m.

“My experience attending a course online via the Learning Tree AnyWare solution went very well. The instructor stayed in touch with me throughout the session so I always felt I was actively part of the class. I am looking forward to taking another online course with Learning Tree and will be recommending the format to our training coordinator for others to take advantage of”.

- M. Evans, Service Desk Analyst
Hewitt Associates

Prev
Next