Training Course:SQL Server AdministrationSchool/Trainer:CBIT Canadian Beaver Training Ottawa
Ottawa, Ontario, Canada
Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced
Course Description:
'' Module 0: Rdbms Essentials
| About the Relational Database Management System
SQL Server Terminology: Databases, Tables, Columns, Rows, Keys, Etc
Application Development and SQL Server
Oltp: The Transactional Server
Olap: The Analysis Server
XML Integration
Core SQL Server Services
Other SQL Server Services
The Role of ADO .NET
| Module 1: Installing SQL Server
| Overview
The Server’s Hardware
Preparing for An Installation
Installing SQL Server
Configuring SQL Server
Checking the Installation
| Module 2: Creating the Database
| Planning the Installation
SQL Server Installation
Data Storage Architecture
Creating Database Files
Using File Groups
Optimizing Data Storage
Importing Data
| Module 3: Tsql For Administrators
| SQL Data Types
Using Variables
Type Conversion
Conditional Constructs
Looping Constructs
Useful Functions
Error Handling
System Tables
Stored Procedures and Metadata Views
| Module 4: Implementing Security
| SQL Security Overview
Other Security Considerations
Planning Security
Configuring the Server
Creating Logins
Creating Users
Granting Permissions: Grant, Deny and Revoke
Using Server Roles
Using Database Roles
Application Roles
| Module 5: SQL Server Automation
| The Need for Automation
Jobs
Alerts
Operators
Sqlmail Integration
| Module 6: Optimizing Performance
| Index Overview
Deadlocks and Livelocks
Optimization Overview
Using Query Analyzer
Gathering Performance Data
Optimizing for Select
Optimizing for Insert, Update and Delete
Query Hints
Join Strategies
SQL Server Transactions and Locks
| Module 7: Backup and Recovery
| Fault Tolerance Vs Backup
Fault Tolerance: Clustering, Mirroring, Fail-over.
Planning a Backup Strategy
Implementing a Backup Strategy
Automating Backups
Recovering From Failure
Recovering the Master Database
| Module 8: Monitoring SQL Server
| Overview of Monitoring Tools
Planning To Monitor SQL Server
Implementing Alerts
Using Performance Counters
Query Analyzer
SQL Server Profiler
| Module 9: Replication
| Replication Architecture
The Replication Topology
The Publisher
The Distributor
The Subscriber
Monitoring Replication
| Module 10: SQL Server Enterprise Services
| SQL Reporting Services
Portal Server
BizTalk Server 2004
HTTP Integration
Msdtc
...''
Elements of this syllabus are subject to change.
Please go to the school's official website for training price and schedule:
http://www.cbit-ccti.com/
Phone:613 742-6800
School Address/Venue(s):
CBIT Canadian Beaver Training Ottawa
214 Montreal Rd
Suite 100
Ottawa, Ontario
K1L 8L8
Canada
Jobs & Resumes: Ottawa
Houses & Roommates: Ottawa
Travel Agencies: Ottawa
Search other schools for SQL Server Administration training resources.
Other training courses offered by CBIT Canadian Beaver Training Ottawa:
Team Building and Workplace Efficiency
SQL Server Programming
SQL Server 2008
Oracle Server
Building a Data Warehouse with Oracle
Oracle Core Administration Skills
PL-SQL Programming for Oracle Professionals
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself. |
|
| 
