Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Tuesday... 01-11-2016
Search Course Here




Live Chat
Support
SQL DEV  Online Training

SQL DEV



overview


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.

prerequisties

  • All attendees should have a basic knowledge of syntax.

Duration

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

Corporate
  • It is a 4 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
Classroom
    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

Videos

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

PUBLIC DEMO

(1) Workday Technical Demo Training

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

(2) SAP MII Demo Training

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

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings