SQL Server Transact(T)-SQL Training Program
Home >
Database Centric Training Programs >
Sql Server Training Programs >
SQL Server T-SQL Training Program
SQL Server T-SQL Training Program Highlights
Transact-SQL is the database programming language, provided in Microsoft SQL Server to access & manipulate information stored
Microsoft SQL Server databases.
The goal of this course is to provide the program participant with the technical skills required to write basic to
advanced Transact-SQL queries/procedures for Microsoft® SQL Server™ 2000/2005/2008 database management systems.
Objective:
On completing the course participants should be able to:
- Create and Manage SQL Server Databases
- Create Data Types and Tables
- Implement Data Integrity
- Implement database objects such as views, triggers, indexes, stored procedures & user-defined functions
- Manage Transactions and Locks
Audience & Prerequisites:
This program will be ideally suitable for the audience given below and basic understanding of key RDBMS concepts & SQL is a pre-requisite for this course
- SQL Server DBA
- SQL Server DBMS programmers
- Students who wish to learn T-SQL
Pay as you go:
You pay in three installments. Example: For a single participant following is the
pay schedule:
| Installment 1 | Installment 2 | Installment 3 |
| $ 300 | $ 400 | $ 600 |
Pricing (in USD):
| No. of participants | 1 | 2 | 3 |
| Cost (per participant) | $ 1300 | $ 1250 | $ 1200 |
Brief Course Outline:
Duration: 14 hours. The program will be rendered in 7 days
through sessions of 2 hours each.
- Day 1:
- What Is SQL Server
- SQL Server Database
- SQL Server Security
- For more information check out the program outline
- Day 2:
- SQL Server Programming Tools
- The Transact-SQL Programming Language
- Elements of Transact-SQL
- Additional Language Elements
- Day 3:
- Creating Databases
- Creating File groups
- Managing Databases
- Practical Excercise
- For more information check out the program outline
