Install Microsoft SQL Server 2012/14 and the bundled tools Learn many tools that facilitate effective Database Administration Monitor the smooth running of the Database Server Maintain the Database and Indexes Setup and control Database Security
DurationHighlights
Install Microsoft SQL Server 2012/14 and the bundled tools
Learn many tools that facilitate effective Database Administration
Monitor the smooth running of the Database Server
Maintain the Database and Indexes
Setup and control Database Security
Cope effectively with Database Disaster Recovery
Implement High Availability and Replication
Use relevant TSQL commands
Understand the basics of Integration Services
Implement SQL Server Full-text search
Course Details
SQL Server 2012/2014 Overview
Availability and Scalability Features
Security Features
Data Management Features
Administration and Maintenance Features
Development Features
To enable SQLiMail
Testing mail delivery
Installing SQL Server 2012/2014
SQL Server Editions
Installing Microsoft SQL Server
System Requirements
Preparing for a SQL 2012/14 Installation
Installation Checklist
Setup Features
Using the System Consistency Checker
Component Install
Unattended Installation
Installation Sequence
Installation Maintenance
Upgrading from previous versions of SQL Server
Retaining SQL previous versions
To verify the Installation
Administrative Tools
Upgrading to SQL Server Management Studio
Management Studio Windows
Registered Servers
Object Explorer
Review Database Objects
Modify Database Properties
Create Database Scripts
The Maintenance Plans Node
Solution Explorer
Query Editor
Template Explorer
Dynamic Help
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
SQLCMD Syntax
SQLCMD Variables
Dedicated Administrative Connection
SQL Server Management Studio SQLCMD Mode
Using SQL Management Objects
SMO Object Model
Monitoring the Database Server
Managing Metadata Views
Metadata Storage
System Views
Information Schema
Catalog Views
Sys All
Dynamic Management Views
System Stored Procedures
Database and Index Maintenance
Index Management
New Index Features
Creating Indexes
Online Index Maintenance
Parallel (multiple CPU) Index Operations
Lock Options
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
Index Fragmentation
Using the Database Tuning Advisor
Securing SQL Server 2012 2014
Implementing Securables
New Security Features
Principals
Securables
Permissions
Permission Types
Managing Logins
Managing Users
Managing Schemas
Schema Definition
Using Schemas
Managing Execution Context
Managing Permissions
Manage Server Permissions
Manage Server-Scope Securable Permissions
Manage Database Permissions
Manage Database-Scope Securable Permissions
Managing Certificates
Native Data Encryption
Code and Module Signing
SQL Server Disaster Recovery
Disaster Recovery
SQL 2012 / 2014 Disaster Recovery Feature
Enhanced Features
Database Snapshots
Creating a Snapshot
Common Snapshot Applications
Undeleting table rows
Undoing a table update
Recovering a dropped object
Backup and Restore
Backup Changes
Restore Changes
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
Database Availability
SQL Server 2012 /2014 Data Availability
Database Mirroring
The Witness Server and Automatic Failover
Configuring Database Mirroring
Transaction Safety Level
Operating Modes
High Availability Operating Mode
High Protection Operating Mode
High Performance Operating Mode
Mirroring Security
Monitoring Mirroring
Database States for Database Mirroring
Prepare the Servers
Configure Mirroring
Verify Principal and Mirror Access
Execute the Mirror Failover
Verify Mirror and Witness Status
Terminating the Mirror Session
Replicating Information
Replication Enhancements
Stand-alone Replication Monitor
Support for Oracle Publishing
HTTP Synchronisation for Merge Replication
Subscriber Initialisation
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
SQL Server 2012 /2014 Integration Services
Creating the Database Objects
Creating a Package Using Business Intelligence Studio
Integration Services Project Template
OLE DB Command object
Column Mappings
Adding a Data Viewer
Monitoring and Performance
SQL Server Profiler
Optimal Data Storage
Diagnostic Tools
Query Analyzer
Database Engine Tuning Advisor
Index Optimisation
Federated Database Servers
Partitioned Indexes
Lock optimsation
Best Practices for Native XML Web Services
Who Should Attend
IT professionals who need the fundamental skills to install, maintain, administer and troubleshoot Microsoft SQL Server 2012.
History Of JBI Training
JB International (JBI Training) is a London (UK) company which was formed in 1995, delivering Technology training courses to leading organisations.
JBI has always focused on cutting edge technology and is widely recognised as a leading specialist provider of training in the fields of Artificial Intelligence, Machine Learning, Analytics, DevOps, Security....
Instructors & Consultants
We are confident that you will find our instructors to be among the finest around. Our Instructors bring into the classroom the experience of applying their skills in the "Real World" as systems developers and consultants.
Many are leading figures in the world of Technology and are able to add a lot of value to your training. The instructors are personable and able to communicate their technical knowledge effectively to delegates.
Increasingly, clients are looking for consultancy and project mentoring to help get leading-edge systems design , development and implementation underway smoothly.
JBI is able to provide this service and have a number of leading consultants who can add value to client projects.
This instructor-led, live training in the UK (online or onsite) is aimed at application developers and engineers who wish to master more sophisticated usages of the Teradata database.
Using the free version of Microsoft SQL Server, one of the top 3 Relational Database Management Systems used by 98 of the Fortune 100 companies we will cover all the necessary skills to build, maintain and interrogate a relational database system.
This course covers all the skills needed to use Oracle Database in professional work. Structured knowledge of SQL can be an asset to business analysts, report writers, application developers in the RAD environments (Oracle Forms, Oracle Fusion and even Microsoft Access)
During this 2 day course, you will optimise your understanding of how to use DQS to cleanse, match, standardise, and enrich data to guarantee a result of reliable and consistent analytics. This course will equip you with up-to-date regulations and fundamental objectives to ensure the highest qualit...
This is an associate-level course offered by Oracle. Oracle PL/SQL (Procedural Language extensions to SQL) Developer Certified Associate (JP) is not an entry-level course and is designed for IT professionals who already have experience working on Database development and design.
About Coursetakers.com
Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the UK, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy
Online
USA
UK
India
UAE
South Africa
Canada
New Zealand
Australia
Malaysia
Singapore
Saudi Arabia
Egypt
Jordan