SQL SERVER 2005/2008/2008 R2
DBA SSIS SSRS SSAS BI Developer TRAINING
LearFromGuru is a team of Experts who provide professional training services in Microsoft Database Technologies. LearnFromGuru has helped hundreds of professionals and IT consultants to settle successfully in DATABASE MODELING, DESIGN, DEVELOPMENT and Database Administration
DBA BATCH Starts from April 19th
Please Contact training@learnfromguru.com or 614-209-1054 for
Demo classes
Timings
Course contents
Remote Access
Fee Structure
Special discounts for Corporate/ Groups
Training from Ten plus years of SQL SERVER Expert and MCDBA and MCITP Certified
Training Highlights
Free Remote SERVERS ACCESS
3 Months free job support
Shared SQL Server resources
Free material
Free paid website access
Placement assistance
Resume preparation
Interview questions
Production DBA scripts
FTP site with full materials
Video Material and Quizzes
SQL SERVER 2005/2008 DBA Course Highlights
» SQL SERVER 2005/2008 PRODUCTION CLUSTER SETUP
» REPLICATION TECHNOLOGIES
» DISASTER RECOVERY SETUP
» SQL SERVER 2008 MIRRORING
» REALTIME PRODUCTION CRITICAL SCENARIOS
» REALTIME PRODUCTION PERFORMANCE AND TUNING ISSUES
» REBUILD MASTER AND RECOVER PRODUCTION DATABASES
» SQL SERVER INTEGRATION SERVICES (SSIS)
» SQL SERVER REPORTING SERVICES (SSRS)
» SQL SERVER ANALYSIS SERVICES (SSAS)
TSQL BI Developer Course Highlights
» FULL DEVELOPMENT CYCLE EXAMPLES
» Database Design and SQL SERVER 2008 PROGRAMMING FOR BACKEND DEVELOPER
» Data Modeling
» MORE THAN 50 SQL SERVER SCRIPTS
» SQL SERVER INTEGRATION SERVICES
» SQL SERVER REPORTING SERVICES
» project work for SSIS , SSRS and SSAS
SQL SERVER INTEGRATION SERVICES
» Introduction to the SSIS environment
» Tasks
» Drilling into the Data Flow
» Expressions and Variables
» Containers
» Advanced Tasks
» Event Handling and Logging in SSIS
» Migration from DTS
» Administrating SSIS
» Enterprise package development.
SQL SERVER REPORTING SERVICES
» SSRS Architecture and components
» Installation and Setup
» BIDS environment and the Report Designer IDE
» Report Development Lifecycle
» Reporting Services Report Designer
» Designing and Developing Reports with Reporting Services
» Report Deployment
» Report Builder
» Grouping and Sorting
» Parameters
» Expressions, Functions, and Custom Code
» Report Management
» Adhoc Reporting
» Report security
