Course Overview
1. Learn Database models
2. Overview of SQL Server Management Studio and Transact-SQL language
3. Master writing simple and complex queries that retrieve data from the database
4. Calculate information across result sets using aggregate queries (sum, min, max, avg, etc.)
5. Insert, update, and delete data
6. Retrieve data from tables
7. Joins
8. Sub-queries
9. Working with Data Types
10. Procedure and Functions
11. Understand the different Views
12. Working with Triggers
13. Design a database
14. Maintain databases, tables, and sequences with SQL statements
15. Create and manage views
16. Ensure the integrity of multiple, related database updates by using transactions
17. Retrieve data using cursors
Course Duration & Fee
• Project duration : 1 months
• Course fee : Please call our office
Certification
Once you complete the course successfully, Dishaa Pro shall issue a certificate of completion as “Dishaa Pro certified professional”.
In order to maintain our quality and reputation, we issue certificate of completion on stringent parameters. It is important that you meet these parameters and standards of performance.