SQL SERVER

SQL Server Integration Services

Duration of       Hours 

25

Duration time may vary depends on course progress

About

SQL Server Integration Services

Overview:

SQL Server is relational database management system(RDBMS) from Microsoft. It is both GUI and command based software. It is commonly used as the back end system for websites and cooperate CRMs and can support thousands of concurrent users. It runs on T-SQL, a set of programming extensions from Sybase and Microsoft which includes exception and error handling, transaction control and declared variables. Microsoft SQL Server is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications.


Training Objectives of SQL Server:

The Main Objective of this course covers all of the SQL Server Database performance tuning topics including global tuning with SQL Server parameters, SQL tuning, file and table space management, user administration and security and table and index management.

 

 

Course Content

Course Contents:


  •  Availability and Scalability Features


  •  Security Features


  •  Data Management Features


  •  Administration and Maintenance Features


  •  Development Features


  •  To enable SQLiMail


  •  Testing mail delivery


  •  Installing SQL Server 2005 & 2008


  •  SQL Server 2005 & 2008 Editions



Installing Microsoft SQL Server:


  •  System Requirements


  •  Preparing for a SQL 2005 Installation


  •  Installation Checklist


  •  Setup Features


  •  Using the System Consistency Checker


  •  Component Install


  •  Unattended Installation


  •  Installation Sequence


  •  Installation Maintenance



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 2005 & 2008 Services node


  •  SQL Server 2005 & 2008 Network Configuration node


  •  SQL Server 2005 & 2008 Native Client Configuration node


  •  The SQLCMD Management Utility


  •  SQLCMD Syntax


  •  SQLCMD Variables


  •  Dedicated Administrative Connection


  •  SQL Server Management Studio SQLCMD Mode



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


  •  Reorganizing an Index


  •  Disabling an Index


  •  Dropping an Index


  •  Index Fragmentation


  •  Using the Database Tuning Advisor



Securing SQL Server 2005 & 2008:


  •  Implementing Securable


  •  New Security Features


  •  Principals


  •  Securable


  •  Permissions


  •  Permission Types


  •  Managing Logins


  •  Managing Schemas


  •  Managing Users


  •  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


  •  Native Data Encryption


  •  Code and Module Signing



SQL Server Disaster Recovery:


  •  Disaster Recovery


  •  SQL 2005 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


  •  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 2005 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


  •  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 Synchronization for Merge Replication


  •  Subscriber Initialization


  •  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 2005 & 2008 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 Optimization


  •  Federated Database Servers


  •  Partitioned Indexes


  •  Lock Optimization


  •  Best Practices for Native XML Web Services

Have some Questions?

Call us at our care or drop quick contact box

Why with us?
  • Live Quality Training 

  • Live demonstration of of features and practicals.

  • 100% Assurance Placement Assistance

  • Effective Resume building

  • Internship Program for real exposure

  • Interview preparation with mock interview drills

  • Process of applying jobs at right places

  • Guidance of getting flexible, part time jobs

  • Facebook - Black Circle

 

Corporate Office

KEYZONE IT

364 E Main ST STE 1001

Middle Town

DE 19709

USA

+1 720  738 4411

info@keyzoneit.com

Subscribe with us for regular

JOB POSTINGS

© 2023 by KEYZONE IT