Mail : training@ecorptrainings.com
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 Blog

Workday HCM Demo New Batches Starting from Monday... 8-1-2018
Search Course Here




Live Chat
Support
TSQL Online Training

T-SQL



overview

Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to SQL. SQL, the acronym for Structured Query Language, is a standardized computer language that was originally developed by IBM for querying, altering and defining relational databases, using declarative statements. T-SQL expands on the SQL standard to include procedural programming, local variables, various support functions for string processing, date processing, mathematics, etc. and changes to the DELETE and UPDATE statements. These additional features make Transact-SQL Turing complete.
prerequisties
  • None.
Duration
Online
  • It is a 8 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

Corporate
  • It is a 2 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
  • Introduction to Transact-SQL and semantics
  • Types of Transact–SQL statements (DDL, DCL, TCL, DML)
  • Transact–SQL Syntax elements
  • The SQL Query editor
  • Simple SELECT statements
  • Operators
  • Ordering information
  • INSERT/UPDATE statements
  • The TOP clause
  • Aggregate functions (SUM, AVG, COUNT, MAX, MIN)
  • GROUP BY statements
  • Wildcards
  • Entity Relationship Diagrams (ERDs)
  • Join types (INNER, OUTER, CROSS, UNION)
  • Views
  • Stored procedu
  • res
  • Variables
  • Transact-SQL in the context of BI projects
Videos
TSQL Videos will be updated Soon
To Watch More Videos Click Here

Flash News


AngularJS New Batch Starting From 8th JAN & 9th JAN.


Hadoop Dev New Batch Starting From 8th JAN & 9th JAN.


IBM COGNOS TM New Batch Starting From 8th JAN & 9th JAN.


Informatica Dev New Batch Starting From 8th JAN & 9th JAN.


Mean Stack New Batch Starting From 8th JAN & 9th JAN.

SAP BODS new Batch Starting From 8th JAN & 9th JAN.

SAP S/4 HANA New Batch Starting From 8th JAN & 9th JAN.


Tableau New Batch Starting From 8th JAN & 9th JAN.

PUBLIC DEMO


(1) Workday Technical Demo Training

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

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