Students will be able to: Develop scalable, distributed applications with SQL to meet organizational requirements. Create modular code using stored procedures and formulate triggers, Develop reusable code with stored procedures and functions, Handle SQL runtime errors to create robust software Audit data changes using triggers. Contents of this subject: 1- Data definition. Managing Tables with DDL, Creating schemas, Referencing schemas versus using the default schema, hiding schemas with synonyms. 2- Building tables, Adding and enforcing constraints. 3- Declaring variables and parameters, Creating and utilizing local variables, Passing input and output parameters, Calling built-in scalar functions, Converting data using CAST and CONVERT, Ordering data with ranking functions, Maintaining Data, Modifying data. 4- Creating Views, Stored Procedures and Stored procedure compilation and execution. 5- Auditing and implementing constraint on data by the means of Triggers. 6- Handling errors by communicating problems to the client with RAISERROR, Intercepting errors with TRY...CATCH.
