ONLINE SQL SERVER 2005 DBA TRAINING – AUG 10
Course Fee: $400 / 8 Weeks.
Contact: training@macrobase.com [214-336-2518]
Course Length: 48 hours, Sat, Sun 2PM-5PM CST

Macrobase LLC is offering Job oriented hands on training for Microsoft SQL Server 2005 DBA from a highly experienced instructor. The training is designed exclusively to suit the job market requirements. The training includes a step by step to develop a complete project. Please send email to attend a free Orientation on August 9 (2pm – 3pm), 2008, Regular classes start from August 10, 2008.

Highlights:
• Very attractive course coverage, one of the best in the market.
• What other trainer normally don’t cover are SSRS (Reporting service) , SSNS ( Notification Service) , SSIS ( Integration service), we cover all in detail.
• This training is for beginner as well as experienced database programmer/DBA, very detail implementation of each topic.
• Highly experienced instructor having nearly 8 years of experience with Microsoft SQL Server.
• Complete Hands-on experience during training and adequate exercises and relevant material will be provided regularly.
• Guaranteed to survive in the job after placement with regular support.
• Assistance will be provided to complete Certification for interested candidates.
• Exposure to different real-time scenarios and solutions for each topic.
• 8 weeks Online Training, you should have computer (at least 1GB RAM), DSL internet connection microphone, speaker.
• Compulsory Quiz every week.
• Limited seats (10).

Course Content:

• Installing and Configuring SQL Server 2005
o Install SQL Server 2005
o Configuring Instances
o Management Studio Overview
o Creating a database
o Database Files
o Managing Databases

• Tables, Views, Indexes & Data Integrity
o Creating tables
o Data Integrity
o Using of views
o Creating & Managing views
o Clustered & non- clustered indexes
o Managing indexes

• Stored Procedures
o Creating stored procedures
o Input/Output parameters
o Returning procedure status
o Error Handling in T-SQL
o Using cursors
o Using temporary tables
o Creating & using CLR stored procedures

• User defined functions & Triggers
o Types of user defined functions
o Creating and Managing user-defined functions
o Creating and using CLR functions
o Creating and Managing Triggers

• SQL Server Security , Encryption and Object Security
o Authentication Modes
o Principles
o Securables
o Permissions
o Logins and Users
o Schemas

• SQL Profiler & DB Tuning Advisor & Execution Plan Analysis
o Using SQL Profile
o Using Database Engine Tuning Advisor
o Execution Plan Analysis

• Encryption
o Encrypting Database Objects
1. Stored procedures
2. User defined functions
3. Triggers
4. Views
o Encrypting table data
1. Database Master key
2. Symmetric key
3. Asymmtetric key
4. Certificates
o Encrypting data over network

• SQL Server Reporting Services(SSRS)
o Introduction to SQL server reporting services (SSRS)
o Creating and Deploy SQL server reports.

• Working with XML Data
o Intrduction to SQL Server XML
o Creating and using XML Objects
o Working with XML Data

• Capacity Planning
o Disk Type
o Database file and file groups
o Predicting size of data
o Managing Log file size

• Archive, Backup and Recovery
o Backup Strategy
o Database Recovery Models
o Backup Types
o Perform a Backup
o Transaction Log backups
o SQL Server Recovery Process
o Restoring A Database

• Automating SQL Server
o Overview
o SQL Server Agent Service
o Creating and Managing Jobs
o Creating and Managing Alerts

• Highly Available Solutions
o Points of failure
o Clustering – Server level
o Mirroring - db level
o Log Shipping

• Database Mirroring
o Setting up and Configuring database mirroring
o Testing failover from principal to mirror.
o Implement Database mirroring

• Replication
o Replication scenarios
o SQL Server replication Types
1. Snapshot replication
2. Transactional replication
3. Merge replication
o Setting up replication
o Implement Replication

• SQL Server Integration Services (SSIS)
o Introduction
o Creating SSIS Packages
o Deploying and Managing SSIS packages


• SQL Server Notification Services (SSNS)
o Introduction
o SSNS Sample Applications work through
o Configuring and using SSNS Applications.