Mail :
India : +91-8143-111-555
USA : +1-703-445-4802
uk : +44-20-3287-2021
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Wednesday... 26-07-2017
Search Course Here

Live Chat
SQL DEV  Online Training



SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle.


  • All attendees should have a basic knowledge of syntax.


  • It is a 12 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

  • It is a 4 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
    Private Classroom arranged on request and minimum attendies for batch is 4.

course content

  • SQL Server 2012 Overview
    • Version History
    • Feature Overview
    • Development Tools

  • Programming with Transact SQL (TSQL) - the Basics
    • Using Variables
    • Control of Flow Statements
    • Error Handling
    • Using Cursors

  • Programming Views
    • Creating Views
    • Updating Through Views
    • Indexed Views

  • Programming Stored Procedures
    • Creating Procedures
    • Passing Parameters

  • Programming User Defined Functions
    • Scalar, Inline Table and Multi-Statement
    • Data Manipulation in UDFs
    • Profiling UDFs

  • Programming Triggers
    • Trigger Syntax
    • Trigger Events
    • Enabling/Disabling Triggers
    • Nested Triggers

  • TSQL Enhancements
    • Ranking Functions
    • Recursive Queries
    • Relational Operators

  • Monitoring your SQL Server
    • Data Definition Language Triggers
    • DDL Event Notifications
    • Metadata Views

  • Messaging with the SQL Server 2012 Service Broker
    • Architecture Overview
    • Service Broker Example
    • Conversation Architecture
    • Conversation Process
    • Security

  • Using SQL Server 2012 Integration Services (SSIS)
    • Work Flow and Data Flow
    • Package Design
    • Deployment
    • Worked Examples

  • XML-Based Solutions
    • XML Data Type
    • FOR XML Enhancements
    • OPENXML Enhancements
    • XML Schemas
    • XML Indexes

  • Web Services and HTTP Endpoints
    • Web Services Architecture
    • Native HTTP Support
    • HTTP Endpoint Declaration
    • XML Input/Output Types

  • Programming with Notification Services
    • Notification Applications
    • Design Patterns
    • Instance and Configuration Files

  • Coding SQL Server with .NET
    • Enabling the .NET CLR
    • Creating Managed Stored Procedures
    • Creating Managed UDFs
    • Creating Managed Triggers

  • Building SQL 2012 Client Applications
    • ADO.NET Client Development
    • ADO.NET Enhancements
    • Asynchronous Support
    • Snapshot Isolation
    • Bulk Import

  • SQL Management Objects
    • Managing SQL Server
    • Managing Replication

  • Programming SQL 2012 Reporting Services
    • Report Manager
    • Report Server
    • Creating Reports
    • Deploying Reports
    • Viewing Reports


SQL DEV videos will be updated soon
To Watch More Videos Click Here

Flash News

AngularJS New Batch Start From 14th JULY & 15th JULY.

Hadoop Dev New Batch Start From 15th JULY & 16th JULY.

IBM COGNOS TM New Batch Start From 16th JULY & 17th JULY.

Informatica Dev New Batch Start From 17th JULY & 18th JULY.

Mean Stack New Batch Start 18th JULY & 19th JULY.

SAP BODS new Batch Starting From 19th JULY & 20th JULY.

SAP S/4 HANA New Batch Start From 20th JULY & 21st JULY

Tableau New Batch Start From 21st JULY & 22nd JULY


(1) Workday Technical Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th JULY & 07:00A.M IST on 14th JULY

Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :