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