Excellent Sql Server Training By Sql Expert Having 10+Yrs Exp

[intuites]

T-SQL • MS SQL Server (Transact SQL) :Introduction and overview of all Data Base Objects, Constraints-Primary, Foreign, Composite ,Check, Default, Nullability.

• DDL SQL Statements

• Operators:

• Aggregate Functions: 

• Introduction to Dynamic SQL: Explanation of functionality, Various Statements (DECLARE, EXECUTE, type of variables).

• System Functions : Date Functions, String Functions,

Explanation of these system functions along with its syntax and its usage in scenario.

• System Stored Procedures:Explanation of most of the common system stored procedures along with its syntax and usage.

• Join in SQL Server: Purpose of Joins, Usage, Advantages/Disadvantages and differences along with syntax.

• Sub-queries and Co-related Sub-queries:

• Set Operators:

• Views: 

• Common Table Expressions (CTE’s): Introduction to CTE, Introduction and examples of Recursive CTE’s.

• Management of temporary data base objects:Local temporary table, Global temporary table.

• Advanced Dynamic SQL

• Control Flow Statements:.

• Table Variables

• Execution Plans

• Stored Procedures :

• Triggers: 

• Cursors

• Indexes :

• Execution Plans :

• SQL Server Hints

MSBI- SSIS • Introduction To SQL Server 2005 Integration Services :Product History, SSIS Package Architecture Overview, Development and Management Tools, Deploying and Managing SSIS Packages, Source Control for SSIS Packages.

• SSIS for DMAs : Using SQL Server Management Studio : 

• Business Intelligence Development Studio: Launching BIDS, Project templates, The package designer, The Toolbox, Solution Explorer, The Properties window, The Variables window, The SSIS menu.

• Introduction to Control Flow :Control Flow Overview, Precedence Constraints, The Execute SQL Task, The Bulk Insert Task, The File System Task, The FTP Task, The Send Mail Task.

• Advanced control Flow:  Containers – grouping and looping, The Web Service Task, The WMI tasks, The Analysis Services tasks, The Execute Process Task, The Execute Package Task.

• Introduction to Data Flow: 

• Variables and Configurations : 

• Debugging, Error Handling and Logging : 

• Advanced Data Flow : 

• Extending SSIS through Custom Code :.

• SSIS Package Deployment :Configurations and deployment, The deployment utility, Deployment options, Deployment security, Executing packages – DTExec and DTExecUI.

• SSIS Package Management :The SSIS Service, Managing packages with DTUtil, Managing packages with SQL Server Management Studio Scheduling packages with SQL Server Agent.

•

SSRS • Introduction To SQL Server 2005 Reporting Services: Tour of Features, Reporting Services Architecture, Reporting Services Terminology, Reporting Services Editions, Taking Reporting Services for a Spin.

• Creating Reports :Deconstructing Reporting Services, Shared Data Sources, Creating Reports from Scratch.

• Calculations and Formatting :Creating Expressions, Using the Global Collections, Formatting Items, Conditional Formatting.

• Grouping and Sorting :Creating Groups, Calculating Totals and Percentages, Interactive Sorting, Creating Drill-Down Reports.

• Report Parameters :Creating Report Parameters, Creating Drop-Down Parameters, Multi-Valued Parameters, Debugging Parameter Issues.

• Creating Matrix Reports and Charts :

• Managing Report Services :

• Reporting Services Secutity :Two Parts to Reporting Services Security, Securing Access to Reports, Data Source Security.

• Programming Reporting services : 

• Advanced Reporting Services Programming :Using the Reporting Services Web Service, Working with Custom Assemblies.

• Snapshots and Subscriptions :Caching and Snapshots, Creating Standard Subscriptions, Creating Data-Driven Subscriptions, Managing Subscriptions.

• Ad-Hoc Reporting with Report Builder :

SSAS

• Introduction To SQL Server 2005 Analysis Services: What Is Microsoft BI?, Core concept – BI is the cube or UDM, Example cube as seen ,using Excel pivot table, MS BI is comprehensive – more than Analysis Services on SQL Server, Demonstration of SQL Reporting Services with cube as data source.

• OLAP Modeling : 

• Using SSAS in BIDS : Intermediate SSAS : KPIs, Perspectives, Translations – cube metadata and currency localization, Actions – regular, drill-through and reporting.

• Advanced SSAS : 

• Cube Storage And Aggregation :.

• Beginning MDX : Basic syntax, Using the MDX query editor in SQL Server Management Studio, Most-used Functions & Common tasks, New MDX functions

• Intermediate MDX: Adding calculated members, Adding scripts, Adding named sets, .NET Assemblies.

• SSAS Administration :

• Introduction to Data mining: 

• Introduction to Reporting Clients : Future Directions - Integration with Office 12 :

DBA Concepts • Maintenance and Troubleshooting of System Databases:  Moving system databases, Rebuilding system databases.

• Troubleshooting, Maintenance and Starting the SQL Server instances with following methods:  Single user mode, Minimal Configuration Mode, Command Prompt, Net Command.

• Monitoring SQL server : Job Activity Monitor, Activity monitor, Log File Viewer, Performance Monitor, Windows Event viewer, Monitoring by SQL Server Alerts, SQL Server Profiler

• Clustering:   Connection Setup of Clusters, Nodes, Quorum, Automatic failover, moving to another Node, Monitoring Clusters.

• Performance tuning:   Types of Isolation levels, Locks, Deadlocks, Blockings,Sql Litespeed, Sql Diagnostic Manager, Log Reader, DBCC, System Stored , Procedures, Regular, Weekly And Monthly Activities.

• Query Optimizer and Query Execution Plan :

• Indexing:  Types of Indexes, Differences of Indexes, Index Structure, Rebuild and Reorganizing, Fill Factor.

• T-Log structure

• Data Base Backups: Full Backup, Differential Backup, Transaction Log Backup, Tail Backup.

• Recovery Models: Simple recovery model, Bulk-Logged recovery model, Full recovery model.

 

Highlights of the Training :

 

1) The instructor is a  SQL Server Expert  with 10+ years of Experience.

2) The training is 80% practical and 20% theoretical

3) Training with Real time examples

4) Assignments for every 2 classes 

5) Classes on all weekdays except occasionally on weekends.

6) Online training using WebEx : Easy to install and record your own sessions

7) Trainer Certified by Intuites

8) Batches starting every 2 weeks.

9) Duration of the Training :45 Days.

 

       If Interested in Placement after training, we provide the following   :

 

 Complete Mockup Sessions  for Vendor and Client  Interviews

 Resume Review and Preparation by Dot Net Expert

 Dedicated recruiters to place you and excellent people to help with interviews. 

 Strong relationships with many Prime Vendors and our direct clients for placements.

 Competitive Pay as per market, on-time payment with our transparent payment system. 

 Our E-Verification may help you to get the extra 17 months extension on OPT

 Assurance of timely visa status upgrades from OPT/CPT/L1 to H1B and then Green card  with one of the nation’s best ranked immigration attorney

For further details, please contact Pavan at (234)-542-3945 or by email at [email protected].

Due to high call volume, if we missed your call, please leave us a message or send us an email.

 

      To know more about Intuites, please visit our website : www.intuites.com

 

       To hear more about Intuites in employees' words, please check out our reviews at    

www.facebook.com/intuites