This is Sai Phanindra, working as SQL Server production DBA in one of the Top MNCs for more than six years. I am Microsoft Certified DBA (MCDBA) as well as Technology Specialist (MCTS). I have been providing trainings - Online and Offline for the last THREE years. I provide Job support activities as well.
You can reach me anytime at my Mobile : 91-0-9666440801 (INDIA)
Or mail me your queries to:
saiphanindrait@yahoo. com
saiphanindrait@gmail. com
SQL Server and MSBI Online Training from SQL School
SQL School, one of the best institutes for online training provides Microsoft Business Intelligence [MS BI] course with complete practical approach. Course Duration is for minimum of 60 hours, completely practical and covering
SQL Server Integration Services [SSIS], SQL Server Analysis Services [SSAS] and SQL Server Reporting Services
[SSRS].
SQL Serve and MSBI Online Training from SQL School are completely interactive and practical.
To join free demo on SQL Serve and MSBI Online Training from SQL School please visit
SQL School, one of the best institutes for online
training provides Microsoft Business Intelligence [MS BI] course with
complete practical approach. Course Duration is for minimum of 60 hours,
completely practical and covering SQL Server Integration Services [SSIS], SQL Server Analysis Services [SSAS] and SQL Server Reporting Services [SSRS]. SQL Server Integration Services (course content overview below)
Need for MSBI Process and Workflow Management
Control Flow and Data flow Tasks
Data Modeling Requirements
ETL with non-SQL Server sources
Variables and Dynamic SSIS Configurations
Advanced Control Flow Tasks
Error Handling and Event Handling
Incremental Data Load and Buffer Management
SSIS Transactions, Isolation Levels and Checkpoints
SCD, DQS and SCRIPT Operations
Custom SSIS Components (CHECKSUM) and Data Profiling
SSIS Catalog (SQL Server 2012) versus MSDB Deployments
SQL School : For SQL Server DEV, DBA and MSBI training courses SQL School
is one of the best training institutes for SQL Server DEV, DBA and MSBI
courses. We have been providing LIVE Online Instructor led Trainings
for the last SEVEN years. All our training sessions are COMPLETELY
PRACTICAL on LIVE environment with Real-time examples and Case Studies. Courses Offered:
Study Material and Practice Material included in the course.
*ALL OUR SESSIONS ARE COMPLETELY PRACTICAL*
Sign up for a free demo today!! http://www.sqlschool.com contact@sqlschool.com
+91 09666440801 (India)
+1 214 628 5666 (USA) http://sqlschool.com
SQL
School
is one of the pioneers IT Institutions providing specialized in SQL Server 2012
DBA Training. We have been providing Online Training, Classroom Training and Video
Training for the last SEVEN years. All
our sessions are completely Practical and Real-time.
SQL
SERVER DBA TRAINING COURSE DETAILS SQL Server Basics
SQL School training institute offers MSBI Online
Training with Project and Placement. Course includes complete practical
training with in-depth discussion on SQL Server Integration Services [SSIS], SQL Server Analysis Services [SSAS] and SQL Server Reporting Services
[SSRS].
SQL Server Integration Services (course content overview below)
·Need for MSBIProcess and Workflow Management
·Control Flow and Data flow Tasks
·Data Modeling Requirements
·ETL with non-SQL Server sources
·Variables and Dynamic SSIS Configurations
·Advanced Control Flow Tasks
·Error Handling and Event Handling
·Incremental Data Load and Buffer Management
·SSIS Transactions, Isolation Levels and
Checkpoints
·SCD, DQS and SCRIPT Operations
·Custom SSIS Components (CHECKSUM) and Data Profiling
·SSIS Catalog (SQL Server 2012) versus MSDB
Deployments
SQL School is one of the best training institutes for SQL Server DEV,
DBA and MSBI courses. We have been providing LIVE Online Instructor led
Trainings for the last SEVEN years. All our training sessions are
COMPLETELY PRACTICAL on LIVE environment with Realtime examples and Case
Studies. Courses Offered:
Study Material and Practice Material included in the course.
*ALL OUR SESSIONS ARE COMPLETELY PRACTICAL*
Sign up for a free demo today!! http://www.sqlschool.com contact@sqlschool.com
+91 09666440801 (India)
+1 214 628 5666 (USA) http://sqlschool.com
SQL School training institute offers Microsoft BI /
SQL SERVER BI Training with Project and Placement. Course Duration is
for minimum of 60 hours, completely practical and covering SQL Server
Integration Services [SSIS], SQL Server Analysis Services [SSAS] and SQL Server Reporting Services [SSRS]. SQL Server Integration Services (course content overview below)
Need for MSBI Process and Workflow Management
Control Flow and Data flow Tasks
Data Modeling Requirements
ETL with non-SQL Server sources
Variables and Dynamic SSIS Configurations
Advanced Control Flow Tasks
Error Handling and Event Handling
Incremental Data Load and Buffer Management
SSIS Transactions, Isolation Levels and Checkpoints
SCD, DQS and SCRIPT Operations
Custom SSIS Components (CHECKSUM) and Data Profiling
SSIS Catalog (SQL Server 2012) versus MSDB Deployments
SQL Server Reporting Services (course content overview below)
SSRS 2012 Architecture and Need for Web Services
Reporting life Cycle and SSRS Workflow
Report Filters and Dynamic Parameters
Chart Based Reports
List and Rectangle Reports
Sub Reports and Linked Reports
Gauges Reports and Dundas Report Control Operations
Cube Reports with MDX and DAX
Report Tuning and Schedules
Report Caching, Refresh and Snapshot Options
Data Driven Subscriptions
Managing Reporting Services
Report builder Applications
Security Management
Report Delivery and Hosting
SSRS Tuning and Issue based Troubleshooting tips
SSRS Interview Questions and Guidance
For detailed SSRS course content http://sqlschool.com/SSRS-Online-Training.html
*ALL OUR SESSIONS ARE COMPLETELY PRACTICAL*
For free Demo session on SQL SERVER BI Training with Project and Placement and further details, please log on to http://www.sqlschool.com SQL School contact@sqlschool.com
Office: (+91) 040 64577244 (SR Nagar, Hyderabad, India)
USA: 214.628.5666 http://sqlschool.com
SQL School is one of the pioneers IT Institutions providing
specialized in SQL Server 2012 DBA Training. We have been providing Online
Training, Classroom Training and Corporate Training for the last SEVEN years.
All our sessions are completely Practical and Real-time.
SQL SERVER DBA COURSE DETAILS FOR ONLINE
TRAINING
·SQL Server Basics
·SQL Server Design Architecture
·SQL Server 2008 R2 - Installation
·SQL Server 2012 – Installation
·SQL Server Service Accounts and Configurations
·TCP/IP and Named
Pipes Configurations
·Authentication
Modes and Authorization Techniques
·Collation and File
Stream Settings
·SQL Server Database Design & Planning
·SQL Database: FileGroups and Files
·Log File Sizing
and Placement
·SQL Server Table Design & Pages
·INSERT, UPDATE and DELETE
·SELECT and Inner Queries
·DELETE versus
TRUNCATE
·SELECT INTO and
INSERT..SELECT statements
·Table Compression Techniques
·Data Integrity & Consistency
·SQL Server Views and Schemas
·Schema Binding and Encryptions
·JOINS and Sub Queries
·Nested Queries and Linking Tables
·Uses of Indexes and Performance
·Stored Proceduresand User Defined
Functions
·DDL Triggers and DML Triggers
·Cursors Usage and Limitations
·Table Variables and Temporary Tables
·T-SQL Transactions Concepts & Types
·Locks and Memory Concepts & Locking Hints
·Blocking Issues and Open Transactions
·New Features in SQL Server 2012
·Choosing the best Isolation Level
·Lock Hints and Adminsitration
·Blocking & Deadlocks Issues
·Backup Strategies & Backup Types
·Backup Options and Audits
·Point-In-Time, Partial and Piecemeal Restores
·Restore Audits and MSDB
·Backup Jobs and Schedules
·Replication Techniques and Types
·Replication Monitor and Warnings
·Peer – Peer Replication Topology and Limitations
·Log Shipping Modes and Issues
·Manual Failover Process and Syncup Issues
·DB Mirroring and Encryption
·Automatic Failover and EndPoint Security
·SQL Server Security & Client Security
·Database & Object Security
·Security Issues and Audits
·Data Level Encryptions and Data Security
·Credentials,
Proxies and Job Security
·Import -Export Techniques
·Tuning & Troubleshooting
·Performance Tuning & Tips
·Security Audits in DENALI
·DBCC Commands and Management
·Server Level Audits and Monitoring
·Advanced SQL DB Administration Checklist
·Solutions for Log Space Issues and Tempdb Issues
·Solutions for Memory Issue and Network Issues
·Solutions for Long Running Queries and Frequent Queries
·DBCC and Dynamic Management Views
·Profiler & Activity Monitor and Network Issues
·Partitioning Techniques and Compression Techniques
·Database Snapshots and Usage
·Certificates,Signatures,
Cryptography
·SQL Server Keys andTDE
Implementation
·DB Engine Tuning Advisor and Client Statistics
·Optimizing SSIS Packages
·Database Maintenance Plans using SSIS
·History Maintenance and Database Shrinking Operations
·Backup Strategies, Healthcheck Commands for Routine Backups
·Recovery Path and Failover Options
·DB Mail & Alert System with Notifications
·Upgrades, Migrations and Service Pack Installations
·SQL Server Failover Cluster Configuration
·Active Directory Configurations and Storage (SAN) Management
·Active/Active and Active/Passive Cluster Configuration Issues
·SQL Server Cluster Management Operations
·MSDTC and Resource Governor Importance and Usage
·Contained Databases and Always-On Availability Groups
