SQL – Training for SQL for Business Intelligence
Join this one-day training course to gain the technical skills required to maximise the capabilities of SQL for Business Intelligence. Delegates will be taught how to write basic SQL queries on either Oracle or Microsoft SQL Server. This course is ideal for Business Intelligence developers who would like to gain an in-depth understanding of SQL’s ability to extract important data from their organisation to make efficient business decisions.
It is recommended that those who wish to further their knowledge and skills in this area also attend the Data Warehousing ETL Process course we offer.
SQL Training Content:
Duration: 1 day
Getting Started with Databases and SQL
Querying and Filtering Data
Joining Data from Multiple Tables
Grouping & Summarising Data
Working with Sub-queries
Modifying Data in Tables
Using programming objects for Data Retrieval
SQL Training Goals:
By the end of the SQL training delegates will be able to:
SQL Training Prerequisites:
In order to be successful on this SQL training course it is recommended that attendees have experience with basic relational databases.
SQL Training Audience:
This course is appropriate for any job roles required to write SQL queries, and in particular business intelligence developers.