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
