If you need to extract data from a relational database management system (RDBMS) such as Oracle or Microsoft SQL Server, the Oracle SQL Developer tool – which this programme focuses on – will enable you to do that.
Using ANSI standard code, where possible, that can be applied to virtually all databases (although any variances are explained in the accompanying course manual), we show you all the basic techniques you need to understand in order to utilise this tool.
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 modify tables
- Create and edit queries
- Sort and group data
- Use text and date functions
- Create basic conditional statements
- Create basic pivot data tables