T-SQL Programming
This course contains basics of SQL Server and T-SQL Programming.
Introduction to Microsoft SQL server
- Introductions
- Sql server 2008 editions
- Sql server 2008 requirements
- Downloading sql software
- Selecting installation options
- Installing a named instance
- Sql server installation center overview
- Lunching SQL server management studio
Management Studio
- Introduction
- Working with queries
Keys and Constraints
- Introduction
- Primary Keys
- Foreign Keys and Composite Keys
- Understanding Constraints
Data Definition Language (DDL)
- Creation of table
- Modifying the structure of a table
- Dropping a table
- Working with different options
Data Manipulation Language (DML)
- Inserting, updating & deleting operations
- Operators, Built-in functions, grouping
Basic Queries
- Introduction
- SELECT...FROM
- WHERE
- GROUP BY
- ORDER BY
Special Condition in Query
- Introduction
- Operators
- Combining Conditions
- IN
- LIKE
- BETWEEN
- UNION
- EXCEPT and INTERSECT
Working with Functions
- Using Operators
- ISNULL and COALESCE
- Using Functions
Joins
- Introduction to Joins
- Inner join
- Outer join
- Cross joins
- Unions
Working with Indexes
- Introduction t
- indexes
- Clustered & non clustered indexes
- Creating, dropping indexes
- Index Maintenance Concepts
Triggers
- Introduction to Triggers
- DML Triggers
- DDL Triggers
Introduction to T-SQL Programming
- Variables
- IF-ELSE
- WHILE
- ERROR Handling
Using T-SQL Logic
- Tables
- Views
- User-Defined Functions
- Stored Procedures
- Triggers
- Database Cleanup
Other Types of Data
- XML Data
- MAX Data
- Spatial Data Type
- NEW DATE and TIME
Using Complex Queries
- CTE Queries
- Ranking Functions
- MERGE
- Output Clause
Linked Server
- Introduction
- Creating Login
- Using Query in Linked Server
Database Snapshot
SQL Server Performance
| Course Name | Delivery Mode | Fee | Special Offer |
|---|
| Classroom | -- | 8000 | -- |
Basic programing knowledge will be helpful.
• Delegate pack consisting of study material and exercises.
• Live Instructor training with a proficient, industrially rich and seasoned expert
This is a complete hands-on training where the trainer will demonstrate each feature and participants will follow and do the same on the system.
After you enroll, you will be guided on how to access the system.
No. You will need to arrange software for your use.
You can gather your doubts and come by prior appointment to get your doubts cleared.
Yes, participants receive a certificate after completing the course provided, they have attended 90% of the class.
