1. Gain an understanding of Relational databases.

2. Be able to design relational databases (Entity Relationship Diagram) for any type of organisation such as Tesco etc.

3. Develop practical experience in MySQL and SQL functions.

4. Ability to manipulate data using SQL.

5. Gain insights into data warehousing design and data mining techniques.

1. SQL vs NOSQL databases
2. Relational Databases
3. Entity Relationship Design
4. Data Types
5. MYSQL
6. Data Manipulation with SQL
7. Data Warehousing
8. Designing Star & Snowflake schema

Time: 3 hrs per week
Teaching Duration: 12 weeks
Assessment: 4 weeks
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, data warehousing, and data mining.

Design and implement database solutions, utilising entity-relationship design principles and SQL programming to create efficient database structures.

Develop BI solutions by querying databases using SQL, designing data models based on entity-relationship diagrams, and creating reports and dashboards.

Manage and maintain databases, ensuring efficiency, security, and integrity using skills in entity-relationship design and SQL.

Build and maintain data pipelines and ETL processes, utilizing SQL for data manipulation and entity-relationship design for database modelling.

Design and implement data-driven solutions, integrating database technologies, data warehousing and data mining 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.