SQL Server









Preferred method of contact?

SQL Server Database Administration

COURSE TYPE

Practitioner

Course Number

2108

Duration

4 Days

View Schedule

Help protect your organisation by using the knowledge gained in this course to correctly manage mission-critical 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.

You Will Learn How To

  • 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

Important Course Information

Requirements:

  • Relational database experience at the level of:
  • Working knowledge of computers and a familiarity with Windows

Recommended Experience:

  • Programming experience

Software:

  • This course uses Microsoft SQL Server 2014, running on Windows Server 2008
  • This course is applicable to those using earlier versions of SQL Server

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.

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

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

7 - 10 Mar AnyWare Enrol Now

How would you like to attend?

Live, Online via AnyWare

9 - 12 May Rockville, MD/AnyWare Enrol Now

How would you like to attend?

Live, Online via AnyWare
In-Class

16 - 19 May AnyWare Enrol Now

How would you like to attend?

Live, Online via AnyWare

23 - 26 May New York/AnyWare Enrol Now

How would you like to attend?

Live, Online via AnyWare
In-Class

20 - 23 Jun Alexandria, VA/AnyWare Enrol Now

How would you like to attend?

Live, Online via AnyWare
In-Class

25 - 28 Jul AnyWare Enrol Now

How would you like to attend?

Live, Online via AnyWare

15 - 18 Aug New York/AnyWare Enrol Now

How would you like to attend?

Live, Online via AnyWare
In-Class

10 - 13 Oct AnyWare Enrol Now

How would you like to attend?

Live, Online via AnyWare

17 - 20 Oct Rockville, MD/AnyWare Enrol Now

How would you like to attend?

Live, Online via AnyWare
In-Class

31 Oct - 3 Nov New York/AnyWare Enrol Now

How would you like to attend?

Live, Online via AnyWare
In-Class

19 - 22 Dec AnyWare Enrol Now

How would you like to attend?

Live, Online via AnyWare

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.

After-Course Computing Sandbox
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.

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.

- ,

Prev
Next

Please Choose a Language

Canada - English

Canada - Français