1. Gain an understanding of designing Relational databases for companies like Tesco, Just Eat etc.

2. Develop practical experience in MySQL and SQL functions, equipping students with the ability to manipulate data effectively and perform advanced data analysis tasks.

3. Master Tableau for dynamic and interactive data visualisation, allowing them to translate complex data into actionable insights and compelling visualisations.

4. Gain insights into & design data warehousing solutions.

5. Understand the concept of data mining.

1. Entity Relational Diagram
2. Data types
3. Fundamentals of SQL
4. Data Manipulation using SQL
5. Data Warehouse designs
6. Star & Snowflake Schema
7. Data Mining techniques
8. Tableau

Time: 3 hrs per week
Teaching Duration: 12 weeks
Assessment: N/A
Course Materials: Provided

Intensity
The course is intensive and requires 100% attendance and dedication. A lot of exercise for you to do during the course with guidance and feedback from your tutor.

Live datasets
You will work with live datasets which will give you the experience and the skills needed to succeed.

Analyse and interpret data to uncover insights, trends, and patterns using skills in data modelling, database design, SQL, Tableau, data warehousing, and data mining.

Design and develop business intelligence solutions, including data visualisation dashboards and reports using Tableau, SQL, and data warehousing techniques.

Specialise in creating compelling visualisations and infographics using Tableau to communicate complex data effectively.

Apply statistical and machine learning techniques to analyse large datasets, leveraging skills in data manipulation, SQL, data mining, and data visualisation for predictive modelling and decision support.

Build and optimise data pipelines and infrastructure to support data analysis and processing, utilizing knowledge of database design, SQL, MySQL, and data warehousing.

Design and implement data-driven solutions for organisations, integrating technologies such as databases, data warehousing, data mining, and visualization tools like Tableau to meet business objectives.

1. A discount of £150 on all P/T courses if payment is paid in full.

2. A discount of £300 on all our Bootcamp programmes if payment is paid in full before the start of the course.

3. All short courses under £500 must be paid in full before the beginning of the programme.

4. All payments should be made directly to the School’s account and not to any third party.

1. A deposit of £600 is to be paid on all P/T programmes and the remaining can be split into 4 instalments.

2. A deposit of £1000 is to be paid on the Bootcamp programmes and the remaining is to be paid in 4 instalments or less.

3. There is no interest in any instalment plan.

4. All payments should be made directly to the School’s account and not to any third party.

1. Check what support your organisation provides for career development (CPD).

2. Discuss your career development plan and how much your employer would like to contribute towards your fees.

3. Liaise with Cavillion to pay the remaining amount in instalments.