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

Contest



  

HANDS-ON Transfer of Technology Training

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

26


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

Inquiries


How much if i enroll to this short course?


When the training start for this course and how much?

  
CNCTC Live Chat Inquiry

Scheds Updates

Stay Informed Subscribe

Name *

Email *