Advanced SQL for Data Reporting and Analysis
The course Advanced SQL for Data Reporting and Analysis is designed to broaden your knowledge and practical skills in writing SQL queries using advanced SQL features such as the
analytical SQL functions in Oracle server, hierarchical queries and subqueries.
Full course notes are provided along with sample database files. At the beginning of the SQL training you will be given instructions on how to install Oracle XE 11g Server and the sample SQL database. A link to the video recording of the lecturer’s screen will be sent to you after each session.
Key Topics in Advanced SQL for Data Reporting and Analysis
- Advanced GROUP BY features
- Partitioned OUTER JOINS
- Set operators
- Retrieving data using subqueries
- Hierarchial SQL queries
- Analytical SQL functions
- Connecting MS Excel to external data sources
- Using Power Query to analyse data
- Connecting MS Access to external data
- Building reports with MS Access
The course Advanced SQL for Data Reporting and Analysis is suitable for students who want to improve and enhance their knowledge and practical skills in writing complex SQL queries for data analysis and creating reports.
Students taking course should have taken the following classes or have equivalent knowledge of
The overall duration of the course is 10 hours
- At your site
- Live on-line instructor-led
- Public classes