If you need to extract data from a relational database management system (RDBMS) such as Oracle or Microsoft SQL Server, the Microsoft SQL developer tool – which this advanced course focuses on – will enable you to do that.
Using ANSI standard code, where possible, that can be applied to virtually all databases, we show you some of the advanced techniques that will enable you to better utilise this tool, from working with conditional statements to creating subqueries.
Is it right for me?
What will I get out of it?
By the end of the course you will be able to:
- Create and use stored procedures
- Use conditional statements in queries
- Declare and use variables
- Declare and use parameters
- Create subqueries
- Create looping routines
- Create error handling routines
- Use the debugging tools