Client feedback shows that delegates on our courses will best engage when they can relate course topics to their own day-to-day practices and requirements. Where possible, we run this course as a consultative, workshop-style event, in which discussion of relevant topics takes place in relation to the delegates' own applications and scenarios.
To facilitate this type of event, a subject matter expert leads the training, hands-on labs and discussions to ensure course topics are covered in a meaningful, relevant and timely manner. Delegates may be able to bring their own practical requirements and work to the course if the subjects and course topics are suitable.
Our 5-day SQL Server 2012/2014 training course for administrators will give delegates the skills of setting up, maintaining and getting the most out of Microsoft's latest version of SQL Server .
Demonstrations and course labs will be on SQL 2012 with any specific differences being demonstrated where necessary (usually in a short session at the end of each day).
Availability and Scalability Features
Data Management Features
Administration and Maintenance Features
To enable SQLiMail
Testing mail delivery
SQL Server Editions
Installing Microsoft SQL Server
Preparing for a SQL 2012/14 Installation
Using the System Consistency Checker
Upgrading from previous versions of SQL Server
Retaining SQL previous versions
To verify the Installation
Management Studio Windows
Review Database Objects
Modify Database Properties
Create Database Scripts
The Maintenance Plans Node
Upgrading to SQL Server Computer Manager
SQL Server 2012 or 2014 Services node
SQL Server 2012 or 2014 Network Configuration node
SQL Server 2012 or 2014 Native Client Configuration node
The SQLCMD Management Utility
Dedicated Administrative Connection
SQL Server Management Studio SQLCMD Mode
Using SQL Management Objects
SMO Object Model
Managing Metadata Views
Dynamic Management Views
System Stored Procedures
New Index Features
Online Index Maintenance
Parallel (multiple CPU) Index Operations
Included Columns in Indexes
Partitioned Tables and Indexes
XML Index Support
Altering an Index
Rebuilding an Index
Reorganising an Index
Disabling an Index
Dropping an Index
Using the Database Tuning Advisor
New Security Features
Managing Execution Context
Manage Server Permissions
Manage Server-Scope Securable Permissions
Manage Database Permissions
Manage Database-Scope Securable Permissions
Native Data Encryption
Code and Module Signing
SQL 2012 / 2014 Disaster Recovery Feature
Creating a Snapshot
Common Snapshot Applications
Undeleting table rows
Undoing a table update
Recovering a dropped object
Backup and Restore
Media Integrity Changes
Recovering the MASTER Database
Create a mirrored backup
Restore from the backup mirror
Create a snapshot
Restore the snapshot data
Automate the creation of daily snapshots
SQL Server 2012 /2014 Data Availability
The Witness Server and Automatic Failover
Configuring Database Mirroring
Transaction Safety Level
High Availability Operating Mode
High Protection Operating Mode
High Performance Operating Mode
Database States for Database Mirroring
Prepare the Servers
Verify Principal and Mirror Access
Execute the Mirror Failover
Verify Mirror and Witness Status
Terminating the Mirror Session
Stand-alone Replication Monitor
Support for Oracle Publishing
HTTP Synchronisation for Merge Replication
Replicating DDL Statements
Modified User Interface
Replication Management Objects
To Configure Publishing and Distribution
Configuring Peer-to-Peer Replication
Create a Publication
Create a Subscription with RMO
Creating the Database Objects
Creating a Package Using Business Intelligence Studio
Integration Services Project Template
OLE DB Command object
Adding a Data Viewer
SQL Server Profiler
Optimal Data Storage
Database Engine Tuning Advisor
Federated Database Servers
Best Practices for Native XML Web Services
At the end of this course you will be able to:
1. Install Microsoft SQL Server 2012/2014 and the associated bundled tools
2. Understand the many tools that facilitate effective Database Administration
3. Monitor the smooth running of the Database Server
4. Maintain the Database and Indexes
5. Setup and control Database Security
6. Cope effectively with Database Disaster Recovery
7. Implement High Availability and Replication
8. Use relevant TSQL commands
9. Understand the basics of Integration Services
10. Implement SQL Server Full-text search
23/10/2017: Debates on the present state of C++ in the programming world divide the participants into two camps: some dislike C++ and predict it's imminent...
12/10/2017: Microsoft recently released the public road map that gives the holistic approach to Integration and the key product offerings that contribute...
05/10/2017: MVC The Model View Controller (MVC) architectural pattern has a long history (together with its variants) and has been used in many languages...
16/01/2018: Data Analysts at a Government establishment required the ability to respond rapidly to ad-hoc requests for information, including parliamentary...
03/10/2017: When a leading High Street Retailer (and purveyor of fine foods) recognised that teams of software engineers were writing overcomplicated and...
31/01/2019: Java is a well-established programming language that has been around since the mid 1990s. It’s used extensively in industry and commerce, and...
Bring a JBI course to your office
and train a whole team onsite
0800 028 6400 or request quote
0800 028 6400
"great tips help reduce build times"
"we got access to exclusive content"
"Short course meant less time off"
"what an inspiring trainer !"
"colleagues at 2 sites joined via web"
"I passed my exam the next day"