Main Menu

Our Partners

Authorized Pearson Vue Test Center

Schedule your Exam Now!

TESDA Registered
Get Coupon Code

Live Online Training

Live CCNA Remote lab



HANDS-ON Transfer of Technology Training

Learning Transact Structured Query Language (T-SQL) with Microsoft SQL 2005 and 2008


Course Duration:  30 HRS

Course Description:

Transact-SQL is central to the use of Microsoft® SQL Server™. All applications that communicate with SQL Server do so by sending Transact-SQL statements to the server, regardless of an application's user interface.

Course Prerequisites:

Has basic knowledge in any database application such MS Access, MySQL, Oracle etc.

Course Outline 

  • Introduction to T-SQL and Data Management System
  • SQL Server Fundamentals
  • SQL Server Tools
  • Introducing the T-SQL Language
  • Data Retrieval
  • SQL Functions
  • Aggregation and Groupings
  • Multi-Table Queries
  • Advanced Queries and Scripting
  • Transactions
  • Advanced Capabilities
  • T-SQL Programming Objects
  • Creating and Managing Database Objects
  • Analyzing and Optimizing Query Performance
  • T-SQL in Applications and Reporting

« Prev item - Next Item »
What do you think?

Leave a Question


How much if i enroll to this short course?

When the training start for this course and how much?

CNCTC Live Chat Inquiry

Job Openings

Scheds Updates

Stay Informed Subscribe

Name *

Email *