SQL Server for Developer Training

At the end of the SQL Server Training course, professionals will be able to:

• Master writing simple and complex queries that retrieve data from the database
• Calculate information across result sets using aggregate queries (sum, min, max, avg, etc.)
• Insert, update, and delete data
• Understand the differences among views, stored procedures, triggers, and user-defined functions, and know the advantages and drawbacks of each
• Build stored procedures, functions, and triggers
• Design a database
• Maintain databases, tables, and sequences with SQL statements
• Create and manage views
• Ensure the integrity of multiple, related database updates by using transactions
• Retrieve data using cursors
• Manage binary data using BLOBs
• Develop and deploy SQL server applications