Facets Demo New Batches Starting from Saturday... 22-10-2016
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 09th OCT & 10th OCT.

Hadoop Dev New Batch Start From 10th OCT & 11th OCT.

IBM COGNOS TM New Batch Start From 11th OCT & 12th OCT.

Informatica Dev New Batch Start From 12th OCT & 13th OCT.

Mean Stack New Batch Start 13th OCT & 14th OCT.

SAP BODS new Batch Starting From 14th OCT & 15th OCT.

SAP S/4 HANA New Batch Start From 15th OCT & 16th OCT

Tableau New Batch Start From 16th OCT & 17th OCT


Facets Demo Training

Demo Schedule : 08:30P.M EST / 07:30P.M CST / 05:30P.M PST on 21st OCT & 06:00A.M IST on 22nd OCT
Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :