Get ASP.NET MVC How to Tips & Tricks - click here
Your details are safeBuyer's Satisfaction Contact Us
 Welcome Guest | Register | Login Why online training? | Buyers FAQs | Testimonials | Contact us 

Our Quality Professors

Our professors includes
Contact us for training ...

Training Category

Some more tutorials


More ...

Microsoft SQL Server T-SQL 2012 Training Course

Training by Itfunda

Pricing and Details Support Forum Comments

Microsoft SQL Server T-SQL 2012 Training Course
Summary: This is a comprehensive training on SQL Server T-SQL 2012 delivered by an Industry Expert working in MNC which gives you enough knowledge on T-SQL.


Delivery mode (?): Offline & Online Classroom training,
Duration/Validity: 15 days (1 Hour Per Day Mon to Fri)

Tips for buying: You may buy without logging in, however to provide a better service we suggest to login.
License/Pricing details INR Price USD Price Discount Special discount Final price Buy
Training for one person Rs 12037.10 $200.00 - - Rs 12037.10/ $200.00 Continue >
Contact us for volume licenses discount.Payment can be done securely using Credit card, Debit card or Net banking.


Relational Databases and SQL

  • The Client/Server System
  • The Relational Database Model
  • SQL and SQL-Based Systems
  • Transact-SQL Statements
  • Working with Other Database Objects
  • Using SQL from an Application Program

The Management Studio

  • Managing the Database Files
  • Viewing and Modifying The Database
  • Working with Queries
  • Using Books Online

Retrieving Data From a Single Table

  • The SELECT Statement
  • The SELECT Clause
  • The WHERE Clause
  • The ORDER BY Clause

Retrieving Data from Two or More Tables

  • Inner Joins
  • Outer Joins
  • Other Skills for Working with Joins
  • Unions

Summary Queries 

  • Aggregate Functions
  • Grouping and Summarizing Data
  • Summarizing Data Using SQL Server Extensions


  • Subqueries in Search Conditions
  • Other Ways to Use Subqueries
  • Guidelines for Working With Complex Queries
  • Common Table Expressions

Inserting, Updating, and Deleting Data

  • Creating Test Tables
  • Inserting New Rows
  • Modifying Existing Rows
  • Deleting Existing Rows
  • Merging Rows

Working With Data Types 

  • SQL Data Types
  • Converting Data

Advanced Data Types 

  • Introduction
  • The HierarchyID Data Type
  • Sparse Columns and Column Sets
  • FILESTREAM Storage
  • Spatial Data


  • String Data
  • Numeric Data
  • Date/Time Data
  • Other Functions


  • Creating and Managing Views
  • Using Views
  • Using The View Designer

Creating User-Defined Functions 

  • User-Defined Function Overview
  • Scalar Functions
  • Inline Table-Valued Functions
  • Multi-Statement Table-Valued Functions
  • Using Functions, Views, and Stored Procedures

Complex Querying 

  • Working with NULL Values
  • Ranking Grouped Data
  • Writing Correlated Subqueries
  • Using Common Table Expressions

Coding Scripts 

  • Variables and Temporary Tables
  • Controlling the Execution of a Script
  • Advanced Scripting Techniques

Creating Stored Procedures and Triggers

  • Creating Stored Procedures
  • Creating Triggers

Advanced Query Techniques 

  • Full-Text Search
  • Advanced T-SQL Techniques
  • Executing Dynamic SQL

Transactions and Error Handling

  • Transaction Concepts
  • Applications and Transactions
  • Creating Explicit Transactions
  • Using TRY/CATCH Error Handling

ITFunda .com

Itfunda's Profile

ITFunda.Com is an e-commerce website that furnishes a platform to the interested buyer and seller to interact and transact for the software or software related services. 

We are a part of SN ITFunda Services LLP, a parent establishment of a popular Microsoft(R) technology related knowledge based website

SN ITFunda Services LLP is a authorized distributor / re-seller of
  • Own products
    • .NET How to's
    • ASP.NET How to's
    • jQuery How to's
    • ASP.NET AJAX Tutorials
    • .NET Corporate trainings and
    • Online .NET Trainings
  • TechSmith Corporation products like 
    • Camtasia Studio
    • SnagId
    • Morae
  • Nevron Software
    • Nevron .NET Vision
    • Nevron Chart for Sharepoint
    • Nevron Chart for SSRS
    • Nevron .NET Chart
    • Nevron Diagram for .NET
    • Nevron Gauge for .NET
    • Nevron Gauge for Sharepoint
    • Nevron Sharepoint Vision Suite
    • Nevron SSRS Vision
  • Questpond training materials
  • Deccansoft training materials


If you have bought this, please cast your vote and provide your comment about this tutorial.

Please Sign In to vote.

Share this to:

Facebook Twitter LinkedIn Google+ Pinterest Email Addthis

Other Trainings

About Us | Contact Us | Partners | Privacy Policy | Terms and Conditions | Buyer's FAQs | Seller's FAQs | Currency Converter | Go Top

Notice: If you found someone plagiarising our content/materials, kinldy let us know.

© SN ITFunda Services LLP. Site design and layout is copyright to SN ITFunda Services LLP.
Copying or duplicating or mimicking the site design and layout is prohibited and will be treated as a legal offence and will be prosecuted.
Logos, company, product, service or other names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 11032014 | 10/28/2016 7:32:58 PM