SQL Server Course | SQL Training
Course
In Cardiff
Description
-
Type
Course
-
Location
Cardiff (Wales)
-
Duration
3 Days
-
Start date
Different dates available
Delegate pack consisting of course notes and exercises Manual Certificate Experienced Instructor Refreshments
Facilities
Location
Start date
Start date
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 8 years
Subjects
- Security
- Server
- IT
- Database
- SQL
- Database training
- IT Security
Course programme
Introduction
SQL Server Essential Administration is intended for individuals charged with administering a SQL Server 2008 Database System.
This course focuses on only the core administration responsibilities enabling new SQL Server 2008 Database Administrators to build the skills necessary to Install, Configure and Support a Simple SQL Server deployment.
The objective is to provide the essential skills for managing a single instance system, enabling administrators to get up and running to a basic level fairly quickly, but also to provide awareness to some of the more advanced services available.
Pre-Requisites
- Basic understanding of relational databases and the SQL Language.
Attending the following courses, prior to this course would be beneficial:
- Advanced SQL Server Database Querying
- Transact SQL Programming
Course Outline
Installing and Configuring SQL Server
- Preparing to Install SQL Server
- Installing SQL Server
- Configuring a SQL Server Installation
- Configuration Manager
- Management Studio Server Properties
- Sp_Configure
Managing Databases and Files
- Planning Databases
- Creating Databases
- File groups and Data Files
- Transaction Log Files
- Managing Databases
- Options
- Attaching and detaching
Disaster Recovery
- Planning a Backup Strategy
- Backing Up User & System Databases
- Restoring User Databases
- Performing Online Restore Operations
- Recovering Data from Database Snapshots
- System Databases and Disaster Recovery
Managing Security
- Overview of SQL Server Security
- Protecting the Server Scope
- Protecting the Database Scope
- Protecting the Server Scope
- Auditing Security
Establishing Client Connectivity
- Network Libraries
- ODBC & OLE-DB connections
- SQL Native Client
- Configuring Server Connectivity Settings
Automating Administrative Tasks
- Automating Administrative Tasks in SQL Server
- Using SQL Server Agent
- Creating Maintenance Plans
- Implementing Alerts
- Managing Multiple Servers
- Managing SQL Server Agent security
Monitoring SQL Server
- Viewing Current Activity
- Using SQL Server Profiler
An Introduction to Troubleshooting and Performance Tuning
- Troubleshooting SQL Server
- Performance Tuning in SQL Server
An Overview of Other Services
- An Overview of Replication Service
- An Overview of High Availability Services
- An Overview of Integration Services
- An Overview of Service Broker
- An Overview of Common Language Runtime
Additional information
- SQL training provided by the Largest Training Company globally
- Focusing on the core Administration Responsibilities enabling new SQL Server 2008 Database Administrators
- Build the skills necessary to Install, Configure and Support a Simple SQL Server deployment
- GUARANTEED LOWEST PRICE IN THE INDUSTRY
- Intended for individuals charged with administering a SQL Server 2008 Database System
- Courses delivered by world class SQL training instructors in luxury venues
- SQL Server Essential Administration includes material, manuals and exam preparation
- Book Online or Call 01344 203999 to speak to a SQL training advisor today
SQL Server Course | SQL Training